Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Report with invalid parameters stops sending subscriptions Expand / Collapse
Posted Friday, April 30, 2010 4:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 10, 2010 3:47 AM
Points: 1, Visits: 5
Hi everyone,

I have a report which is based on assets. Each user selects which assets they want to be notified about using the subscription web interface. For example lets say John chooses assets 1, 2 & 3. Any one of these assets may become undeployed and when it does it will no longer show in the asset drop down list on subscriptions. I've got 2 problems here.

1. Is that when I go in to edit this subscription and bring down the drop down list because it can't find one of the assets it had previously it deselects all the assets. So if asset 1 becomes undeployed asset 2 and 3 are deselected when the subscription is viewed. I do not want to allow new users to select undeployed assets but I do not want it to be removed from a users subscription.

2. If all the assets in a subscription are undeployed then the subscription throws an error : "One or more report parameters have an invalid parameter value" and this causes the subscription to stop because it cannot continue without an asset in the drop down list. If some but not all of the assets are undeployed the subscription continues. If an asset is redeployed it is successfully sent in the subscription again as long as all assets are not undeployed at the same time. I require that the subscription never stops trying as these assets will become redeployed and undeployed all the time and the subscription still holds as valid and should never stop sending.This means that if all assets are undeployed they have to create a new subscription.

I've had some thoughts that it may be possible to create a dummy asset that the user has to select, this means the user must be aware of this work around though and is not ideal. Also it does not fix the problem with deselecting the other existing assets when the subscription is viewed through the web interface.

Could it be possible to make the undeployed assets in the list invisible so they can't be selected but they are still checked by the code. This would require me to edit the aspx pages for the reporting web interface. How is this done?

I've been using SQL Reports for about 2 days now so I'm not very familiar with what can and can't be done. Any help would be much appreciated Thanks! Ron

Post #913558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse