I can think of some work arounds, but your suggestion of crosstabbing
thedata first sounds like the best bet. I'd love to see it, please.
Thanks.
Lawrence Lustig wrote:
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
--
Kayza Kleinman
Director, Nonprofit Helpdesk
Jewish Community Council of Greater Coney Island, Inc.
3001 West 37th Street
Brooklyn, NY 11224
Tel. 718 449-5000
Fax 718 946-8240
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.nphd.org <http://www.nonprofithelpdesk.org/>
“Putting Technology to Work For You”
