User Supplied Date Function in SAP Crystal Reports 2011

[Former Member]

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 10^th 2014

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

Thanks for the Help!

Tony

[abhilash_kumar]

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

[Former Member]

This Worked.

Thanks Abhilash!

[Former Member]

Hello Tony,

Look into this: 

Thanks,

DJ

[Former Member]

This Worked.

Thanks Dhananjay!

[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