How to create a dashboard report

  • Thread starter Thread starter Elaine16025
  • Start date Start date
E

Elaine16025

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

Elaine
 
You can create a main report with multiple subreports. Once a report
displays, it is static.
 
Thank you Duane! Are there any limits as for how many subrepots the
main report can have?

Elaine
 
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".
 
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.
 
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
 
Back
Top