Stuck with a Crosstab report! [RS]

[cognosjon]

Morning all,

completely at a standstill this morning, not sure if its a mental block or something more sinister.

I been asked to reproduce a lovely excel spreadsheet that has lots of charts and tables within it, the problem I'm facing is shown in the attached file. All of the reports are similar to this in that the first section of the report is the current week, which i have no problem displaying whilst at the end of the report they wish to display the previous 4 weeks totals as individual columns. The data is in a flat file format.

Any suggestions?

 

[goose]

You need to create a discontinuous crosstab, you will find an example in the docs. If the flat file is in a simple format you can use as a datasource to by creating an odbc dsn for it on your server and then using that in cc.

[cognosjon]

Cheers Angus,
thanks for the kick in the right direction.