Home: Completely Web Based: Perfect Tracker:
Perfect Tracker discussion

James Administrator Oct 15, 2000, 5:14 PM Perfect Tracker discussion Welcome to the Perfect Tracker discussion forum. In here you can discuss any questions and answer that you might have concerning Perfect Tracker. This forum is relatively new, but there are many people who visit this site. We just need to get the ball rolling, so feel free to post your question or testimonial. Thanks

Guest Anonymous Mar 13, 2001, 8:04 AM Re: Perfect Tracker discussion I'm new to Perfect Tracker. It is working great in our environment. I was interested in accessing the database through MSAccess/MSExcel - to generate some 'tabular' reports that contain more than 4 fields... ??? ODBC ??? or something like that. Any ideas?

Guest Anonymous Mar 15, 2001, 12:36 PM Re: Perfect Tracker discussion If there are some fields that you always want to show, you can simple add them to the select list. The following makes the tabular report to always show the submitter in addtion to the four dynamically selected fields and the ticket ID. set Local.sql = 'SELECT TICKET_ID, SUBMITTED_BY, ' + Session.QTAB_SQL_SELECT + ' FROM PT5_TICKET'; If you want to be able to dynamically select more than 4 fields to display, you will need to modify RepTab.htx and RepTabRun.htx. You just need to copy the mechanism from the 4 existing fields.

Guest Anonymous Mar 19, 2001, 1:04 PM Re: Perfect Tracker discussion Access has a report widzard for you to build reports. But if you do it that way, the report will not be accessible from the browser.