Progress Bar in Reports (1 Viewer)

hmoritz72

New member
Local time
Today, 06:02
Joined
Nov 17, 2008
Messages
8
I am having some issues figuring out how to display a progress bar per record in my report in Access 2010.

I have two fields called CurrentProgress and ProjectDays. My intention is to divide CurrentProgress by ProjectDays to get a percentage of progress.

My other option is a field called ProcessStatus which has a value of 1,2,3 and 4 (corresponds with Design, Build, Inspection and Lab). I could use this information also to reflect the progress if I need to.

Is there a way to show in the report, per record a line or rectangle with that percentage (or process status) displayed? Like a bar graph. I have tried so many things but am at a loss for what to do. Anything will help!
 

CJ_London

Super Moderator
Staff member
Local time
Today, 11:02
Joined
Feb 19, 2013
Messages
16,605
you can use a line or a box control depending on the dimensions required

then, depending on which section you put it you can set its height or width as required with some code in the onformat event along the following lines

'100% completed=4" width = 5760 twips @ 1440 twips/inch
me.linecontrolname.width=currentprogess/projectdays*5760
 

Users who are viewing this thread

Top Bottom