locked
Charts on multiple pages?? RRS feed

  • Question

  • Hi All,

    I am using SQL Reportig Services 2005 for displaying reports in Bar Graph charts. The problem is that the width of each bar in chart is not fixed and changes based on volume of data. If number of rows retrieved by dataset connection are many, then the graph appears too cramped and is not readable.

    Is there any way, programmatically or at design time, that we can change the width of chart based on number of rows retrieved in the dataset?

    Any help or reference will be highly appreciated.

    Thanks in Advance !!!

     

    Thursday, April 27, 2006 2:17 PM

Answers

  • Assuming all the data you are showing as bars are really detail rows rather than grouped data, you could consider the following approach:

    Add a (detail) group to the list with the following grouping expression:

    =Int((RowNumber(Nothing)-1)/20)

    As a result you would get 20 detail rows per (repeating) list instance. Then just put the chart inside the list. Those chart instances will never "see" more than 20 detail rows at once.

    -- Robert

    Thursday, April 27, 2006 4:17 PM

All replies

  • Assuming all the data you are showing as bars are really detail rows rather than grouped data, you could consider the following approach:

    Add a (detail) group to the list with the following grouping expression:

    =Int((RowNumber(Nothing)-1)/20)

    As a result you would get 20 detail rows per (repeating) list instance. Then just put the chart inside the list. Those chart instances will never "see" more than 20 detail rows at once.

    -- Robert

    Thursday, April 27, 2006 4:17 PM
  • Thanks Robert !!!

    The solution given by you works fine. But I did not get what you mean by 'data you are showing as bars are really detail rows rather than grouped data'.

    Is there any limitation to the approach that you have given?

    Thanks for reply once again !!!

     

    Friday, April 28, 2006 6:40 AM