Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports Parameters

Hello SAP Users:

I am having some problem with Crystal Reports and Parameters. I want to put only those values in the parameter field to be selected by user that are selected by some query by the parameter itself. For example if I have a GroupCode field, I will like to retrieve only those values in the parameter field which are less than 101 from the database from which user will be select values according to his needs.

Regards.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 04, 2012 at 03:35 AM

    Hi Salman

    First, create a parameter with name XXXX@select * from OWHS

    XXXX is the parameter in SAP user input, then @, then query

    then filter data only the parameter value by click select expert

    The above method can be used for 8.8,

    cheer

    Gary


    parameter.png (15.5 kB)
    recordfilter.png (6.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 03, 2012 at 03:17 PM

    Hi Salman,

    You would need to write a separate SQL Query and add it as a 'Command Object' in the report.

    You don't need to link the fields in this query to the other tables of the report. This query would be used as source for the parameter.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2012 at 08:21 AM

    Thanks a lot to both of you guys. I stand grateful.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.