Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Crystal Reports Groups Expand / Collapse
Author
Message
Posted Friday, September 13, 2013 9:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 12:43 PM
Points: 219, Visits: 719
I have a crystal report that groups by provider alphabetically.

For each provider, we have procedures-items section 1 through 10
For each provider, we also have procedure-instructions 1 through 10

The crystal report looks like this....

Provider Name

Procedure - Items #1
Item Type, Item Code, Item Description (can be multiple item types, item codes, item descriptions under the Items heading)
Procedure - Instructions #1
"ajalsdfjalsf"

Procedure - Items #2
Item Type, Item Code, Item Description
Procedure - Instructions #2
"alsdjf;alsjf"

Etc... through #10


Is it possible to use TSQL to get something formatted like this where the procedure Instructions #4 will only be listed for the same procedure item #4 and grouped together?

Provider | Procedure # | Item | Item Type| Item Code | Item Description | Instructions | Instruction Description

Smith | #4 | True | Equipment | 24053 | Laser | False | Null
Smith | #4 | True | Equipment | 26356 | Knife | False | Null
Smith | #4 | False | Null | Null | Null | True | "Procedure Instructions here"

=============================================================

Kline |......
Kline |......
ETC.....
Post #1494624
Posted Wednesday, September 25, 2013 9:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 12:43 PM
Points: 219, Visits: 719
Sure that is easy. You would use the pivot relational operators.
Post #1498444
Posted Wednesday, September 25, 2013 9:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 12:43 PM
Points: 219, Visits: 719
Thank you!
Post #1498445
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse