Skip to Content
avatar image
Former Member

User Supplied Date Function in SAP Crystal Reports 2011

Hello,

I am new to SAP Crystal Reports 2011 (Crystal Reports).

Does anyone know of a function in Crystal Reports that allows a user supplied date?

I will need a User Supplied Date in a Report that Allows a User to Select Records based on a Date or Date Range.

--For example, a User may want to see a list of Customer Software Licences granted on January 10th 2014

or a list of Software Licence applications granted between October 1st 2013 thru December 31st 2013 --

Thanks for the Help!

Tony

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 11, 2014 at 04:35 PM

    Hi Anthony,

    Open the Field Explorer and create a parameter. The Type of the prompt should be 'Date' or 'DateTime' depending on the datatype of the field in the database. In the Prompt options you should have an option to make this a Range by setting the 'Range Values' to 'True'.

    Once the prompt is ready, go to Report > Selection Formulas > Record and use a formula similar to this:

    {Database_Date_Field} IN {?Date_range_prompt_name}

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2014 at 04:34 PM

    Hello Tony,

    Look into this: Crystal Reports 2011: Prompt for a DateTime range

    Thanks,

    DJ

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dhananjay,

      I need help with Stored Procedures in Sap Crystal Reports 2011 (Crstal Reports).

      Can you help me or direct me to a tutorial that speaks about this?

      Specifically, I created 3 Reports using SQL (in command) with 3 DSNs

      but I need to store them in a Procedure using only 1 DSN.

      Thanks for the help!

      Tony