Hi,
I am attempting to do some reports from Liberum Help Desk. I can produce reports successfully for the full data range that we have been running the helpdesk, but cannot get the monthly data out correctly.
The monthly data returned has the same amount of jobs as the full data range.
If anyone has modified the .asp for these reports (viewreports.asp and/or reports.asp), could they please post some code here?
My SQL is limited, so any help is most appreciated.
Many thanks,
Yvette
I thought I would add some more info to this problem, as I have not heard anything ffrom anyone ...
When attempting a Department report from 01/01/2009 to 12/31/2009 the following info is returned;
When I change the date, to get the report for December only ... from 12/01/2009 to 12/31/2009 I get the following information returned. The report query is not being changed to reflect the change in dates, and the data returned is the same as above.
Any help with this would be most appreciated.
HI yvette, as you've not reposted you've either figured this out... Or not!!
It would be better to post the actual structure of the SQL query you're using rather than the results. The initial query and then how you tried to filter by date would be good. It is going to be a simple query structure problem.