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.
'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
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
Many thanks.
Good idea.
FYI, to add the query to page is also working well.
Many thanks.
Sven