Report per Record... not all records

  • Thread starter Thread starter Yair Sageev
  • Start date Start date
Y

Yair Sageev

Is it possible to get the following behavior when printing and previewing
reports:

I would like be able to scroll down and get continuos pages for each record
in a report. I want the navigation button to jump me to the next record in
the database and show its report.

The problem I'm having is that we're not interested in printing a report of
*all* the records in the database, just a report for a given set of data
keyed by a unique ID. As a result, page numbering doesn't work because the
next "report" starts at e.g. page 9 and not page 1.

In general, I find that the method for viewing reports using the navigation
buttons conflicts with their function in a form. In a form, we can use tab
panels to place all of the data on a single screen. Navigation buttons
always take you to the next record. With a report the nav buttons take you
to the next page, and consecutive records show up as a consecutive pages.

Is there a way to change this behavior?

Thanks in advance.
 
Thanks Marshall,

One question: The OpenReport takes up to four arguments. If I use the
where clause, do I have to provide a filter as well, or can I just use the
where clause. If the latter is the case, what do I pass for the filter --
null?
 
It's working. Yes, pass null. Thanks!


Yair Sageev said:
Thanks Marshall,

One question: The OpenReport takes up to four arguments. If I use the
where clause, do I have to provide a filter as well, or can I just use the
where clause. If the latter is the case, what do I pass for the filter --
null?



record
in
Click to expand...
report
of
Click to expand...
take
Click to expand...
 
Back
Top