Report net a date in the heading of a report

[coledog]

 i have someone that want to put the current date in the heading of a report this date is built a cube and not a package they want to pull out the current day from the cube  and have it display at the top of a list

[MFGF]

Go to the query explorer and add a second query to the report.  Drag the Current Day from the Time Dimension into the second query as a data item.  Next go to the page explorer and select your page.  Click on the page body, and use the Ancestor button to get hold of 'Page'.  In the Query property of the page, select Query2.

Finally, add a layout calculation to the page heading, and select your date from Query 2 as the expression.

Hope that helps,

MF.