Knowledgebase
[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))
Helpful
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.
Jack
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:

http://support.flexquarters.com/supportfiles/Sample VB DOT Net.zip
or
http://support.flexquarters.com/supportfiles/SampleVBDOTNet.zip

Please refer below mentioned article which contains sample ASP,VBA & vbs code:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2204/76/sample-code-for-asp-c-qodbc-connection
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2571/0/using-quickbooks-data-with-vba
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2356/57/qodbc-and-microsoft-visual-basic-and-ado
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2510

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