Friday, March 30, 2012

report parameters

Hi
On a 2000 platform is it possible to make a parameter field searchable ?
So instead of just taking the first letter it should search using what the
user enters.
For instance when looking for washington
entering Was would place the marker on washingtonMichael, I'm pretty new to SRS, but I used this in the criteria next to
the column pcname to allow a filter for the pcname in the parameter:
LIKE '%' + @.pcname + '%'
I guess you could leave out the first % sign if you wanted each return
to begin with a particular character. Therefore you could enter Wa in
the field and might return WA9300, WASH93k9, etc. or the way it is
written sWAkjh93, redwakoe might also be returned.
Karen
michael v wrote:
> Hi
> On a 2000 platform is it possible to make a parameter field searchable ?
> So instead of just taking the first letter it should search using what the
> user enters.
> For instance when looking for washington
> entering Was would place the marker on washington

No comments:

Post a Comment