RDL3 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

RDL3

Author

Topic

OBINNA_EKE
Posting Yak Master

234 Posts

Posted - 2010-12-30 : 06:42:29

<?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="Students">
<rd:DataSourceID>bbc1eac1-783b-4844-869d-64b638afd1a5</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>
</DataProvider>
<ConnectString>
</ConnectString>
</ConnectionProperties>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<ReportParameters>
<ReportParameter Name="VisibleColumnsList">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>VisibleColumnsList</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="HeaderColumnsList">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>HeaderColumnsList</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="UserColumnFilterBlock">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>UserColumnFilterBlock</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>2.5cm</RightMargin>
<LeftMargin>2.5cm</LeftMargin>
<BottomMargin>2.5cm</BottomMargin>
<rd:ReportID>91239076-10be-4db9-9661-470ec7b1fd3c</rd:ReportID>
<CodeModules>
<CodeModule>System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</CodeModule>
</CodeModules>
<PageWidth>21cm</PageWidth>
<DataSets>
<DataSet Name="Students">
<Fields>
<Field Name="ID">
<DataField>ID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="Title">
<DataField>Title</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="First">
<DataField>First</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Last">
<DataField>Last</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Scores">
<DataField>Scores</DataField>
<rd:TypeName>System.Collections.Generic.List`1[System.Int32]</rd:TypeName>
</Field>
<Field Name="Salary">
<DataField>Salary</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="Address">
<DataField>Address</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="City">
<DataField>City</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DateOfBirth">
<DataField>DateOfBirth</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="Nationality">
<DataField>Nationality</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FavoouriteMusic">
<DataField>FavoouriteMusic</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Hobby">
<DataField>Hobby</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OwnsAnIPod">
<DataField>OwnsAnIPod</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Students</DataSourceName>
<CommandText>
</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<rd:DataSetInfo>
<rd:DataSetName>
</rd:DataSetName>
<rd:TableName>
</rd:TableName>
<rd:ObjectDataSourceType>SampleReport.Students, SampleReport, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null</rd:ObjectDataSourceType>
</rd:DataSetInfo>
</DataSet>
</DataSets>
<Code> Public Shared Function ManageVisibility(ByVal fieldName As String, ByVal sParameterValues As Parameter) as Boolean

'If sParameterValues Is Nothing Then
' return False
'end if

If sParameterValues.IsMultiValue Then
Dim values() As Object = TryCast(sParameterValues.Value, Object())

For i As Integer = 0 To values.Length - 1
if values(i) = fieldName Then
return False
end if
Next i
End If
return True
End Function

Public Shared Function GetFriendlyHeader(ByVal fieldHeaderName As String, ByVal sParameterValues As Parameter, ByVal sHeaderParameterValues As Parameter) as String

Dim values() As Object = TryCast(sParameterValues.Value, Object())
Dim HeaderValues() As Object = TryCast(sHeaderParameterValues.Value, Object())

if(values.Length <> HeaderValues.Length) then
return ""
end if

For i As Integer = 0 To values.Length -1
if values(i) = fieldHeaderName Then ' Find out the index by comparing technical column name with the passing column paramet from header label
return HeaderValues(i) ' Ok we got one, now return the values from HeaderValues (Friendly name) for the same index.
end if
Next i
return ""
End Function

Public Shared Function GetFriendlyHeader2(ByVal fieldHeaderName As String, ByVal xmlParameterValues As String, ByVal sHeaderParameterValues As Parameter) as String

Dim objXMLDoc As System.Xml.XmlDocument = New System.Xml.XmlDocument()
'Dim objXMLDoc As New System.Xml.XmlDocument()
Dim objNodeList As System.Xml.XmlNodeList
Dim node As System.Xml.XmlNode
objXMLDoc.LoadXml(xmlParameterValues)

Dim counter
counter = 0
objNodeList = objXMLDoc.getElementsByTagName("UserColumn")

If objNodeList.count > 0 then
For each node in objNodeList

if objNodeList.item(counter).Attributes.getNamedItem("UserColumnId").value = fieldHeaderName
return objNodeList.item(counter).Attributes.getNamedItem("UserColumnFriendlyName").value
end IF
counter = counter + 1

Next
return ""
End If

End Function

</Code>
<Width>39.02776cm</Width>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>33.01587cm</Width>
<Style>
<Color>DarkRed</Color>
<FontFamily>Verdana</FontFamily>
<FontSize>16pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.7619cm</Height>
<Value>Student Report</Value>
</Textbox>
<Table Name="table1">
<DataSetName>Students</DataSetName>
<Top>0.7619cm</Top>
<Width>35.77776cm</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="ID">
<rd:DefaultName>ID</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Title">
<rd:DefaultName>Title</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Title.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="First">
<rd:DefaultName>First</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!First.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Last">
<rd:DefaultName>Last</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Last.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Scores">
<rd:DefaultName>Scores</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Scores.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Salary">
<rd:DefaultName>Salary</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Salary.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Address">
<rd:DefaultName>Address</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Address.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="City">
<rd:DefaultName>City</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!City.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="DateOfBirth">
<rd:DefaultName>DateOfBirth</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Format(Fields!DateOfBirth.Value,"dd MMM yyyy h:mm tt")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Nationality">
<rd:DefaultName>Nationality</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Nationality.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="FavoouriteMusic">
<rd:DefaultName>FavoouriteMusic</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!FavoouriteMusic.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Hobby">
<rd:DefaultName>Hobby</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Hobby.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="OwnsAnIPod">
<rd:DefaultName>OwnsAnIPod</rd:DefaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!OwnsAnIPod.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.53333cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.GetFriendlyHeader("ID", Parameters!VisibleColumnsList, Parameters!HeaderColumnsList)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtTitle">
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Title</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="rubbish">
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.GetFriendlyHeader("First", Parameters!VisibleColumnsList, Parameters!HeaderColumnsList)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtLast">
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Last</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.GetFriendlyHeader("Scores", Parameters!VisibleColumnsList, Parameters!HeaderColumnsList)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Salary</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Address</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.GetFriendlyHeader2("City", Parameters!UserColumnFilterBlock.Value(0), Parameters!HeaderColumnsList)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Date Of Birth</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<rd:DefaultName>textbox11</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Nationality</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Favoourite Music</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<rd:DefaultName>textbox13</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Hobby</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<rd:DefaultName>textbox14</rd:DefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#4e0000</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Verdana</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>Owns An IPod</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.55873cm</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("ID", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>1.25cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Title", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("First", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Last", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Scores", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Salary", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.25cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Address", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("City", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("DateOfBirth", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>5cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Nationality", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("FavoouriteMusic", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>4cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("Hobby", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2.53968cm</Width>
</TableColumn>
<TableColumn>
<Visibility>
<Hidden>=Code.ManageVisibility("OwnsAnIPod", Parameters!VisibleColumnsList)</Hidden>
</Visibility>
<Width>2cm</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Height>1.85397cm</Height>
</Body>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>

If it is that easy, everybody will be doing it

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-30 : 08:46:43

Is there a question here?

--
Gail Shaw
SQL Server MVP

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2010-12-31 : 05:37:16

SELECT solution FROM MindReader

-----------

I used to think I wasn't a morning person but it never got better in the afternoon

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2011-01-03 : 09:03:43

Instead of

SELECT solution FROM MindReader

you should use the built in SQLTEAM function WaitForPeso.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 09:12:27

I must get him to tell me which model of crystal ball he uses. The one I have doesn't work so well.

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2011-01-03 : 11:49:23

You can buy my virtual crystal ball if you like?!!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-03 : 12:25:20

Swap for my not-so-functional one?

--
Gail Shaw
SQL Server MVP

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-03 : 12:49:07

Now there's an idea for a SQLTeam handle: SQLSauron

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2011-01-05 : 12:23:10

Rob, wouldn't that be Joe C?

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-05 : 13:06:25

He would make an excellent wizard.

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2011-01-18 : 14:15:43

I don't know about the wizardry nor the "excellent" portion of your comment.

Terry

-- You can't be late until you show up.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources