Force header even when detail does not exist
I have a report thar has groups in a specified order and each group header (based on conditions that have to be met) shows detail record counts in 12 columns; the header groups whose condition is not met (and as such dont have detail) do not display a header on the report. How do I get them to display with a count of 0 if they have no detail records? By the way, I don't have individual tables joined. I have a single SQL commmand. Is there a way to force the headers using a command? If not, how else could I do it?
|