Hi All,
I have branches in that, one branch has following departments i.e cse,ece,csit,mec,civ.I kept value prompt
on branch.when i select one particular branch i am getting all departments information but i want
aggregation of those departments in one single row.please can u post ur ideas how to solve the issue
Regards,
Ram
Hi Ram,
If you remove those items from the report that are unique and group and summarise on the common items then this will produce you a single line. Would you be able to provide an example of what you want to create.
Kind Regards
Rob
If you get a chance please send an XML file.I will give better solution.
Mean while in the filters put that branch prompt.
For Ex:
1.create the prompt page and take value prompt and use the data item value and display value for Branch prompt. ex for promt name = ?Branch?
2. go to Query Explorer and chose ur query and in the detail filter use this like [Branch]=?Branch?
3. Run the report with your selection.
Note : Observer the Aggregate and Rollup aggregare functions properties in the report and grouping levels as well.