?
Solved

SSRS - Question

Posted on 2014-07-29
6
Medium Priority
?
199 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 15

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 7

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 15

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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
LVL 7

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 15

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Integration Management Part 2
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…
Suggested Courses

609 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