By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

Summarizing Grouped data in Report

P: 46
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
Jan 3 '08 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,365
Well, seeing as how you want two different reports, just create two different queries for the reports. Besides, since your other report is only going to be aggregate, nothing's going to happen if you don't have all the detail data in the query.
Jan 3 '08 #2

P: 46
I think I figured it out. I was not using the grouping/sorting properly. After doing that, it was cake. I'm such a novice.
Jan 4 '08 #3

Rabbit
Expert Mod 10K+
P: 12,365
Glad you figured it out. Everyone starts out as a novice.
Jan 7 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.