Javier, I followed Razzak’s instructions and was able to copy ALL the var to a new report with no problem at all. This below was the original report variables. I used the copy icon in the expression builder. [cid:[email protected]] [cid:[email protected]]
Less than 15 seconds later, I used the paste button. All copied over. [cid:[email protected]] [cid:[email protected]] James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Monday, September 20, 2021 5:35 PM To: [email protected] Subject: RE: [RBASE-L] - Moving variables between reports CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. I was hoping for a way to copy all the variables at once. When you have dozens of variables it can be time consuming. When I have more time I will explore doing "surgery" to the SYS_REPORTS3 table; I have had success in the past doing some changes for forms but have not really played with reports. Luckily, there are always several ways to do thing in R:Base. 😊 Javier, Javier Valencia, PE 913-915-3137 -----Original Message----- From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of A. Razzak Memon Sent: Monday, September 20, 2021 10:50 AM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Moving variables between reports Javier, You can copy a report/label variable from the Expression Builder, and paste it into another report/label. Buttons for "Copy" and "Paste" have been added to the Expression Builders for the Form, Report, and Label modules, to allow users to copy and paste selected, either specific or all, variables. Please note the "Copy" and "Paste" buttons are located next to the "Up" and "Down" arrow buttons, which reorder the location of a variable in the Expression Builder. You must select the variables first, which enable the "Copy" button. In addition, you may also use [Ctrl]+[C] to copy selected expression(s) and [Ctrl]+[V] to paste expression(s) while placing the mouse cursor over the expression builder window. Very Best R:egards, Razzak https://www.rbase.com http://www.facebook.com/rbase At 05:27 AM 9/20/2021, [email protected]<mailto:[email protected]> wrote: >I have a report that uses a large number of report defined variable to >calculate totals, cumulative totals averages and weighted averages for >several columns and at various breaks. I have a second report that uses >the same defined variable but with a completely different layout. > >Is there a way to bulk copy the variables from the first report to the >second? The alternative is to copy the first report with all the >variables to a third report, delete the layout, open a second session >or R:Base and copy the layout of the second report to the third report. > >Hopefully there is an easier way to do it. > >Javier, -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0MPF2s-1mWlP20iQK-004Slo%40mrelay.perfora.net. ________________________________ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743465CDD4F14D21157B2009A0A09%40SA0PR02MB7434.namprd02.prod.outlook.com.
