HOW TO GENERATE A CUSANY REPORT =============================== 1. Modify and Cut'n'Paste this URL into the browser; To generate the URL run this (replace {LAB_ID}) and make sure to add "&cusany=1" to the end of the URL select 'URL' = CINRG.dbo.GET_REPORT_Link('BillQ',{LAB_ID},'GENERATE-HTTP') -> http://www.oilanalysis.net/CommonFiles/Reports/default/SR-GENERATE.php?ss=L-5098714-3474087&lid=5098714&oem_template=WEARCHECK&cusany=1&overwrite=1 2. Run URL (PDF report will be put into the /L/CUSANY folder automatically) 3. Put PDF file into the appropriate folder (Mobile, Aviation, Industrial...) 4. Rename to this format; OA-RPT-{TEST_PKG}-{RATING}-{COMPONENT_CODE}-{OEM}-{LANG}-CUSANY.pdf (i.e. OA-RPT-IND3-SEV-WTGB-WEARCHECK-EN-CUSANY.pdf) NOTE: To change brand code -- CHANGE LAB_ID insert into cinrg.dbo.Sample_Lock (LAB_ID, [USER_ID], USER_TYPE, LOCK_TYPE, DATE_CREATED, DATE_EXPIRY) values(, 9996, 'EMPLOYEE', 'SAMPLE_TRIGGER', GETDATE(), DATEADD(hh, 1, getdate())) -- CHANGE LAB_ID and BRAND_CODE update CINRG.dbo.Samples SET BRAND_CODE = where LAB_ID =