BusinessObjects Board

Pass variable between reports

I have a report made up of four tabs and five Queries and I would like an object selected in Query 1 to be in the title of each of the four reports. It works in the first, but in the others it says #MULTIVALUE even though the first query establishes just one value for this object. Is there a way to pass this value between reports to enable it to show on each?


TrevR :uk: (BOB member since 2014-03-05)

Really a Deski question?


Nick Daniels :uk: (BOB member since 2002-08-15)

I always seem to get asked that and I’m not sure why. I am working in Deski Version 12.5.0.1190 so doesn’t that make it a Deski question?


TrevR :uk: (BOB member since 2014-03-05)

Can you put the header in the top margin?

Do you mean to add a Header in the Section Format? If I try to add the variable I need to the formula it says: “Bad variable type. You must create a boolean variable”.


TrevR :uk: (BOB member since 2014-03-05)

try to put “max()” or “min()” in your object. Those two functions will give you only one value other than MULTIVALUE.


bonotatsujin :taiwan: (BOB member since 2017-12-20)

It always turns out to be such a simple solution! Thanks very much, that sorted it.


TrevR :uk: (BOB member since 2014-03-05)