Does anyone know of a way to create a Reportnet report that looks like a calendar view
That is the same sort of view as you would get in MS Outlook for a month to view\week to view etc.
I am looking for the same type of solution. Have you found any way to do this?
I had a similar requirement to this and used a repeater query across a calendar dimension. Worked a treat. Option to break on month week etc. Attached some xml as an example. Shout up if I can help further.
Daniel
<report xml:lang="en-gb" xmlns="http://developer.cognos.com/schemas/report/1/"><!--RS:1.1-->
<modelConnection name="/content/package[@name='Vis - Vision']/model[@name='model']"/>
<querySet xml:lang="en-gb">
<BIQuery name="Query1">
<cube><dimension name="Order Date Month Name"><level name="Order Date Month Name"><item aggregate="none" refItem="Order Date Month Name" key="true" isHeader="true"/></level></dimension><factList><item aggregate="none" refItem="Order Date" sort="ascending" isHeader="true"/></factList></cube>
<tabularModel name="Tabular Model1"><dataItem name="Order Date Month Name" aggregate="none"><expression>[Vision KPI].[Order Date].[Order Date Month Name]</expression></dataItem><dataItem name="Order Date" aggregate="none"><expression>[Vision KPI].[Order Date].[Order Date]</expression></dataItem><filter><condition>[Vision KPI].[Order Date].[Order Date Year Name] = '2007'</condition></filter></tabularModel></BIQuery>
</querySet>
<layoutList>
<layout refQuery="Query1">
<pageSet refLevel="Order Date Month Name"><page name="Page1">
<pageBody>
<repeater across="7" down="4" refQuery="Query1">
<style>
<CSS value="border-collapse:collapse"/>
</style>
<repeaterBody>
<style>
<CSS value="padding:3mm"/>
</style>
<textItem><queryItemRef refItem="Order Date"/></textItem></repeaterBody>
</repeater>
</pageBody>
<pageHeader>
<textItem><queryItemRef refItem="Order Date Month Name"/></textItem>
<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>