Solved

Render History Snapshot from VB code with parameters

Posted on 2009-04-03
9
850 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

810 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