Special report

[Rajesh99]

I have a tabular report in which every field comes from a table except one that comes from a detail table. How can I create this report. It should look like:

cust_id cust_name productid(s)
1 John 100,101,102 ..


productid(s) are from detail table.

Any clues?

 

[randy700]

Have you tried building the report from a query?

Randy

 

[sillysod]

if im right in thinking you want to show the details across the page rather than down, well ivenever found a way to do this.

I would imagine the way to do this would be to create a recordset, then cycle through this recordset concatenating the values needed into a string. But tbh i dont know how this wuld work since youd have multiple parent records so you woud get all the child records against every parent.