Column Difficulties - Please Assist  
Index ‹ Information Technology ‹ SVCS
Author Message
solidac
PostPosted: Top
SVCS >> Column Difficulties - Please Assist I have posted several entries in regard to understanding columns.

I really need assistance immediately for our client reports.

I have tried working with the margins in the report to no avail.

Is there a book or technical documents dedicated to column use within RS?


EXAMPLE XML FILE:

<?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="IPC_VISION_DEV">
<DataSourceReference>IPC_VISION_DEV</DataSourceReference>
<rd:DataSourceID>67c8718b-280a-444c-ad0b-19b7389f839e</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.5in</BottomMargin>
<RightMargin>0.5in</RightMargin>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>0in</ColumnSpacing>
<ReportItems>
<Table Name="table1">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="NAM_Name_ID">
<rd:DefaultName>NAM_Name_ID</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total Member Companies: </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<rd:DefaultName>textbox15</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=" " &
CountDistinct(Fields!NAM_Name_ID.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.20833in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>0.125in</Left>
<DataSetName>IPC_VISION_DEV</DataSetName>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="NAM_Company_ID">
<rd:DefaultName>NAM_Company_ID</rd:DefaultName>
<ZIndex>3</ZIndex>
<ToggleImage>
<InitialState>true</InitialState>
</ToggleImage>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>14pt</FontSize>
<BackgroundColor>=iif(RowNumber(nothing) mod 1
=0,"Beige",Nothing)</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!NAM_Company_ID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="table1_Group1">
<Parent>=Fields!NAM_Company_ID.Value</Parent>
<GroupExpressions>

<GroupExpression>=Fields!NAM_Company_ID.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Width>7.25in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>

<Value>=code.aim_(Fields!ADDR_Org_Name_1.Value,Fields!ADDR_Org_Name_2.Value,Fields!ADDR_Address_1.Value,
Fields!ADDR_Address_2.Value, Fields!ADDR_City.Value, Fields!ADDR_State.Value,
Fields!ADDR_Zip.Value, Fields!ADDR_Country.Value)
</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Silver</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>

<SortExpression>=Fields!NAM_Company_ID.Value</SortExpression>

<SortExpressionScope>table1_Group1</SortExpressionScope>
</UserSort>
<Value>Sort by Company ID</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.20833in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>6.25in</Width>
</TableColumn>
<TableColumn>
<Width>1in</Width>
</TableColumn>
</TableColumns>
<Height>0.91666in</Height>
</Table>
</ReportItems>
<Height>1in</Height>
</Body>
<PageHeader>
<ReportItems>
<Image Name="image1">
<Sizing>AutoSize</Sizing>
<ZIndex>3</ZIndex>
<Width>1.73958in</Width>
<Source>Embedded</Source>
<Style />
<Height>0.73958in</Height>
<Value>ipc</Value>
</Image>
<Textbox Name="textbox3">
<Left>2.125in</Left>
<Top>0.25in</Top>
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>2</ZIndex>
<Width>4in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Verdana</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>20pt</FontSize>
<BorderColor>
<Default>White</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.375in</Height>
<Value>Member Companies</Value>
</Textbox>
<Line Name="line1">
<Left>0.125in</Left>
<Top>0.875in</Top>
<ZIndex>1</ZIndex>
<Width>7.25in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>2pt</Default>
</BorderWidth>
</Style>
<Height>0in</Height>
</Line>
<Textbox Name="textbox2">
<Left>5.625in</Left>
<Top>1in</Top>
<rd:DefaultName>textbox2</rd:DefaultName>
<Width>1.75in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<Format>g</Format>
<BorderColor>
<Default>White</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Globals!ExecutionTime</Value>
</Textbox>
</ReportItems>
<Height>1.25in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageHeader>
<rd:ReportID>41bf6997-fee7-4744-876b-9c360ee885fc</rd:ReportID>
<LeftMargin>0.5in</LeftMargin>
<EmbeddedImages>
<EmbeddedImage Name="ipc">

<ImageData>Qk3+iwAAAAAAADYAAAAoAAAApwAAAEcAAAABABgAAAAAAMiLAAAAAAAAAAAAAAAAAAAAAAAA/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v+/v7+/v7+/v7+AAAA</ImageData>
<MIMEType>image/bmp</MIMEType>
</EmbeddedImage>
</EmbeddedImages>
<DataSets>
<DataSet Name="IPC_VISION_DEV">
<Query>
<CommandText>SELECT Names.NAM_Company_ID,
Addresses.ADDR_Org_Name_1, Addresses.ADDR_Org_Name_2,
Addresses.ADDR_Address_1,
Addresses.ADDR_Address_2, Addresses.ADDR_Country,
Addresses.ADDR_City, Addresses.ADDR_State, Addresses.ADDR_Zip,
Names.NAM_Name_ID
FROM Names INNER JOIN
Renewal_Information ON Names.NAM_Name_ID =
Renewal_Information.RNL_Name_ID INNER JOIN
Addresses ON Names.NAM_Address_ID =
Addresses.ADDR_Address_ID
WHERE (Renewal_Information.RNL_Status IN ('A', 'N')) AND
(Names.NAM_Delete_Flag <> 'X') AND (Renewal_Information.RNL_Renewal_Code =
'IPC') AND
(Names.NAM_Record_Type = 'MC')
ORDER BY Addresses.ADDR_Org_Name_1</CommandText>
<DataSourceName>IPC_VISION_DEV</DataSourceName>
</Query>
<Fields>
<Field Name="NAM_Company_ID">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>NAM_Company_ID</DataField>
</Field>
<Field Name="ADDR_Org_Name_1">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Org_Name_1</DataField>
</Field>
<Field Name="ADDR_Org_Name_2">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Org_Name_2</DataField>
</Field>
<Field Name="ADDR_Address_1">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Address_1</DataField>
</Field>
<Field Name="ADDR_Address_2">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Address_2</DataField>
</Field>
<Field Name="ADDR_Country">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Country</DataField>
</Field>
<Field Name="ADDR_City">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_City</DataField>
</Field>
<Field Name="ADDR_State">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_State</DataField>
</Field>
<Field Name="ADDR_Zip">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Zip</DataField>
</Field>
<Field Name="NAM_Name_ID">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>NAM_Name_ID</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="DSGroup">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT Names.NAM_Company_ID,
Addresses.ADDR_Org_Name_1, Addresses.ADDR_Org_Name_2,
Addresses.ADDR_Address_1,
Addresses.ADDR_Address_2, Addresses.ADDR_Country,
Addresses.ADDR_City, Addresses.ADDR_State, Addresses.ADDR_Zip,
Names.NAM_Name_ID
FROM Names INNER JOIN
Renewal_Information ON Names.NAM_Name_ID =
Renewal_Information.RNL_Name_ID INNER JOIN
Addresses ON Names.NAM_Address_ID =
Addresses.ADDR_Address_ID
WHERE (Renewal_Information.RNL_Status IN ('A', 'N')) AND
(Names.NAM_Delete_Flag <> 'X') AND (Renewal_Information.RNL_Renewal_Code =
'IPC') AND
(Names.NAM_Record_Type = 'MC')
ORDER BY Addresses.ADDR_Company_ID</CommandText>
<DataSourceName>IPC_VISION_DEV</DataSourceName>
</Query>
<Fields>
<Field Name="NAM_Company_ID">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>NAM_Company_ID</DataField>
</Field>
<Field Name="ADDR_Org_Name_1">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Org_Name_1</DataField>
</Field>
<Field Name="ADDR_Org_Name_2">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Org_Name_2</DataField>
</Field>
<Field Name="ADDR_Address_1">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Address_1</DataField>
</Field>
<Field Name="ADDR_Address_2">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Address_2</DataField>
</Field>
<Field Name="ADDR_Country">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Country</DataField>
</Field>
<Field Name="ADDR_City">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_City</DataField>
</Field>
<Field Name="ADDR_State">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_State</DataField>
</Field>
<Field Name="ADDR_Zip">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ADDR_Zip</DataField>
</Field>
<Field Name="NAM_Name_ID">
<rd:TypeName>System.Double</rd:TypeName>
<DataField>NAM_Name_ID</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Author>Terry Ward</Author>
<Code>Public Shared Function aim_(ByVal torg1 As String, ByVal torg2 As
String, ByVal taddr1 As String, ByVal taddr2 As String , ByVal tcity As
String, ByVal tstate As String, ByVal tzipcode As String, ByVal tcountry As
String) As String
Dim vaddr1, vaddr2, vaddress, tend As String
tend = ""
vaddr1 = taddr1 + vbCrLf
vaddr2 = taddr2 + vbCrLf

if not len(trim(tcountry)) = 0 then
tend = vbCrLf + tcountry + vbCrLf
end if

if trim(taddr2) = "" then
if not trim(torg2) = "" then
vaddress = trim(torg1) + vbCrLf + trim(torg2) + vbCrLf + vaddr1 +
trim(tcity)+", "+ trim(tstate) + " " + trim(tzipcode) + tend
else
vaddress = trim(torg1) + vbCrLf + vaddr1 + trim(tcity)+", "+ trim(tstate)
+ " " + trim(tzipcode) + tend
end if
else
vaddress = vaddr1 + vaddr2 + trim(tcity)+", "+ trim(tstate) + " " +
trim(tzipcode) + tend
end if

Return vaddress
End Function


Public Function AltCol(ByVal RowNum As Integer) As String
Dim ReturnColor as String
If RowNum Mod 2
ReturnColor = "WhiteSmoke"
Else
ReturnColor = "White"
End If
Return ReturnColor
End Function</Code>
<Width>7.875in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Line Name="line2">
<Left>0.125in</Left>
<Top>0.125in</Top>
<ZIndex>2</ZIndex>
<Width>7.25in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>2pt</Default>
</BorderWidth>
</Style>
<Height>0in</Height>
</Line>
<Textbox Name="textbox6">
<Left>5.375in</Left>
<Top>0.25in</Top>
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>1</ZIndex>
<Width>2in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>="Page " & Globals!PageNumber & " of " &
Globals!TotalPages</Value>
</Textbox>
<Textbox Name="textbox4">
<Left>0.125in</Left>
<Top>0.25in</Top>
<rd:DefaultName>textbox4</rd:DefaultName>
<Width>3.75in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>="Report Name: " & Globals!ReportName</Value>
</Textbox>
</ReportItems>
<Height>0.625in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
</Report>

Information Technology425  
 
 
 
Index ‹ Information Technology ‹ SVCS