Prompt in Crystal report

[Former Member]

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.

Thanks

Syed Faiz

[abhilash_kumar · Accepted solution]

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

[Former Member · Accepted solution]

I have created the prompt but the prompt is not filtering the report data. for example suppose i have report and i create a Location prompt and run the report for location=mumbai, i am getting data for all the locations.

Also i want my report to have run time parameter. i dont want it to be static

[Former Member · Accepted solution]

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.

--Naga

[Former Member]

Hi

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.

--Naga