Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: How to list parameters on report.

    We have a Crystal Reports developer who is calling stored procedures for her reports. The procedures typically have six to ten optional parameters, primarily for filtering the result set. The parameters are selected from drop-down lists when the report is called. The developer is using Crystal Business Views to prompt for parameters.
    At the top of the report she wants to list the parameters used in the report and the values selected for them.
    Can anybody tells us the best way (best practices) for referencing the parameter values and printing them on the report?
    Last edited by blindman; 09-19-06 at 16:02.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Sep 2006
    Posts
    7
    I'm the developer and I thought I'd provide a little more info.

    We're using Crystal Reports Server XI. We're using Dynamic Parameters with stored procedures as the source. The source stored procedures have two columns: ID and Value. When creating the parameters, the ID becomes the parameter value and the Value becomes the parameter description. We display the parameters with Description only.

    When we use the parameter in a report that has a stored procedure as it's datasource, the parameter value is what is sent to the report stored procedure and the parameter description is lost to the report. I need to display this description on the report. Any ideas?

    TIA.

  3. #3
    Join Date
    Jul 2010
    Posts
    1
    Facing same problem.

  4. #4
    Join Date
    Aug 2010
    Posts
    4
    Hi have you tried creating a formula and then calling the join function(list being the name of the parameter list.

    "Chocolate", "Vanilla" and "Strawberry".

    Join (list)

    Returns the String "Chocolate Vanilla Strawberry".

    Join (list, "***")

    Returns the String "Chocolate***Vanilla***Strawberry".

    Many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •