Hi All,
So here’s the situation, I’ve created a couple of scheduled monthly reports that run on the 5th of the current month that return information for the previous month. What I’m trying to accomplish is to display the month and year in the report page header. When I add a Layout Calculation to the page header, that simply captures the month and year Data Items I’ve added to the query, the report won’t validate. However, this problem seems to be intermediate. Sometimes it works, sometimes not.
To demonstrate this problem I’ve posted a sample report based on the Go_Sales_Go_Retailers sample below.
I’ve been told by Cognos support that this is a known issue in Report Net -> Report Studio.
What I would like is for someone who has the Cognos samples installed to try this and let us know what the results are.
Your task is to display the [Order Year] Fact Data Item from Query 1 in the header section of the report.
So here's the report...... Good Luck!!!!
So, my question is, does anybody have a work around? How do you display dates?
Nuffsaid.
So here’s the situation, I’ve created a couple of scheduled monthly reports that run on the 5th of the current month that return information for the previous month. What I’m trying to accomplish is to display the month and year in the report page header. When I add a Layout Calculation to the page header, that simply captures the month and year Data Items I’ve added to the query, the report won’t validate. However, this problem seems to be intermediate. Sometimes it works, sometimes not.
To demonstrate this problem I’ve posted a sample report based on the Go_Sales_Go_Retailers sample below.
I’ve been told by Cognos support that this is a known issue in Report Net -> Report Studio.
What I would like is for someone who has the Cognos samples installed to try this and let us know what the results are.
Your task is to display the [Order Year] Fact Data Item from Query 1 in the header section of the report.
So here's the report...... Good Luck!!!!
Code:
<report xml:lang="en-ca" xmlns="[URL unfurl="true"]http://developer.cognos.com/schemas/report/1/"><!--RS:1.1-->[/URL]
<modelConnection name="/content/package[@name='GO Sales and Retailers']/model[@name='model']"/>
<querySet xml:lang="en-ca">
<BIQuery name="Query1">
<cube><dimension name="Retailer name"><level name="Retailer name"><item key="true" refItem="Retailer name" aggregate="none" isHeader="true"/></level></dimension><dimension name="Product line"><level name="Product line"><item key="true" refItem="Product line" aggregate="none" isHeader="true"/></level><level name="Product type"><item key="true" refItem="Product type" aggregate="none" isHeader="true"/></level></dimension><factList><item refItem="Revenue" aggregate="automatic" isHeader="true"/><item refItem="Order year" aggregate="none"/></factList></cube>
<tabularModel><dataItem name="Retailer name" aggregate="none"><expression>[gosales_goretailers].[Orders].[Retailer name]</expression></dataItem><dataItem name="Product line" aggregate="none"><expression>[gosales_goretailers].[Products].[Product line]</expression></dataItem><dataItem name="Product type" aggregate="none"><expression>[gosales_goretailers].[Products].[Product type]</expression></dataItem><dataItem name="Revenue" aggregate="total"><expression>[gosales_goretailers].[Orders].[Revenue]</expression></dataItem><filter use="required" summary="false"><condition>[gosales_goretailers].[Orders].[Order year]=2006</condition></filter><dataItem name="Order year" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order year]</expression></dataItem></tabularModel></BIQuery>
<BIQuery name="Query1_crosstab"><cubeReference refQuery="Query1"/><summary><rowEdge><level refLevel="Retailer name"><item refItem="Retailer name"/></level></rowEdge><columnEdge><level refLevel="Product line"><item refItem="Product line"/></level><level refLevel="Product type"><item refItem="Product type"/></level></columnEdge><dataCells><item refItem="Revenue"/></dataCells></summary></BIQuery></querySet>
<layoutList>
<layout>
<pageSet>
<page name="Page1">
<pageBody>
<crosstab refQuery="Query1_crosstab">
<style>
<CSS value="border-collapse:collapse"/>
</style>
<crosstabCorner/>
<crosstabRows/>
<crosstabColumns/>
<crosstabLevel refLevel="Retailer name"><textItem><queryItemRef refItem="Retailer name"/></textItem></crosstabLevel><crosstabLevel refLevel="Product line"><textItem><queryItemRef refItem="Product line"/></textItem></crosstabLevel><crosstabLevel refLevel="Product type"><textItem><queryItemRef refItem="Product type"/></textItem></crosstabLevel><crosstabCell><textItem><queryItemRef refItem="Revenue"/></textItem><member refMember="Revenue"/></crosstabCell></crosstab>
</pageBody>
<pageHeader>
<block class="reportTitle">
<textItem><text>DISPLAY: QUERY ITEMS ->FACTS ->ORDER YEAR: HERE</text><style><CSS value="color:red"/></style></textItem></block>
<style>
<CSS value="padding-bottom:10px"/>
</style>
</pageHeader>
<pageFooter>
<table>
<tableRow>
<tableCell>
<textItem>
<expression>AsOfDate()</expression>
</textItem>
<style>
<CSS value="vertical-align:top;text-align:left;width:25%"/>
</style>
</tableCell>
<tableCell>
<textItem>
<text>- </text>
</textItem>
<textItem>
<expression>PageNumber()</expression>
</textItem>
<textItem>
<text> -</text>
</textItem>
<style>
<CSS value="vertical-align:top;text-align:center;width:50%"/>
</style>
</tableCell>
<tableCell>
<textItem>
<expression>AsOfTime()</expression>
</textItem>
<style>
<CSS value="vertical-align:top;text-align:right;width:25%"/>
</style>
</tableCell>
</tableRow>
<style>
<CSS value="border-collapse:collapse;width:100%"/>
</style>
</table>
<style>
<CSS value="padding-top:10px"/>
</style>
</pageFooter>
</page></pageSet></layout>
</layoutList>
</report>So, my question is, does anybody have a work around? How do you display dates?
Nuffsaid.
![[flip]](/data/assets/smilies/flip.gif "[flip] [flip]")
short lived however. When I removed your prompt query (and prompt page) the report would no longer validate.![[banghead]](/data/assets/smilies/banghead.gif "[banghead] [banghead]")
Bizarre.