470,593 Members | 2,306 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,593 developers. It's quick & easy.

How to display all group headers even if there is not data for that group?

I have a report that lists names of people who are out of compliance in 6 different categories. Sometimes nobody is out of compliance in category 2 or 3 but I still want the report to show the header for that category. Whats the best way to do this?
Mar 22 '22 #1
1 4044
32,298 Expert Mod 16PB
Hi CJ.

Were I in your position I'd start by spending some very basic time & effort in writing out your question so those reading it have an understanding of what you need help with.

I can only guess that this report is based on a crosstab query, as that's the only way I know that columns, or Fields, might be missed out horizontally.

In a crosstab query there is a way to specify the columns outside of the data. I don't use crosstabs much myself but I do know that in the SQL version of a crosstab you can do this using the PIVOT clause.

Good luck.
Mar 23 '22 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Steve Harclerode | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.