How To Setup Reports For MyGrower

Part 1: Setting up the report on customers server

• Create a MyGrower Reports folder under Apps> AGRIS

• Make sure this is on main AGRIS server

• In AGRIS, Go to (package where report resides)>Report Manager>Advanced Reports>Report writer features

  • Currently, th4se are the reports that can be used with MyGrower:

1. The Inventory Report called Open Sales Order Report,

2. The Commodity Accounting Report called Proof of Yield

3. Ticket Ownership POY by Farm & Field

4. Sales History by Product Category

5. Stock/Equity

6. 1099 - Report

7. and any custom versions of these

• Click Insert>Standard Reports OR User Defined Reports>Choose the report you want to bring into MyGrower, If it is an existing User Defined Report, it must be on the updated Report Engine

• Change output to a 5=Multi Font Graphic File, Enter

• Create a number (preferably starting with 9 so it could be on the bottom)

• Should add “MYG” to beginning or end of the report name to help distinguish it from others

• Copy and paste directory path from the folder created above to the AGRIS report setup

• For file name, type “RANDOM”, and for Ext. type “PDF”

• Change “Open Output File After Processing” from a “Y” to a “N”

• Hit Ok, Ok

• Enter the name id that is used to print the report to "Beginning = MYG" to "Ending = MYG"  ( this allows MYG to override and supply the proper name id)  Example for MYG Proof of Yield Statements:

• Hit OK

• The editable template will pop up, close it, and when prompted to save hit “YES”

• To test running the report that was created, run the report, then make sure you could open the copy found inside the MyGrower Reports folder.

Part 2: Setting up the report inside MyGrower

• Log in as the Customer Super Admin

• Click “Forms” on left

• Go to “Reports” up top

• Click add a new record

• Choose Server>Dataset>Report Type>Exact report number as the one created in AGRIS. Name the Report then click Update

• Now log on as a grower, and verify that report runs