SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2005 Parameter validation


SSRS 2005 Parameter validation

Author
Message
e.j.egan
e.j.egan
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 46
It's also created some issues. My boss now want to ensure we are validating user entered values. His fear "...what to prevent someone from entering a select * or delete statement". Fine. But the parameter is defiined as a varchar(4) so it will only pass the first 4 characters anyway.
dorai.pandi 54335
dorai.pandi 54335
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: 3
Hi,
This is working fine in the solution(i.e., rdl file when I preview) but not working from report server.
It's throwing some error like :
Error during processing of ‘ValidateDate’ report parameter. (rsReportParameterProcessingError)
What can be done to solve this kind of issue?

Thanks
Dorai Pandi.P
sgmunson
sgmunson
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7209 Visits: 4382
Given the level of angst on this topic, I wonder if perhaps using SSRS is really the right solution for a scenario with what amounts to a desire for "cascading" parameters (a parameter that depends on the value of another parameter, or for a rather complex mix of inputs, all requiring validation. Seems to me that kind of requirement is far more appropriate to a developed application than to a reporting scenario.

The idea behind reporting is to keep it simple, and 11 parameters, while possible, is way beyond simple. That's not to say SSRS can't do it, but I question any kind of "reporting" being labelled as reporting when there are that many parameters. How can one person really keep track of that many selections? Something is missing here...

Just my two cents...

Steve
(aka sgmunson)
:-):-):-)

Steve
‌(aka sgmunson)
Smile Smile Smile
Health & Nutrition
CozzaroNero
CozzaroNero
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 271
Hi there,

you said
"In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the FX button then paste this code =CODE.CheckDate( .Value) "

Unfortunately, the option "Non-Queried" doesn't exist.

For Default Values, I have ticked the radio-Box for Specify Values, clicked on the Fx button and copied =CODE.CheckDate( .Value).

For Available Values, I'm not sure what to select, if I select "NONE", I received an error message about this newly created parameter:
".... BC30157 Leading '.' or '!' can only appear inside a 'with' statement" that is documented in this page
http://msdn.microsoft.com/en-us/library/1f35a50w.aspx

What should be the set-up for "Available Value" ?

Thank you,
AL
MMartin1
MMartin1
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2837 Visits: 2031
I would just add that if a start date is greater than an ending data, there should be no data returned. The user will get the point sooner or later, though it helps to have that hidden message appear at this time, as described earlier.

----------------------------------------------------
How to post forum questions to get the best help
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