Monthly Archives: June 2012

How to Pass Multi-Valued Parameters to another Report

Right click the cell you want to use to go to the other report Select Text Box Properties Select Action Select Go to report Specify a report and select the one you created that you want to go to. Note: … Continue reading

Posted in Uncategorized | Leave a comment

Simple SQL Update with Join and Where Exists

UPDATE Part_Master SET RECVEN_01 = VENID_10from Part_Master as P INNER join Order_Master as O ON P.PRTNUM_01 = O.PRTNUM_10WHERE EXISTS(SELECT PRTNUM_10, VENID_10FROM Part_Master as P join Order_Master as O ON P.PRTNUM_01 = O.PRTNUM_10WHERE TYPE_01 = ‘B’ OR TYPE_01 = ‘O’GROUP BY … Continue reading

Posted in Uncategorized | Leave a comment