Most users of MAX at one time or another have run into the arduous task of trying to edit MAX forms and reports. The main thing to realize is that the report extract file pre-creates report sections. If you look at the formulas you’ll see {Report_Extract.GRP} < 10 or =1 and so on. Well, if you are going to make sub-reports or other custom elements in the reports you’ll need to make the section identifier aka {Report_Extract.GRP} is included in your formula.
Additionally the report extract sometime concatenates fields which can be very cumbersome to work with. In such cases you can link the tables and by pass the Extract to add the needed fields. Either way you can most always figure out a solution.
Example:
Component in Shop Paperwork
if {Report_Extract.GRP} = 1 and {@PrintMPN} = 0 then
//{Report_Extract.RPTL132}[1 to 15]
{Report_Extract.RPTL100}[1 to 30]
else
""
The above translates to Group 1 and the MPN check box in MAX is unchecked (1 would be checked) . The report extract column in this case gets populated by Component Part ID. In column position 1-30.
{Report_Extract.RPTL100}[1 to 30]
Example:
You want to add a footer section on the Shop Paperwork that contains a subreport but it prints on both pages.
By editing the subreport format – click suppress and in the x-2 formula editor specify {Report_Extract.GRP} = 10
