Suppress blank rows in crosstab

  • Thread starter Thread starter Rajat
  • Start date Start date
R

Rajat

Hi,

I have a crosstab query that is pivoting on date for just
the past 12 months although there are many more months of
data in the dataset.

Several records come back without any values in
the "column heading".

Is this because there is data against these row headings
but not for the past 12 months? or is it because there is
data but it sums to zero (owing to positive and negative
values)?

I want to write the crosstab so it suppresses those
records which are entirely blank in the past 12 months.

Can I do this without querying the crosstab query?

Thanks,

Rajat
 
It isn't clear whether you want to suppress rows or columns. Blank rows
should not appear unless you are using a left or right join.

Since this is a query NG, you are asking about a crosstab, and you have been
here before, you should remember to post your SQL with your question.
 
Back
Top