Create a macro button that will filter / sort, then print out a report.
Posted by Greg Henngler on November 18, 2001 2:31 PM
I have a 14 column daily report that I need to group by column B, then descending sort by column K within the new groups. Once this is done, I want it to print. To make this as user-friendly as possible, I'd like to attach all that to a button to allow someone to just perform the simple task of clicking.
GH
Posted by Richard S on November 18, 2001 5:02 PM
If I am interpreting you correctly, Sort by column B first, then by column K. You can then use data sub-total at each change in column B and click on Page Break between groups. Is this what you wanted?
Richard
Posted by Richard S on November 18, 2001 5:04 PM
And if that works the way you want, just record a macro from the tools menu, create a button from the forms menu, and assign the macro to that button.
Richard
Posted by GH on November 18, 2001 7:46 PM
OK, that works, but now I have a small formatting issue. Is there a way to sub-total and page break like you indicate without have sub-totals and grand total lines in the report itself?
Thanks
GH
Posted by Juan Pablo on November 18, 2001 8:41 PM
Uncheck the third checkbutton (Summary below data). I think that should do that you want.
Juan Pablo
Posted by Juan Pablo on November 18, 2001 8:42 PM
Sorry, it won't... memory lapse...
