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
 
You must log in or register to reply here.

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

Using VBA To Enter A Sumproduct Formula Into A Cell 0
Excel Import External Data by Date Automatically 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Access 2000 Parameter Prompt in Report 1
how to creat dashboard 1
Help in creating Excel Dashboard 4
Excel Graphs on Access Forms 3
Weekly Reports 1

Back
Top