Report reuse - One report using multiple record sources

G

Guest

I've taken over a project that has several reports presenting the same fields
based on different queries. So, depending on the criteria, adifferent copy
of the report is used. Is there a way to dynamically associate a record
source with a single report?
 
D

Duane Hookom

If the layout of the fields/controls is the same in all reports, you should
only need a single report. You can dynamically set a filter and/or sort
order in the report. There are lots of previous threads that discussion
solutions for both filtering and sorting a report at run time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Sources - One Report 3
Help with approach to report 5
Automatically create multiple reports from a single report 1
Report for single record 3
Filtering subreports on main report 0
assign record source 5
Multiple record sources 3
2 columns Report with multiple records 7

Top