Skip to Content
0
Apr 09, 2014 at 05:59 AM

how to use hard coded tables

87 Views

Hi all

i want to generate report by this fashion where all the values i can put with separate variable

like for below

eg: for total column of Utilization =[total] where([Service]="Utilization")

for total column of Office Visits =[total] where([Service]="Office Visits")

Item Service Current Quarter Previous Quarter Total Dollars amount Total Dollars amount 1 Utilization 70 $560.00 $2,431.61 0 $0.00 $0.00 2 Office Visits 4 $10.00 $136,170.10 0 $0.00 $0.00 3 Stays 0 $ 0.00 $ 0.00 0 $ 0.00 $ 0.00

please reply

Thanks in advance

Ranjeet