Is there a way to create Stored Procedures directly in OnTime. Or is this something we need to do in SQL management first, then call them from ontime. I  have looked through the User manual and the Administrators Manual and have not found much information on Stored Porcedures other then they can be used, and can simplify creating ...

Hello... The current Work Log report is does not have some of the fields that we would like to have on the report.  Is it possible someone can help me modify spS_WorkLog_WithNames stored procedure.  I would like to add field from DefectCustomFields.Custom_121 if ItemType = DefectFeatureCustom_Fields.Custom_123 if ItemType = ...

Hi... I want to add a new report for Work Logs.  I have a SQL Query that I've created and want to use that.  I've read in forum that I can add under ''Other Reports''.  However, when I go to Manage Reports, I do not see any options under Other Reports.  When I expand Work Log Reports, I can add another Shortcut but it does not ...

I am a contractor working with a client using OnTime 2004 Web Edition. For tracking certain metrics, I cut-and-paste the Defects list into Excel and generate PivotTable Charts.  Because of the way the cut-and-paste technique is working*, this is very time consuming, taking over 30 minutes for less than 300 Defects to be pasted into an ...

Good morning, I'd like to do the following: 1) Create/Edit embedded subreports. I currently cannot find where to do this, nor can I edit existing subreports from copies of the default reports provided. 2) Attach a specific report behind the right-click pop-up menu options given from the various tabs. IE: Features tab, right-click a line item, ...

How can I use ''OnTime Report Designer'' with OnTime Web Edition 2007 ?   Thanks Alberto Acosta   

I am new to SQL, but understand the logic. There are several reports that I would like to have created (hopefully more of taking a standard OnTime report and then customizing). Is it easy to learn how to do the stored procedures for the reports? Or is it just easier to get a person that understands sql to do the report?  

Hi does anyone know how I could create comparative and/or measurement type reports? I would like to produce a report that tells me how long each defect took (from Defect Found to Defect Fixed) to resolve and to group these by severity and/or impact with averages times for each (severity/impact).

The kind of reports that we have in OnTime have produced some questions recently from our users.  Right now our reports fall into six categories:   DefectThese reports focus on different aspects of defects:  as a list, in a more detailed paragraph report, by user, by status, by estimated/actual time, and fixed/foundFeatureSimilar ...