Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Charts_PieTypeOnReports.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Charts_PieTypeOnReports.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Charts_PieTypeOnReports.mdb
    Posted: 10 Jul 2008 at 1:36am
This db demonstrates four alternative methods of depicting pie charts (on access 
reports), showing total scores for various codes("G", "R", "Y") pertaining to 
different group leaders.
 
    (a) Style A - RowSource for the chart is filtered as per run time value of key field 
         (GrpID). This is done via user defined function.
 
    (b) Style B - RowSource for the chart is fed run time values of total scores for 
         different codes for the given key field (GrpID). This is done via user defined 
         functions.
 
    (c) Style C - Mini-Query serving as RowSource for the chart is built at run time, 
         directly using values of total scores for different codes for the given key field 
         (GrpID).
 
    (d) Style D - Child field (GrpID) in the chart is linked to master field (GrpID) located 
         in the group header section.

Download Access 2K/XP/2K3: uploads/37/Charts_PieTypeOnReports.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down