X hits on this document

291 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 views291
Page views291
Page last viewedSun Dec 04 22:04:28 UTC 2016
Pages96
Paragraphs1592
Words22003

Comments