That was one thing I was thinking about. I actually have code that did
something like this, except that it wasn't a proper report, but an
actual crosstab. I could adapt it. However, that loses some of the nice
features of having one report.
David M. Blocker wrote:
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
--
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”
