mrc Documentation

michaels, ross & cole, ltd.

http://www.mrc-productivity.com/

 

 

Drilling Down in Reports

 

Drilling down in reports is now only a few steps away -- thanks to mrc and m-Painter.

1.      Build and generate a report as your normally would

2.      Open m-Painter for this application by clicking on the Paint output icon on the Manage Reports screen.

3.      You can now Smartlink (Drill Down) between this report and another report (for example, R00934). For this example we will be passing the product number. Select the PRDNO field on the detail line. Click on the “Insert/Edit” Icon in the m-Power toolbar. Under Target location, select mrc Report. In the URL section, enter MRCWORKLIB.RXXXXXs?run=2. [Where XXXXX is your application number]. Click the Add Field Parameter. Type R001 for Parameter Name and select Product Number from the drop down list. Click OK. Your Link window should resemble this:

 

 

 

1.      Click OK. Your PRDNO field should now be a hyperlink. Note: run=2 tells the report to skip the prompt page and go directly to the 2nd screen. R001 tells the report that the first record selection criteria will be F_V_TU_[PRDNO] (or ${row.PRDNO} for Web 2.0) (Which, in our case, is the substitution code for the appropriate Product Number.

2.      Click the Save and Deploy button. Re-run your application. You can note that the Product Number is now Smartlinked to Report 934.

 

Note: Your receiving application (i.e. R00934) needs to have product number set as the first record selection.