Wednesday, March 06, 2013 12:11 PM
I have created a Range Chart in SSRS 2008 r2 version which uses a particular field called Savings Category as Category Groups (x- axis) . The Field Savings Category is populated with values coming from database as well as few values which is fetched from dual. The Problem in the Range Chart is that the values are not getting displayed for the field Savings Category which has values fetched from dual source and the values fetched from Database has been displayed . How do i solve this problem to display both the values coming from database as well as dual source.
Thanks in Advance,
Wednesday, March 06, 2013 12:34 PM
Are you able to get the data in Query designer ?
It seems you are using Oracle Db as source, since DUAL table doesn't exist in SQL Server. So please let us know.
Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com
Wednesday, March 06, 2013 12:37 PM
Ya you are correct I am using Oracle DB as Source and data does exist for the fields coming from dual source in Query Designer.
Tuesday, March 12, 2013 8:50 AMModerator
Hi Sheethal. K,
To narrow down the root cause, please check the issue with a different type of chart such as a Column chart.
- If the Savings Category field can display well in the new chart, the issue should be caused by the design of the Range chart. Is the Savings Category field placed in the Values area of the chart? If so, right click the filed from the Values area and open the Series Properties dialog box. Generally, we need to set the Bottom value and the Top value. Besides, check whether there are any filters added to the chart or group.
- If the Savings Category field doesn’t display well in the new chart, the issue might occur due to the data type of the field. You can try to convert the field to a different data type to see the result.
If the issue persists, please send me the files to sqltnsp AT Microsoft.com (Please replace AT with @) or upload the files to skydrive.live.com so that we can make further analysis and help you out.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, March 17, 2013 5:21 PM