- Category: Blog
- Published: Wednesday, 12 June 2019 14:25
- Written by Ray White
From http://www.stdtime.com This video describes how to put custom fields onto reports. To begin you can see I have the Project Tasks tab selected and I have a couple columns here that are custom fields. You may not realize that but I’ve actually added these as custom values. I’ve entered some values and some other values are computed. If you go to the View menu and choose Columns and then click Custom Fields you can see these extra fields that I’ve added.
What I want to do is put these onto a report. These are the two fields I’ll put on the report and the first thing I’ll draw your attention to is this long, ugly number down at the bottom of this dialog box. That is the data base column that would be added to the report. You may have renamed this column but this is the default format that they come in. Write these numbers down so that you can drag and drop them onto a report. Let’s go ahead and close this.
I’m going to run a Project Tasks report, click OK. The first thing you should do is go to the File menu and choose “Save As.” Don’t change this report because you may want to go back to it as your default. Always choose File “save as” and create a completely different report. Then we’re going to go into the Design View; I’ve got a couple columns here that I’ll get rid of and we’ll put in our custom fields. This first one was the margin, so let’s rename the header and then we had CostPlus.
The next thing we’ll do is click on this tab that says Fields. And you see some of the database tables that are included in this report. Yours may look different depending on which tables are available. I’m going to open up the Project Tasks table, scroll down and we’re going to find all of the fields that I can drag and drop onto the report.
The first one, you remember, was this one. Let’s drag that onto there, these are the ones I asked you to write down. I’ll take this and right align it so that it looks real nice as a number. Go back in here and do the next thing with this one.
We’ve dragged both of those onto the report and resized them and changed the alignment so they look nicer. So we’ve Margin and CostPlus and these are the custom fields that are in the database. We’re working in the Design View; we’ll go back up to the Preview tab and click that. Then scroll down here to that project that we saw earlier. Those are the custom values that we saw earlier on the Project Tasks tab.
They show up here in the report because I dragged them from the fields over onto the detail section of the report. Of course you can drop that into any section that you would like but we happen to be working on the detail section so I dragged them there and that is how they show up. You’ll want to choose File, Save As but in my case I’m going to close the report and not save and here are the values again on the Project Tasks tab. Hope this tutorial helped!
See more at: http://www.stdtime.com
Standard Time ► http://www.stdtime.com
Twitter ► http://twitter.com/ScoutwestInc
Facebook ► http://www.facebook.com/timesheetsoftware
Linkedin ► http://www.linkedin.com/company/scoutwestinc
Pinterest ► http://www.pinterest.com/scoutwestinc
Android App ► http://play.google.com/store/apps/details?id=com.scoutwest.standardtime
iOS App ► http://itunes.apple.com/us/app/standard-time/id818412788
YouTube Subscribe ► http://www.youtube.com/subscription_center?add_user=scoutwestinc