Hi. I have a hosted instances of OnTime that is working very well.  But I need some reports that are not available in your standard list of reports.  I remember at a previous company using an earlier version of hosted OnTime, I was able to download the SQL backups on a nightly basis and build reports directly against that ...

Hi. We would like to relate customers to projects, so it is possible to get project reports and task reports for a specific customer. We have a custom field in the Project Layout called Customer Contact, and mapped this through a pick list to all customer contacts. We would like this to be a linked list with two pick lists one for Customer and ...

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 ...

Hi Dan, it's been a while! I've since tried your suggested changes and it does reduce the pagecount to 1. But presented on the page is Defect Found (only the first of 5 workflow steps) 140 (the total number of defects within the project, which are at differing workflow steps) So, stating the obvious, it doesn't seem to be splitting ...

Hello Scott, We've integrated OnTime with a report designer by DataDynamics called ActiveReports.  There is some basic information on working with the Report Designer and scripting in our user's guide, which can be found here on our documentation page:http://www.axosoft.com/support/default.aspx?cn=sup_docs The best place for more detailed ...

I have copied the same exact stored procedure from this forum post and tested it on my end. The application did not seem to generate any errors when attempting to create a new custom report. Can you please give me the exact reproduction steps on this issue? Where do you exactly see this error message? Are you running the latest OnTime 2007 ...

I saw several posts about this but I have been unable to get any of the suggestions to work. I have the completion date field on a custom report and where there is no completion date filled in for a task it prints 01/01/1899.   I have some code in the detail format event handler:           dt = ...

Hello Joshuah, There is a way to insert your company logo into a report, here's how:- Within OnTime, go to ''Reports>Manage Reports''. - Select the report you want to alter, and click the icon in the toolbar that's labeled ''Make a copy of the selected report or shortcut''. You'll notice a yellow copy of the selected report will appear below ...

Hi, I am trying to do exactly what Greg is/was trying to do so any help that you can provide would be greatly appreciated. e.g. For a worklog report that uses the following stored procedure (spS_WorkLog_WithNames) how can I access the parameters @FromDate and @ToDate and include those on the report? I need to be able to print the period that ...

Hello Dan thanks for your reponse and help. I did give this a shot but unfortunately the report came back empty. The project I had selected when the report was run has approx 250 defects in it at this point. I've attached a screen of the new report criteria and the output. If you could give it a quick once over to check I've made no glaringly ...

Hello All, We have a need to edit a custom worklog report that we've copied from the built-in worklog report in OnTime 2007. Over in our New Programming tab, we have information that I want to include in the worklog report (Job Number and a Billable column) How would I include this into the custom worklog report when it appears that the only ...

The only way that you can have a report that would give you both defects and features together would be to create a custom report via SQL statements in the OnTime application. Below is an example of a custom SQL report that has combined defects, features, tasks and incidents into one single report. Thank you,

Hi, I have just started using Ontime and have been asked to make some changes to some reports.One of the changes is to change the padding inside a Richtextbox. I have tried to add the following code to the C# scipt for ...

When creating a custom report in OnTime, it is recommended that you have some basic knowledge of SQL and Active Reports. Below is an attached text file that gives you an example of how to create a custom report by using SQL statements. This particular SQL statement will give you all open defects, features, tasks and incidents from the OnTime ...

You would need to create a custom report in the OnTime application that will give you a detailed list of defects and features together in one report. Once the report is created, you will also need to specify how to filter this information based on the particular version within the actual report. To create a custom report such as the one that you ...