>>>>>Hi. I'm relatively new to VFP and its Report Designer. I am working on a system to print "Watch specifications". Since watches are complicated things, the specifications must be broken down into various sub-sections, e.g., Case, Bracelet, Movement, etc., sometimes with 2 or 3 sections printed on a page. My problem is that there is too much data to fit on one page. What can I do to include all of the information necessary, but tell the VFP Report Designer to "page break" at specific lines? Also, where do I put my information, i.e., in the "Detail" band or do I need separate "Group" bands for each section? Any help would be greatly appreciated.
>>>>>
>>>>>Thanks in advance.
>>>>
>>>>You may group your report by WatchId and select 'start each group with new page', so you will have group footer for each watch and other info will be in Detail band.
>>>
>>>Edward, thanks for your quick response. If I do that, am I supposed to put each section (Case, Bracelet, etc.) in a separate group? If so, what do I use for the "Group Expression" for the other groups after I've used WatchID for the first one?
>>
>>You may do this, grouping by 2 levels: first- WatchId, second- ItemId (case, bracelet, etc.), but I'm not sure that it's what you want to achieve. It depends on required report layout. My assumption that you may just have several lines in Detail Band:
>>Group Header
>>Case ....
>>Bracelet ...
>>Something Else ....
>>Group Footer
>>
>>All this also depends on data structure.
>
>OK. Here's the nitty, gritty. The data is all stored within one file since data normalization is unnecessary due to the uniqueness of each watch. The Specification Printout, needed for only one watch at a time, has the following layout, where some fields in each section are variable length memos meaning the number of lines below can vary:
>
>Summary:
>Line 1... line 16
>
>Case:
>Line 1... line 38
>
>Bracelet:
>Line 1... line 25
>
>Movement:
>Line 1... line 43
>
>Dial:
>Line 1... line 33

Do these parts go sequentally, e.g. Case lines then Bracelet lines etc. If it's so the simplified report form layout is gouping by watch id/name with Summary in Group Header, and 4 fields (each one taking whole row) in detail band. Each detail field will be based on UDF, e.g. getcase(), getbracelet() etc. The UDFs will essentially concatenate fields related to Case,Bracelet etc. Each field should be marked as 'Stretch with Overflow' and 'Fix on the Bottom of Band'.