Report Manager Column Width larger Preview
Hi there,
I made a report showing the ReportServer.ExecutionLog. In preview mode in Visual Studio 2005, the column width in the report is 25cm. The page width is 43cm, interactivesize page width is also 43cm. CanGrow=True. In preview mode of VS the width is displayed
correctly. However in the deployed version in the Report Manager the width is much larger. Is this a bug? What can/must I do to get the proper width displayed in the Report Manager?
<pre><?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="ReportServer">
<rd:DataSourceID>a6cbcf22-0e0c-4acc-a010-63f19ab16c1e</rd:DataSourceID>
<DataSourceReference>ReportServer</DataSourceReference>
</DataSource>
</DataSources>
<InteractiveHeight>27cm</InteractiveHeight>
<Description>Report ExecutionLog met UserName</Description>
<rd:DrawGrid>false</rd:DrawGrid>
<strong><InteractiveWidth>43cm</InteractiveWidth>
</strong> <rd:GridSpacing>0.1cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>0.5cm</RightMargin>
<LeftMargin>0.5cm</LeftMargin>
<BottomMargin>2.5cm</BottomMargin>
<rd:ReportID>6945edcd-86bb-44b9-8fcb-3685af423768</rd:ReportID>
<CodeModules>
<CodeModule>Baanstede, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null</CodeModule>
</CodeModules>
<strong> <PageWidth>43cm</PageWidth>
</strong> <DataSets>
<DataSet Name="ReportServerAd">
<Fields>
...
<Field Name="Parameters">
<DataField>Parameters</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
....
</Fields>
<Query>
<DataSourceName>ReportServer</DataSourceName>
<CommandText>SELECT *
FROM vewExecutionLogAd AS [log]
WHERE (CONVERT(DateTime, LEFT(CONVERT(VarChar, [Start], 105), 10), 105) BETWEEN @DatVanaf AND @DatTotMet)
ORDER BY Start DESC</CommandText>
<QueryParameters>
<QueryParameter Name="@DatVanaf">
<Value>=Parameters!DatVanaf.Value</Value>
</QueryParameter>
<QueryParameter Name="@DatTotMet">
<Value>=Parameters!DatTotMet.Value</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Author>MyName</Author>
<Code />
<Width>40.05628cm</Width>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Table Name="table1">
<DataSetName>ReportServerAd</DataSetName>
<Top>0.91429cm</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
...
<Textbox Name="Parameters">
<CanShrink>true</CanShrink>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Century Gothic</FontFamily>
<FontSize>7pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>1pt</PaddingTop>
<PaddingBottom>1pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!Parameters.Value</Value>
</Textbox>
</ReportItems>
...
</TableCells>
<Height>0.45cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
...
<TableCell>
<ReportItems>
<Textbox Name="lblParameters">
<Style>
<Color>White</Color>
<BackgroundColor>SteelBlue</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Century Gothic</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>9</ZIndex>
<Value>Parameters</Value>
</Textbox>
</ReportItems>
</TableCell>
...
</TableCells>
<Height>0.55873cm</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
...
<TableColumn>
<Width>25cm</Width>
</TableColumn>
...
</TableColumns>
</Table>
</ReportItems>
<Height>1.92302cm</Height>
</Body>
<Classes>
<Class>
<ClassName>Baanstede</ClassName>
<InstanceName>Bst</InstanceName>
</Class>
</Classes>
<Language>nl</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>27cm</PageHeight>
</Report>
I'll be back
July 3rd, 2011 5:02am
Hi Josie,
Thanks for your question. Based on my research, one possible reason of this issue is hadn’t check the check-box of Can increase to accommodate
contents, it is one property of textbox height, please follow below to check it.
1. Right-click the textbox of the column that the width is incorrect, select Textbox Properties.
2. In the Textbox Properties dialog box, click Format tab, check the check-box of Can increase to accommodate contents, click OK.
Hope it helps you.
If your issue still exists, please feel free to let me know.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 5:38am
This topic is archived. No further replies will be accepted.
Other recent topics
