Field that is termed "suppressed" but shows data does not export

[themanpap]

Crystal Reports 9
Win XP
Access Database

All,
I have a report that I use for two locations. One location shows 8 fields, and the other location shows 10 fields. For the first location (8 fields), I suppress the two fields that I don't need, and after refreshing the report, I can export it fine to a .csv file. Everything exports without a problem.
For the second location (10 fields), after refreshing my report and seeing data in all 10 fields on the screen, when I export to a .csv file, only the 8 fields show up. It as if the two fields that are marked as suppressed fields (even though they show data) are still saying they're suppressed, and therefore, don't want to export the data.
Any clues?
Thanks in advance!

 

[synapsevampire]

The first 8 is the real error, if you've suppressed data, it should NOT export.

You might want to share HOW you're suppressing data, and more importantly, why you think that suppressed data should be exported.

I sometimes use parameters to differentiate between export requirements and display requirements, so in this case you might add a parameter and allow the users to decide if they want all data or suppress some of it, and suppress based on the parameter.

Service packs often address export issues, so try applying the latest.

-k

 

[themanpap]

I actually put the most recent service pack on my computer, so I know that's not it.
For suppressing the data, I actually suppress the field itself. With the field selected, I choose "Format Field", then choose the Common tab, and then click the check mark next to suppress. I then edit the formula to say "building number <> '2'(for the second location) ", so that the field is suppressed if building '1' (the first location) is chosen from a parameter.

Here's an example of what's being displayed:

bldg number ---------fields------
a b c d e f g h i j k
1 x x x x x x x x x
2 x x x x x x x x x x x

Now, an example of what's being exported (.csv file, with the x, being what is actually exported):

building number
1 x,x,x,x,x,x,x,x
2 x,x,x,x,x,x,x,x

I would think that if the data is displayed on the screen, it should export everything that is displayed. To an end user, it would be confusing to think that even though you have 10 fields displayed, only 8 get exported.

 

[lbass]

In most cases you should NOT check the box for suppress if you then add a conditional formula to the x+2 formula area. If the conditional formula does not execute (e.g., if the formula is null), then the display will default to the checkbox status. Not sure this would affect the export issue, however.

-LB