[Rt-users] Help with Reports

[phillip]

Thanks that solves half of my problem so how do I get the requstor name into 
the report and  and get all the tickets for the whole month?

On Thursday 15 April 2004 08:44 am, Helmut Lichtenberg wrote:
> On Thu, Apr 15, 2004 at 07:47:50AM -0400, phillip wrote:
> > I'm trying to write my own report directly . But what i want is to see
> > report containing only the name of the requester, the timeworked total
> > per month, the owners of each ticket by name not by number as in one of
> > the reports that i generated. so please help.
>
> That's basic sql. One example:
>
>    Select Tickets.id,
>           Tickets.TimeWorked,
>           Tickets.created,
>           Tickets.Priority,
>           Users.name
>    from tickets, users
>    where tickets.owner = users.id;
>
> HTH
> Helmut