Mutiple Crosstabs with same dataset but different grouping

[skurkal]

Hi

I am using CR XI and have a dataset with 6 months worth of dates and values.

The first crosstab shows vaules by week for all weeks in the dataset which I was able to do easily but the second crosstab needs to be a daily one with only 15 days worth of data shown.

I wrote a formula as follows and put it in the row selection of the crosstab:

If (command.date) >= Currentdate - 15
then command.date

But this shows the 15 dates and a blank row with the rest of the days summed together and obviously the totals are also off. How do I get rid of this and show totals and values for only 15 days?

06/01 20
06/02 25
06/03 5
06/04 19
.
.
.
06/15 26
<blank> 4598
Total 5899


After a whole day of trying new things I have run out of ideas.
Thanks!

 

[lbass]

Create the second crosstab in a subreport that limits the record set to the exact ones you need.

-LB

 

[skurkal]

I was hoping there was another way ... but thanks for confirming.