Solved

Render History Snapshot from VB code with parameters

Posted on 2009-04-03
9
851 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:CathyChapman
  • 4
  • 4
9 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24069176
what did you mean "history snapshot in SSRS"?
report subscription?
0
 

Author Comment

by:CathyChapman
ID: 24077532
We want a snapshot of the report to be created and saved under the history tab using the parameters that we pass to the report.  Report subscription will not work for this because there are parameters that will need to change with each snapshot.
0
 

Expert Comment

by:Gav-B
ID: 24099335
Perhaps you need a fresh approach.

Have you tried looking into Data Driven Subscriptions? Would they solve your problem?
(I'm still not exactly sure what your problem is)
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:CathyChapman
ID: 24100196
I believe that this would totally solve my problem.  Unfortunately, we have the standard edition of RS where data driven subscriptions are not available....
0
 

Expert Comment

by:Gav-B
ID: 24105310
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?
0
 

Author Comment

by:CathyChapman
ID: 24110592
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.
0
 

Accepted Solution

by:
Gav-B earned 500 total points
ID: 24137350
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.
0
 

Author Comment

by:CathyChapman
ID: 24138162
Your suggestion of setting multiple schedules is a potential solution, but it's not the automated process I am looking for.  I have our Hardware group looking into upgrading to an enterprise version of sql server but the issues around that are probably best for a different question.  Thanks.
0
 

Expert Comment

by:Gav-B
ID: 24138800
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.handshakesoftware.com
Thanks for giving me my first points :) Please post an update when/if you find a better solution.
- Gav B.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
create insert script based on records in a table 4 24
View SQL 2005 Job package 16 70
Sql Server group by 10 45
SQL Error - Query 6 42
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question