X hits on this document

329 views

0 shares

0 downloads

0 comments

56 / 96

Flexible Solutions, Inc. – GP Reports Viewer

56

3.

I n S Q L S e r v e r R e p o r t i n g S e r v i c e s y o u w i l l n e e d t o m o d i f y y o u r d a t a s e t t o l i n k i n G P R V _ P O P 5 0 2 0 (the unposted version is shown below): 0

SELECT <...field list...> FROM POP10100 INNER JOIN GPRV_POP50200 ON POP10100.PONUMBER = GPRV_POP50200.PONUMBER

Once the GPRV_POP50200 table has been added to the report, a condition must be added that uses the three parameters created above. This is necessary for the reports to print the correct Purchase Order(s) for the current user. In Crystal Reports this is accomplished by adding a record selection formula. The minimum required selection formula is shown below:

{?USERID} = {GPRV_POP50200.USERID} and ( {?SEQNUMBR} = -1 or {?SEQNUMBR} = {GPRV_POP50200.DOCPRINTSEQ}) and (trim({?PONUMBER}) = "" or {?PONUMBER} = {GPRV_POP50200.PONUMBER})

In SQL Server Reporting Services you will need to modify your dataset to use the three newly created parameters by adding a WHERE clause, for example:

SELECT <...field list...> FROM POP10100 INNER JOIN GPRV_POP50200 ON POP10100.PONUMBER = GPRV_POP50200.PONUMBER WHERE (GPRV_POP50200.USERID=@USERID) AND ((GPRV_POP50200.DOCPRINTSEQ=@SEQNUMBR) OR (@SEQNUMBR = -1)) AND (RTRIM(@PONUMBER) = '' OR GPRV_POP50200.PONUMBER = @PONUMBER)

Document info
Document views329
Page views329
Page last viewedFri Dec 09 15:43:27 UTC 2016
Pages96
Paragraphs1592
Words22003

Comments