Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Paging A Stacked Bar Chart Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 2:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 1, 2014 9:23 PM
Points: 23, Visits: 111
What our users want, sorted largest - smallest on the x axis for y axis value.

I tried the put chart in list, set list to same dataset as chart, rename details row group, apply ceiling using RowCount to new grouping. And this worked, but it worked to limit the original records BEFORE any of the additional grouping in the chart is applied.

So say the first column in the chart is composed 35 individual records. It would display the chart based on the first 10 of those individual records, next page, another 10 individual records and so on.

I need it to page based on number of columns in the (overall) chart, not individual records in the original data set. Is there any way to accomplish this?
Post #1597492
Posted Wednesday, July 30, 2014 7:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:49 PM
Points: 171, Visits: 501
I think what you need to do is calculate the y-axis aggregate values in the dataset query using SQL or as a calculated field in the dataset. That way you can leverage the y-axis value for the sorting and grouping of the rows in the data and thus control the paging of the bar chart also.
Post #1598062
Posted Thursday, July 31, 2014 7:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 1, 2014 9:23 PM
Points: 23, Visits: 111
Yeah, I was trying to avoid that since it would add more complexity on the SQL side. There are currently different grouping criteria that are handled in formulas within the report. Some are based on record count, some are based on actual value, or a sum of values.

If there's a way to do that within the report it would likely be a lot cleaner.
Post #1598256
Posted Thursday, July 31, 2014 8:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:49 PM
Points: 171, Visits: 501
Perhaps what you need to do is specify the scope of the RowCount function to a higher level of grouping than the immediate, default scope.

For example, suppose there are three levels of grouping on a table: Group A, Group B, and Group C, each one nested inside the previous group such that Group C is the detail grouping, Group B contains Group C, and Group A contains Group B.

If you have a text box in Group C and you have an expression of = RowCount(Fields!field_name.Value), you will get a value of 1 since Group C is the detail "group." But in that very same text box inside Group C you can have an expression of =RowCount(Fields!field_name.Value, "Group B"), and that will usually return a value greater than 1; it will show the number of rows in Group B that are grouped along with the current individual row of Group C. The same logic applies to = RowCount(Fields!field_name.Value, "Group A").

You can even have = RowCount(Fields!field_name.Value, "dataset_name") to return the count of rows in the entire dataset.

Hope this helps,
Geoff

Post #1598281
Posted Friday, August 8, 2014 9:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 1, 2014 9:23 PM
Points: 23, Visits: 111
Thank you for your suggestions, but I've about come to the conclusion that there is no way to do this. The problem being that I need access to the final generated results, not the raw incoming data. Something like applying filtering after the category axis sorting, not before it.

I'm trying to simulate functionality on another older system users are used to. Horizontal scrolling pages the chart 10 items on the x-axis at a time.
Post #1601245
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse