Basic question about CrossTabs from a newbie

rbuser

Sorry, this is probably an easy question to answer but....

I need a cross tab which shows months/years in a consistent way e.g.


2001

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

But, if there is no data for say March, ReportBuilder misses this column
out. I need it to be present even if there is no data for this month.
Any ideas on how to do this?
Thanks

Carl Davies

Carl.davies@carmarthen.wales.nhs.uk

digitalmetaphors

To get these values in the crosstab, you'll need to create 'fake' records
for the empty months. One approach would be to use a JIT pipeline. The
JITPipeline could get the records from the query. You could track the
previous and next record, to see if the dates skip a month. Then you can
keep the current record position on the dataset, but provide the pipeline
field value to be the month that it skipped. You would also have to check to
see how many months are skipped, and iterate through those for each
subsequent call to get field value from the JITPipeline. See the
JITPipeline demos in the main reports demos project for some examples.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks, very much appreciated