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....
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
Procedure - Items #2
Item Type, Item Code, Item Description
Procedure - Instructions #2
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"