Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
problem in pie chart

Answered problem in pie chart

  • Saturday, September 01, 2012 4:03 PM
     
      Has Code
    Sign In to Vote
    0

    hi

    i create a dataset for pie chart that the quary of that is 

    ="SELECT    competitor_annual_Plan.year , competitor_annual_Plan.parent_competitor_nameName , " &
                      "competitor_product_info.quantitylastyear "&
" FROM     competitor_annual_Plan , "&
                      "competitor_product_info "& 
                      "WHERE   competitor_annual_Plan.competitor_annual_Plan_code = competitor_product_info.parent_competitor_annual_codeName "&
" AND (competitor_annual_Plan.year = " & Parameters!year.Value & ") "&
 Iif(Parameters!product_family.Value="0",""," and competitor_product_info.MSC_product_family = " & Parameters!product_family.Value )

    the above quary is true, and  my pie chart work properly( i set  quantitylastyear filed as value of pie chart but i wanna replace sum of that )

    for this perpose i change my quaey to  below quary but doesnt work and my pie chart is empty


    ="SELECT    competitor_annual_Plan.year , competitor_annual_Plan.parent_competitor_nameName , " &
                      "sum(convert(float,competitor_product_info.quantitylastyear ))  as total"&
" FROM     competitor_annual_Plan , "&
                      "competitor_product_info "& 
                      "WHERE   competitor_annual_Plan.competitor_annual_Plan_code = competitor_product_info.parent_competitor_annual_codeName "&
" AND (competitor_annual_Plan.year = " & Parameters!year.Value & ") "&
 Iif(Parameters!product_family.Value="0",""," and competitor_product_info.MSC_product_family = " & Parameters!product_family.Value ) &
 " group by competitor_annual_Plan.year , competitor_annual_Plan.parent_competitor_nameName

    • Edited by shabnam2012 Saturday, September 01, 2012 4:24 PM
    •  
     

All Replies

  • Sunday, September 02, 2012 11:40 PM
     
     Answered Has Code
    Sign In to Vote
    0

    Hi,

    Please try this one:

    ="SELECT    competitor_annual_Plan.year , competitor_annual_Plan.parent_competitor_nameName , " &
                      "sum(convert(float,competitor_product_info.quantitylastyear ))  as total"&
" FROM     competitor_annual_Plan , "&
                      "competitor_product_info "& 
                      "WHERE   competitor_annual_Plan.competitor_annual_Plan_code = competitor_product_info.parent_competitor_annual_codeName "&
" AND (competitor_annual_Plan.year = " + Parameters!year.Value + ") " +
 iif(Parameters!product_family.Value="0",""," and competitor_product_info.MSC_product_family = " + Parameters!product_family.Value ) +
 "group by competitor_annual_Plan.year , competitor_annual_Plan.parent_competitor_nameName"

    Share the result please.

    Cheers

    Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP