February 28, 2011 at 1:31 pm
I am currently using SQL Server 2008 R2 Report Builder 3.0. I have created a bar chart report that has a single parameter. That parameter is displayed on the y-axis. When it is selected the value becomes the text on the y-axis. That works properly. However, the data does not display properly. When I select the first value in the parameter list, that works fine. However, no other parameter displays any data. What am I doing wrong??? HELP!!!
February 28, 2011 at 9:52 pm
Hi !
Is there a link betwn the parameter value and the value which conditions it ?
Like City Table:
No City
1 London
2 Amesterdam
Query in your chart
Select Emp, Value from Sales where City = 'London'
Here instead of London u need to map the No field, which might have got stored in the relational sales table.
If the above is not please ignore.
March 1, 2011 at 7:29 am
I am connecting to a SharePoint list for the y-axis values. I have the parameter added and it points to the appropriate column in the SharePoint list. To me, it doesn't make sense why it works for one and not all.
March 2, 2011 at 8:27 am
I don't know how to modify the query to add a where clause because it is in XML. Again, I have one parameter. That parameter appears in a drop down list properly when I run the list. The list has the appropriate values. The axis on the chart displays the appropriate value that was selected from the drop down. Its just the actual data on the chart does not change. The category group is set to the parameter. I do not understand this. It should not be this hard. :unsure:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply