If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Calendar view

Started by petercade, 12 Mar 2007 07:50:39 AM

Previous topic - Next topic

petercade

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.

tyler564

I am looking for the same type of solution.  Have you found any way to do this?

DanMan

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>