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

Text Item Repeating across several pages

Started by RobSil, 21 Jan 2010 04:52:14 PM

Previous topic - Next topic

RobSil

I have a report that is supposed to look like:

Intro Area
Intro text to explain the report, etc.

[line Chart]



[Pie Graph]


My line chart/pie graph are < 1 page in size but my table can span multiple pages.  For every page that the table spans, the Text Item's I have up in the first area repeat at the top of each page.  It is like they are in the page header, but I've checked (and double checked) that they are not.

how do you stop these text items from repeating onto each page?

Thanks,
Robin

MFGF

Hi,

Define a boolean variable with the expression PageNumber() = 1

Select your table containing your text items (or select each text item) and set the Render variable property to be based on your boolean variable - make sure Render for Yes is checked.

Regards,

MF.
Meep!

RobSil

Thanks for the reply MFGF!  I am still having some issues though, but your solution is putting me on the right track.  To elaborate a bit more...


I have a page structure of...

Page Body
   - Block
       - Text Item  "Some intro text" (e.g.)
   - Block
       - Text Item "2nd line of text" (e.g.)
   - Block
       - combination chart
   - Block
       - list


The last list is what is repeating across pages, bringing the first two Text Items with it to the top of each page.  I don't have tables, but I did put the RenderVariable on the blocks to be the same... "IsPageOne" with an expression of "PageNumber() = 1", render when is set to Yes.  The text then doesn't get rendered on ANY page.  When I set render when to be No... it renders on all pages the list table is on again... strange!

When I put into the header the expression: "PageNumber() = 1" the 1st page header says 1, rest say 0... so it seems like PageNumber() = 1 is evaluating properly.

Thoughts?

Thx,
Robin



MFGF

Try using the Render Variable directly on each text item rather than on the blocks.  Does this work?

MF.
Meep!

RobSil

Hey there,

Thanks for the quick response!

Unfortunately, it behaves the same way.

IsPageOne, render when = Yes
Text Item doesn't display on any page.

IsPageOne, render when = No
Renders on each page the list is on.

No variable, renders on each page the list is on (same as Render When = no).

It's only for the list that it does this... if I add in a pie graph at the end of my report the text doesn't show.  Is there anything about the list that would repeat previous Text Items in the report?  I plan to have text throughout my report so hoping for a solution that is flexible enough to allow this without having text repeating everywhere.

To back up a bit... am I mis-understanding the logical order in which the report would be filled?  It is a top to bottom filling correct?  Also... would it be related to queries and what queries are used where? (this was going to be a seperate question once I had my text issue sorted out)...

Basically this report is on 1 set of data.  As you read through the report you will get a successively more summarized version of the data.  So you have some text, then you have a line graph summarizing at one level to give a brief overview, then a more detailed table, then a Pie Graph that completely summarizes things into 1 clear image.

Right now I have 1 Query at the Page level that all my charts/lists inherit.  Since it's the same data I thought it made sense to have 1 query.  Should I have multiple queries, 1 for each of my charts instead?  Wondering if something like this might be affecting how the report is filled... grasping at straws I know... but this has been puzzling me for almost 2 days now. 

Thanks!

R.



MFGF

Puzzling - I just tried exactly this - a report with four blocks, the first two containing text items, the third a combination chart and the fourth a list.  I defined my boolean variable as above and applied it to the Render Variable property for the irst two blocks.

When I run the report, the text items, chart and list appear on the first page, and just the list appears on subsequent pages.

What version of Cognos 8 are you using?

If it is of any use, the XML of my report is below:

MF.

<report xmlns="http://developer.cognos.com/schemas/report/6.0/" expressionLocale="en-gb">
            <modelPath>/content/package[@name='GO Sales (query)']/model[@name='model']</modelPath>
            <drillBehavior modelBasedDrillThru="true"/>
            <queries>
               <query name="Query1">
                  <source>
                     <model/>
                  </source>
                  <selection><dataItem name="Product name" aggregate="none" rollupAggregate="none"><expression>[Sales (query)].[Product].[Product name]</expression></dataItem><dataItem name="Quantity" aggregate="total"><expression>[Sales (query)].[Sales].[Quantity]</expression></dataItem></selection>
               </query>
            <query name="Query2"><source><model/></source><selection><dataItem name="Current year" aggregate="none" rollupAggregate="none"><expression>[Sales (query)].[Time dimension].[Current year]</expression></dataItem><dataItem name="Product line" aggregate="none" rollupAggregate="none"><expression>[Sales (query)].[Product].[Product line]</expression></dataItem><dataItem name="Revenue" aggregate="total"><expression>[Sales (query)].[Sales].[Revenue]</expression></dataItem></selection></query></queries>
            <layouts>
               <layout>
                  <reportPages>
                     <page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
                        <pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
                           <contents>
                              <block>
         <contents><textItem><dataSource><staticValue>Some Intro Text</staticValue></dataSource></textItem></contents>
      <conditionalRender refVariable="Boolean1"><renderFor refVariableValue="1"/></conditionalRender></block><block>
         <contents><textItem><dataSource><staticValue>Second Line of Text</staticValue></dataSource></textItem></contents>
      <conditionalRender refVariable="Boolean1"><renderFor refVariableValue="1"/></conditionalRender></block><block>
         <contents><combinationChart showTooltips="true" maxHotspots="10000" refQuery="Query2" name="Combination Chart1">
                              <legend>
                                 <legendPosition>
                                    <relativePosition/>
                                 </legendPosition>
                                 <legendTitle refQuery="Query2">
                                    <style>
                                       <defaultStyles>
                                          <defaultStyle refStyle="lx"/>
                                       </defaultStyles>
                                    </style>
                                 </legendTitle>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="lg"/>
                                    </defaultStyles>
                                 </style>
                              </legend>
                              <ordinalAxis>
                                 <axisTitle refQuery="Query2">
                                    <style>
                                       <defaultStyles>
                                          <defaultStyle refStyle="at"/>
                                       </defaultStyles>
                                    </style>
                                 </axisTitle>
                                 <axisLine color="black"/>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="al"/>
                                    </defaultStyles>
                                 </style>
                              </ordinalAxis>
                              <numericalAxisY1>
                                 <axisTitle refQuery="Query2">
                                    <style>
                                       <defaultStyles>
                                          <defaultStyle refStyle="at"/>
                                       </defaultStyles>
                                    </style>
                                 </axisTitle>
                                 <gridlines color="#cccccc"/>
                                 <axisLine color="black"/>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="al"/>
                                    </defaultStyles>
                                 </style>
                              </numericalAxisY1>
                              <combinationChartTypes>
                                 <bar><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Product line"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></bar>
                                 <line dataPointSize="0"/>
                                 <area/>
                              </combinationChartTypes>
                              <style>
                                 <defaultStyles>
                                    <defaultStyle refStyle="ch"/>
                                 </defaultStyles>
                              </style>
                              <defaultChartMeasure refDataItem="Revenue"/><commonClusters><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Current year"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></commonClusters></combinationChart>
                        </contents>
      </block><block>
         <contents><list refQuery="Query1" horizontalPagination="true" name="List1">
                                 
                                 
                                 
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="ls"/>
                                    </defaultStyles>
                                    <CSS value="border-collapse:collapse"/>
                                 </style>
                              <listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Product name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Product name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Quantity"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Quantity"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
      </block>
                           </contents>
                        </pageBody>
                        <pageHeader>
                           <contents>
                              <block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles></style>
                                 <contents>
                                    <textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles></style>
                                       <dataSource>
                                          <staticValue/>
                                       </dataSource>
                                    </textItem>
                                 </contents>
                              </block>
                           </contents>
                           <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="ph"/>
                              </defaultStyles>
                              <CSS value="padding-bottom:10px"/>
                           </style>
                        </pageHeader>
                        <pageFooter>
                           <contents>
                              <table>
                                 <tableRows>
                                    <tableRow>
                                       <tableCells>
                                          <tableCell>
                                             <contents>
                                                <date>
                                                   <style>
                                                      <dataFormat>
                                                         <dateFormat/>
                                                      </dataFormat>
                                                   </style>
                                                </date>
                                             </contents>
                                             <style>
                                                <CSS value="vertical-align:top;text-align:left;width:25%"/>
                                             </style>
                                          </tableCell>
                                          <tableCell>
                                             <contents>
                                                <pageNumber/>
                                             </contents>
                                             <style>
                                                <CSS value="vertical-align:top;text-align:center;width:50%"/>
                                             </style>
                                          </tableCell>
                                          <tableCell>
                                             <contents>
                                                <time>
                                                   <style>
                                                      <dataFormat>
                                                         <timeFormat/>
                                                      </dataFormat>
                                                   </style>
                                                </time>
                                             </contents>
                                             <style>
                                                <CSS value="vertical-align:top;text-align:right;width:25%"/>
                                             </style>
                                          </tableCell>
                                       </tableCells>
                                    </tableRow>
                                 </tableRows>
                                 <style>
                                    <defaultStyles>
                                       <defaultStyle refStyle="tb"/>
                                    </defaultStyles>
                                    <CSS value="border-collapse:collapse;width:100%"/>
                                 </style>
                              </table>
                           </contents>
                           <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="pf"/>
                              </defaultStyles>
                              <CSS value="padding-top:10px"/>
                           </style>
                        </pageFooter>
                     </page>
                  </reportPages>
               </layout>
            </layouts>
         <XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/></XMLAttributes><reportVariables><reportVariable type="boolean" name="Boolean1">
         <reportExpression>PageNumber () = 1</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable></reportVariables></report>
Meep!

RobSil

Thanks for your help MFGF!

I'm going to re-create my report from scratch quickly and see if I can't sort this out.  Will also use tables for layout to see if that helps.  It seems quite odd that this happens.

How come the Render When option is necessary?  Is there any reason why the report isn't just rendered once by default?

Thanks!
R.

MFGF

Objects such as text items which are used outside of a reporting object (list, crosstab, chart etc) are assumed to be part of the page layout, and will by default get rendered on every page.  If you want to prevent this you need to resort to the kinds of conditional rendering techniques we have been investigating.  It would be great to have a property for them which drives the pagination, though!  Maybe in a future release?

MF.
Meep!

RobSil

I see.

Oh and I am using Cognos Report Studio 8.2.  It is bundled in with a CA product eHealth that I am using and producing reports on data from that product... but in the end I'm using Cognos Report Studio 8.2.

Thx,
R.

RobSil

Quote from: MFGF on 22 Jan 2010 09:30:28 AM
Objects such as text items which are used outside of a reporting object (list, crosstab, chart etc) are assumed to be part of the page layout, and will by default get rendered on every page.  If you want to prevent this you need to resort to the kinds of conditional rendering techniques we have been investigating.  It would be great to have a property for them which drives the pagination, though!  Maybe in a future release?

MF.

An alternative is to have a complex text object designed to integrate field values directly into it :).  There is no way currently to have large paragraphs of text mixed with dynamic data is there?

MFGF

#10
Quote from: RobSil on 22 Jan 2010 09:33:10 AM
I see.

Oh and I am using Cognos Report Studio 8.2.  It is bundled in with a CA product eHealth that I am using and producing reports on data from that product... but in the end I'm using Cognos Report Studio 8.2.

Thx,
R.

8.2.  Hmmmmm - as I recall there were a few "unintended features" in that release  ;)

Hope the conditional rendering isn't one of them!

I'm guessing the XML report spec I provided may be no good to you in that case, as it was created in 8.4.1.  You could always try, though - copy it to the clipboard and then in Report Studio go to Tools -> Open Report from Clipboard.  I strongly suspect it will barf when it sees the XML schema version number, though.

MF.
Meep!

MFGF

#11
Quote from: RobSil on 22 Jan 2010 09:40:17 AM
An alternative is to have a complex text object designed to integrate field values directly into it :).  There is no way currently to have large paragraphs of text mixed with dynamic data is there?

Well, yes - sort of.  You can drop Singleton queries in amongst your text items to retrieve database values in appropriate places.  A singleton is still considered part of the page layout, though, unlike a reporting object (list, crosstab, chart, map etc)

MF.
Meep!

RobSil

What is a Singleton query?  I looked for "Singleton" in the PDF reference but didn't come across anything.

R.

RobSil

No matter the combination I try... text in tables, text in blocks, Print When expressions, etc. etc. The text still doesn't display properly.  I may have to consider some other structure.. perhaps sub-reports or something...  XML of my report below:

<report xmlns="http://developer.cognos.com/schemas/report/3.0/" expressionLocale="en-us"><!--RS:8.2-->
   <modelPath>/content/package[@name='eHealth Reporting']/model[@name='model']</modelPath>
   <layouts>
      <layout>
         <reportPages>
            <page class="pg" name="Page1">
               <pageBody class="pb">
                  <contents>
                     <table class="tb"><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Intro Text:</staticValue></dataSource><conditionalRender refVariable="IsPageOne"><renderFor refVariableValue="1"/></conditionalRender></textItem></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;width:100%"/></style></table><combinationChart depth="0" class="ch" refQuery="LineChartQuery">
                        <legend class="lg">
                           <legendPosition>
                              <relativePosition/>
                           </legendPosition>
                           <legendTitle class="lx"/>
                        </legend>
                        <ordinalAxis class="al">
                           <axisTitle class="at"/>
                           <axisLine color="black"/>
                        </ordinalAxis>
                        <numericalAxisY1 class="al">
                           <axisLine color="black"/>
                           <axisTitle class="at"/>
                           <gridlines color="#cccccc"/>
                        </numericalAxisY1>
                        <combinationChartTypes>
                           <line dataPointSize="0"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg. Client Response"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                           <line dataPointSize="0"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg. Network Response"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                           <line dataPointSize="0"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg. Server Response"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                        </combinationChartTypes>
                        <style>
                           <CSS value="padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px"/>
                        </style>
                        <chartPalette>
                           <chartColor value="#5858DE"/>
                           <chartColor value="#51CAE4"/>
                           <chartColor value="#DE58D2"/>
                           <chartColor value="#D8DE58"/>
                           <chartColor value="#6D1D9D"/>
                           <chartColor value="#F6C18D"/>
                           <chartColor value="#A0A0FF"/>
                           <chartColor value="#2D82AD"/>
                           <chartColor value="#8358DE"/>
                           <chartColor value="#FB9898"/>
                           <chartColor value="#FFCB33"/>
                           <chartColor value="#D3A0FF"/>
                           <chartColor value="#2398D4"/>
                           <chartColor value="#9E389E"/>
                           <chartColor value="#719DC5"/>
                           <chartColor value="#EA4AA0"/>
                           <chartColor value="#84C4FF"/>
                           <chartColor value="#05A4AF"/>
                           <chartColor value="#E3975D"/>
                           <chartColor value="#CE669A"/>
                        </chartPalette>
                        <commonClusters><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Calendar Date"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></commonClusters></combinationChart>
                     <list class="ls" refQuery="TableQuery">
                        
                        
                        
                        <style>
                           <CSS value="border-collapse:collapse"/>
                        </style>
                        <listColumns><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Calendar Date"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lc"><contents><textItem><dataSource><dataItemValue refDataItem="Calendar Date"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Sys Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lc"><contents><textItem><dataSource><dataItemValue refDataItem="Sys Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Avg. Client Response"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lm"><contents><textItem><dataSource><dataItemValue refDataItem="Avg. Client Response"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Avg. Network Response"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lm"><contents><textItem><dataSource><dataItemValue refDataItem="Avg. Network Response"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Avg. Server Response"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lm"><contents><textItem><dataSource><dataItemValue refDataItem="Avg. Server Response"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list>
                     <pieChart depth="0" holeSize="0" class="ch" avoidLabelCollision="true" refQuery="PieGraphQuery">
                        <legend class="lg">
                           <legendPosition>
                              <relativePosition/>
                           </legendPosition>
                           <legendTitle class="lx"/>
                        </legend>
                        <axisTitle class="at"/>
                        <pieLabels class="al"/>
                        <style>
                           <CSS value="padding-left:5px; padding-right:5px; padding-top:5px; padding-bottom:5px"/>
                        </style>
                        <chartPalette>
                           <chartColor value="#5858DE"/>
                           <chartColor value="#51CAE4"/>
                           <chartColor value="#DE58D2"/>
                           <chartColor value="#D8DE58"/>
                           <chartColor value="#6D1D9D"/>
                           <chartColor value="#F6C18D"/>
                           <chartColor value="#A0A0FF"/>
                           <chartColor value="#2D82AD"/>
                           <chartColor value="#8358DE"/>
                           <chartColor value="#FB9898"/>
                           <chartColor value="#FFCB33"/>
                           <chartColor value="#D3A0FF"/>
                           <chartColor value="#2398D4"/>
                           <chartColor value="#9E389E"/>
                           <chartColor value="#719DC5"/>
                           <chartColor value="#EA4AA0"/>
                           <chartColor value="#84C4FF"/>
                           <chartColor value="#05A4AF"/>
                           <chartColor value="#E3975D"/>
                           <chartColor value="#CE669A"/>
                        </chartPalette>
                        <pieSlices><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg. Network Response"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg. Server Response"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg. Client Response"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></pieSlices></pieChart>
                  </contents>
               </pageBody>
               <pageHeader class="ph">
                  <contents><textItem><dataSource><staticValue>Header Text</staticValue></dataSource></textItem></contents>
                  <style>
                     <CSS value="padding-bottom:10px"/>
                  </style>
               </pageHeader>
               <pageFooter class="pf">
                  <contents>
                     <block>
                        <contents>
                           <textItem>
                              <dataSource>
                                 <staticValue>- </staticValue>
                              </dataSource>
                           </textItem>
                           <textItem>
                              <dataSource>
                                 <reportExpression>PageNumber( ) </reportExpression>
                              </dataSource>
                           </textItem>
                           <textItem>
                              <dataSource>
                                 <staticValue> -</staticValue>
                              </dataSource>
                           </textItem>
                        </contents>
                        <style>
                           <CSS value="text-align:center"/>
                        </style>
                     </block>
                  </contents>
                  <style>
                     <CSS value="padding-top:10px"/>
                  </style>
               </pageFooter>
            </page>
         </reportPages>
         <defaultDataFormats/>
      </layout>
   </layouts>
   <reportVariables>
      <reportVariable name="Is Html" type="boolean">
         <reportExpression>ReportOutput( )  = "HTML"</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable>
   <reportVariable type="boolean" name="IsPageOne">
         <reportExpression>PageNumber() = 1</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable>
   </reportVariables>
<queries><query name="LineChartQuery"><source><model/></source><selection><dataItem name="Calendar Date" aggregate="none"><expression>[General Dimensions].[Date].[Calendar Date]</expression></dataItem><dataItem name="Sys Name" aggregate="none"><expression>[General Dimensions].[Element].[Sys Name]</expression></dataItem><dataItem name="Group Name" aggregate="none"><expression>[General Dimensions].[Group].[Group Name]</expression></dataItem><dataItem name="Avg. Client Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Client Response]</expression></dataItem><dataItem name="Avg. Network Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Network Response]</expression></dataItem><dataItem name="Avg. Server Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Server Response]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Group Name] = 'CIS-BA-Complete'</filterExpression></detailFilter><detailFilter><filterExpression>[Calendar Date] BETWEEN
(_first_of_month(_add_months(current_date, -1)))
AND
(_last_of_month(_add_months(current_date, -1)))</filterExpression></detailFilter></detailFilters></query><query name="TableQuery"><source><model/></source><selection><dataItem name="Calendar Date" aggregate="none"><expression>[General Dimensions].[Date].[Calendar Date]</expression></dataItem><dataItem name="Sys Name" aggregate="none"><expression>[General Dimensions].[Element].[Sys Name]</expression></dataItem><dataItem name="Group Name" aggregate="none"><expression>[General Dimensions].[Group].[Group Name]</expression></dataItem><dataItem name="Avg. Client Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Client Response]</expression></dataItem><dataItem name="Avg. Network Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Network Response]</expression></dataItem><dataItem name="Avg. Server Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Server Response]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Group Name] = 'CIS-BA-Complete'</filterExpression></detailFilter><detailFilter><filterExpression>[Calendar Date] BETWEEN
(_first_of_month(_add_months(current_date, -1)))
AND
(_last_of_month(_add_months(current_date, -1)))</filterExpression></detailFilter></detailFilters></query><query name="PieGraphQuery"><source><model/></source><selection><dataItem name="Calendar Date" aggregate="none"><expression>[General Dimensions].[Date].[Calendar Date]</expression></dataItem><dataItem name="Sys Name" aggregate="none"><expression>[General Dimensions].[Element].[Sys Name]</expression></dataItem><dataItem name="Group Name" aggregate="none"><expression>[General Dimensions].[Group].[Group Name]</expression></dataItem><dataItem name="Avg. Client Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Client Response]</expression></dataItem><dataItem name="Avg. Network Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Network Response]</expression></dataItem><dataItem name="Avg. Server Response" aggregate="calculated"><expression>[Daily Response Path Measurements].[Avg. Server Response]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Group Name] = 'CIS-BA-Complete'</filterExpression></detailFilter><detailFilter><filterExpression>[Calendar Date] BETWEEN
(_first_of_month(_add_months(current_date, -1)))
AND
(_last_of_month(_add_months(current_date, -1)))</filterExpression></detailFilter></detailFilters></query></queries></report>

