Need a simple VB code para sa datareport!! please help me.

[rainier]

---

magPEP, naa ko himoun na na report...dali ra cya pero kahilagan 2 columns ang need nako...

sample: (ang correct na result)

(Column 1) (Column 2)

name: client 1 name: client 2
address : client1 address address : client2 address
age: 20+ age: 22+

name: client 3 name: client 4
address : client3 address address : client4 address
age: 23+ age: 26+

etc.........until end..


need kayo ang code para sa Datareport sa VB6... wala ko kahibaw unsaon nako pagpaagi...

thanks kaayo...

please share sa knowledge for other to learn...

[rainier]

mga bai, nagita ko ug tabang sa code... kong naay lain paagi oki ra sa akoa... suggestion is open... unsay mas dali gamiton ug sayon duhaton.. VB ang gamit nako sa program...

thanks mga bai...

[cold_fusion]

See http://vbcity.com/forums/faq.asp?fid...port&#TID48756

This is mainly creating a temporary table with the fields of your original table duplicated 2 times. Then every 2 rows of your original table will be inserted to a single row of the temporary table.

The temp table will then be used as the source for the datareport object.

I hope this helps.

[rainier]

thanks bai, on testing nako...i hope its works..

[cold_fusion]

You're welcome .