Exporting CR without grouping or formatting

Hi, I'm currently evaluating Crystal Reports XI, testing it's exporting capabilities.

All I want to do is export from a report, just the data (rows of underlying records) with just the field headers (names) in the first row. Just as you would when exporting a query/table from applications such as MS Access into a Tab delimited text file, or comma delimited file.

What I do not want to export is any additional information on the report I.e. Report headers, page headers, group headers and information, totals.

I have tried in CR, csv, ttx, txt, xls (data only), but all of these include grouping information of some sort if the report itself is grouped on the report side.

Has anyone managed to export just the data from a report that has grouping on the report?

Any ideas?

Any help would be greatly appreciated.If you want to export only some part of report then that should be in subreport and export the subreport

export to excel question

i used matrix control.

Grouping and Sorting Property

I checked the property

visibility can be to toggled by another report item

report show is right. the item is toggled by another report item

but export the excel file

the report item is not togled by another report item

the excel show like a table.

how can i set the excel show.

set the item is toggled by another report item

this is i want .

JAPAN TOTAL
	TKY MET-1 SD
	TKY MET-2 SD

this is not i want

JAPAN TOTAL
	TKY MET-1 SD
	TOKYO-1
	TOKYO-2
	TOKYO-3
	TOKYO-4
	TOKYO-5
	TKY MET-2 SD

please explain your question.|||

sorry, I am not explain my question.

Export to CSV w/ grouping problem after 2005 upgrade

Hi,

After upgrading to reporting services 2005 from 2000, reports that used to export to CSV correctly don't now. It appears the CSV export suddenly stops at a table with grouping. Any ideas would be appreciated...

Thanks.I am having the same problem although I'm not sure it is the grouping that breaks it. I have many reports, and after converting to 2005 some of them export data in the table to csv and others do not. I am unable to find any differences between the reports that work and those that don't - all of the having groups in the table. I am disappointed that the original post was back in February and there have been no responses?|||I fixed this by changing the Output property of the table from Auto to Yes. Although I'm still not sure why it was working on some reports and not others. Both had the same conditional expressions for visibility in them and the Output property of both were set to Auto.

Export to CSV w/ grouping problem after 2005 upgrade

Hi,

After upgrading to reporting services 2005 from 2000, reports that used to export to CSV correctly don't now. It appears the CSV export suddenly stops at a table with grouping. Any ideas would be appreciated...

Thanks.
I am having the same problem although I'm not sure it is the grouping that breaks it. I have many reports, and after converting to 2005 some of them export data in the table to csv and others do not. I am unable to find any differences between the reports that work and those that don't - all of the having groups in the table. I am disappointed that the original post was back in February and there have been no responses?|||I fixed this by changing the Output property of the table from Auto to Yes. Although I'm still not sure why it was working on some reports and not others. Both had the same conditional expressions for visibility in them and the Output property of both were set to Auto.