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

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 03:52 PM

    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é

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 03:53 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 06:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2007 at 08:12 PM

    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

    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.