Flexible Solutions, Inc. – GP Reports Viewer
AND SOP10100.SOPNUMBE = GPRV_SOP50200.SOPNUMBE WHERE (GPRV_SOP50200.USERID = @USERID) AND ((GPRV_SOP50200.SEQNUMBR = @SEQNUMBR) OR (@SEQNUMBR = -1)) AND (GPRV_SOP50200.DOCTYPE = @DOCTYPE) AND (RTRIM(@SOPNUMBE) = '' OR GPRV_SOP50200.SOPNUMBE = @SOPNUMBE)
MODIFYING A REPORT FOR USE WITH PURCHASE ORDER PROCESSING
You can use your existing Crystal and SQL Server Reporting Services reports with the Replace SOP / POP Reports feature of GP Reports Viewer, but you will need to make a few modifications to your reports first.
The sample reports that ship with GP Reports Viewer provide a good example of how to modify a report to work with Purchase Order Processing. The steps needed are listed below:
Replace all existing parameters on the report with the following 3 parameters:
Number (if Crystal Report) Integer (if Reporting Services)
Description Used to ensure that the report will only include documents for the current user. Similar to the USERID parameter, this is used to ensure that the report will only include documents for the current user's report printing session. Used to ensure that the report will include the documents being printed.
The parameters must be added to the report in the order shown above.
Add the GPRV_POP50200 table and link this table to the POP10100 table for open PO reports or the POP30100 table for historical PO reports) on the PONUMBER field. The link in your report should be an Inner Join link type and in Crystal Reports it will look like the following: