Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Parameter fields, then outputting all in between?

Status
Not open for further replies.

CInman

IS-IT--Management
Mar 15, 2001
81
GB
I want to ask the user for a Date Range, via the parameter fields. This is easy enough and is done. However, I now have a FROM and TO date at my disposal - how do I output all the dates in between?
e.g.
FROM date = 1/1/01
TO date = 5/1/01
... I want the output to show ...
1/1/01
2/1/01
3/1/01
4/1/01
5/1/01
... preferably via GROUPing so I can subtotal, etc. Any ideas?
 
You need a record selection formula:
{datefield} in {?Fromdate} to {?Todate}

You can also make just one parameter field, and make it a range parameter, there is no need to have 2 parameters.

In terms of grouping, when you group by a date field, crystal will ask you how often the group should be calculated. Just select daily and you will have your report. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
I will try that, and thank you very much for your time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top