Change the code in the Global Variables in the Balance sheet report (11200) as follows:
Existing code 1...
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
// Delete the following line.
<AutoRefresh>0</AutoRefresh>
// End of the deleted line.
<DataSources>
...
Replacement code 1...
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
...
Existing code 2...
</ConnectionProperties>
// Delete the following line.
<rd:SecurityType>None</rd:SecurityType>
// End of the deleted line.
<rd:DataSourceID>078b3105-54dd-41a2-b2cc-97cc545456f5</rd:DataSourceID>
...
Replacement code 2...
</ConnectionProperties>
<rd:DataSourceID>078b3105-54dd-41a2-b2cc-97cc545456f5</rd:DataSourceID>
...
Existing code 3...
<DataSet Name="DataSet_Result">
// Delete the following lines.
<Query>
<DataSourceName>DataSource</DataSourceName>
<CommandText />
</Query>
// End of the deleted lines.
<Fields>
...
Replacement code 3...
<DataSet Name="DataSet_Result">
<Fields>
...
Existing code 4...
</Fields>
<rd:DataSetInfo>
...
Replacement code 4...
</Fields>
// Add the following lines.
<Query>
<DataSourceName>DataSource</DataSourceName>
<CommandText />
</Query>
// End of the added lines.
<rd:DataSetInfo>
...
Existing code 5...
</DataSets>
// Delete the following lines.
<Code>Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function
Public Function BlankPos(ByVal Value As Decimal)
if Value > 0 then
Return ""
end if
Return Value
End Function
Public Function BlankZeroAndPos(ByVal Value As Decimal)
if Value >= 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNeg(ByVal Value As Decimal)
if Value < 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNegAndZero(ByVal Value As Decimal)
if Value <= 0 then
Return ""
end if
Return Value
End Function
</Code>
<Language>=User!Language</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportUnitType>Invalid</rd:ReportUnitType>
<rd:ReportID>3601b3ac-04bd-4ad8-9e53-8b1236ed6d8f</rd:ReportID>
// End of the deleted lines.
<Body>
...
Replacement code 5Existing code 6...
</TextRuns>
</Paragraph>
...
Replacement code 6...
</TextRuns>
// Add the following line.
<Style />
// End of the addded line.
</Paragraph>
...
Existing code 7...
<TablixColumn>
// Delete the following line.
<Width>1.575cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 7...
<TablixColumn>
// Add the following line.
<Width>0.59055in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 8...
<TablixColumn>
// Delete the following line.
<Width>6.525cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 8...
<TablixColumn>
// Add the following line.
<Width>2.3622in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 9...
<TablixColumn>
// Delete the following line.
<Width>3.4cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 9...
<TablixColumn>
// Add the following line.
<Width>0.90551in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 10...
<TablixColumn>
// Delete the following line.
<Width>3.6cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 10...
<TablixColumn>
// Add the following line.
<Width>0.90551in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 11...
<TablixColumn>
// Delete the following line.
<Width>2.95cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 11...
<TablixColumn>
// Add the following line.
<Width>0.90551in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 12...
<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 12...
<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 13<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 13<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 14<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 14<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 15<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 15<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 16...
<TablixRow>
// Delete the following line.
<Height>0.423cm</Height>
// End of the deleted line.
<TablixCells>
...
Replacement code 16...
<TablixRow>
// Add the following line.
<Height>0.16654in</Height>
// End of the added line.
<TablixCells>
...
Existing code 17...
</TextRuns>
</Paragraph>
...
Replacement code 17...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 18...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>0cm</Left>
<Height>0.423cm</Height>
<Width>1.5cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 18...
</Paragraphs>
<Style>
...
Existing code 19...
</TextRuns>
</Paragraph>
...
Replacement code 19...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 20...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>1.65cm</Left>
<Height>0.423cm</Height>
<Width>6cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 20...
</Paragraphs>
<Style>
...
Existing code 21...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>7.65cm</Left>
<Height>0.423cm</Height>
<Width>3.15cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 21Existing code 22...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>12.15cm</Left>
<Height>0.423cm</Height>
<Width>2.3cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 22...
</Paragraphs>
<Style>
...
Existing code 23...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>14.85cm</Left>
<Height>0.423cm</Height>
<Width>3.15cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 23...
</Paragraphs>
<Style>
...
Existing code 24...
</TextRuns>
</Paragraph>
...
Replacement code 24...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 25...
<TablixRow>
// Delete the following line.
<Height>0.423cm</Height>
// End of the deleted line.
<TablixCells>
...
Replacement code 25...
<TablixRow>
// Add the following line.
<Height>0.16654in</Height>
// End of the added line.
<TablixCells>
...
Existing code 26</TextRuns>
</Paragraph>
...
Replacement code 26</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 27...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>0cm</Left>
<Height>0.423cm</Height>
<Width>1.5cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 27...
</Paragraphs>
<Style>
...
Existing code 28</TextRuns>
</Paragraph>
...
Replacement code 28</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 29</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>1.65cm</Left>
<Height>0.423cm</Height>
<Width>6cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 29Existing code 30</TextRuns>
</Paragraph>
...
Replacement code 30</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 31</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>8.55cm</Left>
<Height>0.423cm</Height>
<Width>2.3cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 31Existing code 32</TextRuns>
</Paragraph>
...
Replacement code 32</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 33</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>12.15cm</Left>
<Height>0.423cm</Height>
<Width>2.3cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 33Existing code 34</TextRuns>
</Paragraph>
...
Replacement code 34</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 35</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>15.75cm</Left>
<Height>0.423cm</Height>
<Width>2.3cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 35Existing code 36</TextRuns>
</Paragraph>
...
Replacement code 36</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 37</TextRuns>
</Paragraph>
...
Replacement code 37</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 38</TextRuns>
</Paragraph>
...
Replacement code 38</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 39</TextRuns>
</Paragraph>
...
Replacement code 39</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 40...
</TablixMembers>
<DataElementName>Detail_Collection</DataElementName>
...
Replacement code 40...
</TablixMembers>
// Add the following lines.
<Visibility>
<Hidden>=IIF((Fields!G_L_Account___Balance_at_Date___G_L_Account___Net_Change_.Value<> 0),False,True )</Hidden>
</Visibility>
// End of the added lines.
<DataElementName>Detail_Collection</DataElementName>
...
Existing code 41...
<Height>0.846cm</Height>
</Tablix>
...
Replacement code 41...
<Height>0.846cm</Height>
// Add the following lines.
<Width>15.2cm</Width>
<ZIndex>1</ZIndex>
<Style />
// End of the added lines.
</Tablix>
...
Existing code 42...
<Height>1.692cm</Height>
</Body>
...
Replacement code 42...
<Height>1.692cm</Height>
// Add the following line.
<Style />
// End of the added line.
</Body>
...
Existing code 43...
</Body>
<Width>18.85cm</Width>
...
Replacement code 43...
</Body>
// Add the following lines.
<Code>Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function
Public Function BlankPos(ByVal Value As Decimal)
if Value > 0 then
Return ""
end if
Return Value
End Function
Public Function BlankZeroAndPos(ByVal Value As Decimal)
if Value >= 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNeg(ByVal Value As Decimal)
if Value < 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNegAndZero(ByVal Value As Decimal)
if Value <= 0 then
Return ""
end if
Return Value
End Function
</Code>
// End of the added lines.
<Width>18.85cm</Width>
...
Existing code 44...
<Width>3.25cm</Width>
<Style>
...
Replacement code 44...
<Width>3.25cm</Width>
// Add the following line.
<ZIndex>1</ZIndex>
// End of the added line.
<Style>
...
Existing code 45<Width>3.15cm</Width>
<Style>
...
Replacement code 45<Width>3.15cm</Width>
// Add the following line.
<ZIndex>2</ZIndex>
// End of the added line.
<Style>
...
Existing code 46</TextRuns>
</Paragraph>
...
Replacement code 46</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 47<Width>7.5cm</Width>
<Style>
...
Replacement code 47<Width>7.5cm</Width>
// Add the following line.
<ZIndex>3</ZIndex>
// End of the added line.
<Style>
...
Existing code 48</TextRuns>
</Paragraph>
...
Replacement code 48</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 49<Width>7.5cm</Width>
<Style>
...
Replacement code 49<Width>7.5cm</Width>
// Add the following line.
<ZIndex>4</ZIndex>
// End of the added line.
<Style>
...
Existing code 50</TextRuns>
</Paragraph>
...
Replacement code 50</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 51<Width>7.5cm</Width>
<Style>
...
Replacement code 51<Width>7.5cm</Width>
// Add the following line.
<ZIndex>5</ZIndex>
// End of the added line.
<Style>
...
Existing code 52</TextRuns>
</Paragraph>
...
Replacement code 52</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 53<Width>0.75cm</Width>
<Style>
...
Replacement code 53<Width>0.75cm</Width>
// Add the following line.
<ZIndex>6</ZIndex>
// End of the added line.
<Style>
...
Existing code 54</TextRuns>
</Paragraph>
...
Replacement code 54</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 55...
<BottomMargin>2cm</BottomMargin>
</Page>
...
Replacement code 55...
<BottomMargin>2cm</BottomMargin>
// Add the following line.
<Style />
// End of the added line.
</Page>
...
Existing code 56Replacement code 56...
</Page>
// Add the following lines.
<Language>=User!Language</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportID>3601b3ac-04bd-4ad8-9e53-8b1236ed6d8f</rd:ReportID>
<rd:ReportUnitType>Cm</rd:ReportUnitType>
// End of the added lines.
</Report>
...
Change the code in the Global Variables in the Income statement report (11201) as follows:
Existing code 1...
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
// Delete the following line.
<AutoRefresh>0</AutoRefresh>
// End of the deleted line.
<DataSources>
...
Replacement code 1...
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
...
Existing code 2...
</ConnectionProperties>
// Delete the following line.
<rd:SecurityType>None</rd:SecurityType>
// End of the deleted line.
<rd:DataSourceID>8ebf26e0-0b0c-48b1-aba7-282651564ae8</rd:DataSourceID>
...
Replacement code 2...
</ConnectionProperties>
<rd:DataSourceID>8ebf26e0-0b0c-48b1-aba7-282651564ae8</rd:DataSourceID>
...
Existing code 3...
<DataSet Name="DataSet_Result">
// Delete the following lines.
<Query>
<DataSourceName>DataSource</DataSourceName>
<CommandText />
</Query>
// End of the deleted lines.
<Fields>
...
Replacement code 3...
<DataSet Name="DataSet_Result">
<Fields>
...
Existing code 4...
</Fields>
<rd:DataSetInfo>
...
Replacement code 4...
</Fields>
// Add the following lines.
<Query>
<DataSourceName>DataSource</DataSourceName>
<CommandText />
</Query>
// End of the added lines.
<rd:DataSetInfo>
...
Existing code 5...
</DataSets>
// Delete the following lines.
<Code>Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function
Public Function BlankPos(ByVal Value As Decimal)
if Value > 0 then
Return ""
end if
Return Value
End Function
Public Function BlankZeroAndPos(ByVal Value As Decimal)
if Value >= 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNeg(ByVal Value As Decimal)
if Value < 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNegAndZero(ByVal Value As Decimal)
if Value <= 0 then
Return ""
end if
Return Value
End Function
</Code>
<Language>=User!Language</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportUnitType>Invalid</rd:ReportUnitType>
<rd:ReportID>7ca5956a-9e85-4253-98fd-d228e8432978</rd:ReportID>
// End of the deleted lines.
<Body>
...
Replacement code 5Existing code 6...
</TextRuns>
</Paragraph>
...
Replacement code 6...
</TextRuns>
// Add the following line.
<Style />
// End of the addded line.
</Paragraph>
...
Existing code 7...
<TablixColumn>
// Delete the following line.
<Width>1.575cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 7...
<TablixColumn>
// Add the following line.
<Width>0.59055in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 8...
<TablixColumn>
// Delete the following line.
<Width>6.3cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 8...
<TablixColumn>
// Add the following line.
<Width>2.3622in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 9...
<TablixColumn>
// Delete the following line.
<Width>2.25cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 9...
<TablixColumn>
// Add the following line.
<Width>0.70866in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 10...
<TablixColumn>
// Delete the following line.
<Width>3cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 10...
<TablixColumn>
// Add the following line.
<Width>0.70866in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 11...
<TablixColumn>
// Delete the following line.
<Width>3cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 11...
<TablixColumn>
// Add the following line.
<Width>0.70866in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 12...
<TablixColumn>
// Delete the following line.
<Width>2.025cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 12...
<TablixColumn>
// Add the following line.
<Width>0.70866in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 13<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 13<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 14<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 14<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 15<TablixColumn>
// Delete the following line.
<Width>0.2cm</Width>
// End of the deleted line.
</TablixColumn>
...
Replacement code 15<TablixColumn>
// Add the following line.
<Width>0.07874in</Width>
// End of the added line.
</TablixColumn>
...
Existing code 16...
<TablixRow>
// Delete the following line.
<Height>0.423cm</Height>
// End of the deleted line.
<TablixCells>
...
Replacement code 16...
<TablixRow>
// Add the following line.
<Height>0.16654in</Height>
// End of the added line.
<TablixCells>
...
Existing code 17...
</TextRuns>
</Paragraph>
...
Replacement code 17...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 18...
</TextRuns>
</Paragraph>
...
Replacement code 18...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 19...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>8.1cm</Left>
<Height>0.423cm</Height>
<Width>4.05cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 19...
</Paragraphs>
<Style>
...
Existing code 20...
</TextRuns>
</Paragraph>
...
Replacement code 20...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 21...
</TextRuns>
</Paragraph>
...
Replacement code 21...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 22...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>14.1cm</Left>
<Height>0.423cm</Height>
<Width>4.05cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 22...
</Paragraphs>
<Style>
...
Existing code 23...
</TextRuns>
</Paragraph>
...
Replacement code 23...
</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 24...
<TablixRow>
// Delete the following line.
<Height>0.423cm</Height>
// End of the deleted line.
<TablixCells>
...
Replacement code 24...
<TablixRow>
// Add the following line.
<Height>0.16654in</Height>
// End of the added line.
<TablixCells>
...
Existing code 25</TextRuns>
</Paragraph>
...
Replacement code 25</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 26...
</Paragraphs>
// Delete the following lines.
<Top>0.846cm</Top>
<Left>0cm</Left>
<Height>0.423cm</Height>
<Width>1.5cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 26...
</Paragraphs>
<Style>
...
Existing code 27</TextRuns>
</Paragraph>
...
Replacement code 27</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 28</Paragraphs>
// Delete the following lines.
<Top>0.846cm</Top>
<Left>1.65cm</Left>
<Height>0.423cm</Height>
<Width>6cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 28Existing code 29</Paragraphs>
// Delete the following lines.
<Top>0.846cm</Top>
<Left>8.1cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 29Existing code 30</Paragraphs>
// Delete the following lines.
<Top>0.846cm</Top>
<Left>10.35cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 30Existing code 31</Paragraphs>
// Delete the following lines.
<Top>0.846cm</Top>
<Left>14.1cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 31Existing code 32</Paragraphs>
// Delete the following lines.
<Top>0.846cm</Top>
<Left>16.35cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 32Existing code 33</TextRuns>
</Paragraph>
...
Replacement code 33</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 34...
<TablixRow>
// Delete the following line.
<Height>0.423cm</Height>
// End of the deleted line.
<TablixCells>
...
Replacement code 34...
<TablixRow>
// Add the following line.
<Height>0.16654in</Height>
// End of the added line.
<TablixCells>
...
Existing code 35</TextRuns>
</Paragraph>
...
Replacement code 35</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 36...
</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>0cm</Left>
<Height>0.423cm</Height>
<Width>1.5cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 36...
</Paragraphs>
<Style>
...
Existing code 37</TextRuns>
</Paragraph>
...
Replacement code 37</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 38</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>1.65cm</Left>
<Height>0.423cm</Height>
<Width>6cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 38Existing code 39</TextRuns>
</Paragraph>
...
Replacement code 39</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 40</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>8.1cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 40Existing code 41</TextRuns>
</Paragraph>
...
Replacement code 41</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 42</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>10.35cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 42Existing code 43</TextRuns>
</Paragraph>
...
Replacement code 43</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 44</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>14.1cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 44Existing code 45</TextRuns>
</Paragraph>
...
Replacement code 45</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 46</Paragraphs>
// Delete the following lines.
<Top>0cm</Top>
<Left>16.35cm</Left>
<Height>0.423cm</Height>
<Width>1.8cm</Width>
// End of the deleted lines.
<Style>
...
Replacement code 46Existing code 47</TextRuns>
</Paragraph>
...
Replacement code 47</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 48</TextRuns>
</Paragraph>
...
Replacement code 48</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 49</TextRuns>
</Paragraph>
...
Replacement code 49</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 50</TextRuns>
</Paragraph>
...
Replacement code 50</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 51...
</TablixMembers>
<DataElementName>Detail_Collection</DataElementName>
...
Replacement code 51...
</TablixMembers>
// Add the following lines.
<Visibility>
<Hidden>=IIF((Fields!G_L_Account___Net_Change_.Value<> 0),False,True )</Hidden>
</Visibility>
// End of the added lines.
<DataElementName>Detail_Collection</DataElementName>
...
Existing code 52...
<Height>1.269cm</Height>
</Tablix>
...
Replacement code 52...
<Height>1.269cm</Height>
// Add the following lines.
<Width>15.5cm</Width>
<ZIndex>1</ZIndex>
<Style />
// End of the added lines.
</Tablix>
...
Existing code 53...
<Height>2.115cm</Height>
</Body>
...
Replacement code 53...
<Height>2.115cm</Height>
// Add the following line.
<Style />
// End of the added line.
</Body>
...
Existing code 54...
</Body>
// Delete the following line.
<Width>18.95cm</Width>
// End of the deleted line.
<Page>
...
Replacement code 54...
</Body>
// Add the following lines.
<Code>Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function
Public Function BlankPos(ByVal Value As Decimal)
if Value > 0 then
Return ""
end if
Return Value
End Function
Public Function BlankZeroAndPos(ByVal Value As Decimal)
if Value >= 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNeg(ByVal Value As Decimal)
if Value < 0 then
Return ""
end if
Return Value
End Function
Public Function BlankNegAndZero(ByVal Value As Decimal)
if Value <= 0 then
Return ""
end if
Return Value
End Function
</Code>
<Width>22.775cm</Width>
// End of the added lines.
<Page>
...
Existing code 55...
<Width>3.25cm</Width>
<Style>
...
Replacement code 55...
<Width>3.25cm</Width>
// Add the following line.
<ZIndex>1</ZIndex>
// End of the added line.
<Style>
...
Existing code 56<Width>3.15cm</Width>
<Style>
...
Replacement code 56<Width>3.15cm</Width>
// Add the following line.
<ZIndex>2</ZIndex>
// End of the added line.
<Style>
...
Existing code 57</TextRuns>
</Paragraph>
...
Replacement code 57</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 58<Width>7.5cm</Width>
<Style>
...
Replacement code 58<Width>7.5cm</Width>
// Add the following line.
<ZIndex>3</ZIndex>
// End of the added line.
<Style>
...
Existing code 59</TextRuns>
</Paragraph>
...
Replacement code 59</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 60<Width>7.5cm</Width>
<Style>
...
Replacement code 60<Width>7.5cm</Width>
// Add the following line.
<ZIndex>4</ZIndex>
// End of the added line.
<Style>
...
Existing code 61</TextRuns>
</Paragraph>
...
Replacement code 61</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 62<Width>7.5cm</Width>
<Style>
...
Replacement code 62<Width>7.5cm</Width>
// Add the following line.
<ZIndex>5</ZIndex>
// End of the added line.
<Style>
...
Existing code 63</TextRuns>
</Paragraph>
...
Replacement code 63</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 64<Width>0.75cm</Width>
<Style>
...
Replacement code 64<Width>0.75cm</Width>
// Add the following line.
<ZIndex>6</ZIndex>
// End of the added line.
<Style>
...
Existing code 65</TextRuns>
</Paragraph>
...
Replacement code 65</TextRuns>
// Add the following line.
<Style />
// End of the added line.
</Paragraph>
...
Existing code 66...
<BottomMargin>2cm</BottomMargin>
</Page>
...
Replacement code 66...
<BottomMargin>2cm</BottomMargin>
// Add the following line.
<Style />
// End of the added line.
</Page>
...
Existing code 67Replacement code 67...
</Page>
// Add the following lines.
<Language>=User!Language</Language>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportID>7ca5956a-9e85-4253-98fd-d228e8432978</rd:ReportID>
<rd:ReportUnitType>Cm</rd:ReportUnitType>
// End of the added lines.
</Report>
...