on 09-11-2014 5:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
90 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.