Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Dynamic Text based on Parameters

    We are creating a report that is based upon a user selected range of dates. I am trying to have the Title appear on the report based upon that range. Any ideas? Can this be done? Any help would be appreciated...

    Reverie

  2. #2
    Join Date
    Jan 2005
    Location
    Avon Lake, OH
    Posts
    112

    Lightbulb

    Reverie,

    Here's one way:

    I have a parameter field DateFrom. Create a formula field that will return a string, e.g.

    If {?DateFrom} >= Date("1/1/2005") Then
    "This Year"
    Else If {?DateFrom} >= Date("1/1/2004") Then
    "Last Year"
    Else
    ToText({?DateFrom}, "yyyy")

    Drag the formula over as the report title. The title will be "This Year" for any date from 2005, "Last Year" for 2004, and the actual year for any other date.

    You could also use a Display String formula in the format editor for the title field (works in Crystal 10, not sure about other versions).

    Good luck!


    Barry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •