Crosstab concatenation -- reproduce in Crystal Reports?

[Guest]

I have received invaluable help from Duane Hookom here, who helped me to
create extremely powerful crosstab reports using the Concatenate expression.
The queries and reports work fabulously, but the reports themselves are
pretty high-maintenance for the endusers to manage (requires manually
manipulating headings in the report each time a new group is added to the
crosstab).

The best solution for this particular report would be a crosstab report in
Crystal Reports based on the underlying Access crosstab query. However, I'm
having trouble getting Crystal Reports to do the "concatenate thing" in the
Crosstab Expert. There is simply a list of built-in, automated summing
features, none of which will display all of the data in the underlying
crosstab cells.

My Access query is as follows (and works flawlessly, thanks to Duane's help):

TRANSFORM First(Concatenate("Select CompanyLocationCode FROM
qryCARDIOTHORACICSURGERY_MatrixData WHERE [City]=""" & qcarCity_SPLN!City &
""" AND SubProductLineName=""" & qcarCity_SPLN!SubProductLineName & """ ORDER
BY CompanyLocationCode",Chr(13) & Chr(10))) AS Company
SELECT qcarCity_SPLN.City, qcarCity_SPLN.ProductLineName,
qcarCity_SPLN.[Service Line Name]
FROM qryCARDIACINVASIVE_MatrixData, qcarCity_SPLN
WHERE (((qcarCity_SPLN.ProductLineName)="Cardiothoracic Surgery") AND
((qcarCity_SPLN.[Service Line Name])="Cardiovascular"))
GROUP BY qcarCity_SPLN.City, qcarCity_SPLN.ProductLineName,
qcarCity_SPLN.[Service Line Name]
PIVOT qcarCity_SPLN.SubProductLineName;

Does anybody have enough experience in Crystal Reports to help me manipulate
the properties of a Crystal crosstab report to accomplish the same thing as
my Access query? I'm thinking it shouldn't be very difficult, but support
for Crystal is not as ubiquitous as for Access. I'm using Crystal because it
formats and lays out the report much more automatically than Access does.

Thanks in advance,

Steve Vincent
Lead Trainer, Information Technology Dept
Franciscan Health System
(e-mail address removed)

 

[Guest]

Are you sure you need to manually maintain headings? Have you looked at my
crosstab report samples at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane?

The crosstab.mdb has a solution for dynamic column headings that don't
require routine maintenance.