** RESOLVED ** Using Data Item from query in a layout expression - right format?

[piro299]

Hello,

I have a report with a header and a table with the content of a supplier.

I would like to add the data item from the query which is related to the name of the supplier in the header.

In the header in have a block object with a text in which I tried to add the data item in this way.

Code Select Expand


'Supplier Name ' + [Query1].[supplier name]

But this will not work and give me an error that I can not use a data item in a layout expression.

What can I do to fix it?

Many thanks in advance.
Sven

[HalfBloodPrince]

Use query calculation , create a singleton query

http://pic.dhe.ibm.com/infocenter/cx/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.0.doc%2Ft_cr_rptstd_wrkdat_insert_singleton.html

[piro299]

Many thanks.

Good idea.

FYI, to add the query to page is also working well.

Many thanks.
Sven