Is it possible to deal with consolidated dataset in SSRS?
Hello, Here is my sample data. Notice that I have data stored at the consoladated levels month, quarter, season,year. Its it possible to create a report from this dataset and still have groups? I would like to pull week into the details section and create groups for the consolidated levels, but i dont want to aggrate at the consoladated levels and just pull the values at those levels. there will be times that i would like to "override" the consoladated level based on data in the detail section.
October 30th, 2012 12:54pm
Hello, Based on your description, we can create a recursive hierarchy group. In Reporting Services, a recursive hierarchy group organizes data from a single report dataset that includes multiple hierarchical levels, such as the report-to structure for manager-employee relationships in an organizational hierarchy. To create recursive hierarchy group, please refer to the following steps: 1. Create a dataset that contains all the hierarchical data. 2. In Design view, add a table and drag dataset fields to the data region. 3. In the Row Groups pane, right-click Details and then click Group Properties. 4. On General tab, click Add in Group experssionssection, and select the file to group in the Group on list, for example Time Id. 5. Go to Advanced tab, select Time Parent Id in the Recursive Parent list. When preview the report, the report displays the recursive hierarchy group. In order to show the hierarchy, we can format the recursive hierarchy group with indent levels. For more information, please see: How to: Create a Recursive Hierarchy Group Regards, Fanny LiuFanny Liu TechNet Community Support
October 31st, 2012 1:14am
Hello Fanny, This will force all the data into the details section of the report. I know i can indent to make it "look" like groups. But I actually need groups so that I can override some monthly, quarter and year calculations. for the most part I would want to get the consolidated value from the dataset but there will be times that i need to say sum the weeks and / by X at the monthly level. the solution proposed cant deal with that, correct? is there a way to say put the week in the detail section and actually create SSRS groups BUT rather the sum(value) somehow refer to the consoladated value oin the dataset? let me know if youhave any qurestions.
November 3rd, 2012 9:53am
November 3rd, 2012 3:19pm