Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhaskar.vce
Starting Member
5 Posts |
 Posted - 2009-07-12 : 22:05:23
|
| I have an issue while generating a report ...i will give my scenarioI have Company ,division and sub division and employeess and their salary..i should get a company level report group by Company,Division,Subdivision with their corresponding salary values and total Salary Values....supposeHp is the company, BCR is the dept and e1,e2,e3 and s1,s2,s3 are sal are the emp i should get like thisHp -------------total sal of emp company level BCR-----------total sal division level e1,e2,e3 ----total sal and i want these things in one column salaries column I have used grouping in report but they are generating Complete total value,i tried to create another dataset but i am unable to use that dataset items in single report....then i have created temp table where i have calculated total values at each level and saved them into these tables and mada join with actual table and i have populated the Report i got what i want but it is taking time , so question is do we have any other way rather than this or can we do with out using temp tables...if yes please let me know Thanks In Advance,,BachiBhaskar Avisha |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
Aggreating Values