Search in reports (1 Viewer)

rythem

I.S Analyst
Local time
Today, 04:56
Joined
Mar 28, 2005
Messages
30
When i get a report, it has pages full of information. I want to be able to display a selective report based on the date.

Is there any way that i can enter the date and the report shows me information based on that date alone.

Thanks
 

KenHigg

Registered User
Local time
Today, 07:56
Joined
Jun 9, 2004
Messages
13,327
Put something like the following in the reports underlying query's date field as a parameter:

[Enter date:]
 

rythem

I.S Analyst
Local time
Today, 04:56
Joined
Mar 28, 2005
Messages
30
date

Should it be unbound?

I will need to write a code for it to check and display the reprot for that date?
how do i do this.

I hope i am getting it right.

thanks
 

KenHigg

Registered User
Local time
Today, 07:56
Joined
Jun 9, 2004
Messages
13,327
In the query that you use for the report, you should have the date field. On this field, in the query builder one row is called 'Criteria'. Just type the code I supplied on that row, in the date column. That's it. When you run the report, or preview/print the report, you should be prompted to enter a date. Which is then used for the criteria.
 

rythem

I.S Analyst
Local time
Today, 04:56
Joined
Mar 28, 2005
Messages
30
Report

Hello,

this works thankyou so much.
 

Users who are viewing this thread

Top Bottom