how to add option for activity log in report?

Open discussion about our Asset Navigator application

how to add option for activity log in report?

Postby ibskyde on Wed Jan 31, 2007 1:08 pm

Hoping someone might be able to point me in the right direction...created a new report that for the most part mimics the built in help desk "All Tickets by Category" report only the new one also searches by date parameters as well. What I'm wondering is how do I get the new report to prompt to display the Activity logs as well for the tickets? I added the HD_Ticket_Activity_List table and linked the Ticket ID with the ID in the HD_Ticket_List table the same way as with the All Tickets by Category report. I've also set up the same SubReport1: HD_Ticket_Actvitiry_List in the design tab, however when I go to run the report I'm never prompted to add the activity logs to the report so I know I'm missing something (I know very very little about SQL so it doesn't surprise me :) ). Any thoughts or hints would be appreciated. Thanks!!
ibskyde
Junior
 
Posts: 2
Joined: Tue Dec 21, 2004 5:59 pm

Postby ibskyde on Thu Feb 01, 2007 5:09 pm

here a pic of the option I'm looking for (forgot to attach previously)
ibskyde
Junior
 
Posts: 2
Joined: Tue Dec 21, 2004 5:59 pm


Return to Asset Navigator 4 Discussion

Who is online

Users browsing this forum: Google [Bot] and 2 guests

cron