Solved

SSRS - Question

Posted on 2014-07-29
6
186 Views
Last Modified: 2014-07-31
Team - I have built around 10 rdl's in SSRS 2008 R2. I have a classic asp page where end user will update the "Report Date" and "Complete" as Status

SQL Table:
ReportDate smalldatetime
Status varchar(max)

Once the user submits the button, SQL table will be updated with the above 2 fields.

Can I ask SSRS to refresh all the reports & download them to a fileshare "//share/reports/" folder after every update in that sql table?

I have heard of Data driven subscription but dont know any idea to get this done.

Any help would be much appreciated.
0
Comment
Question by:Manju
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40226614
Hi,

There is a wonderful article for Data Driven Subscription hope you would like it and it will help you to understand Data driven Subscription..

http://www.experts-exchange.com/Database/MS-SQL-Server/MS-SQL_Reporting/A_10969-Data-Driven-Subscription-using-SSRS-2012.html
0
 
LVL 6

Author Comment

by:Manju
ID: 40226636
Vikas - The above link is for email subscription.

What i need is "file share"

User will save "ReportDate" and "Status" in a table using classic asp front end.

I want the reports to be saved in fileshare after every submit in that table. Lets say that table name is "ReportDataTable"
0
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40226663
Hi,

The method remains same for data driven subscription for file share you just need to select option for file share in place of email in first step
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 6

Author Comment

by:Manju
ID: 40226671
What I meant was... I chose file share and in fact chose the query too. Select * from  report data table. However the file is not downloaded in the share for every update in the table
0
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40228506
See ,

It will be downloaded on the Subscription time and at the time for Subscription it will check the condition that is Data Driven Subscription
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 40229004
If you want to data on some updates then you can go with Data Alert of SQL Server 2012 (SSRS) feature.

It will be integrated with Sharepoint.

It will intimate  if data is related to your wish.

It may help you.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
custom SSRS migration from one server to another 16 47
SSRS Dynamic Column Names 3 62
Ssrs date parameters 12 77
SSRS List box paramaters showing duplicate choices 2 16
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

24 Experts available now in Live!

Get 1:1 Help Now