how to limit the characters in the string report parameter?

i have added one string parameter in the report. is it possible to
limit the characters in the string parameter. so that use cannt enter
the characters more than 30.
any suggestions
Thanks
VinodFor your parameter, I assume you use it in your dataset right?
Well it doesn't really matter, but what I was gonig to suggest is that you
do this:
=SubString(@.reportparameter, 1, 20)
Or in your dataset SQL:
(example)
declare @.paramLimitLength
set @.paramLimitLength = substring(@.reportParameter, 1, 20)
exec somestoredprocedure @.paramLimitLength
=-Chris
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161357963.532395.315200@.k70g2000cwa.googlegroups.com...
>i have added one string parameter in the report. is it possible to
> limit the characters in the string parameter. so that use cannt enter
> the characters more than 30.
> any suggestions
> Thanks
> Vinod
>|||Thanks for the reply Chris
No, i am nt using the dataset for report parameter. my new report
parameter is the input to the stored procedure. i need to limit the
characters in the report layout, so that user cant enter the value more
than 30 characters.
i dont know whether we can limit the characters upto 30 in the report
layout.
let me know if you are not clear.
Thanks
Vinod
Chris Conner wrote:
> For your parameter, I assume you use it in your dataset right?
> Well it doesn't really matter, but what I was gonig to suggest is that you
> do this:
> =SubString(@.reportparameter, 1, 20)
> Or in your dataset SQL:
> (example)
> declare @.paramLimitLength
> set @.paramLimitLength = substring(@.reportParameter, 1, 20)
> exec somestoredprocedure @.paramLimitLength
> =-Chris
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161357963.532395.315200@.k70g2000cwa.googlegroups.com...
> >i have added one string parameter in the report. is it possible to
> > limit the characters in the string parameter. so that use cannt enter
> > the characters more than 30.
> >
> > any suggestions
> >
> > Thanks
> > Vinod
> >