July 29, 2014 at 2:35 pm
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?
July 30, 2014 at 7:15 pm
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.
July 31, 2014 at 7:27 am
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.
July 31, 2014 at 8:02 am
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
August 8, 2014 at 9:47 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply