The Monthly Sale Report Scripted ( Part 4 )

From Dwayne Wright - www.dwaynewright.com

This is a series of discussions on the breakdown of a monthly sales report. This report is designed to be able to be reused in just about any sales report situation. The total script itself can be found at ...

/2007/10/monthly-sale-report-scripted-part-1.html

============================
ABOUT DISPLAYING THE REPORTS RESULTS
============================

#REPORT DISPLAY
Go to Layout [ original layout ]

New Window [ Name: "MONTHLY SALES REPORT"; Height: 50; Width: 50; Top: 50; Left: 50 ]

Show/Hide Status Area [ Show ]

Go to Layout [ “monthly sales report” (MonthySales) ]

Adjust Window [ Resize to Fit ]

Sort Records [ Specified Sort Order: MonthySales::Date; ascending ]
[ Restore; No dialog ]

Move/Resize Window [ Current Window; Height: Get ( WindowHeight ); Width: Get ( WindowWidth ) + 100 ]

Enter Preview Mode

Pause/Resume Script [ Indefinitely ]

============================
ABOUT WHAT THE SCRIPT IS DOING ABOVE
============================
Wrapping up this discussion, you can see the window management of this report. It is pretty standard fare except perhaps the Move/Resize/Window option. In preview mode, a window using the Adjust Window [ Resize to Fit ] command seems a bit small. So I’m taking the adjusted window length and adding 100 pixels to it.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.