Skip to main content
Question

Report Designer: Mismatch between total span of value

  • December 5, 2024
  • 2 replies
  • 117 views

GISANCAR
Sidekick (Customer)
Forum|alt.badge.img+8

We have a couple of report layouts that can’t be opened in Report Designer 200.3.0000

The layouts work in IFS Cloud to generate printouts and they can be opened and modified in the older Report Designer for v10 (100.0.0003).

The error message given, when opening the layout, in the latest version:

“Mismatch between total span of value of 120 and no of columns of the table”

Clicking OK on the message, the layout is closed and not possible to edit in this version.

 

I can’t find anything in the documentation about this error, or anyone who can answer and help me how to address the issue.

To be able to work around this I had to install the old version of Report designer on a different server, because the old version requires Java 8 while the new version requires Java 11 and I can’t make them co-exist on the same computer.

 

The only location where ‘120’ exists in the RDL is in this location:

                           <table-cell>
                              <properties>
                                 <border-bottom-style>solid</border-bottom-style>
                                 <border-bottom-width>0.25pt</border-bottom-width>
                                 <display-align>after</display-align>
                                 <font-size>10pt</font-size>
                                 <font-weight>bold</font-weight>
                                 <number-columns-spanned>120</number-columns-spanned>
                              </properties>
                              <data>../../../tns:PURCHASE_ORDER_PRINT_REP_TRANSLATIONS/tns:REPORT_TEXTS/tns:TXNEWLINES</data>
                              <conditions>
                                 <visible>tns:RE_OPTION2 = -1 or tns:RE_OPTION2 = 0</visible>
                              </conditions>
                              <text-field>
                                 <properties>
                                    <font-family>Verdana</font-family>
                                    <font-weight>bold</font-weight>
                                    <left>0cm</left>
                                    <top>0pt</top>
                                 </properties>
                                 <data>../../../tns:PURCHASE_ORDER_PRINT_REP_TRANSLATIONS/tns:REPORT_TEXTS/tns:TXNEWLINES</data>
                              </text-field>
                           </table-cell>
 

How can I figure out what the correct value should be?

2 replies

Forum|alt.badge.img+17
  • Superhero (Partner)
  • 516 replies
  • November 12, 2025

Hui ​@GISANCAR 

 

Do You know how to manage that error?


GISANCAR
Sidekick (Customer)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 42 replies
  • November 13, 2025

@knepiosko,

Yes, I figured it out, how to correct the issue. The problem is that I don’t remember what I did 😊.

You have use the older version of Report Designer. I figured out which table that was causing the error - it was a mismatch between the number of columns stated in the XML compared to the number of columns defined.

I don’t remember if I counted the number of defined columns and then updated to the correct value or if I rebuilt the the heading table row that had the mismatch...