1. 

   biceda, Member

   Hi,

   Is it possible to allow some special characters in the User Parameter input fields?
   I understand limiting to Text only to reduce SQL injection issues.

   I'm trying to pass an Item code into a select statement that has "-" in it. eg Item code "100-075-AA00"

   It works in report filters, but fails on User Parameter input fields.

   Thanks.
2. 

   myDBR Team, Key Master

   Hi,
   there are no limitations on characters in the user parameters. Could you elaborate what your report parameters looks like and the problem you are facing. Do you get an error message or what is the problem?

   --
   myDBR Team
3. 

   biceda, Member

   Hi,

   Sorry, fixed issue. Simple mistake, my SQL statement didn't have the User Parameter enclosed in quotes.

   Thanks,
   Darryl.

Reply

You must log in to post.