Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Adding an average line to a bar chart

Author  Topic 

homeguard
Starting Member

32 Posts

Posted - 2008-05-25 : 12:58:49
I have an average that changes based on the date ranges that the user selects, for some reason it always shows up at 0 value even though i tied the value directly to the textbox, ive tried just about every trick i know. Here is what it looks like.



I want the top level AHT the first chart should be 13.66 the second one should be 8.01.

I can enter a hard value but i need it to change based on what the user enters.

homeguard
Starting Member

32 Posts

Posted - 2008-05-27 : 23:14:19
i found a way, it isnt what i wanted to do though, i just created at temp table that had the calculations in it and added it to the datasource, i guess this is the only way?
Go to Top of Page
   

- Advertisement -