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
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 5
Level 3
bosecorp
Level 3

Likes

46 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
bosecorp
Level 3

Likes

46 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
bosecorp
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

Avatar
Boost 5
Level 3
graceatespn
Level 3

Likes

24 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 3
graceatespn
Level 3

Likes

24 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
graceatespn
Level 3

16-10-2012

Apologies if I am misunderstanding, but I think this functionality already exists.

Avatar

Avatar
Boost 5
Level 3
bosecorp
Level 3

Likes

46 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
bosecorp
Level 3

Likes

46 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
bosecorp
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

Avatar
Boost 50
Level 6
alysonmurphy
Level 6

Likes

166 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 6
alysonmurphy
Level 6

Likes

166 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
alysonmurphy
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

Avatar
Boost 5
Level 3
bradley_weidner
Level 3

Likes

26 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
bradley_weidner
Level 3

Likes

26 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
bradley_weidner
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.

Avatar

Avatar
Boost 5
Level 3
bosecorp
Level 3

Likes

46 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
bosecorp
Level 3

Likes

46 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
bosecorp
Level 3

26-10-2012

Works like a charm!  Thank you.   Also, there is this link to more information but clearly this documentation needs to be more detailed http://microsite.omniture.com/t2/help/en_US/arb/index.html#Differences_Between____ReportBuilder_and_...

Avatar

Avatar
Applaud 5
Level 1
mak00s2
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
mak00s2
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
mak00s2
Level 1

31-01-2013