Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report with invalid parameters stops sending subscriptions


Report with invalid parameters stops sending subscriptions

Author
Message
mrfroth
mrfroth
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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

:-D
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search