Forum

This content is now out of date.

Visit Our Community

Limit number of values plotted in chart

Hi,

We are building a report that has both a table and bar chart. The data is in the format , but we are never sure how many rows we will get but it could be 100s.

The table is able to be paginated in 100 row increments but the chart tries to plot all the rows.

The makes the chart unreadable as we have 100s of bars on the same chart.

Is there any way of only charting say the top 20 values but still allowing the table to display all rows?

Thanks,

Michael

Forgot to mention that we are using a Stored Procedure based view which means we can't simply add a filter to restrict the number of rows.

This would also restrict the number of rows displayed in the table which we don't want to do.
Hi Michael,

Unfortunately the chart is tied to the table, as they report off the same report definition.

What you may want to think about is creating a co-display report.
You can have 1 report show just the table with all 100 results, and the other report can be limited to show only the first 20 (chart only).

This should give you the results you were after.

Regards,
David
David, how do you limit the co displayed chart (chart only) as you mention above?

I have a report showing all results and want the co-displayed report to only show the top 10 results.

I can't figure out how to specify the top 10 only.

Thanks