Post reply

Graph page break after certain amount of values

  • January 19, 2012 at 2:42 am

    #253842

    Hi Guys,

    is it possible to have a 'page break' on a graph? I have maybe 70 entries on the horizontal axis. To have them all on one graph gets very messy. I want to break the graph affter 15-20 entries and start a new graph underneith. I can do it with a number of SQL quries that return the specific selection of data, but can it be done in RS with just one data set?

    if so, how?

    cheers

    Ian

    Ian Cockcroft
    MCITP BI Specialist

  • January 19, 2012 at 7:01 am

    #1435812

    I would think that you can put several different graphs on the page, and apply a filter to each graph for the data elements you want in the graph. This way you only use one dataset and one trip to the DB, but each graph shows only the data you want it to show.

  • January 19, 2012 at 11:55 pm

    #1436293

    Thanks Daniel, in the end I added a row_number column to the sql and used the filter property of the graph to show 10 columns at a time.

    Also had to use the visibility to suppress graphs if the MAX row_number was less than what that particular graph was filtered to show.

    cheers

    Ian

    Ian Cockcroft
    MCITP BI Specialist

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply