Report Studio 8.4.1 Question

[Sidney786]

Hi

I have created a report in report studio.
The report contains a prompt page and a main page.

I have a header in the report which i would like to display data.
I also would like to place a calculation at the bottom of the report.

See example below

Employee: XXXXXX Area:Europe
Manager: xxxxxx Sales Total:XXXXX

Country Location Item
======= ======== ====
England Midlands Pallet
Spain Central Kites
France Paris Tents

Total Sale percentage: xxxxxx

How do I populate the xxxx's in the report?
If i introduce singleton items they create a new query which does not carry down the parameters from the initial query 1.

If i bring in area into the header it brings in Asia and should be Europe. Also how do I display the prompt select in the report header?

Thanks

Sid

 

[blom0344]

You simply add query filters that refer to parameter values of prompts. The selected prompt value can easily be shown in a report expression using the 'paramdisplayvalue' function:

paramdisplayvalue('some_parameter')

You might consider following some training as this is REALLY basic stuff..

Ties Blom

 

[Sidney786]

Hi

Thank for your response, however, it is not prompt parameters that are the issue, its query items from query 1 that i want to place in the header, which is more complex as adding them creates new query??

Any suggestions

 

[blom0344]

Dataitems can only be used within a datacontainer (list,crosstab,repeater) or in case the report page itself is associated with a query.

I honestly do not know why you want query output in a header. Headers are used for layout matters, logo's etc

Ties Blom