Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Render History Snapshot from VB code with parameters

Posted on 2009-04-03
9
Medium Priority
?
857 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 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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 

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 1500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

824 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