Questions about Orders Management Database Sample Previews By Empl

[Guest]

I'm trying to figure out how this report limits the data displayed to a
certain date range. I see that it calls another form to get the begin and end
date, but I can't see how that limits what is displayed in the report. Can
someone explain this?

Brice

 

[Guest]

Hi Brice,

Try looking in the query that is powering the report. It's probably
limiting the date range in there.

Damian.

 

[Guest]

It does not appear to be tied to a query in the DB. It calls a form to get
begin and end date. Based on your information, I dug to find out how a report
refers to a query.

I opened up the properties of the report and this solved the mystery.

Under the Data tab, there is a field called Record Source. Looks like they
used BUILD to create a report only query and one of the fields in this report
only query has criteria based on the form data queried by the report. Didn't
know you could call a form to get data AND create a report only query using
that data to decide what to display on the report. Live and learn.

Thanks for the lead.

Brice