Hi All, I have a report where I need to display the records based on the grouping of WorkcenterID or startdate. I have added a footer with "sum" for timeleft field. whenever I select a particular workcenter from the dialog query..its working fine displaying the sum for that workcenter. But when i open the report without selecting specific filter criteria..all the records are printed and summing the total of all the time left field at the last page. My requirement is to get for each workcenter or startdate..the totalling or sum shud work. Is this possible..please let me know how do you write a query in fetch method. Any thoughts on that is highly appreciated.
Thanks, Raj