Reporting Services :: SSRS Data Driven Subscriptions In SharePoint
Sep 30, 2015
I am looking for a good tutorial on how to set up Data Driven subscriptions through the SharePoint 2012 version of SSRS. I am needing to set up a Data Driven subscription that uses one report, but sends out the specific portion of the report to the appropriate recipients. I have used the information located at URL.... but it doesn't seem to provide all the steps needed to schedule the reports needed. It focuses around setting up the reports to go to shared folder locations. I need something around setting it up to go to email recipients.Â
View 5 Replies
ADVERTISEMENT
Jul 28, 2015
get the data from report to create data driven SSRS Subscriptions,
write query :
Running Report:
View 5 Replies
View Related
Jun 27, 2009
I have researched this question and so far have found very different opinions as to how or if it is possible.I have created 2 Data-driven subscriptions in SSRS. 1 for our sales persons and another for our managers reports. For the salespersons report, the solution works brilliantly as expected and I can appreciated the increased simplicitly for having 1 subscription to drive reports to a sales staff of over 100 folks.One the other hand, I can't seem to grasp the significance of this type of solution for the Sales managers when they have multiple salespersons that report to them.
Apparently, SSRS 2008 has provided no practical solution for this scenario that would be easily implemented in a Data driven subscription.Since I can't find a way to pass in muliple integer values that represent each of the salesreps for a single manager, I am stuck with potentially sending multiple reports for each of the Sales Reps residing under a single manager. Not very elegant or useful as I'd hoped for using Data driven subscriptions. I have even changed the parameter datatype to string and used something like:
paramSalesPeople = substring((SELECT ( ', ' + CAST(territoryid AS VARCHAR(2000)))
FROM Reports..SalesForce t2
WHERE t1.SalesManagerID = t2.SalesManagerID
ORDER BY SalesManagerID
FOR XML PATH( '' )), 3, 1000 )
To create a comma-delimited list of values for the parameters in effort of generating 1 (ONE) record per Manager. But the Data Driven Subscription fails miserably.So the question, Is it or is it not possible to have multiple values passed as a single parameter to a data driven subscription to consolidate the number of required reports into one. If not, it would seem that it should be possible since it can be done from the reports parameters drop-down menu.I have read someones recommendation to script the multi-valued parameter which seems to defeat the intent of the term "Data Driven' Subscription if I have to hard-code this logic into a script.
View 8 Replies
View Related
Jun 11, 2015
I am trying to find a reference for a client that lists the fields available to be substituted into a data driven subscription from the query, along with the expected data types.  For example, the field on whether or not to include a link to the report seems to be expecting a bit data type.I have searched and can't seem to find anything.  I guess I could walk through the interface and try different data types, but if  a list exists, that would be better.Â
View 4 Replies
View Related
Mar 27, 2008
I am running the following ENTERPRISE version of SQL Server, I am admin on the box and do not have the New data-driven Subscription showing up on the Subscription tab.
Does anyone have any ideas why?
Edition Product Level Product Version
-----------------------------------------------------------------------
Enterprise Edition SP4 8.00.2039
View 5 Replies
View Related
Apr 20, 2015
I have a single data driven subscription that is a batch of 250 subscriptions running on SQL Server 2008 R2. All the parameter values for the report are sourced from a database table. During the execution of the data driven subscription 5 of those subscriptions failed due to timeout error.
Final Status as shown on Subscription screen "Done: 250 processed of 250 total; 5 errors."
The SSRS log file has the subscription GUID which is a single record in the reporting server database tables. How can i identify the individual failed subscriptions? Is there an easy way or a work around that i should implement to identify the failed subscriptions?
View 5 Replies
View Related
Jun 1, 2015
I have an issue with a data driven subscription under SSRS 2008R2 in which users are emailed a message based on a condition. For the last two months the majority of the users were mailed the message successfully but this month two users failed to get their message. I checked the selected email address in our mail system and they seemed to be correct. But running these two address (unlike the others which ran sucssfully) caused an error and they did not receive their message.
Â
The error in the SSRS log read:
Â
Line 96485: library!ReportServer_0-81!b9c!05/29/2015-13:25:49:: Call to DeleteItemAction(|eju4fz45zsbn3sykjtpuegec|@|/XX/XXYYZZ/ Report Name123|).
Line 96486: library!ReportServer_0-81!b9c!05/29/2015-13:25:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException:
The item '|eju4fz45zsbn3sykjtpuegec|@|/XX/YYZZAA/ReportName123 |' cannot be found.;
View 3 Replies
View Related
Jun 23, 2015
The 'Data Driven Subscription Button' is missing from the Subscription option for any report developed in Microsoft SQL Server 2012 SSDT...
Following version is running on SQL Server : Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
 Oct 19 2012 13:38:57
 Copyright (c) Microsoft Corporation
 Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
And Report Server Log is saying: resourceutilities!WindowsService_15!a64!06/23/2015-10:05:08:: i INFO: Reporting Services starting SKU: Enterprise
I am having all SSRS roles including Content Manager, Â etc..
View 3 Replies
View Related
Aug 26, 2015
I want to create data driven subscription via Email for SSRS report.
To do so i can add my self either in To or CC.
I don't want multiple mails in my inbox as sent mails have excel as attachment, but I want notification for all the mails sent.
View 2 Replies
View Related
Jan 30, 2008
Hello folks,
Does anybody have experience with e-mail distribution using Data Driven Subscriptions?
I want to build the following:
I have a table with names and e-mail addresses of people in my data warehouse. This table changes over time, more people will be added and data (for example e-mail addresses) can change.
I made 1 report that I want to mail to all the people in the table. This report contains 1 parameter; the e-mail address of a person.
So basically it€™s quite simple: I want to e-mail all the people in the table a personalized (by the parameter) report each month.
Can anybody tell me how I can achieve this with SSRS 2005(SSEE)? I know how to make a data driven subscription but how can I make one pending on the data in a table?
Any help would be appreciated. I will write a blog about this when I've done it so your input will not get lost.
Jorg
View 1 Replies
View Related
Jul 18, 2007
I'm trying to create a subscription that places a file (excel or PDF) in sharepoint. I haven't been able to find a path that works. I was wondering if anyone else had had this issue and how they overcame it.
Thanks.
View 1 Replies
View Related
Oct 9, 2008
I have published SSRS reports to sharepoint and used the Reporting Services Report viewer to present the reports on a Page.  Everything works fine for the day, however in the morning, when I go to view the page, I get an error messageÂ
The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
View 9 Replies
View Related
Apr 29, 2015
I have a RS 2008 R2 SP3 Service in SharePoint Integrated Mode.
Since 5 days my Subscriptions were not sent anymore. I did no changes to these machines. There were some data driven subscriptions in pending state. I delete these entries via SharePoint.
When I look at Report server  Execution Logs, there is no error, that i can associate to subscriptions. New Subscription are created and deleted in the Log, but they will never been processed.
I have done a Reboot to the RS Box but, that was not the solution.
View 4 Replies
View Related
Sep 1, 2015
I have a Daily Invoice Report that has subscriptions for all customers and is run every night. Â The report has parameters of @date & @Customer. Â We had issues with invoices not being sent due to the Owner on the reports was disabled in Active Directory. Â We do not know how many reports did not get sent out so I am tasked with creating a script to rerun the reports for each day in August. Â I have queried the subscriptions, but need to figure out how to rerun the reports using the existing parameters set in the subscription, increment the report parameter date, and execute the emailing of the report.
Here is my query that gives me all the subscription information, but how do I rerun the job for all subscriptions for each date in August?
SELECT USR.UserName AS SubscriptionOwner
   ,SUB.ModifiedDate
   ,SUB.[Description]
   ,SUB.EventType
   ,SUB.DeliveryExtension
[Code] ....
View 2 Replies
View Related
Sep 29, 2015
We couldn't get the report through SSRS deployed URL. Â We found dead locks in SQL DB end.how to proceed further issue resolution.
View 5 Replies
View Related
Oct 23, 2015
I have installed SQL 2012 on my DB Server. The SSRS database version table(s) list the current version as 163. The Version number that's displayed in the Programs and Features for SSRS Add-in for SharePoint (yes, on the db server) is 11.2.5623.0.
On my two SharePoint servers the version number for SSRS Add-in for SharePoint shows 11.2.2058. I have installed SQL Server 2012 Service Pack 2 on all three machines. When the SharePoint box calls into SSRS to render a report I get this error:
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'. --->
Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'.
what else I need to install - and where - to correct this error. What is expecting version '162' and why?
View 2 Replies
View Related
May 13, 2009
I have integrated sharepoint list data to SQL Server reporting services. I am using the below to query sharepoint list data using sql reporting services.
<Query>Â Â <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>Â Â
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">Â Â Â Â Â
<Parameters>Â <Parameter Name="listName">Â Â Â Â Â Â Â
[Code] .....
By using this query, I am getting a dataset which includes all the columns of sharepoint list. Among these columns, I wanted to display only 2 columns (i.e Region and Sales type) using chart. I have created a Region parameter but when I click preview, the drop down box is giving me all the repeatative values of region like
RG1,RG1,RG1,RG2,RG2,RG2,RG2,RG3..........
I wanted to display only distinct values of Region parameter so that whenever end user select region from the parameter drop down, it will display the respective value of Sales type column.Also when I select only RG1 parameter, it is giving me a chart including the sales type of all the Regions. (it should display me only the sales type of RG1) How can I link these 2 columns so that they will display the values respectively. Â
View 36 Replies
View Related
Nov 21, 2015
I have developed the SSRS report and  deployed them on SharePoint 2013 BUt when I run report through  broswer It take long time to execute.
View 3 Replies
View Related
Feb 17, 2012
I replied to an thread in the pre-2010 forum before I realized the forum I was in...
I'm using Visual Studio 2008 to Design my SSRS reports. The report viewer is using SharePoint 2010 SP1 integrated mode.
I am using a conditional statement to determine which report to drill to based on the SSRS textbox's column.
=iif((Fields!Type.Value =
"Total")OR
(Fields!Type.Value ="Variance - (F)/U"),"DivisionSpendingReport","DivisionSpendingReportDetail")
Works fine in Visual Studio. Once deployed to SharePoint though, the drill through returns an error that says report can't be found. So I added the .rdl to the conditional statement in the report Design.
=iif((Fields!Type.Value =
"Total")OR
(Fields!Type.Value ="Variance - (F)/U"),"DivisionSpendingReport.rdl","DivisionSpendingReportDetail.rdl")
It now works in SharePoint but not in Visual Studio...
Do I need to keep adding and removing the ".rdl" in order to make any changes to this report???!!!
View 4 Replies
View Related
Jul 8, 2015
We have a Report Server integrated with SharePoint. A month ago we deployed a report (rdl file) in SharePoint, but the person who deployed it was no longer connected with us. So we decided to deactivate it in our Active Directory. Yesterday, our users returned issues regarding they are unable to access their report. I believe the issue was "object reference not set to an instance of an object".
So I tried to download the rdl file and redeployed it but i am getting error upon deploying to SharePoint. My workaround is to delete the rdl file in SharePoint, redeploy the shared datasource and shared datasets and the rdl file. It went and was now able to run the report in SharePoint.
Is there something relation/happened when deactivating the account in AD that users unable to access the report in SharePoint?
View 2 Replies
View Related
Sep 22, 2015
I have a set of SSRS reports published on the server. It can be accessed through a web application or through SharePoint. Most of the reports work fine through both - web app and SharePoint. However, one of the report, which returns large amount of data has some problem:
1. It generates fine from web app
2. It generates fine from SharePoint; only if one or two values selected from Filter dropdown
3. However, if all items (about 20 items) selected from Filter dropdown... and click on View Report, it processes for a while and then shows nothing. The page remains blank.
Did some research and felt the problem is with Distributed Cache Service.
Tried restarting it; tried changing SPDistributedCacheClientSetting settings - requestTimeout, channelOpenTimeout... but didn't work.
I checked Event Viewer logs, SharePoint logs and SSRS logs but couldn't find any relevant error messages.
View 5 Replies
View Related
Aug 17, 2015
I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server Deployment
[URL]
I am looking to follow the topology example by the letter, which involves installing PowerPivot for SharePoint (aka SSAS in SharePoint mode) in the same server as my SQL, and installing SSRS in SharePoint (SP) integrated mode in the same server as SharePoint.
I understand, however, that if I wanted to install SSRS in SP mode in the same server as SQL, I could but only if the server contains the SP Object Model.
My first question is, what would involve having the SP Object Model in the SQL Server?
Would only installing SP binaries be enough; or Do I need to do a minimal install of SP in the SQL server enough for it to joing the SP farm? And most importantly, what would be the licensing implications for SP in case I want proceed down this route and have SSRS in SharePoint mode installed in the same server as the SQL?
View 4 Replies
View Related
May 22, 2015
I have created a ssrs report using ssrs-2012 that contains 2 tables 2 pie charts and 1 line chart. But I am unable to see 2 pie charts and and 1 line chart after deploying the rdl in sharepoint server.
Why I am not able to see those charts, or sharepoint server will not support charts at all.
View 7 Replies
View Related
Jul 7, 2015
In one of my datasets, my field "Team" is a SharePoint choice column that is a checkbox, so multiple entries are in it. In my Parameter, I have it as a multiple-value, and I'm specifying the values directly in both available and default.For my filter, I have [Team] IN [@Team], which is where the problem comes in. It will only filter the results of entries that only have ONE listed in Team.Â
For example:Â One entry has "Building" in Team column which SSRS is displaying. But it will NOT display entries where "Building" and "Clerks" are displayed. I believe this is because SSRS sees this as 1 line of text, so it does not just see"Building" but "Building" and "Clerks" so it will omit it.I've tried to have my parameter set to "Get values from a query" but the problem there is the drop-down is too confusing since it interprets it as "Building" and then "Building, Clerks", and then "Building, Clerks, Economic Development' as another drop down, which defeats the purpose of the filter.
how I can get SSRS to show ALL entries that contain "Building" when I choose "Building" as a drop-down choice in my parameter? Instead of only showing ones that is Building only and dismissing other teams?
View 3 Replies
View Related
Sep 1, 2015
i have created an report which retrieve data from table which contains a datetime field. The data of that particular field is stored in UTC time. when i navigating the report from sharepoint site i wish the datetime field will be converted into local time based on the selected timezone of the user.
View 6 Replies
View Related
Aug 17, 2015
issue where SSRS reports being executed from a report library in SharePoint intermittently are reloaded after hitting the apply button to run. Â We are using SSRS 2010 and SharePoint 2013 in integrated mode. So a user clicks on the report, fills in the parameters and hits apply. Maybe 70% of the time the report runs fine. Â The other 30% the report just reloads and wipes out any parameter selections. We do have a load balancer in front of the web servers.
I've ran fiddler to capture some of the error logging.
HTTP/1.1 401 Unauthorized
Cache-Control: private
Content-Length: 16
Content-Type: text/plain; charset=utf-8
SPRequestGuid: 3101219d-876e-60c8-a883-dcdee38b81b5
request-id: 3101219d-876e-60c8-a883-dcdee38b81b5
[code]....
Things we have tried. Multiple versions of IE 8,9,10,11, Firefox, Chrome. Â All browsers seem to exhibit the behavior.
We ran so more traffic monitoring and it doesn't appear on these refreshes that report actually connects to the data context so it seems to be failing prior to that. (Possibly at the SharePoint server. Logging from the server apparently didn't show much in terms of when this occurred) It doesn't seem to matter if the report has 1 or 10 parameters.Â
We did notice that when we took the load balancer out of the equation and just hit the web server directly, the refreshes "appeared" to decrease in regularity but still occur.Also, the reports do not exhibit the refresh issue when running locally within Visual Studio 2013.
View 4 Replies
View Related
Mar 6, 2015
We have SSRS reports (pointing to SQL 2012) containing cascading parameters that we have deployed on SharePoint 2013 and once a user makes a selection to the parent parameter, child parameters are getting refreshed based on the selection in the parent parameter and then we see this:
Once we hit Apply, the Loading image comes up and approximately10 seconds later, The whole webpage gets refreshed and the parameter selections get reset to default parameters.Â
This is getting frustrating because there are about 10 parameters in the report and once a user makes selections and hit apply if the page gets reset, the user has to make all the selections again.
We are working with Microsoft support on this who suggested us to increase the timeout setting of DistributedCache service on all our SharePoint servers which did seem to work initially but I do see this issue happening occasionally.
View 4 Replies
View Related
Jan 8, 2007
Hi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
View 12 Replies
View Related
Feb 22, 2007
Is it possible to copy an existing Data Driven Subscriptions and make some minor changes?
Elias
View 1 Replies
View Related
Jan 8, 2007
I am using Reporting Services 2005 locally for testing purposes and also on a production server. Locally, I can create data-driven subscriptions, but not on the server. The only difference I can think of between my local test environment and the production server is the versions of SQL server database. Locally, I am using SQL server 2005 but on the server I am using SQL server 2000 (but with Reporting Services 2005). Can the version difference be the reason for not being able to use data-driven subscriptions?
Note: I have followed various guidelines and walkthroughs that describe how a data-driven subscription is created, i.e. stored credentials on the report server and such should not be the problem.
Operating systems: locally; Windows XP. Server; Windows Server 2003.
Thanks!
/Stefan
View 8 Replies
View Related
Oct 1, 2015
We are facing an issue related to SSRS 2012. We have Reporting Services 2012 configured on a couple of servers. On one server, we have created Datasources and Data-driven subscriptions for our reports and selected email as the report delivery option. But the subscriptions are not working. The LastRunTime column is NULL in the Subscriptions table in the ReportServer database and no email is being triggered. Also, no error message is displayed. The same reporting solution is working on another server that also uses Reporting Services 2012.
View 14 Replies
View Related
Aug 26, 2015
I have a Data Driven Subscription which runs every day for the previous day. If for any reason the report subscription fails, i would like to get the last time it ran successfully. I know in the subscription table we have lastRunTime, but it will show the recent one which failed but i would like to know when it ran successfully last.Â
Example:
Saturday 5:00 AM - Ran Successfully
Sunday  5:00 AM - Ran Successfully
Monday  5:00 AM - Ran successfully
Tuesday  5:00 AM - Failed
LastRunTime column will have Tuesday 5:00 AM.Â
Is there a way to get Monday 5:00 AM which is the last ran successfully ?? How can i get the history of a subscription?
View 8 Replies
View Related
May 22, 2007
hi all,
i built my report with BIDS, configured my datasource and report. then i deployed it. on http://localhost/reports, I to go to the Report, but under "subscriptions", I don't see the "create data driven subscriptions" button.
however, under properties/datasources of my report, I clearly configured the
"Credentials stored securely in the report server"-setting.
Did I forgot something??????
Thx
View 3 Replies
View Related
