sort

[gshilpa24]

Hi,
Can anyone tell me how to display 25 records per page when i run the output in pdf format in report studio?  There are lakhs of records in the database...I am getting all the records in the output...
I tried to change the rows per page and formats in list properties... But its not working... Please let me know what to be done on this.

Please help me.

Thanks in Advance.

[JO]

Hi ,

I am able to achieve with the same functionality wich you mentioned, setting rows per page property for the list as 25. It is working fine. Please find the report which I tried for Go Sales and Retailers.

<report xmlns="http://developer.cognos.com/schemas/report/3.0/" expressionLocale="en-us"><!--RS:8.2-->
   <modelPath>/content/package[@name='GO Sales and Retailers']/model[@name='model']</modelPath>
   <layouts>
      <layout>
         <reportPages>
            <page class="pg" name="Page1">
               <pageBody class="pb">
                  <contents><list class="ls" refQuery="Query1" rowsPerPage="25">
                        <style>
                           <CSS value="border-collapse:collapse"/>
                        </style>
                        <listColumns><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><staticValue>Row Number</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lc"><contents><textItem>
                                       <dataSource>
                                          <reportExpression>RowNumber()</reportExpression>
                                       </dataSource>
                                    </textItem>
                                 </contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Order number"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lc"><contents><textItem><dataSource><dataItemValue refDataItem="Order number"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Product name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lc"><contents><textItem><dataSource><dataItemValue refDataItem="Product name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle class="lt"><contents><textItem><dataSource><dataItemLabel refDataItem="Quantity"/></dataSource></textItem></contents></listColumnTitle><listColumnBody class="lm"><contents><textItem><dataSource><dataItemValue refDataItem="Quantity"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list>
                  </contents>
               </pageBody>
            </page>
         </reportPages>
      </layout>
   </layouts>
<queries><query name="Query1"><source><model/></source><selection><dataItem name="Product name" aggregate="none"><expression>[gosales_goretailers].[Orders].[Product name]</expression></dataItem><dataItem name="Quantity" aggregate="total"><expression>[gosales_goretailers].[Orders].[Quantity]</expression></dataItem><dataItem name="Order number" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order number]</expression></dataItem></selection></query></queries></report>

-Jo

[gshilpa24]

Hi,
Thanks for the reply. Even i tried working with rows per page property in list, it is working fine. But if i try to use in another report which has more than 2 lists , where the lists are dragged inside the table and table cells with formatting done for font. Here when i try to use the property "Rows per page "it is not working . There are lakhs of records in the database. When i run the report, it appears to be very minute. The report cant be seen at all.
Please suggest me , if you have experienced the same kind of issue anytime.

Thanks in Advance.

[kvuppala]

Do you have formatting on the table cell which might be limiting the list to be shown.

[gshilpa24]

Formatting is done on the table cell. Border is defined , padding, backgroud color, font .
Padding is set to 3px 5px 3px 5px. The report appears to be very minute at the top left corner when run in pdf format.

[kvuppala]

If possible attach the xml file. Can take a look and figure out what the problem is. I have bunch of reports that has lists embeded in table cells. I don't seem to have any problem.

[gshilpa24]

Hi ,
Please find the attachment. I have attached a copy of xml . Please let me know is there anything wrong in formatting part.