Post reply

Can I have a description witha parameter ?

  • June 5, 2013 at 9:59 am

    #278677

    Hi

    can I use a description for a parameter(Like Crystal)

    Example

    I get clientid and clientname for query

    but I only want to show clientname in parameter but use clientid for value

    Thanks In Advance

    Joe

  • June 5, 2013 at 11:25 am

    #1621434

    Yes, there are 2 values associated with a parameter, the Label and the Value. The Label is what is displayed to the user, the Value is what is passed to the query.

  • June 5, 2013 at 12:02 pm

    #1621450

    Thanks for the quick reply

    But how do I assign one a value and one a label ?

    I have it setup to get avalable values from a query via dataset2 example: select distinct id,name from client

    Thanks

  • June 6, 2013 at 6:42 am

    #1621710

    jbalbo (6/5/2013)

    Thanks for the quick reply

    But how do I assign one a value and one a label ?

    I have it setup to get avalable values from a query via dataset2 example: select distinct id,name from client

    Thanks

    Sounds like you only need one parameter with some type of drop down. In the parameter properties, choose to get available values from a query. Add the connection to your dataset (dataset2) and then choose the value and label fields from the drop down. The label is what the users will see, the value is what will be sent to your query.


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

  • June 6, 2013 at 7:35 am

    #1621739

    Thanks so much...

    wow.. I totally missed that!!

    Even though I looked at it 100 times!!!

    Thanks

    Again

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

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