SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 SSRS 2012 Subscriptions seems to be using old qry
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cmdr_Data
Starting Member

1 Posts

Posted - 12/27/2012 :  21:41:15  Show Profile  Reply with Quote

Using SSRS 2012 I have created subscriptions for reports. The subscriptions email the reports at the time I need them.
However it also emails reports at times that I originally used for testing. i.e. these reports fire off at midnight and I am seeing them at midnight as expected and one of them again at 4pm.
An additional oddity is that I can create the report at my desk and export it as a PDF at my desk and everything is fine. However the emailed PDF report either contains an old formula or query because on of the cells in the report contain the placeholder NaN as the result of some older attempts.
This is my first time working with this version and I am not very experienced. Where do I even begin to look for a problem like this? Only the emailed PDF contains this error. But the old email and old formula possibility seems to be the direction to follow.

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 01/03/2013 :  01:59:35  Show Profile  Reply with Quote
seems like you've duplicate set of subscriptions still existing at server which point to test versions. Have a look at subscriptions in report server.
this can be accessed by connecting to Reporting services instance and expanding home-> subscriptions

see this link

http://www.codeproject.com/Articles/18497/Distributing-Reports-Through-Subscriptions-SQL-Ser

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000