X hits on this document

504 views

0 shares

0 downloads

0 comments

55 / 96

Flexible Solutions, Inc. – GP Reports Viewer

55

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:

1.

Replace all existing parameters on the report with the following 3 parameters:

Parameter USERID

Type String

SEQNUMBR

Number (if Crystal Report) Integer (if Reporting Services)

PONUMBER

String

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.

2.

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:

Document info
Document views504
Page views504
Page last viewedTue Jan 17 03:11:44 UTC 2017
Pages96
Paragraphs1592
Words22003

Comments