I was able to get the report to use the 'on before generate' EEP. Would I create another EEP in the 'on after generate' area to clear the variable vspdy (that gives me the trailer number)? Is that the appropriate place or would that clear the variable too soon?
Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Friday, November 07, 2008 10:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: report Jim, So you are asking to be to jump to a form from within a report? If so you might try playing with the HotSpot option for reports. Or you create a form that looks like a report that you can clik on your link column to go to your selection. Jan -----Original Message----- From: "Jim Belisle" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 7 Nov 2008 10:27:00 -0600 Subject: [RBASE-L] - Re: report 7.6.4.30919 ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Friday, November 07, 2008 10:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: report Jim, I forget. What version are you in? Jan -----Original Message----- From: "Jim Belisle" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 7 Nov 2008 10:09:42 -0600 Subject: [RBASE-L] - report Now that I have this temporary view working, below is how I want to use it. I have a report based on a view that gives me all the costs associated with the products the company makes. This works fine for most of our products. On our larger products however, I need to insert the labor into the report by adding the total hours to assemble a specific model. Each model is different based on the "add ons" the customer wants so the labor to assembly that model is "job specific". So what I want is to keep the existing report structure that gives me the material and labor for the parts associated with this model and then at the end go to the WORKINFO table and insert the hours for the assembly of that model. Would the best approach be to create a temporary table or view to insert the specific info into? (That is what I just did with the view you folks helped me with) If that is the case then I would need to know how best to put that into the report. I assume I would need to create an EEP within the report for this task. I have never run reports off temporary tables though I have created temporary tables & views within a command file. Jim
