Solved

Render History Snapshot from VB code with parameters

Posted on 2009-04-03
9
843 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
 

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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

759 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now