June 10, 2014 at 11:01 am
I've a report that is published into the SSRS reporting services. This report has a subscription with few parameters.
One of the parameters has multi values (gets values from the database) and the subscription has 1 or 2 values (eg: 99, 9999). The subscription works alright without any issues.
When one of the values say 99 is deleted from the database for some reason, the parameter shows blank and sbscription will fail.
Not sure if this is Reporting services limitation or I could be wrong.
Can some one advise and give suggesstions?
Thanks for your help.
Jay
June 19, 2014 at 8:38 am
Please let me know if there is any information on this. Thanks.
June 19, 2014 at 9:00 am
That would be normal because the subscription is expecting the value to be present. Since it is not, you are getting a null in return and the whole value then becomes null.
If the values are necessary for the report, why would any of them get deleted?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply