To get Aggregate Data In a single row.

[Prakash Bhai]

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

[RobsWalker68]

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

[ksvchowdary]

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.