group sections in a report to print or generate subreport

Hello all,

Is it possible to generate a report (or a subreport) that will allow a
separate report for each server (for grouping and printing purposes)
if I have many server names (with DB, Apps, etc.) in one huge report.

Maybe using a button on the large, main report (with all server names)
to print the server name on the current page along with the server's
information? Or instead of printing maybe there could be another
button that could generate a subreport of that current page's server
and it's information?

My question is:
After generating a report, how does one go about grouping sections
together in the main report to print or to generate a subreport of a
specific grouping?

Thanks,
Dave

Use the Sorting and Grouping dialog?

--
Duane Hookom
Microsoft Access MVP


"David W" wrote:

Hello all,

Is it possible to generate a report (or a subreport) that will allow a
separate report for each server (for grouping and printing purposes)
if I have many server names (with DB, Apps, etc.) in one huge report.

Maybe using a button on the large, main report (with all server names)
to print the server name on the current page along with the server's
information? Or instead of printing maybe there could be another
button that could generate a subreport of that current page's server
and it's information?

My question is:
After generating a report, how does one go about grouping sections
together in the main report to print or to generate a subreport of a
specific grouping?

Thanks,
Dave

Is the data for all servers in the same table?
If so, there is no need for a sub report, use Sorting and Grouping the group
the servers.
If not, your database design needs rework.
If you want to show only one server on a report or a group of servers, use
the Where argument of the OpenReport method.
--
Dave Hargis, Microsoft Access MVP


"David W" wrote:

Hello all,

Is it possible to generate a report (or a subreport) that will allow a
separate report for each server (for grouping and printing purposes)
if I have many server names (with DB, Apps, etc.) in one huge report.

Maybe using a button on the large, main report (with all server names)
to print the server name on the current page along with the server's
information? Or instead of printing maybe there could be another
button that could generate a subreport of that current page's server
and it's information?

My question is:
After generating a report, how does one go about grouping sections
together in the main report to print or to generate a subreport of a
specific grouping?

Thanks,
Dave