I'm trying to create two reports that produce the same data. One is a summary report, the other is detail. The detail report, for example should display all the recrods below, but combined. For example all data with conftype field = 41, should be one record and so on, with the final value totals combined.
I'm afraid that I will not be able to do so. please advise me on how I can sum up each conftype by final value without losing all of the data. Thank you.
my query on the form.
select '200701','200712',eid,name,conftype,rate, rotation,confattendance, confoffered,sum(finalvalue)FinalValue from ViewConfAttnRate where period between '200701' and '200712' group by eid,name,conftype,rate, rotation,confattendance, confoffered order by name
the following gets returned in sql server:
the following gets returned in sql server:
eid conftype rate rotation confattended offered finalvalue
9503 4 0.3 1 3 12 0.833333333
9503 41 0.3 1 4 10 1.333333333
9503 4 0.3 2 1 13 0.256410256
9503 4 0.3 2 7 12 1.944444444
9503 41 0.3 2 8 16 1.666666667
9503 4 0.3 3 4 13 1.025641026
9503 41 0.3 3 4 16 0.833333333
9503 39 1 5 5 5 1