Report Editor - Table Report Header Row

Hello,

I created a table report at one time and got a header row to only print on first page.

You can define it in the properties of the cell to only print on first page.

I'm now trying to create a new report with a table and cannot do the same for new report.

Crazy part is i can copy the table from one report to another and that is my work around.

Although if i need to add a new column the header row for that column prints on all pages.

I just upgraded to 8.1 so not sure if it's that but it's driving me nuts. I've compared the working one to the new one and cannot figure it out.

Any help is appreciated.

Thank you,

Lu

  • May I ask what the old version was, where the header worked as expected?

    Are you using separate Databand- and Headerband-components in the report or a Table-component?

  • Markus,

    I created it in 7.13.

    No i'm only using a Table-component with two rows.

    On the first row in each of the cell properties I tell it to print only on first page.

    Then the second row on the table-component I put some data element in there to fill in the report.

    I think you can copy and paste this into a report if you wanna look at it.

    I created a simple report for testing. Here is one with working table and not working table.

    Just create a report with Person and choose column XDateInserted,XDateUpdated,EntryDate.

    Then paste the following into Page 1 for each example.

    * Working __________________________________________

    <?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="StiReport Clipboard"><Brush>Transparent</Brush><ClientRectangle>0,0,0,0</ClientRectangle><Components isList="true" count="1"><Table1 Ref="1" type="Stimulsoft.Report.Components.Table.StiTable" isKey="true"><Brush>Transparent</Brush><ClientRectangle>0,20,772,60</ClientRectangle><ColumnCount>3</ColumnCount><Components isList="true" count="6"><Table1_Cell1 Ref="2" type="TableCell" isKey="true"><Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border><Brush>Transparent</Brush><ClientRectangle>0,0,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>d43d2988342042ba88f67be9fa0e26e1</Guid><HorAlignment>Center</HorAlignment><ID>0</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell1</Name><PrintOn>OnlyFirstPage</PrintOn><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>Date Inserted</Text><TextBrush>Black</TextBrush><TextOptions>,,,,WordWrap=True,A=0</TextOptions><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell1><Table1_Cell2 Ref="3" type="TableCell" isKey="true"><Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border><Brush>Transparent</Brush><ClientRectangle>260,0,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>b124c8fba887420b92983ed3c30c0079</Guid><HorAlignment>Center</HorAlignment><ID>1</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell2</Name><PrintOn>OnlyFirstPage</PrintOn><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>Date Updated</Text><TextBrush>Black</TextBrush><TextOptions>,,,,WordWrap=True,A=0</TextOptions><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell2><Table1_Cell3 Ref="4" type="TableCell" isKey="true"><Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border><Brush>Transparent</Brush><ClientRectangle>520,0,252,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>bb73599e6f914fc78aa30881a6850775</Guid><HorAlignment>Center</HorAlignment><ID>2</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell3</Name><PrintOn>OnlyFirstPage</PrintOn><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>Start Date</Text><TextBrush>Black</TextBrush><TextOptions>,,,,WordWrap=True,A=0</TextOptions><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell3><Table1_Cell4 Ref="5" type="TableCell" isKey="true"><Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border><Brush>Transparent</Brush><CanGrow>True</CanGrow><ClientRectangle>0,30,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><GrowToHeight>True</GrowToHeight><Guid>8fe7a55eb8b44ba2a3f33ea26a2e0acb</Guid><HorAlignment>Center</HorAlignment><ID>7</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell4</Name><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>{Person.XDateInserted}</Text><TextBrush>Black</TextBrush><TextOptions>,,,,WordWrap=True,A=0</TextOptions><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell4><Table1_Cell5 Ref="6" type="TableCell" isKey="true"><Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border><Brush>Transparent</Brush><CanGrow>True</CanGrow><ClientRectangle>260,30,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><GrowToHeight>True</GrowToHeight><Guid>7aa77b36a9fa4f40b1fb0f32d48572b8</Guid><HorAlignment>Center</HorAlignment><ID>8</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell5</Name><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>{Person.XDateUpdated}</Text><TextBrush>Black</TextBrush><TextOptions>,,,,WordWrap=True,A=0</TextOptions><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell5><Table1_Cell6 Ref="7" type="TableCell" isKey="true"><Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border><Brush>Transparent</Brush><CanGrow>True</CanGrow><ClientRectangle>520,30,252,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><GrowToHeight>True</GrowToHeight><Guid>6854f9925fce4a13a52f846c6fea4d86</Guid><HorAlignment>Center</HorAlignment><ID>9</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell6</Name><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>{Person.EntryDate}</Text><TextBrush>Black</TextBrush><TextOptions>,,,,WordWrap=True,A=0</TextOptions><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell6></Components><Conditions isList="true" count="0" /><DataRelationName isNull="true" /><DataSourceName>Person</DataSourceName><Filters isList="true" count="0" /><Guid>240bb68667644ec29abff417d73cac9b</Guid><HeaderRowsCount>1</HeaderRowsCount><IsSelected>True</IsSelected><MinHeight>0.2</MinHeight><Name>Table1</Name><NumberID>22</NumberID><RowCount>2</RowCount><Sort isList="true" count="0" /></Table1></Components><Conditions isList="true" count="0" /><Name /></StiSerializer>

    * Not Working __________________________________________

    <?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="StiReport Clipboard"><Brush>Transparent</Brush><ClientRectangle>0,0,0,0</ClientRectangle><Components isList="true" count="1"><Table1 Ref="1" type="Stimulsoft.Report.Components.Table.StiTable" isKey="true"><Brush>Transparent</Brush><BusinessObjectGuid isNull="true" /><ClientRectangle>0,20,772,60</ClientRectangle><ColumnCount>3</ColumnCount><Components isList="true" count="6"><Table1_Cell1 Ref="2" type="TableCell" isKey="true"><Border>All;Black;1;Solid;False;4;Black</Border><Brush>Transparent</Brush><ClientRectangle>0,0,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>5c719d982cd4492f88875fd79ce3663b</Guid><HorAlignment>Center</HorAlignment><ID>0</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell1</Name><PrintOn>OnlyFirstPage</PrintOn><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>Date Inserted</Text><TextBrush>Black</TextBrush><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell1><Table1_Cell2 Ref="3" type="TableCell" isKey="true"><Border>All;Black;1;Solid;False;4;Black</Border><Brush>Transparent</Brush><ClientRectangle>260,0,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>c593ff7255dc4c7bb236236914d1205b</Guid><HorAlignment>Center</HorAlignment><ID>1</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell2</Name><PrintOn>OnlyFirstPage</PrintOn><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>Date Updated</Text><TextBrush>Black</TextBrush><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell2><Table1_Cell3 Ref="4" type="TableCell" isKey="true"><Border>All;Black;1;Solid;False;4;Black</Border><Brush>Transparent</Brush><ClientRectangle>520,0,252,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>f4a3f7eff77f488d972eae4052cc5646</Guid><HorAlignment>Center</HorAlignment><ID>2</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell3</Name><PrintOn>OnlyFirstPage</PrintOn><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>Start Date</Text><TextBrush>Black</TextBrush><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell3><Table1_Cell4 Ref="5" type="TableCell" isKey="true"><Border>All;Black;1;Solid;False;4;Black</Border><Brush>Transparent</Brush><ClientRectangle>0,30,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>7c2b194c2c464ab7b01f5ffba23ab559</Guid><HorAlignment>Center</HorAlignment><ID>5</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell4</Name><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>{Person.XDateInserted}</Text><TextBrush>Black</TextBrush><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell4><Table1_Cell5 Ref="6" type="TableCell" isKey="true"><Border>All;Black;1;Solid;False;4;Black</Border><Brush>Transparent</Brush><ClientRectangle>260,30,260,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>ddf4a5a2fa844dfe849906ef63c06919</Guid><HorAlignment>Center</HorAlignment><ID>6</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell5</Name><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>{Person.XDateUpdated}</Text><TextBrush>Black</TextBrush><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell5><Table1_Cell6 Ref="7" type="TableCell" isKey="true"><Border>All;Black;1;Solid;False;4;Black</Border><Brush>Transparent</Brush><ClientRectangle>520,30,252,30</ClientRectangle><Conditions isList="true" count="0" /><Font>Arial,9</Font><Guid>5fb36459324a4d5abf1899df5c7f71f9</Guid><HorAlignment>Center</HorAlignment><ID>7</ID><JoinCells isList="true" count="0" /><Margins>0,0,0,0</Margins><Name>Table1_Cell6</Name><Restrictions>AllowMove, AllowSelect, AllowChange</Restrictions><Text>{Person.EntryDate}</Text><TextBrush>Black</TextBrush><TextQuality>Typographic</TextQuality><Type>Expression</Type></Table1_Cell6></Components><Conditions isList="true" count="0" /><DataRelationName isNull="true" /><DataSourceName>Person</DataSourceName><Filters isList="true" count="0" /><Guid>78ada21310e54e05901fed270acdacbc</Guid><IsSelected>True</IsSelected><Name>Table1</Name><NumberID>25</NumberID><RowCount>2</RowCount><Sort isList="true" count="0" /></Table1></Components><Conditions isList="true" count="0" /><Name /></StiSerializer>

  • Your not-working table has the property HeaderRows set to 0, that's the reason why it is not working.

    In addition, you do not need to set the PrintOn property on the columns, just setting Header Print On = Only First Page is enough when Header Rows is set to 1.

  • Markus,

    Thanks so much this was the solution. I did not even notice that. I thought i look at all setting and compared.

    I appreciate the help.

    Lu