Skip to Content
author's profile photo
Former Member

Dynamic text in Web Report (lookup on Variable Value)

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,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Jul 06, 2004 at 10:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded