Crosstab Report 1

[JLuxner]

Using Crystal 8.5
Connecting through SQL server

I am trying to create a crosstab report that will list each procedure in a surgery and total cost of the surgery. The current table shows:

Pro_ID Case_ID Procedure_Name
9604 8656 ANGIO LV/COR W/POSSIBLE INTERVENTION (FV 2)9613 8656 ANGIO CORONARY STENT LAD
9614 8656 ANGIO CORONARY STENT ADDITIONAL - CIRCUMFLEX
9615 8656 ANGIO PTCA EACH ADDITIONAL VESSEL

On my main report which is grouped first on Case_ID will list each procedure (in the details band) however, my crosstab report (which is in the header) will only show the first procedure name instead of listing all 4 procedures. How can I get the crosstab report to display all procedures for that case ID.

Thanks for your help in advance.

 

[synapsevampire]

When you say in the header, I guess you mean in the group header?

If the cross-tab is in the group header (or group footer), it should demonstrate ALL of the data within that group, meaning all of the rows within the details.

Do you want all of the procedures, or all of the distinct procedures.

Example data and expected ouput would be useful here.

Place the Pro_id as the Row, and the count pro_id as the summary.

This will provide you with a count of them, however you may misunderstand what a cross-tab does, it provides summary data, not details.

If you expect each row to be duplicated, it doesn't work that way, you'd need to create a formula that concatenated uniqueness to base it on.

-k

 

[JLuxner]

Thank you synapsevampire's for your reply. I will try to clarify more of what I am after.
I am trying to create a cross-tab report of each surgery that is done.
Dr. A Dr. B Dr. C Dr.D
ProcedureA cost$ Cost$ Cost$ Cost$
(all proc. listed)
Procedure B cost$ Cost$ cost$ cost$
Procedure C Cost$ Cost$ cost$ Cost$

What is happening with the application that we have is I am only able to get the first procedure to appear. It does not list the additional procedures that may occur in this same case visit. When only the scheduled procedure name appears, it makes it look like Procedure A cost this Dr A this much and Procedure A cost Dr. B Twice as much money. If I could get all of the procedures that were done to list out in a cross tab report, it would show why Procedure A cost Dr. B that much more money (ie. it went on to many othere procedures). (we would be able to compare apples to apples).

In the actual report (located in the Details Band), I can get all of the procedures to list. However, the export to Excel isn't what I am after. Thanks again for any help,
JLuxner