We have a need to initiate the creation of a history snapshot in SSRS from a VB application. The report(s) that need to be run have parameter values that need to be passed to them. We are having trouble figuring out how to set it up so the snapshots are created.
We can update reports and make them run using SetExecutionOptions when there are no parameters but this method doesn't allow for parameters and we have not determined the correct way to do this.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
So then; the solution to your problem is to get the full version?
Sounds like you have a good business case for it! - You don't get what you don't ask for.
Aside from DDSubs I know that if you setup parameters in a report they are available in an orginary schedule, although one at a time, so you'd need to setup multiple schedules for each parameter.
...or is that not true for the standard edition either?
It would be a good idea to set up multiple schedules, except for one small problem. I don't have a set date and time when the schedules would need to be set for. We have a VB application that is being called from a job scheduler in our enterprise accounting package. This is doing all of the month end activities. At the end of this job is when we want the reports to run. Some months this might be the 3rd day of the month. Other months it could be the 4th, 5th, 6th, etc... and there is no way to know exactly when all of the month end processing is complete so that the reports can be run. Hence why I want a VB app that can just create the snapshot and save it to history on demand.
It is a bit difficult to advise around your custom VB app without coming into your company as a business analyst.
As an interim to something better; set multiple schedules (shared ones where appropiate) for the 6th of each month. Then if you really need of them before that on a certain month you can manually change the schedules to run on the earlier day.
It's not pretty, but it is a solution.
The something better is upgrading so you have DDSubs available. A good in-house VB developer would also be a good idea (something I am not..).
Aside from Reporting Services, also look into "Business Objects - Crystal Reports" and "Handshake", which provides very powerful data driven reports.
I loth having to do anything manually, to the point of almost automating myself out of a job! :D
So I'm sorry I cannot provide a full solution without looking at your VB app & intergration.
I seriously advise checking out Handshack though, it's a very powerful programme. My company uses it to great effect.
www.handshakesoftwa
Thanks for giving me my first points :) Please post an update when/if you find a better solution.
- Gav B.
Business Accounts
Answer for Membership
by: EugeneZPosted on 2009-04-04 at 14:49:01ID: 24069176
what did you mean "history snapshot in SSRS"?
report subscription?