Morning all...hope your not feeling the cold.
I have a report that returns list of open tasks in a workflow management application I have built. In addition to the general fields on the report (Task_Number, Title, Date, Due_Date...etc) I would also like to include a listbox below (within the Detail section of the report) that returns a list of actvity records for this Task...from an activitiy table.
The problem is that I have set the criteria for the list box to look at the task number on the report and it works fine for the first record on the report but it then shows the same results in the listbox for every record after that. It is looking up the task number and then doesn't look for it again when the next record is generated.
I hope this makes sense. I would really appreciate any help you may be able to give on this one.
Have a great day!
Gareth
I have a report that returns list of open tasks in a workflow management application I have built. In addition to the general fields on the report (Task_Number, Title, Date, Due_Date...etc) I would also like to include a listbox below (within the Detail section of the report) that returns a list of actvity records for this Task...from an activitiy table.
The problem is that I have set the criteria for the list box to look at the task number on the report and it works fine for the first record on the report but it then shows the same results in the listbox for every record after that. It is looking up the task number and then doesn't look for it again when the next record is generated.
I hope this makes sense. I would really appreciate any help you may be able to give on this one.
Have a great day!
Gareth
