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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating report based on a range of dates!!

Status
Not open for further replies.

trapb

Programmer
Dec 11, 2002
4
0
0
RW
how do I create a report using a range of dates to print data for that period?

I have a stock management problem!!
I need to create a report that prints the goods received and the goods issued when I specify a range of dates!! I thought I would specify the dates in a masked edit box in VB but how do I get the report in seagate?

 
Create a date range parameter, which will prompt the user for what start and end date for the report. Then write a record selection formula to restrict your report to those records with that date, similar to the following:

{YourDateField} in {?DateRangeParameter} Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Create two Parameters {?StartDate} {?EndDate}

and in the Formel Editor from the Selection formula you write

{YourDateField} >= {?StartDate} and
{YourDateField} <= {?EndDate}
 
Create two Parameters {?StartDate} {?EndDate}

and in the Formel Editor from the Selection formula you write

{YourDateField} >= {?StartDate} and
{YourDateField} <= {?EndDate}

I hope this help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top