CR 8.5 - Prompting for Parameter Field(s) values ...

[Former Member]

Post Author: jbdaigle

CA Forum: Formula

I am getting re-acquainted with CR after a 10 tear haidus. I just inherited a CR 8.5 template report to base myself on to produce a new report. This report will produce a dialog box that prompts for field parameter value(s) whenever the end-user refreshes the report. For example the user could select a "ClosingDate" field from the list of available fields and select the current date as a parameter which will force the report to display all entries for the current month.

How is this done. Is there a special functionality or feature in CR 8.5 that allows me to do this? Is this done via formulas - if so, how?

Thanks,

Jean

[Former Member]

Post Author: jbdaigle

CA Forum: Formula

I think I just answered those questions - I looked a little further in the software. However, when I click the refresh button I keep getting the "Refresh Report Data" message. When I go to the original CR report I get the "Enter Parameter Values" dialog box where I can select the parameter field and a value (in a separate pull down field provided automatically by CR). How do I get organized to have something like that to prompt the user whenever he/she refreshes the report?

Jean

[Former Member]

Post Author: jbdaigle

CA Forum: Formula

Bonjour André,

yes that is what I would like to do. How does one go about creating a parameter field though? And how can I edit an existing parameter field?

Jean

[Former Member]

Post Author: John

CA Forum: Formula

Not sure about 8.5 but, in 9, there is a Parameter Field in the Field Explorer box. You just use that to create a new one or edit an existing one.

Hope this helps.

[Former Member]

Post Author: campia

CA Forum: Formula

Hi,

If I understand your question you want to be able to introduce a date period, right?

Create two parameter fields (Startdate and EndDate) with Type = Date.After that in the Selection Formula use the formula: {table.date} in {?StartDate} to {?Enddate}Now you can introduce a date period....

André