Joined: 23 Jun 2009
Online Status: Offline
Posts: 5
Topic: Disabling Group Suppression Posted: 26 Jun 2009 at 12:52pm
Is there a way to disable the suppression of a group field if the group name does not exist?
I have a report that has two groups. Depending on the data, not all names in group 2 occur in every group 1. What I would like is to have all available names in group 2 always appear within each group 1 regardless if it exist in group 1 or not.
"Supress Printing If no Records" in Print Options is not checked
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 26 Jun 2009 at 1:07pm
If I understand your request correctly the data is not being suppressed, it does not exist. If it does not exist it cannot be displayed.
Sometimes you can address this via left joins to force a record to come into the report with associated NULL values from its linked table and then they can be displayed, but ultimately you need a way to make the data exist in order to display it.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 26 Jun 2009 at 1:23pm
DBlank is correct, if the data doesn't exist, Crystal isn't going to display, it doesn't know that it's missing. Using a stored proc, can help in creating data that doesn't exist in the join.
But the ultimate solution is have the data that you want to display in the record set for Crystal to 'see'
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
