Report help needed

[Mister-c]

I've made an activity template for my PC Healthcheck service that adds numerous tasks to the ticket. I want to print a task list out with check boxes and a notes section so that as each task is performed I can tick it off and make any notes. I made a simple report to do this but the problem is the task list doesn't come out in the correct order. They are time ordered on the pending page for the client but it seems to be sorting them randomly on the report. how do I correct this?

Thanks

[Support Team]

Re: Report help needed

Thanks for posting this. I just tested it with system reports and it works well and well sorted. Maybe this has something to do with the customized report. Please test it and check whether it works well with a system report for you.

HTH
Dina

[Mister-c]

Re: Report help needed

Thanks for the reply Dina.

I've tested it with all 3 Calender System Reports and the order is still messed up.

[Support Team]

Re: Report help needed

Maybe you need to re-index your database. While rarely required from what you described it may help. Please contact us directly for more information.

[Mister-c]

Re: Report help needed

Hi, I've re-indexed my database as suggested and it hasn't made any difference. I've even tried creating a new Activity Template and it still seems to sort them with no logic. What criteria does the report engine use to determine the order of tasks?

[Support Team]

Re: Report help needed

Thanks for the update. We've re-checked everything now and as far as we can tell all is working well with Tasks reports - they are sorted by the Task date.
It's either there's a local issue at your end or maybe we simply don't understand what you are referring to. Please send us some screenshots/PDFs that demo the situation and we'll continue from there. Thanks.

[Mister-c]

Re: Report help needed

Ok. I have several pending tasks for my client. they were created in the order you see below:



As you can see task 1 starts earlier than task 2 and task 2 starts earlier than task 3 etc.

If I now run a report such as reports>Calendar>Brief Appointments/Task Report they come out in a random order like this:



Hopefully this makes the issue clearer.

[Support Team]

Re: Report help needed

Thanks! Got that. You are correct and within the same date in reports it is indeed not sorted, but between different days it is sorted correctly (this is how we tested it here). We will open an issue for this in our system so it'll be sorted in the same day as well. Thanks for your help.

[Mister-c]

Re: Report help needed

Is this something that can't be fixed until it is patched in then?

[Support Team]

Re: Report help needed

Unfortunately there isn't a workaround here :-(

[Mister-c]

Re: Report help needed

Is this fix likely to be included in the next update and how close are we to a new update?

[Support Team]

Re: Report help needed

It is on our list. Unfortunately I'm not sure whether it'll make it, we're already in the QA phase of the next release and it's not included. However, we will revisit this and I will post back here in case we have any additional updates.

Thanks,
Dina

[Mister-c]

Re: Report help needed

Hi,

Any update on this?

[Support Team]

Re: Report help needed

No news to share here. We have it filed. Thanks for asking.

[raymond]

Re: Report help needed

Mister-c -- how did you attach screen shots?!?

//ray