Community
Showing results for 
Search instead for 
Do you mean 
Reply

Custom fields in reports

Copper Contributor
Posts: 61
Country: USA

Custom fields in reports

Where can I get info on creating/using/modifying custom fields in reports. I need to make a change to the History/Time Spent report and cannot figure out how to modify the days/hours/minutes calculation.
Greater Chicago area ACC
Nickel Elite Contributor
Posts: 595
Country: USA

Re: Custom fields in reports

Out of curiosity, how do you want to change the calculation?
 
That calculation uses a fairly complex Visual Basic script. If you want to view the script, open the template for editing then open the History subreport. Left click on the Detail section and then right click on the detail section and select Edit Report Scripts from the menu.
 
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com
Copper Contributor
Posts: 61
Country: USA

Re: Custom fields in reports

We need to see the total number of hours and minutes; the roll-up into the number of days is not needed. I did what you stated but didn't see any programming or scripts.
Greater Chicago area ACC
Copper Contributor
Posts: 20
Country: Canada

Re: Custom fields in reports

There is code in the OnPrint event of the Footer section.
 
Best,
Wayne
Copper Contributor
Posts: 61
Country: USA

Re: Custom fields in reports

I see it. Great. Thanks.
Greater Chicago area ACC