Suppress rows not working with export to .csv

[huytonscouser]

i have a details section, and a section expert Suppress(no drill down) formula

{@Dev Size GB} < 0.1


This work fine in the report, and only the required rows appear.


If i try to export this file to a .csv file. I get all the page header titles for the suppressed rows, as well

as the page header titles PLUS the valid rows. If i also suppres page header, i get blank rows, and then valid data.


I.e. my report is 124k rows without suppression, about 10k with suppression, but when exported to

,csv i still get 124k rows.


works fine exported to .xls


What is the issue with export to .csv ?

 

[Madawc]

I hit just the same problem in Crystal 11.5, see thread149-1622628. I got round it by exporting as text with commas between the field, all assembled in a Crystal Formula Field.


It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[IdoMillet]

Different export formats behave differently in Crystal.

You could use a record (or Group) selection formula of:
{@Dev Size GB} >= 0.1

hth,
- Ido


view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[huytonscouser]

Unfortunately {@Dev Size GB} comprises NEXT and PREVIOUS and therefore the formula is not visible in record selection.


On the sap forums, i got the answer :-

This has been entered as an Enhancement Request ID ADAPT00721865 in 2010. To date, there has not been any action on this enhancement. If you wish, you can this to the SAP Idea Place:

https://ideas.sap.com/community/products_and_solutions/crystalreports

Madawc, so the workaround was export to text, and you created a
formula like :-

global stringvar row_for_output := field1 + "," + field2 + "," + ........etc

and this was the only data in the details section ?

i am using crystal 2011

 

[Madawc]

Yes, I combined fields. But it can be done much more simply

field1 & ", " & field2 & ", " & ........etc

I think you need & to combine data of various sorts, string and date as well as numeric.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP