Bolding subtotals in a matrix --(it's not working on report server)
Greetings,
I am using SSRS 2005
Version 2.0.50727 SP2 (maybe I don't have the latest and greatest, but I'm pretty sure my problem just popped up)
Using Windows 7
IE 8.0.7600.16385
So as the title suggests, While my designer shows my subtotals are bold when I view it on the report server the subtotals are not bolded.
Am i missing something? (yes I have clicked the green triangle and changed the font weight to bold. I even changed it using the inscope function) Here is the xml.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<rd:DataSourceID>8bc0c177-5f0b-4957-b718-f836ce5c0fde</rd:DataSourceID>
<DataSourceReference>DataSource1</DataSourceReference>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>1in</RightMargin>
<LeftMargin>1in</LeftMargin>
<BottomMargin>1in</BottomMargin>
<rd:ReportID>630f378b-49c4-48ab-a20a-2a23876eaca8</rd:ReportID>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Grouper">
<DataField>Grouper</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="amount">
<DataField>amount</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="dt">
<DataField>dt</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataSource1</DataSourceName>
<CommandText>Select 'Group1' as Grouper, 100 as amount, '1/31/2010' as dt
Union
Select 'Group1' as Grouper, 250 as amount, '1/31/2010' as dt</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Width>6.5in</Width>
<Body>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>1in</Width>
</MatrixColumn>
</MatrixColumns>
<DataSetName>DataSet1</DataSetName>
<RowGroupings>
<RowGrouping>
<Width>1in</Width>
<DynamicRows>
<Grouping Name="matrix1_Grouper">
<GroupExpressions>
<GroupExpression>=Fields!Grouper.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Subtotal>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<Style>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
<Style>
<FontWeight>700</FontWeight>
</Style>
</Subtotal>
<ReportItems>
<Textbox Name="Grouper">
<rd:DefaultName>Grouper</rd:DefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!Grouper.Value</Value>
</Textbox>
</ReportItems>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<Top>0.625in</Top>
<ColumnGroupings>
<ColumnGrouping>
<Height>0.25in</Height>
<DynamicColumns>
<Grouping Name="matrix1_dt">
<GroupExpressions>
<GroupExpression>=Fields!dt.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<ReportItems>
<Textbox Name="dt">
<rd:DefaultName>dt</rd:DefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!dt.Value</Value>
</Textbox>
</ReportItems>
</DynamicColumns>
</ColumnGrouping>
</ColumnGroupings>
<Width>2in</Width>
<Corner>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</Corner>
<MatrixRows>
<MatrixRow>
<Height>0.25in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="amount">
<rd:DefaultName>amount</rd:DefaultName>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!amount.Value)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
<Height>0.75in</Height>
<Left>0.625in</Left>
</Matrix>
</ReportItems>
<Height>2in</Height>
</Body>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>
Thanks in advance for your help
- Report Writer 'SSRS User'
December 8th, 2010 5:11pm
Hello,
You can try the following
Select that row in a matrix and in the properties window change font weight to "Heavy" from a combo box
Change font size and/or fontstyle Save this report Check what report server you are deploying Deploy a report Observe changes Sergei
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2010 7:20pm
Sergei,
Hey thanks for the response and clever idea. Unfortunately, id did not work. I'm afraid I may have to reinstall. I'm at a loss. It seemed to just start happening too.
again thanks for the idea.
-ssrs user
December 9th, 2010 9:32am
Hi,
Has this issue been resolved? And is there any update? I have tested your report code in the same environment, but everything works fine.
So, I think the problem is not caused by SSRS, but some other specified environment factors. My suggestion is that you can try to upgrade your SSRS to the latest version.
For SQL Server Reporting Services Service Pack, you can refer to:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ca6523d1-d265-4c15-b89a-9268e5e3cda4
Thanks,
Albert Ye
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 9:08pm
This topic is archived. No further replies will be accepted.
Other recent topics
