Dynamic text in Web Report (lookup on Variable Value)

[Former Member]

Hi

If a user specifies a variable value to run a report (say company code), is it possible to have logic which looks up some attribute of company code (let's say country for example) and then displays this as part of some header text above the query results table?

E.G. Report:

These results are for country <value>.

.... col1 col2

row1 200 300

row2 100 400

I've had a look at the Text Element Object, but I couldn't determine if it can be used for this - ?

I'm not sure I could use a Customer Exit Variable to look up the Country, as what could it be attached to if Country is not in the query/Infocube - ?

(I have the added complexity of having multiple queries in one Web Report)

Many thanks in advance,

[Former Member]

Hi,

I see 2 possibilities:

- Use a <b>text</b> variable with processing type customer exit in the query title and read the masterdata table in your customer exit depending on the variable value for company code.

- Create another query (query on masterdata table) with the same variable. This will result in one row returning the (in the query definition) defined attributes.

Heike