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
Patrick ChapmanProgrammer Analyst, Business IntelligenceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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..
Patrick ChapmanProgrammer Analyst, Business IntelligenceAuthor Commented:
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.
PortletPaulEE Topic AdvisorCommented:
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.
lcohanDatabase AnalystCommented:
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.
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Problem is the models that come back in the query should be dynamic.

If that is the case, then Sub reports should work fine as mentioned by lcohan.
Kindly try it once and let us know for more details.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.