Solved

Render History Snapshot from VB code with parameters

Posted on 2009-04-03
9
853 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 43

Expert Comment

by:Eugene Z
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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
In this article I will describe the Backup & Restore 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.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

628 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