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!

Multiple Parameters RE: Dates

Status
Not open for further replies.

jhooker

Technical User
Apr 17, 2013
7
US
Hi all~

I’m trying to pull data in Crystal and am stuck on how to do so logically.

I’ve got a set group of data that I want in every report. I’ve given each record a date value of 09/09/1999 and a series identifier of “DR01” through “DR470” to distinguish this lot.

I want the user to be able to pull up a specific period through a dynamic parameter (exa., 04/01/2013 through 04/30/2013), but still have this 09/09/1999 default data as part of the returned set behind the scenes (i.e., without user interaction).

All the data is located in the same table.

Ideas?
 
Setup a Date Range parameter {?Dates} so users can select their date range.

In Record Selection:
(
{DatabaseDate} = {?Dates} or {DatabaseDate} = Date(1999,09,09)
)
 
Well, I was trying to make that a million times harder than it was.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top