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 fields it gives me in the report designer pertain to the worklog table?

I thank you for any help!

---

Josh Jones
Software Developer
Insequence Corporation
Nashville, TN

If you need to create a report that contains both worklog data as well as other data from other tables you may need to consider a fully custom report (Other Reports).  You can write your own query to return the data you need (preferably write a stored procedure that you call from the report).  This way you can return any data you need and put it in the report, however, the downside is that you will lose auto filter abilities from OnTime (the report cannot use the filters from OnTime).

---

Dan Suceava
http://www.axosoft.com

Yes sir.

 Since the post I made, I finally realized that was the way I needed to go. And I did notice the inability to utilize the filtering after I got my reports working the way I wanted via the custom report method.

I, too, thought of doing it in a stored procedure so I could *theoretically* allow my users the option to input variables such as date ranges.

Is there a way to do that within OnTime? For example, when they click on the custom report it may pop up a C#/VB style inputbox where they can define dates, etc?

On the same note, could you be so kind as to tell me about the custom filter ("Use filter SQL") that is on the reports when you double click on them in the "Manage Reports" dialog? I toyed with simply putting a "WHERE Date > 6/10/07" sort of thing, but had no luck. In short, how does this feature work? I get the impression that it is alarmingly simple, but have had no luck :)

Thank you for the response by the way.

 

---

Josh Jones
Software Developer
Insequence Corporation
Nashville, TN

The ability to prompt users for parameters for the reports is something that we would like to address in a future version of OnTime, at this point it only works for built-in reports.

The filter is just the 'where' part of the query, without the 'where'.  So you almost had it right, just ommit the WHERE.  For dates in particular you'll also need the quotes (e.g. Date > '6/10/07')

---

Dan Suceava
http://www.axosoft.com