How to create a dashboard report

[Elaine16025]

I am wondering if Access can be used to create a dashboard report to
display various data at a glance.

Elaine

 

[Duane Hookom]

You can create a main report with multiple subreports. Once a report
displays, it is static.

 

[Elaine16025]

Thank you Duane! Are there any limits as for how many subrepots the
main report can have?

Elaine

 

[Duane Hookom]

Not that I am aware of. There is a limit to the number of nested levels
which you can find by searching Help for "specifications".

 

[John Spencer]

Well, there is a limit of 754 controls (+ sections) on a report. Each
subreport would count as a control and if there was an attached label that
would count as a control. However, your sub-reports could be nested
inside subreports, so...

The practical limit might be speed of building/loading all this information,
plus the ability of the user to handle the amount of data displayed at one
time.

 

[Elaine16025]

Thank you all! I found using Access to the build a chart dashboard is
quite awkward! I have a hard time to set the size of the charts to make
them fix in the limited space...

Elaine