Post reply

Shared dataset?

  • August 29, 2012 at 11:48 am

    #280664

    Hi,

    2 data regions on my report. graph and tablix

    One stored procedure SP that pulls data in dataset "test"

    for both graph and tablix.

    graph and tablix both have filter on based on field!graph

    field!graph = yes then its on graph , if no then only on the tablix.

    How can I avoid this executing SP twice.

    I tried putting the chart in tablix field but it is not running as desired.

    thanks

  • August 29, 2012 at 12:44 pm

    #1531581

    You should leave your dataset unfiltered and do the field!graph filter on the 'Tablix Properties' > 'Filter'.

    Each object (table, tablix, chart) you tie a dataset to allows you to filter the dataset for the object.

  • September 5, 2012 at 12:27 pm

    #1534063

    thanks for reply . I am trying to insert chart in table. not sure how to do it?

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

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