September 13, 2013 at 9:24 am
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.....
September 25, 2013 at 9:29 am
Sure that is easy. You would use the pivot relational operators.
September 25, 2013 at 9:30 am
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply