#1 2024-08-24 08:16:52

mcrexy
Member
Registered: 2024-08-24

Page Number

I am using a dynamic text in the footer of Master Page. It is working in Birt, but the ReportServer is unable to render it properly.

This is my script in the onRender of the dynamic text --> this.text = "Page " + pageNumber + " of " + totalPage;

On ReportServer, it gets generated as Page 1 of 1, Page 2 of 2 and so on. I would appreciate any help here to render it properly. Thanks!

Offline

#2 2024-08-24 08:23:24

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Offline

#3 2024-08-26 06:34:36

Felix
Moderator
Registered: 2022-08-01

Re: Page Number

hi mcrexy,

Sadly i'm not that experienced with BIRT... is there a way to "wait" for the finished rendering and then update the dynamic text? It looks like that totalPage is incremented for each rendered page?


Softwareentwickler bei Infofabrik

Offline

#4 2024-08-26 07:17:45

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Hi Felix, thank you for replying.

I am also not experience with BIRT, but I heard Birt "run and render".

I realised there is a lot things related to this rendering. How do I set the report to run first before rendering?

Offline

#5 2024-08-26 07:32:25

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Page Number

Hi mcrexy,

did you try this workaround? https://forum.reportserver.net/viewtopi … 3369#p3369

Regards,
Eduardo

Offline

#6 2024-08-26 09:13:30

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Hi Eduardo,

I have tried that and it's working very well. However, I have another report that requires requires 2nd page onwards to start from 0.

I tried to modify the "onRender" of that Page Number that goes like this --> this.text = "Page " + (parseInt(this.text)-1)

It is able to render it properly on 2nd page (e.g. Page 1), but the next page became "3" instead of "Page 2"

For context, the first page is "Cover page", so we do not need to show any page number.

Last edited by mcrexy (2024-08-26 14:41:01)

Offline

#7 2024-08-27 13:39:24

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Page Number

Hi mcrexy,

could you please create a minimal BIRT report that reproduces the issue? The report should be empty and contain no data, only the necessary header and footer. It should function correctly in BIRT but fail in ReportServer, allowing us to replicate the problem.

Regards,
Eduardo

Offline

#8 2024-10-06 17:11:45

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Hi eduardo,

Apologies on my long delay in getting back to you. I was testing this with my other colleagues, as the sample report I wanted to send you guys was working fine. Finally I am able to produce the BIRT (.rptdesign) report you guys are asking for.

How do I send you guys this file? I can't find the button that allows me to attach it.

Regards,
mcrexy

Offline

#9 2024-10-08 12:12:21

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Page Number

Hi mcrexy,

a BIRT report is just text, so you can just copy paste it here (inside code tags).

Regards,
Eduardo

Offline

#10 2024-10-08 15:49:26

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Hi Eduardo,

Thank you for the instruction!

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.24" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.12.0.v202211281949</property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">120</property>
    <data-sources>
        <script-data-source name="API" id="4"/>
    </data-sources>
    <data-sets>
        <script-data-set name="Dummy Data" id="1624">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">SN</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">Module</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">Result</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">SN</property>
                </structure>
                <structure>
                    <property name="columnName">Module</property>
                </structure>
                <structure>
                    <property name="columnName">Result</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">SN</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">Module</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">Result</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">API</property>
            <method name="open"><![CDATA[ptRecNum=0;]]></method>
            <method name="fetch"><![CDATA[if (ptRecNum >= 100)
return false;

row["SN"] = ptRecNum;
row["Module"] = "MOD" + ptRecNum*3/2+5;
row["Result"] = "Pass";
ptRecNum++;
return true;]]></method>
        </script-data-set>
    </data-sets>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <property name="type">a4</property>
            <property name="topMargin">0in</property>
            <property name="leftMargin">2.54cm</property>
            <property name="bottomMargin">0in</property>
            <property name="rightMargin">2.54cm</property>
            <method name="onPageEnd"><![CDATA[//var pageN = reportContext.getPageVariable("Group_page"); // Retrieve current page number
//reportContext.setPageVariable("Group_page", (Number(pageN)+1).toString());]]></method>
            <property name="headerHeight">1in</property>
            <property name="footerHeight">0.8in</property>
            <page-header>
                <grid id="1486">
                    <property name="height">0.7916666666666666in</property>
                    <property name="width">6.166666666666667in</property>
                    <column id="1488">
                        <property name="width">3.0833333333333335in</property>
                    </column>
                    <column id="1489">
                        <property name="width">3.0833333333333335in</property>
                    </column>
                    <row id="1490">
                        <property name="height">0.4895833333333333in</property>
                        <cell id="1492"/>
                        <cell id="1493">
                            <property name="textAlign">right</property>
                        </cell>
                    </row>
                    <row id="1495">
                        <property name="height">0.3020833333333333in</property>
                        <cell id="1497">
                            <property name="colSpan">2</property>
                            <property name="rowSpan">1</property>
                            <text id="1569">
                                <property name="textAlign">center</property>
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[Header of Simple MasterPage]]></text-property>
                            </text>
                        </cell>
                    </row>
                </grid>
            </page-header>
            <page-footer>
                <grid id="1215">
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">thin</property>
                    <property name="height">0.7291666666666666in</property>
                    <column id="1216">
                        <property name="width">1.917in</property>
                    </column>
                    <column id="1217">
                        <property name="width">2.3in</property>
                    </column>
                    <column id="1218">
                        <property name="width">1.9166666666666667in</property>
                    </column>
                    <row id="1219">
                        <property name="verticalAlign">middle</property>
                        <property name="height">22.5pt</property>
                        <cell id="1220">
                            <property name="colSpan">1</property>
                            <property name="rowSpan">1</property>
                            <auto-text id="1551">
                                <method name="onRender"><![CDATA[this.text = "Page " + (parseInt(this.text)-1)]]></method>
                                <property name="type">page-number</property>
                            </auto-text>
                        </cell>
                        <cell id="1221"/>
                        <cell id="1222">
                            <property name="colSpan">1</property>
                            <property name="rowSpan">1</property>
                            <text id="1622">
                                <property name="display">inline</property>
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[Page: ]]></text-property>
                            </text>
                            <auto-text id="1647">
                                <property name="display">inline</property>
                                <property name="type">page-number</property>
                            </auto-text>
                        </cell>
                    </row>
                    <row id="1374">
                        <property name="verticalAlign">middle</property>
                        <property name="height">12.75pt</property>
                        <cell id="1483">
                            <text id="1649">
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[^ onRender of autotext]]></text-property>
                            </text>
                        </cell>
                        <cell id="1376">
                            <text id="1568">
                                <property name="textAlign">center</property>
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[Footer of Simple MasterPage]]></text-property>
                            </text>
                        </cell>
                        <cell id="1500">
                            <text id="1648">
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[^ autotext]]></text-property>
                            </text>
                        </cell>
                    </row>
                    <row id="1378">
                        <property name="verticalAlign">middle</property>
                        <property name="height">12.75pt</property>
                        <cell id="1379"/>
                        <cell id="1380"/>
                        <cell id="1381"/>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
        <simple-master-page name="Coverpage" id="1583">
            <property name="type">a4</property>
            <property name="headerHeight">1in</property>
            <property name="footerHeight">0.8in</property>
            <page-header>
                <grid id="1602">
                    <property name="textAlign">center</property>
                    <property name="height">0.7916666666666666in</property>
                    <property name="width">7.645833333333333in</property>
                    <column id="1603">
                        <property name="width">3.0833333333333335in</property>
                    </column>
                    <column id="1604">
                        <property name="width">4.5625in</property>
                    </column>
                    <row id="1605">
                        <property name="height">0.4895833333333333in</property>
                        <cell id="1606"/>
                        <cell id="1607">
                            <property name="textAlign">right</property>
                        </cell>
                    </row>
                    <row id="1608">
                        <property name="height">0.3020833333333333in</property>
                        <cell id="1609">
                            <property name="colSpan">2</property>
                            <property name="rowSpan">1</property>
                            <text id="1610">
                                <property name="textAlign">center</property>
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[Header of Cover Page]]></text-property>
                            </text>
                        </cell>
                    </row>
                </grid>
            </page-header>
            <page-footer>
                <grid id="1584">
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">thin</property>
                    <property name="height">0.6979166666666666in</property>
                    <property name="width">7.635416666666667in</property>
                    <column id="1585">
                        <property name="width">1.917in</property>
                    </column>
                    <column id="1586">
                        <property name="width">2.3in</property>
                    </column>
                    <column id="1587">
                        <property name="width">3.4270833333333335in</property>
                    </column>
                    <row id="1588">
                        <property name="verticalAlign">middle</property>
                        <property name="height">12.75pt</property>
                        <cell id="1589">
                            <property name="colSpan">1</property>
                            <property name="rowSpan">1</property>
                        </cell>
                        <cell id="1591"/>
                        <cell id="1592">
                            <property name="colSpan">1</property>
                            <property name="rowSpan">1</property>
                        </cell>
                    </row>
                    <row id="1593">
                        <property name="verticalAlign">middle</property>
                        <property name="height">12.75pt</property>
                        <cell id="1594">
                            <property name="colSpan">3</property>
                            <property name="rowSpan">1</property>
                            <text id="1596">
                                <property name="textAlign">center</property>
                                <property name="contentType">auto</property>
                                <text-property name="content"><![CDATA[Footer of Coverpage with no page number]]></text-property>
                            </text>
                        </cell>
                    </row>
                    <row id="1598">
                        <property name="verticalAlign">middle</property>
                        <property name="height">12.75pt</property>
                        <cell id="1599"/>
                        <cell id="1600"/>
                        <cell id="1601"/>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <grid id="1284">
            <property name="masterPage">Coverpage</property>
            <property name="pageBreakAfter">always</property>
            <property name="height">8.59375in</property>
            <property name="width">6.229166666666667in</property>
            <column id="1285">
                <property name="width">6.229166666666667in</property>
            </column>
            <row id="1286">
                <property name="height">8.59375in</property>
                <cell id="1287">
                    <property name="paddingTop">0pt</property>
                    <property name="paddingLeft">0pt</property>
                    <property name="paddingBottom">0pt</property>
                    <property name="paddingRight">0pt</property>
                    <label id="7">
                        <property name="fontFamily">"Arial"</property>
                        <property name="fontSize">20pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">center</property>
                        <text-property name="text">Student Report</text-property>
                    </label>
                    <label id="107">
                        <property name="fontSize">x-large</property>
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">center</property>
                        <text-property name="text"></text-property>
                    </label>
                    <grid id="8">
                        <property name="fontFamily">"Arial"</property>
                        <property name="fontSize">11pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="color">black</property>
                        <property name="marginTop">0pt</property>
                        <property name="marginLeft">0pt</property>
                        <property name="textAlign">left</property>
                        <property name="pageBreakAfter">auto</property>
                        <property name="height">2.21875in</property>
                        <property name="width">6.177083333333333in</property>
                        <column id="367">
                            <property name="width">1.9cm</property>
                        </column>
                        <column id="9">
                            <property name="width">4.03cm</property>
                        </column>
                        <column id="53">
                            <property name="textAlign">center</property>
                            <property name="width">0.48cm</property>
                        </column>
                        <column id="10">
                            <property name="width">3.4166666666666665in</property>
                        </column>
                        <row id="11">
                            <property name="height">0.76cm</property>
                            <cell id="361">
                                <property name="paddingTop">0pt</property>
                                <property name="paddingLeft">0pt</property>
                                <property name="paddingBottom">0pt</property>
                                <property name="paddingRight">0pt</property>
                            </cell>
                            <cell id="12">
                                <label id="31">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Name</text-property>
                                </label>
                            </cell>
                            <cell id="47">
                                <label id="54">
                                    <text-property name="text">:</text-property>
                                </label>
                            </cell>
                            <cell id="13">
                                <label id="1570">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Thomas</text-property>
                                </label>
                            </cell>
                        </row>
                        <row id="14">
                            <property name="height">0.76cm</property>
                            <cell id="362"/>
                            <cell id="15">
                                <label id="30">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Class</text-property>
                                </label>
                            </cell>
                            <cell id="48">
                                <label id="55">
                                    <text-property name="text">:</text-property>
                                </label>
                            </cell>
                            <cell id="16">
                                <label id="1571">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">4E1</text-property>
                                </label>
                            </cell>
                        </row>
                        <row id="17">
                            <property name="height">0.76cm</property>
                            <cell id="363"/>
                            <cell id="18">
                                <label id="32">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">ID</text-property>
                                </label>
                            </cell>
                            <cell id="49">
                                <label id="56">
                                    <text-property name="text">:</text-property>
                                </label>
                            </cell>
                            <cell id="19">
                                <label id="1572">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">A01233394L</text-property>
                                </label>
                            </cell>
                        </row>
                        <row id="20">
                            <property name="height">0.76cm</property>
                            <cell id="364"/>
                            <cell id="21">
                                <label id="33">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">CCA</text-property>
                                </label>
                            </cell>
                            <cell id="50">
                                <label id="57">
                                    <text-property name="text">:</text-property>
                                </label>
                            </cell>
                            <cell id="22">
                                <label id="1573">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Band</text-property>
                                </label>
                            </cell>
                        </row>
                        <row id="23">
                            <property name="height">0.76cm</property>
                            <cell id="365">
                                <property name="paddingTop">1pt</property>
                            </cell>
                            <cell id="24">
                                <property name="paddingTop">1pt</property>
                                <label id="35">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Hobby</text-property>
                                </label>
                            </cell>
                            <cell id="51">
                                <property name="paddingTop">1pt</property>
                                <label id="58">
                                    <text-property name="text">:</text-property>
                                </label>
                            </cell>
                            <cell id="25">
                                <label id="1574">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Basketball</text-property>
                                </label>
                            </cell>
                        </row>
                        <row id="26">
                            <property name="height">1.91cm</property>
                            <cell id="366"/>
                            <cell id="27">
                                <label id="36">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Remarks</text-property>
                                </label>
                            </cell>
                            <cell id="52">
                                <label id="59">
                                    <text-property name="text">:</text-property>
                                </label>
                            </cell>
                            <cell id="28">
                                <label id="1575">
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">NIL</text-property>
                                </label>
                            </cell>
                        </row>
                    </grid>
                    <label id="1077">
                        <property name="fontFamily">"Arial"</property>
                        <property name="fontSize">11pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="textUnderline">none</property>
                        <property name="textAlign">center</property>
                        <text-property name="text">Class Records</text-property>
                    </label>
                    <grid id="1254">
                        <property name="height">2.9583333333333335in</property>
                        <property name="width">6.166666666666667in</property>
                        <column id="1255">
                            <property name="width">6.166666666666667in</property>
                        </column>
                        <row id="1256">
                            <property name="height">2.9583333333333335in</property>
                            <cell id="1257"/>
                        </row>
                    </grid>
                    <grid id="1552">
                        <property name="width">6.145833333333333in</property>
                        <column id="1553">
                            <property name="width">6.145833333333333in</property>
                        </column>
                        <row id="1554">
                            <cell id="1555">
                                <property name="textAlign">right</property>
                                <property name="display">inline</property>
                                <text id="1556">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontSize">9pt</property>
                                    <property name="display">inline</property>
                                    <property name="contentType">plain</property>
                                    <text-property name="content"><![CDATA[Total Page(s): ]]></text-property>
                                </text>
                                <auto-text id="1557">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontSize">9pt</property>
                                    <property name="display">inline</property>
                                    <property name="type">total-page</property>
                                </auto-text>
                            </cell>
                        </row>
                        <row id="1566">
                            <cell id="1567">
                                <property name="textAlign">right</property>
                                <property name="display">inline</property>
                                <text-data id="1482">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="textAlign">right</property>
                                    <method name="onRender"><![CDATA[
]]></method>
                                    <expression name="valueExpr">"Including this page"</expression>
                                    <property name="contentType">html</property>
                                </text-data>
                            </cell>
                        </row>
                    </grid>
                </cell>
            </row>
        </grid>
        <table id="1625">
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">medium</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">medium</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">medium</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">medium</property>
            <property name="masterPage">Simple MasterPage</property>
            <property name="pageBreakBefore">avoid</property>
            <property name="dataSet">Dummy Data</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">SN</property>
                    <text-property name="displayName">SN</text-property>
                    <expression name="expression" type="javascript">dataSetRow["SN"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Module</property>
                    <text-property name="displayName">Module</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Module"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Result</property>
                    <text-property name="displayName">Result</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Result"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="1644"/>
            <column id="1645"/>
            <column id="1646"/>
            <header>
                <row id="1626">
                    <property name="borderBottomStyle">solid</property>
                    <property name="borderBottomWidth">medium</property>
                    <property name="borderLeftStyle">solid</property>
                    <property name="borderLeftWidth">medium</property>
                    <property name="borderRightStyle">solid</property>
                    <property name="borderRightWidth">medium</property>
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">medium</property>
                    <cell id="1627">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <label id="1628">
                            <text-property name="text">SN</text-property>
                        </label>
                    </cell>
                    <cell id="1629">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <label id="1630">
                            <text-property name="text">Module</text-property>
                        </label>
                    </cell>
                    <cell id="1631">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <label id="1632">
                            <text-property name="text">Result</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="1633">
                    <property name="borderBottomStyle">solid</property>
                    <property name="borderBottomWidth">medium</property>
                    <property name="borderLeftStyle">solid</property>
                    <property name="borderLeftWidth">medium</property>
                    <property name="borderRightStyle">solid</property>
                    <property name="borderRightWidth">medium</property>
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">medium</property>
                    <cell id="1634">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <data id="1635">
                            <property name="resultSetColumn">SN</property>
                        </data>
                    </cell>
                    <cell id="1636">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <data id="1637">
                            <property name="resultSetColumn">Module</property>
                        </data>
                    </cell>
                    <cell id="1638">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <data id="1639">
                            <property name="resultSetColumn">Result</property>
                        </data>
                    </cell>
                </row>
            </detail>
        </table>
        <label id="1704">
            <property name="fontFamily">"Arial"</property>
            <property name="fontSize">11pt</property>
            <property name="fontWeight">bold</property>
            <property name="color">#FF0000</property>
            <property name="textUnderline">none</property>
            <property name="textAlign">center</property>
            <text-property name="text">Next table is NOT starting from a new page!!!</text-property>
        </label>
        <table id="1650">
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">medium</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">medium</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">medium</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">medium</property>
            <property name="masterPage">Simple MasterPage</property>
            <property name="pageBreakBefore">avoid</property>
            <property name="dataSet">Dummy Data</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">SN</property>
                    <text-property name="displayName">SN</text-property>
                    <expression name="expression" type="javascript">dataSetRow["SN"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Module</property>
                    <text-property name="displayName">Module</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Module"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Result</property>
                    <text-property name="displayName">Result</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Result"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="1665"/>
            <column id="1666"/>
            <column id="1667"/>
            <header>
                <row id="1651">
                    <property name="borderBottomStyle">solid</property>
                    <property name="borderBottomWidth">medium</property>
                    <property name="borderLeftStyle">solid</property>
                    <property name="borderLeftWidth">medium</property>
                    <property name="borderRightStyle">solid</property>
                    <property name="borderRightWidth">medium</property>
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">medium</property>
                    <cell id="1652">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <label id="1653">
                            <text-property name="text">SN</text-property>
                        </label>
                    </cell>
                    <cell id="1654">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <label id="1655">
                            <text-property name="text">Module</text-property>
                        </label>
                    </cell>
                    <cell id="1656">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <label id="1657">
                            <text-property name="text">Result</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="1658">
                    <property name="borderBottomStyle">solid</property>
                    <property name="borderBottomWidth">medium</property>
                    <property name="borderLeftStyle">solid</property>
                    <property name="borderLeftWidth">medium</property>
                    <property name="borderRightStyle">solid</property>
                    <property name="borderRightWidth">medium</property>
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">medium</property>
                    <cell id="1659">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <data id="1660">
                            <property name="resultSetColumn">SN</property>
                        </data>
                    </cell>
                    <cell id="1661">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <data id="1662">
                            <property name="resultSetColumn">Module</property>
                        </data>
                    </cell>
                    <cell id="1663">
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">medium</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">medium</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">medium</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">medium</property>
                        <data id="1664">
                            <property name="resultSetColumn">Result</property>
                        </data>
                    </cell>
                </row>
            </detail>
        </table>
    </body>
</report>

Offline

#11 2024-10-15 03:46:54

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Hi Eduardo,

Any update on this? We are also buying the commercial version of ReportServer. Any idea if this is a bug or I need a way to do it differently?

Regards,
mcrexy

Offline

#12 2024-10-15 09:33:32

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Page Number

Hi mcrexy,

fyi: we raised RS-8720 and we will write here when we have more information. Does exactly this same report work on your BIRT? Can you pls share a screenshot of what happens in your BIRT and what happens in ReportServer for comparison?
You can use http://imgbb.com for this.

Regards,
Eduardo

Offline

#13 2024-10-17 08:57:42

mcrexy
Member
Registered: 2024-08-24

Re: Page Number

Hi Eduardo,

Thank you for the update.

I will show you screenshots of pages from ReportServer, and BIRT. BIRT (BIRT Designer All-In-One) will have two methods of generating PDF, which I noticed the difference and will tell you a finding from GitHub's reply.

This is Page 4 of the PDF generated from both ReportServer and BIRT.
page4ofboth.png

  1. This is the Page 5 of the PDF generated from ReportServer. ❌
    page5of-Birt-Direct-PDF.png

  2. This is the Page 5 of the PDF generated from BIRT's Web Viewer and exported to PDF. ✅ The result is what we want.
    page5of-Birt-Web-Viewer-PDF.png

  3. However, this is the Page 5 of the PDF generated directly from BIRT, which has the same result as from ReportServer. ❌
    page5of-Report-Server.png


In a GitHub comment by speckyspooky, it was mentioned "Please be aware you need the Run and render task to get the result. If you start the PDF-creation directly from BIRT-eclipse then the pages won't be calculated. If the PDF-created from viewer so the document is created in full with page numbering the PDF looks fine". Is this the reason why point 1 and 3 have same result?

Last edited by mcrexy (2024-10-17 09:04:49)

Offline

Board footer

Powered by FluxBB