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

Manually Prioritize Requests in Report Builder?

Avatar

Avatar
Validate 1
Level 4
danoots
Level 4

Likes

75 likes

Total Posts

47 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 4
danoots
Level 4

Likes

75 likes

Total Posts

47 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
danoots
Level 4

16-08-2017

I'm building a Report Builder dashboard, and want the following to be executed in order:

  1. pull some data in a request
  2. manipulate the data using Excel functionality
  3. pull a second request based on manipulated data

Example:

In initial request, Report Builder returns:

/path-goes-here

Then, Excel functionality conditionally pre-pends this info:

sitename.com/path-goes-here

or

mobile.sitename.com/path-goes-here

Then, second request fires pulling additional information based on manipulated value (sitename.com/path-goes-here / mobile.sitename.com/path-goes-here)

It's not as easy as doing a simple dependent request, since the cells being pointed to in second request aren't output cells of first request. I know Adobe allows you to pre-pend hard-coded text when outputting a request, but this doesn't meet my needs as pre-pended text in my case is conditional.

If I were able to tell Report Builder - execute request 1 first, then execute request 2 after request 1 is completed and a small amount of time has elapsed to execute Excel logic, I'd be able to accomplish what I'm looking for. Don't see a way of doing this.

Anyone have insight?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

227 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
hyderziaee
Employee

25-08-2017

Have you tried controlling the requests via VB Macros.

Check this out: Invoke Report Builder Functionality from Microsoft Excel Functions

Answers (0)