Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 599
  • Last Modified:

Crystal v8.5 - how do I show all group headers even if there is no data in the details section?

Hi
please can someone help - I am running a crystal report that just uses one table from Access, and I need to show all the group headers - even if that group is empty? Can anyone help? I am using Crystal v8.5.
many thanks
Dawnyanne
0
dawnyanne
Asked:
dawnyanne
  • 2
2 Solutions
 
UnifiedISCommented:
Sounds like you might have record selection criteria that is limiting the records that show.  Move the criteria to a conditional suppression formula (from the select expert, check suppress on details and build a formula with the formula builder).  You will likely have to reverse your logic.
0
 
dawnyanneAuthor Commented:
hi
for this particular group there are no records - but i still want the header to show to indicate this. Do you think there is any way around this? I have looked at a lot of other posts on the site but they are not quite the same as my problem.

thank you for your help!
0
 
UnifiedISCommented:
Crystal only shows things for which there are records.  You'll probably need to join another table that includes the other groups.
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
UnifiedIS has the right idea.  Traditionally, the way to handle this is to use a "reference" or "lookup" table as your primary table and then join to it. For example, if you have a table with a list of all Sales people and you want to show a group for each sales person, whether or not that person had sales, you would make the Sales Person table the primary table, then left join the actual Sales table to it.  This would allow you to Display headers/footers for each group.  The downside to this approach is that you might negate the left join if you apply any sort of selection criteria to the table on the right.  You can get around this, most of the time, in Crystal, more definitely in SQL.

Can you go into a little more detail about your report?

~Kurt
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now