Main Index MAIN
INDEX 		Search Posts SEARCH
POSTS 		Who's Online WHO'S
ONLINE 		Log in LOG
IN
Home: Completely Web Based: Perfect Tracker:
Perfect Tracker discussion

 
PreviousPrevious Thread    Next ThreadNext    Print Thread          
Author Subject:   Perfect Tracker discussion

James
Administrator

Oct 15, 2000, 5:14 PM

Perfect Tracker discussion Quote | Reply
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 Quote | Reply
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 Quote | Reply
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 Quote | Reply
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.


PreviousPrevious Thread    Next ThreadNext    Print Thread        
 
 


Search for (options) Powered by Gossamer Forum v.1.1.8