sorchard2000
Technical User
Crystal 8.5
Connecting through SQL Server
I am trying to make a simple listing of all the procedures from our database that we do in our hospital. Every procedure has a code between 1-4 associated with it.
I currently have my data like:
Level 1 Level 2 Level 3 Level4
---------------------------------------------------
(@Level1) (@Level2) (@Level2) (@Level4)
Appendectomy
bump removal broken hip
broken hip etc...
But this produces a listing with lots of blanks in it.
The only grouping I have is for "department_id"
I currently DO have 4 formulas (one formula for each code level) that reads:
if {psmpro.chargelevel_id} = 1.00 then {psmpro.proname_name}
I need to make a list, much like an Excel spreadsheet does where it reads:
Level 1 Level 2 Level 3 Level4
---------------------------------------------------
appendectomy bump removal broken hip open heart
etc...
Is there a simple way to do this or should I just make a small subreport for each level?
Thanks in advance!
sorchard2000
Connecting through SQL Server
I am trying to make a simple listing of all the procedures from our database that we do in our hospital. Every procedure has a code between 1-4 associated with it.
I currently have my data like:
Level 1 Level 2 Level 3 Level4
---------------------------------------------------
(@Level1) (@Level2) (@Level2) (@Level4)
Appendectomy
bump removal broken hip
broken hip etc...
But this produces a listing with lots of blanks in it.
The only grouping I have is for "department_id"
I currently DO have 4 formulas (one formula for each code level) that reads:
if {psmpro.chargelevel_id} = 1.00 then {psmpro.proname_name}
I need to make a list, much like an Excel spreadsheet does where it reads:
Level 1 Level 2 Level 3 Level4
---------------------------------------------------
appendectomy bump removal broken hip open heart
etc...
Is there a simple way to do this or should I just make a small subreport for each level?
Thanks in advance!
sorchard2000