Hey all, I am trying to get a report to print out in TGO.
I want the Instrument setup time, Setup point #, Backsight point #, Foresight point #.
The thing that I am having trouble with is the Timestamp that is in the DC file.
I can go thru the whole 64 page DC file and do this manually, but i know there has to be an easier way to do this.
I have the report generating Setup, backsight, foresight, just need that setup timestamp in there.
any ideas Trimble gurus?
Doug
Make a custom query
If you have Microsoft Access 2000 or later you should be able to make a custom query that includes the records you want.
The main concepts of building custom queries in Trimble Geomatics Office (TGO) are covered in the built-in help under "Database Queries - Overview".
You can find that easily by opening TGO's Help, then do a word search for "query".
The other instructive topic is the one called "To create a new query". That topic includes the details on deleting the schema (DBS) file so the new query is available after TGO automagically rebuilds the DBS file.
So, if one of the existing queries has most of what you want/need, one way to get started would be to make a copy of it by:
1. Open the existing query with Access, then change the View to SQL View.
2. Copy the SQL code to the Windows clipboard
3. Close the existing query, then click on "Create a query in Design View". Close out the dialog asking you to select tables/queries, change to SQL view, and paste the SQL code from the existing query.
4. Save the new query using the naming convention you see in the Query objects so the new name will be available when building your report.
Depending on which tables hold the additional information you need, this may give you all you need. Otherwise, expand the query to bring in the additional data.
If you have an IT person there familiar with Microsoft Access you should try to get them involved from the beginning.
If you make a template from the project that has the custom report, and then that custom report will be available in all subsequent projects built from that template.
Sometimes you can get additional information out of TGO just by specifying the table column where that information is located, you do not always have to make a custom query. This is discussed in the Help topic titled "Database Field Codes".
GB
Hi,
don't know if TGO will handle the timestamps, I think they're not imported in the TGO table 'Terrestrial Setup'
I think the way to go is with the xml style sheets this are the newer Custom Reports that can be generated on the dc or the office pc (with the Ascii File Generator.)
You'll find the stylesheets on the first link,
I use the 'Survey Report' and the 'Prodcutivity Report'
List of Available Style Sheets
succes!
chr.
Good info Glenn...
But I have to agree with Christ...
The custom style sheets are the way to go.
Yup, especially if the desired information is not in any of the database tables as Christ pointed out.
GB
