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
