Report - query issue

kwokm67

I think we have a bug when generating a report that runs a query.

My report runs the query below which prompts the user for Date From and Date To.

FIND Appointment WHERE Appointment.Organisation.Organisation=ThisAppointment.Organisation.Organisation AND Appointment.DateOfEvent>=?'Date From' AND Appointment.DateOfEvent<=?'Date To' ORDER BY Appointment.DateOfEvent,Appointment.StartTimeSC DESC,Appointment.RoomName

My database has entries From November to middle of December 2009.

Issues:-
1) If the user select say 1st Oct to 31st Dec 2009, the report sometimes comes up with no entries.
2) When the report do show entries you get the correct number of records but some of data on some of fields are repeated.

Support, if you need a copy of my BSV or access my app online please let me know. If I am doing something wrong please correct me.

aware_support

Please purchase a support ticket and send us the details of the remote connection to your machine as well as describe steps required to reproduce the problem.

kwokm67

Hi Support,

Is there a reason I need to purchase a support ticket?

My report is just running a simple query to select a set of data between specified date range and display in my report.

pbrad

My guess is that your problem stems from the volume of appointments or your server/memory setup, not the AwareIM application. Are you using the old or the new calendar version? If you are using the old app and have a lot of appointments, try viewing it wit the new calendar view.

Cheers,
Pete

kwokm67

Back on this project again. I am not using the old style calendar.

It appears that sometimes I need to run the report with the same date range several times to get the data displaying on the report.