[QODBC-Desktop] How to Setup User Prompted Date Ranges in Crystal Reports
Posted by brad waddell on 12 March 2009 05:21 PM

How to Setup User Prompted Date Ranges in Crystal Reports

Date Range Setup with crystal Reports X and Before

Setup as Parameters DateFrom and DateTo

     With Crystal Reports X version and before, just set up DateFrom and DateTo parameters to be used in the sp_report like this:

Date Range Setup with Crystal Reports XI

     With Crystal Reports XI, you can select the prompted value type as a DATE, making it easier. For example:

sp_report ExpenseByVendorDetail show Account, ClearedStatus, SplitAccount, Amount parameters DateFrom={?DateFrom}, DateTo={?DateTo}

(172 vote(s))
Not helpful

Comments (2)
Teresa Thomas
19 November 2014 11:32 PM
I would like to do something similar with Excel. Even better, how can i setup the from and to dates to calculate the last three months. i.e. if today is 11/19/14 i would like the report to run from 8/1/14 to 10/31/14.
24 November 2014 11:50 AM
Hi Teresa,

I would like to inform you that you can do this by writing code as per your requirement. I kindly request you to please refer below mentioned link to the sample VB.Net project: VB DOT

Please refer below mentioned article which contains sample ASP,VBA & vbs code:

You can refer above code & make changes according to your requirement.
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).