Link to home
Start Free TrialLog in
Avatar of Patrick Chapman
Patrick Chapman

asked on

Dynamic pointers in SSRS report

Need to find a way to have summary and detail pointers in a bullet graph in SQL Server Report Builder 2008.  My data comes in from a dynamic number of model types and I need to have them as a pointer within a "summary of all models" pointer. I have done it statically, but not where model count can change depending on what our plant is building.
BufferOverviewV2.pdf
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Kindly request you to provide more details on what is the issue you are exactly facing so that we can try to sort it out..
In the meanwhile, please find below some sample examples with how to format a bullet graph better in the below link..
http://blogs.adatis.co.uk/timkent/post/How-to-Bullet-Charts-in-Reporting-Services-2008

>> I have done it statically but not where model count can change depending on what our plant is building.

Above example is kind of dynamic and you would need to ensure that you have the necessary fields captured for every single model you expect in the graph..
Avatar of Patrick Chapman
Patrick Chapman

ASKER

thanks for the feedback.  The issue is that instead of the pointers in a bullet graph pointing to a  columns in one row of data, I need it to be almost like a detail and summary graph to show the main bar for the sum of the car models in my example but also have pointers within to show the detail count for each model.  Problem is the models that come back in the query should be dynamic.  The Passat and Atlas lines are specific columns in a summary record instead of individual detail records with a summary of the records for the main green or red bar you see in my attached picture.  Need to know if possible to do this.  Would try in another chart type but need to be able to show the range markers too to show if we are in a safe count range or too low or too high.  Hope that helps more.
I know almost nothing about SSRS, but your current chart data has to be coming from somewhere.

Is this a query? Can we please see that query?

It may be possible to retain the "dynamic" element AND present a grand total row - but with no information about how you gather the information now, it is impossible to suggest any solution.
If I understand correctly
I need it to be almost like a detail and summary graph to show the main bar for the sum of the car models in my example but also have pointers within to show the detail count for each model.

leads me to think that a linked subreport or maybe just a drilldown could serve the purpose. Please have a look at the link below maybe one of these options will help you to get the summary/detail needed.

I think you should be able to use and pass
...the range markers...
to the linked report as input parameters as noted here: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-a-subreport-and-parameters-report-builder-and-ssrs?view=sql-server-2014
To specify parameters to pass to a subreport....This value can be static text or an expression that references a field or other object in the main report.
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial