detail a and b

[bzsurf03]

I have two unrelated tables and are trying to get data from each simply for exporting and importing purposes. The data in is two detail rows (Detail A and Detail B) depending on which table they came from. This is a report to simply be exported as a .csv file. I want each row of detail to be handled as a different record. When I export to a .csv file and open in excel, it has treated the detail A and B fields as one record. I want them to be on seperate rows. Is there any way to force the detail rows to be treated as two records rather than one. I understand why this is happening I believe, but am looking for a work-around. Thanks in advance for your help.

 

[synapsevampire]

Consider using a Union to create the data set.

-k

 

[synapsevampire]

An alternative would be to place the 2nd tables data in a subreport and place that in the Report Footer.

-k

 

[bzsurf03]

Adding a subreport causes only the main report or the subreport to be exported as a .csv, but not both. Surprised? Me too.

 

[bzsurf03]

I will have to do a refresher with unions, but I like that idea. Thanks k.

 

[lyanch]

If you export it directly to excel, you won't have the problem.. each row will export as a row to excel. Not that it will help you if you have a constraint to use cvs.

Lisa

 

[synapsevampire]

Hmmm, have you applied the hotfixes, I don't see that as a problem with csv exports in later versions.

-k