This could also be done by printing the report in an DECLARE cursor loop that prints one crosstab for each dataset
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, October 20, 2004 10:46 AM Subject: [RBG7-L] - Re: Possible to make this report? > You are correct that a crosstab in a report will include the entire dataset of > the report. In general, when using reports for crosstabs, your report should > include ONLY the crosstab control and whatever explanatory text you need. > > However, you can use more than one column to "break" the rows of the crosstab. > If your view, therefore, contains the break column and you have two levels of > crosstab in the rows -- the report break column and the "real" crosstab row > break column -- you may get results that are functionally identical to what you > want (you wont be able to do the same level of formatting for the breaks, > however). > > Failing that, you need to manually crosstab your data into a table and print a > report based on that. If you do so, the report will need to change each time > you add a column to the cross tab. To get around this, you could export the > data to Excel and use that as the reporting format. I have some code that will > crosstab the data for you regardless of the number or rows or columns in the > crosstab output. Let me know if you want it. > -- > Larry > >
