in that i need to sort first by Check# and than By date, i did it well.
but one Check # is 135 and it’s date is 26 and rest all check # is starting from 393 and date starting from 25,26,27…
now the Issues is, i must need to sort this report by Check# and at the end of the report i need the Total for Date 25, and then Total for date 26 and then…etc…
Because you need to do a summary at the end that is based on a different sort/group, you probably need to look at using a subreport. You would place the subreport in your report footer section, and use the same criteria and tables for it that you use in your main report. Group by date but not by check # and summarize the data there. Link to the main report based on any parameters you might be using to filter the data in the main report (I probably wouldn’t link to fields in this situation.)
(BOB member since 2007-04-16)