stacked column chart
I have a stacked column chart with sales of every branch. There are about 40 branches, so it's becoming a bit difficult to view when the sales figures are displayed for each branch. Can I split the chart into two pages for better view with figures?
May 13th, 2012 8:45am

I think yes, you need to filter out branches in select statements , so it could be parametric or just two data setsBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2012 8:47am

I am calling a stored procedure as dataset like this: EXEC AP_S_SALES_SUMMARY_REPORT @fromdate, @todate It will lead to the output as branchname branchid netsales netsalesbymanager From the above, Branchname is taken in Category group on x axis, and netsales and netsalesbymanager as stacked columns on y axis I am not sure how the branches can be filtered to get the chart in two pages. I am very new to this. Could you please help me in this.
May 13th, 2012 1:49pm

Hi, If the branch names are specific and you know about the same, then you might split the queries itself to filter the data based on the supplied branches and hence, use 2 datasets with 2 different queries to display 2 charts on single or separate pages. Thanks, Niraj
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2012 1:56pm

Hi There What you could do you can filter your charts based on your BranchID For example your first chart might be displaying only first 20 BranchID id so you can put filer in your chart something Where BranchID <=20 And in next chart you can put condition BranchID > 20 I am putting screenshot for your help. Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. Due to some reason I could not upload Images
May 13th, 2012 5:17pm

I tried that way. Branches are split into two charts. But the since the branchnames are not stored in alphabetical way in the table. I am getting the two charts with branchnames on x axis not in alphabetical order and the user could not be able to analyze properly. is there any way i can split the charts so that the branchnames are in alphabetical order starting from the first chart
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2012 5:10am

Hi There You will be able to sort your chart based on your branches name. please right click on your department category and go to properties and then sort What I will suggest you please bring your dataset in the branches name order and create an auto number inside your query based on Alphabetic order of Departments so that you can easily put filter on your chart. So your department name will be in alphabetic order and you can give them an auto number For example if you have 40 department then sort then alphabetically and then put filter on that auto number column so that first 20 will be in the first chart and other 20 will be in other chart and you do not need to put filter on department id Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
May 14th, 2012 5:23am

Hi Ragavalli, As Syed posted above, you can create two Stacked Column Charts and add filters to each chart. What I would like to explain is that you dont need to create an auto number in your query in order to filter the category group. Actually, after you sort the branchnames category group by A to Z as Syeds screenshot showing, you can directly add a filter to the category group like the one below: Expression: [branchnames] Operator: Between Value: val1 val20 Then, the chart will only display the alphabetically branchnames between val1 and val20 (including val1 and val20). If you have any questions, please feel free to let me know. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 6:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics