Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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.

Very Important crosS Applying yaK Herder

52326 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

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next 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.02 seconds. Powered By: Snitz Forums 2000