Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Not displaying values for Few Fields in Range Charts in SSRS 2008 r2

Answered Not displaying values for Few Fields in Range Charts in SSRS 2008 r2

  • Wednesday, March 06, 2013 12:11 PM
     
     
    Sign In to Vote
    0

    Hi,

    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,

    Sheethal. K

    sheethal.k

     

All Replies

  • Wednesday, March 06, 2013 12:34 PM
     
     
    Sign In to Vote
    0

    Hi Sheetal,

    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
     
     
    Sign In to Vote
    0

    Hi Rahul,

    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.

    Thanks,

    Sheethal. K

    sheethal.k

     
  • Tuesday, March 12, 2013 8:50 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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.

    Regards,

    Mike Yin
    TechNet Community Support