May 11, 2011 at 6:26 am
Hi all,
when i run the report for all the values selected in the paramters ,report is throwing error has "Unclosed quotation mark"
but the same report is working fine for the few selected data in the parameter.
we are using dynamic query in SQL.
is there any size limit for dynamic sql query?or it is limitation in SSRS 2008?so that parameters can hold only restricted no. of values.
May 11, 2011 at 6:35 am
In the parameter you'll have 1 or more value that has an apostrophe in it. That cause the concatenation to generate an invalid query and gives you the output you're having right now.
For future refferences, plz don't post the same question in different forums, we monitor them all, equally!
May 11, 2011 at 6:40 am
in that case it should have threw error when i select few data in the parameters but it is working fine if i select few data
May 11, 2011 at 6:44 am
You're not giving any usefull info to help you.
unclosed quotation mark means you have something like this in your code :
where whatever = 'ok'wrong'
it should be
where whatever = 'ok''wrong'
If could also be an expression where you forgot a quote ("). But you should always get that error (I never had it intermitently).
May 11, 2011 at 7:00 am
Look at your parameter data. Does any of it have a quotation mark in the actual data?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply