X hits on this document

536 views

0 shares

0 downloads

0 comments

54 / 96

Flexible Solutions, Inc. – GP Reports Viewer

54

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 _ S O P 5 0 2 0 (the unposted version is shown below): 0

SELECT <...field list...> FROM SOP10100 INNER JOIN GPRV_SOP50200 ON SOP10100.SOPTYPE = GPRV_SOP50200.SOPTYPE AND SOP10100.SOPNUMBE = GPRV_SOP50200.SOPNUMBE

Once the GPRV_SOP50200 table has been added to the report, a condition must be added that uses the four parameters created above. This is necessary in order for the report to print the correct documents for the current user. In Crystal Reports this is accomplished by adding a record selection formula. The minimum required selection formula is shown below:

{?DOCTYPE} = {GPRV_SOP50200.DOCTYPE} and ( ( { ? S E Q N U M B R } = - 1 ) o r ( { ? S E Q N U M B R } = { G P R V _ S O P 5 0 2 0 0 . S E Q N U M B R } ) and ) { ? U S E R I D } = { G P R V _ S O P 5 0 2 0 0 . U S E R I and ( (trim({?SOPNUMBE}) = D } " " ) o r ( { ? S O P N U M B E } = { G P R V _ S O P 5 0 2 0 0 . S O P N U M B E } ) )

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

SELECT <...field list...> FROM SOP10100 INNER JOIN GPRV_SOP50200 ON SOP10100.SOPTYPE = GPRV SOP50200.SOPTYPE

_

Document info
Document views536
Page views536
Page last viewedFri Jan 20 11:08:24 UTC 2017
Pages96
Paragraphs1592
Words22003

Comments