MFGF

Quote from: RobSil on 22 Jan 2010 09:56:33 AM
What is a Singleton query?  I looked for "Singleton" in the PDF reference but didn't come across anything.

R.

Ah - you're on 8.2, and Singletons were introduced in 8.3 - doh! :)

Rather than a Singleton, you could try using a Repeater from the toolbox - hopefully this should produce very similar results for single data items.

MF.
Meep!

RobSil

Thanks... I'll look into that.. and contact CA about upgrading Report Studio!

R.

RobSil

After posting on the IBM forum I'm pretty sure this is a bug.  A few folks can make it happen in 8.2 but not later versions.

Workaround:  Add layout calculation with expression: if (PageNumber () =1) then ('Text') else ('')

Obviously this has limitations such as having to know the page number, but will let you get some text working with lists in 8.2.




MFGF

Quote from: RobSil on 25 Jan 2010 03:02:56 PM
After posting on the IBM forum I'm pretty sure this is a bug.  A few folks can make it happen in 8.2 but not later versions.

OK - that confirms what I suspected.  Thanks for the update!


Quote from: RobSil on 25 Jan 2010 03:02:56 PMWorkaround:  Add layout calculation with expression: if (PageNumber () =1) then ('Text') else ('')

Obviously this has limitations such as having to know the page number, but will let you get some text working with lists in 8.2.

Great!  You have a workaround for the moment - I can't see any reason why this shouldn't work in 8.3/8.4 either, so it should be safe to use without the worry of having to remember to go back and change it when you upgrade.

Thanks again for the feedback - much appreciated!

MF.
Meep!