locked
Stacked Bar Chart - setting the max value of y axis RRS feed

  • Question

  •  

    Hello.

     

    I've created an table on a report and it have one group. In this group I calculate the average cost of subordinate items. This value I want to highlight in the table by stacked bar chart, where I've added the

    Code Snippet
    =Avg(Fields!Cost.Value)

     

    as the value.

     

    It looks very fine, but I have an problem - the max value of the y axis will be computed by every instance of the bar chart independently to another instances. And caused by this value 3821 looks bigger than 16289.

     

    The only workaround I've found so far is to create an additional dataset, where I aggregade the costs grouped and get the max value by the sql server site.

    But I don't like this solution, because it is an expensive query and to fire it twice will increase the render time of report and I've to maintain the query conditions in 2 different datasets.

     

    Is there another solution for this issue?

     

    Thanks and bye!

    Anatoli Rejditsch.

    Wednesday, September 19, 2007 8:56 AM