Skip to Content
avatar image
Former Member

Prompt in Crystal report

How to create prompt in Crsytal report XI. i googled and i found "


Select the object you want to apply a prompt on and drag it to the

Query Filters Pane


But my question is where is the

Query Filters Pane?

Can somebody guide. if somebody can attach screenshot then it will really help me.


Syed Faiz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 08, 2012 at 03:55 PM

    Hi Syed,

    The Query Filters pane appears when the datasource is a Universe.

    To create a prompt in Crystal Reports, Right-click the Parameter option under "Field Explorer" and click "New".

    In the parameter creation window, type in a name, select the datatype, select the prompt type (Static/Dynamic).

    Then use this parameter in a formula or drag it on the Report Header to see the prompt.

    - Abhilash

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Syed,

      You can go to the 'Report' Tab--> Selection formula's --> Record-->

      In the formula window you need to write the below formula.

      Database field = parameter.

      after apply the formula, you can able to filter the records based on parameter.


  • avatar image
    Former Member
    Nov 08, 2012 at 03:59 PM


    you will create the report level prompts in the field explorer. and then you can goto 'Report' tab and select select 'select expert' --> select record and apply field on the prompt.

    else if you would like to create query prompt then you can goto 'ADD command'. In the ADD command window, their is an option 'Create Paremeter'. you can create parameter their and assign that prompt to that field in that where condition.


    Add comment
    10|10000 characters needed characters exceeded