Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

ReportBuilder: Ability to copy datablocks within a spreadsheet/workbook/tab

Avatar

Level 3

16-10-2012

Currently, ReportBuilder does not allow for copying of datablocks from spreadsheet to spreadsheet and/or worksheet to worksheet.  It's very unproductive to recreate datablocks over and over again when they could just be copied and modified accordingly.  ExcelClient had this capability and it would be great if Adobe ReportBuilder (ARB) could have it as well! 

6 Comments

Avatar

Level 3

16-10-2012

If it does, we haven't been able to reproduce it and neither can ClientCare, but if you know of a way to do this, please share Smiley Happy

Avatar

Level 6

16-10-2012

If you right click on the cell below the header. A5 in this case, you will see "Copy Request" if you then select a new cell and right click, there is a "Paste Request." Is that what you are looking for? It works between worksheets. I have not tried it between Excel files.

RB copy.png

Avatar

Level 3

23-10-2012

Report Builder already functions as described in the original post.

 

You can copy requests and paste requests as depicted in the screenshot above.

 

You can also copy the entire worksheet with requests, which is located under "copy request" in the screenshot above. After you "copy the worksheet with requests" simply right click again and it will say "paste worksheet with requests", if you click paste it will automatically create a new tab for you in the current workbook with all of the requests on that new worksheet.

 

If you want to copy and paste requests or copy and past entire worksheets with requests to a new workbook just make sure you open a new workbook by simply going to the menu in the current workbook that you are using and open a new blank workbook, after you open the new workbook you can paste requests or entire worksheets with requests in the new workbook. There is another way of doing this, but it is not necessary if you follow the above example.