X hits on this document

332 views

0 shares

0 downloads

0 comments

53 / 96

Flexible Solutions, Inc. – GP Reports Viewer

Parameter USERID

Type String

Description Used to ensure that the report will only include documents for the current user.

SEQNUMBR

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

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. This parameter is used to limit the type of document that the report will print. You can also make use of it in your report to print the name of the type of document. The DOCTYPEs are as follows:

DOCTYPE

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

53

MODIFYING A REPORT FOR USE WITH SALES 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.

SOPNUMBE

String

1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order 7 = Packing Slip 8 = Picking Ticket Used to ensure that the report will include the documents being printed. This parameter is required for emailing functionality in GP Reports Viewer to work. Without it, reports will print, but will not email. Even if you are not setting up emailing, consider adding this parameter, so that enabling emailing in the future does not require any additional work.

The parameters must be added to the report in the order shown above.

The sample reports that ship with GP Reports Viewer provide a good example of how to modify a report to work with Sales Order Processing. The steps needed are listed below:

2.

Add the GPRV_SOP50200 table and link this table to the SOP10100 table (for unposted reports) or the SOP30200 table (for historical reports) on the SOPTYPE and SOPNUMBE fields. The link in your report should be an Inner Join link type and in Crystal Reports it will look like the following:

1.

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

Document info
Document views332
Page views332
Page last viewedSat Dec 10 06:00:22 UTC 2016
Pages96
Paragraphs1592
Words22003

Comments