Post reply

reference parameter prompt?

  • January 19, 2006 at 11:50 am

    #111303

    Hi,

    Does anyone know how to reference the parameter prompt value?

    I'd like to have a list of the selected filters/parameters at the top of the report - something like:

    Filters: State = WA, City = Seattle, Last Name = Smith

    I looked at the only relevant post to what I am trying to do:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=236918#bm237551

    but it didn't help much.  I can hardcode the values, I don't need to reuse this code for now.

    I have it so that it says:

    Filters = WA, Seattle, Smith

    but I'd like to add the Parameter Prompt = so that the filters make more sense.

    Not sure how to reference. I've tried the obvious.

    Any clues would be great!

    Thanks, Megan

  • January 19, 2006 at 12:23 pm

    #615901

    Never mind, I just hard coded the Parameter Names for now.

    But if anyone has an answer, it would be nice to know.

  • January 20, 2006 at 2:41 am

    #615997

    I think you mean that in the header appear the name and the value of the report parameter selected... maybe you can try with

    parameters!city.label

     

     

  • January 20, 2006 at 8:53 am

    #616120

    nope, that doesn't work, but i'll let you know if i find something that does.

    thanks.

  • January 23, 2006 at 8:21 am

    #616459

    i think a work around is to include the parameters in a select statement in a stored proc i presume and then just display like you would normally do other selected values

    Everything you can imagine is real.

  • January 23, 2006 at 8:22 am

    #616460

    but if you make it clear what you really want, we can have a look at it

    Everything you can imagine is real.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply