Need Special Report

[Torsten]

Hi!

I need a special Report function. It shoult print 1 Ticket on one Page with the Customer Fields.

Who could do this for me. And to which conditions?

I need it realy fast.

Regards

[jj1987]

SELECT
LEFT( RIGHT( t2.email, LENGTH( t2.email ) - LOCATE( '@', t2.email ) ) , 9 ) AS CLIENT,
t2.ticketmaskid AS TicketID,
FROM_UNIXTIME( t1.dateline, '%Y-%m-%d' ) AS Date,
LEFT( t3.fullname, 18 ) AS Tech,
REPLACE( LEFT( t2.SUBJECT, 45 ) , '\n', ' ' ) AS Subject,
LEFT( t2.fullname, 18 ) AS Requestor,
t1.timespent AS Tspent,
t1.timebillable AS Tbilled
FROM swtickettimetrack AS t1
LEFT JOIN swtickets AS t2 ON ( t1.ticketid = t2.ticketid )
LEFT JOIN swstaff AS t3 ON ( t1.forstaffid = t3.staffid )
WHERE t1.ticketID
IN ( SELECT ticketID FROM swtickettimetrack
WHERE dateline BETWEEN UNIX_TIMESTAMP( DATE_SUB( CURDATE( ) , INTERVAL 14 DAY ) ) AND 

UNIX_TIMESTAMP( CURDATE( ) +2 ) ) AND t2.ticketstatusid =3 AND t1.timebillable >0 ORDER BY 

Tech, Date, TicketID;

There's a DB query that would spit out one ticket per line, maybe you can modify that to your needs.