Charts_PieTypeOnReports.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |