SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 RDL3
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

OBINNA_EKE
Posting Yak Master

234 Posts

Posted - 12/30/2010 :  06:42:29  Show Profile  Reply with Quote
<?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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 12/30/2010 :  08:46:43  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Is there a question here?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2048 Posts

Posted - 12/31/2010 :  05:37:16  Show Profile  Reply with Quote
SELECT solution FROM MindReader

-----------

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

DonAtWork
Flowing Fount of Yak Knowledge

2143 Posts

Posted - 01/03/2011 :  09:03:43  Show Profile  Reply with Quote
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
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/03/2011 :  09:12:27  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/03/2011 :  11:49:23  Show Profile  Reply with Quote
You can buy my virtual crystal ball if you like?!!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/03/2011 :  12:25:20  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Swap for my not-so-functional one?



--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 01/03/2011 12:39:34
Go to Top of Page

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 01/03/2011 :  12:49:07  Show Profile  Visit robvolk's Homepage  Reply with Quote
Now there's an idea for a SQLTeam handle: SQLSauron
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2143 Posts

Posted - 01/05/2011 :  12:23:10  Show Profile  Reply with Quote
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
Go to Top of Page

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 01/05/2011 :  13:06:25  Show Profile  Visit robvolk's Homepage  Reply with Quote
He would make an excellent wizard.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 01/18/2011 :  14:15:43  Show Profile  Reply with Quote
I don't know about the wizardry nor the "excellent" portion of your comment.

Terry

-- You can't be late until you show up.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 1.7 seconds. Powered By: Snitz Forums 2000