A report is generally pulled from the database and not from the current transaction that has not yet been committed to the database. Why do you want to pull a report before the transaction is committed anyways? Just curious?
You could perhaps 'work around' this by committing the transaction to a temporary table using Direct SQL prior to saving the request and pulling the report off that temporary table. Joe ________________________________ From: "Mayfield, Andy L." <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, November 17, 2008 5:29:13 PM Subject: Active Link Question I know this is probably simple, but my brain is having more problems than usual this afternoon. I want the active link to create a report from information on the current screen. The thing that has me stumped is that I need to do this prior to the record being saved. I'm able to get it to work after the record is submitted using the qualification of 'Request ID' = $Request ID$, but of course that will only work after the record has been saved and I need to be able to do it before saving. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"