system
October 2, 2007, 5:56am
#1
Hi,
How can we show empty cells in a cross tab.
For Example, if I have data for Months 1,2,3,5 and 6 and don’t have any data for month 4, I still want to be able to display month 4 with empty cells in it.
Also once I acheive that, I want to fill the blank cells with Zeroes.
How do I do this?
Thanks,
Deepti
deeptipidikiti (BOB member since 2004-08-18)
system
October 2, 2007, 6:04am
#2
You could have done a Search on BOB with keywords ‘Crosstab block’ for past discussions.
Found one here
Hi Guys and Girls,
I’ve searched and haven’t seen anything that works as an answer.
I have a crosstab that has dates running across the page
and sales agents running down the page.
On a couple of days there are no sales.
I still need these days to show in the columns, but with empty values.
Is there a way to do this in the crosstab?
Any help is substantially appreciated.
Cheers
Tim
tim_BO (BOB member since 2007-05-31)
You need to create a separate query for Months column to bring full set of data.
.
haider (BOB member since 2005-07-18)