This is a migrated thread and some comments may be shown as answers.

Alternate Rows Color Strange Behaviours

4 Answers 246 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Arthur
Top achievements
Rank 1
Veteran
Iron
Arthur asked on 30 Jun 2016, 03:00 PM

I have a .trdx report file that uses Conditional Formatting to apply kind of an alternating rows color. This works fine inside the Telerik Report Designer but when I use the very same .trdx file with the HTML 5 Viewer, some colors get inverted.

Please find the attached screenshots. The first one is the one taken in the Designer, the second one is the one taken in the HTML 5 Viewer.

Regards.

4 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 30 Jun 2016, 03:52 PM
Hi Arthur,

Please post the XML content to check the report's settings. Also check if there are external styles messing with the report rendered as HTML in the viewer.

On a side note, check the conditions specified by conditional formatting rules and if the report's data fulfills them.

Regards,
Stef
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Arthur
Top achievements
Rank 1
Veteran
Iron
answered on 30 Jun 2016, 04:06 PM

Here is the XML

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlDataSource2" Width="17cm" UnitOfMeasure="Cm" Name="MovementsDrillDown" xmlns="http://schemas.telerik.com/reporting/2012/3.9">
  <DataSources>
    <SqlDataSource ConnectionString="priarch" SelectCommand="dbo.traxs_Reports_MovementsDrillDown_Hdr_Get" SelectCommandType="StoredProcedure" Name="sqlDataSource2">
      <Parameters>
        <SqlDataSourceParameter DbType="Int32" Name="@product">
          <Value>
            <String>= Parameters.product.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
    <SqlDataSource ConnectionString="priarch" SelectCommand="dbo.traxs_Reports_MovementsDrillDown_Get" SelectCommandType="StoredProcedure" Name="sqlDataSource1">
      <Parameters>
        <SqlDataSourceParameter DbType="Int32" Name="@product">
          <Value>
            <String>= Parameters.product.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>
  <Items>
    <PageHeaderSection Height="1.69999994953474cm" Name="pageHeader">
      <Items>
        <Panel Width="10cm" Height="0.6cm" Left="0.0530167882795433cm" Top="0.962491692155831cm" Name="panel1">
          <Items>
            <TextBox Width="1.64678346396047cm" Height="0.600000023841858cm" Left="0cm" Top="0cm" Value="Product" Name="textBox32">
              <Style VerticalAlign="Middle">
                <Font Size="10pt" Bold="True" />
              </Style>
            </TextBox>
            <TextBox Width="8.35291612582208cm" Height="0.600000023841858cm" Left="1.64698356497731cm" Top="0cm" Value="= Fields.description" Angle="0" Format="" Name="product">
              <Style VerticalAlign="Middle" />
            </TextBox>
          </Items>
        </Panel>
        <TextBox Width="12.5999994277954cm" Height="0.962191700935364cm" Left="0cm" Top="0cm" Value="Movements Drill Down" Name="textBox5" StyleName="Title">
          <Style>
            <Font Name="Arial" Size="22pt" />
          </Style>
        </TextBox>
      </Items>
    </PageHeaderSection>
    <PageFooterSection Height="0.714374980129302cm" Name="pageFooter">
      <Items>
        <TextBox Width="7.8277083571992cm" Height="0.6cm" Left="0.0529166651947631cm" Top="0.0529166651947631cm" Value="=NOW()" Name="currentTimeTextBox" StyleName="PageInfo" />
        <TextBox Width="7.62380838394165cm" Height="0.600000023841858cm" Left="9.33cm" Top="0.05cm" Value="=PageNumber" Name="pageInfoTextBox" StyleName="PageInfo">
          <Style TextAlign="Right" />
        </TextBox>
      </Items>
    </PageFooterSection>
    <DetailSection Height="2.59999989906947cm" Name="detail">
      <Items>
        <Crosstab DataSourceName="sqlDataSource1" Width="12.1868400755823cm" Height="2.40312511982228cm" Left="0.0530167882795433cm" Top="0cm" ColumnHeadersPrintOnEveryPage="True" Name="crosstab1" StyleName="">
          <Body>
            <Cells>
              <TableCell RowIndex="1" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.0260302454211cm" Height="0.499999946652852cm" Left="0cm" Top="0cm" Value="= Count(Fields.ref)" Format="" Name="ref_hidden" StyleName="">
                    <Style Visible="True" VerticalAlign="Middle">
                      <Font Size="8pt" />
                    </Style>
                    <ConditionalFormatting>
                      <FormattingRule>
                        <Style BackgroundColor="240, 240, 240" Color="Black" />
                        <Filters>
                          <Filter Expression="= (Exec("movement_type_row_grp", RowNumber()) + RowNumber("movement_type_row_grp"))%2" Operator="Equal" Value="= 1" />
                        </Filters>
                      </FormattingRule>
                    </ConditionalFormatting>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.60811472726814cm" Height="0.499999933195235cm" Left="0cm" Top="0cm" Value="= Sum(Fields.quantity)" Name="quantity_hidden" StyleName="">
                    <Style Visible="True" TextAlign="Right" VerticalAlign="Middle">
                      <Font Size="8pt" />
                    </Style>
                    <ConditionalFormatting>
                      <FormattingRule>
                        <Style BackgroundColor="240, 240, 240" Color="Black" />
                        <Filters>
                          <Filter Expression="= (Exec("movement_type_row_grp", RowNumber()) + RowNumber("movement_type_row_grp"))%2" Operator="Equal" Value="= 1" />
                        </Filters>
                      </FormattingRule>
                    </ConditionalFormatting>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="2" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.0260302454211cm" Height="0.503125207951519cm" Left="0cm" Top="0cm" Value="= Count(Fields.ref)" Name="ref_parent_hidden" StyleName="">
                    <Style Visible="True" VerticalAlign="Middle">
                      <Font Size="8pt" />
                    </Style>
                    <ConditionalFormatting>
                      <FormattingRule>
                        <Style BackgroundColor="240, 240, 240" Color="Black" />
                        <Filters>
                          <Filter Expression="= Exec("movement_type_row_grp", RowNumber()%2)" Operator="Equal" Value="=0" />
                        </Filters>
                      </FormattingRule>
                    </ConditionalFormatting>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="2" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.60811472726814cm" Height="0.503125194633612cm" Left="0cm" Top="0cm" Value="= Sum(Fields.quantity)" Name="quantity_parent_hidden" StyleName="">
                    <Style TextAlign="Right" VerticalAlign="Middle">
                      <Font Size="8pt" />
                    </Style>
                    <ConditionalFormatting>
                      <FormattingRule>
                        <Style BackgroundColor="240, 240, 240" Color="Black" />
                        <Filters>
                          <Filter Expression="= Exec("movement_type_row_grp", RowNumber()%2)" Operator="Equal" Value="=0" />
                        </Filters>
                      </FormattingRule>
                    </ConditionalFormatting>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.0260302454211cm" Height="0.499999839224793cm" Left="0cm" Top="0cm" Value="= Fields.ref" Name="ref" StyleName="">
                    <Style VerticalAlign="Middle">
                      <Font Size="8pt" />
                    </Style>
                    <ConditionalFormatting>
                      <FormattingRule>
                        <Style BackgroundColor="240, 240, 240" Color="Black" />
                        <Filters>
                          <Filter Expression="= (Exec("movement_type_row_grp", RowNumber()) + Exec("date_visible_row_grp", RowNumber()))%2" Operator="Equal" Value="= 1" />
                        </Filters>
                      </FormattingRule>
                    </ConditionalFormatting>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.60811472726814cm" Height="0.499999825767171cm" Left="0cm" Top="0cm" Value="= Fields.quantity" Name="quantity" StyleName="">
                    <Style TextAlign="Right" VerticalAlign="Middle">
                      <Font Size="8pt" />
                    </Style>
                    <ConditionalFormatting>
                      <FormattingRule>
                        <Style BackgroundColor="240, 240, 240" Color="Black" />
                        <Filters>
                          <Filter Expression="= (Exec("movement_type_row_grp", RowNumber()) + Exec("date_visible_row_grp", RowNumber()))%2" Operator="Equal" Value="= 1" />
                        </Filters>
                      </FormattingRule>
                    </ConditionalFormatting>
                  </TextBox>
                </ReportItem>
              </TableCell>
            </Cells>
            <Columns>
              <Column Width="2.02603026668082cm" />
              <Column Width="2.60811418247393cm" />
            </Columns>
            <Rows>
              <Row Height="0.499999861576526cm" />
              <Row Height="0.49999996900459cm" />
              <Row Height="0.503125230442967cm" />
            </Rows>
          </Body>
          <Corner>
            <Cells>
              <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="4.41498800945365cm" Height="0.900000062997535cm" Left="0cm" Top="0cm" Value="Movement Type" Name="movement_type_hdr" StyleName="">
                    <Style VerticalAlign="Middle">
                      <BorderStyle Bottom="Solid" />
                      <Font Name="Arial" Size="8pt" Bold="True" />
                    </Style>
                    <Action>
                      <ToggleVisibilityAction DisplayExpandedMark="False">
                        <Targets>
                          <Target ItemName="date_visible_row_grp" />
                          <Target ItemName="date_hidden_row_grp" />
                        </Targets>
                      </ToggleVisibilityAction>
                    </Action>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="3.13770812899269cm" Height="0.900000089819652cm" Left="0cm" Top="0cm" Value="Date" Name="date_hdr" StyleName="">
                    <Style VerticalAlign="Middle">
                      <BorderStyle Bottom="Solid" />
                      <Font Size="8pt" Bold="True" />
                    </Style>
                    <Action>
                      <ToggleVisibilityAction DisplayExpandedMark="False">
                        <Targets>
                          <Target ItemName="details_visible_row_grp" />
                          <Target ItemName="details_hidden_row_grp" />
                        </Targets>
                      </ToggleVisibilityAction>
                    </Action>
                  </TextBox>
                </ReportItem>
              </TableCell>
            </Cells>
          </Corner>
          <RowGroups>
            <TableGroup Name="movement_type_row_grp">
              <ReportItem>
                <TextBox Width="4.41498763789091cm" Height="1.50312503406241cm" Left="0cm" Top="0cm" KeepTogether="False" Value="= Fields.movement_type" CanGrow="True" CanShrink="False" Name="movement_type" StyleName="">
                  <Style VerticalAlign="Middle">
                    <BorderStyle Default="None" Bottom="None" />
                    <BorderWidth Default="1pt" Bottom="1px" />
                    <Font Name="Arial" Size="8pt" />
                  </Style>
                  <ConditionalFormatting>
                    <FormattingRule>
                      <Style BackgroundColor="240, 240, 240" Color="Black" />
                      <Filters>
                        <Filter Expression="=RowNumber()%2" Operator="Equal" Value="=0" />
                      </Filters>
                    </FormattingRule>
                  </ConditionalFormatting>
                  <Action>
                    <ToggleVisibilityAction DisplayExpandedMark="False">
                      <Targets>
                        <Target ItemName="date_visible_row_grp" />
                        <Target ItemName="date_hidden_row_grp" />
                      </Targets>
                    </ToggleVisibilityAction>
                  </Action>
                </TextBox>
              </ReportItem>
              <ChildGroups>
                <TableGroup Visible="False" Name="date_visible_row_grp">
                  <ReportItem>
                    <TextBox Width="3.13770779608308cm" Height="0.999999812792953cm" Left="0cm" Top="0cm" Value="= Fields.date" Format="{0:d}" Name="date" StyleName="">
                      <Style Visible="True" VerticalAlign="Middle">
                        <Font Size="8pt" />
                      </Style>
                      <ConditionalFormatting>
                        <FormattingRule>
                          <Style BackgroundColor="240, 240, 240" Color="Black" />
                          <Filters>
                            <Filter Expression="= (Exec("movement_type_row_grp", RowNumber()) + RowNumber("movement_type_row_grp"))%2" Operator="Equal" Value="= 1" />
                          </Filters>
                        </FormattingRule>
                      </ConditionalFormatting>
                      <Action>
                        <ToggleVisibilityAction DisplayExpandedMark="False">
                          <Targets>
                            <Target ItemName="details_visible_row_grp" />
                            <Target ItemName="details_hidden_row_grp" />
                          </Targets>
                        </ToggleVisibilityAction>
                      </Action>
                    </TextBox>
                  </ReportItem>
                  <ChildGroups>
                    <TableGroup Visible="False" Name="details_visible_row_grp">
                      <Groupings>
                        <Grouping />
                      </Groupings>
                    </TableGroup>
                    <TableGroup Name="details_hidden_row_grp" />
                  </ChildGroups>
                  <Groupings>
                    <Grouping Expression="= Fields.date" />
                  </Groupings>
                  <Sortings>
                    <Sorting Expression="= Fields.date" Direction="Asc" />
                  </Sortings>
                </TableGroup>
                <TableGroup Name="date_hidden_row_grp">
                  <ReportItem>
                    <TextBox Width="3.13770793634956cm" Height="0.50312518810207cm" Left="0cm" Top="0cm" Value="=CountDistinct(Fields.date)" Name="date_hidden" StyleName="">
                      <Style VerticalAlign="Middle">
                        <Font Size="8pt" />
                      </Style>
                      <ConditionalFormatting>
                        <FormattingRule>
                          <Style BackgroundColor="240, 240, 240" Color="Black" />
                          <Filters>
                            <Filter Expression="= Exec("movement_type_row_grp", RowNumber()%2)" Operator="Equal" Value="=0" />
                          </Filters>
                        </FormattingRule>
                      </ConditionalFormatting>
                    </TextBox>
                  </ReportItem>
                  <ChildGroups>
                    <TableGroup Name="basic_row_grp" />
                  </ChildGroups>
                </TableGroup>
              </ChildGroups>
              <Groupings>
                <Grouping Expression="= Fields.movement_type" />
              </Groupings>
              <Sortings>
                <Sorting Expression="= Fields.movement_type" Direction="Asc" />
              </Sortings>
            </TableGroup>
          </RowGroups>
          <ColumnGroups>
            <TableGroup Name="ref_col_grp">
              <ReportItem>
                <TextBox Width="2.0260302454211cm" Height="0.900000054374417cm" Left="0cm" Top="0cm" Value="Ref" Name="ref_hdr" StyleName="">
                  <Style VerticalAlign="Middle">
                    <BorderStyle Bottom="Solid" />
                    <Font Size="8pt" Bold="True" />
                  </Style>
                </TextBox>
              </ReportItem>
            </TableGroup>
            <TableGroup Name="quantity_col_grp">
              <ReportItem>
                <TextBox Width="2.60811472726814cm" Height="0.900000022988842cm" Left="-1.35301673781428cm" Top="-2.99999989906947cm" Value="Quantity" Name="quantity_hdr" StyleName="">
                  <Style TextAlign="Right" VerticalAlign="Middle">
                    <BorderStyle Bottom="Solid" />
                    <Font Size="8pt" Bold="True" />
                  </Style>
                </TextBox>
              </ReportItem>
            </TableGroup>
          </ColumnGroups>
        </Crosstab>
      </Items>
    </DetailSection>
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style Color="Black">
        <Font Name="Tahoma" Size="18pt" Bold="True" Italic="False" Underline="False" Strikeout="False" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Title" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black" VerticalAlign="Middle">
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Caption" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style VerticalAlign="Middle">
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Data" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style VerticalAlign="Middle">
        <Font Name="Tahoma" Size="8pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="PageInfo" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="Table" StyleName="Normal.TableNormal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.TableGroup" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Verdana" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="Table" StyleName="Aspect.TableNormal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Verdana" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Aspect.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="227, 222, 209">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Verdana" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Aspect.SubTotal" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="148, 147, 143" Color="241, 238, 232">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Verdana" Size="10pt" Bold="True" Italic="False" Underline="False" Strikeout="False" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Aspect.GrandTotal" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="50, 50, 50" Color="227, 222, 209" VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Verdana" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Aspect.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="241, 238, 232" Color="50, 50, 50">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Verdana" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Aspect.TableGroup" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.SubTotal" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" Bold="True" Italic="False" Underline="False" Strikeout="False" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.GrandTotal" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.TableCorner" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="A4" Landscape="False">
      <Margins>
        <MarginsU Left="10mm" Right="10mm" Top="10mm" Bottom="10mm" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <ReportParameters>
    <ReportParameter Name="product" Type="Integer" Text="Product">
      <Value>
        <String>=33470</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="expand" Type="Boolean" Text="expand">
      <Value>
        <String>=0</String>
      </Value>
    </ReportParameter>
  </ReportParameters>
</Report>

No external styles messing with the report.

And the condition are the same - it is the same report - in the HTML5 Viewer and in the Standalone Designer. The idea is to alternate colors for each Movement Type, then to alternate it again for each Date when the ToggleVisibilityAction is used. I'm just using the RowNumber and the "Parent" RowNumber to alternate the colors.

0
Arthur
Top achievements
Rank 1
Veteran
Iron
answered on 01 Jul 2016, 09:35 AM

I have been digging a bit further. I replaced the value of all the fields with their Conditional Formatting to spot something, and I have.

Please have a look at the screenshots.

- When you see only one number before the one between brackets, this number mod 2 needs to be equal to the number between brackets in order to change color. So for 1 (0), 1%2 != 0 so the cell will remain white.

- When you see two numbers before the one between brackets, the first one will always be the RowNumber of the parent group (Movement Type), which serves as an offset, and the second one will be the RowNumber of this cell in the parent's scope. The sum of the two numbers mod 2 needs to be equal to the number between brackets in order to change color. So for 5 3 (1), (5 + 3)%2 != 1 so the cell will remain white.

Now if you take a look at the Html5Viewer screenshot, I pointed the line where it starts bugging. It shows 5 1 (1) instead of 5 4 (1). The method to get the bugged number is "RowNumber("movement_type_row_grp")".

What's wrong with this method? It works fine in the Standalone Designer, but gives me a false value in the Html5 Viewer. I can't remotely understand what's going on under the bonnet.

 

Regards

0
Stef
Telerik team
answered on 01 Jul 2016, 03:47 PM
Hi Arthur,

Thank you for the provided information.
We managed to reproduce the problem on preview in the HTML5 Viewer. It is logged for further investigation and improvement in our system.

Your Telerik points are updated to thank you for bringing the issue to our attention.

Regards,
Stef
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Arthur
Top achievements
Rank 1
Veteran
Iron
Answers by
Stef
Telerik team
Arthur
Top achievements
Rank 1
Veteran
Iron
Share this question
or