Drawing line at last record

Hi.
I have a table containing two groups and a detail area.My report has multiple pages.I want to draw line after the last record on every page.I think that expression will be written in record's bottom expression area.How can I choose the last record in every page.Or is there another way to do this.Could you help me please?why wont u draw a line on page footer? when u draw a line on page footer it will diplay on the bottom of each page.|||Thanks but it didn't work
I drawed horizontal line across the page footer.
But there is several blank rows between the last record and the line in page footer.And this is never looking good.If you have another idea about this please share with me.

Downloads from the SSIS team

Hi, Just a quick note for all that the SSIS team has started to post fresh content for download.

We will be adding some links to various pages so you can easily see things when looking at the the SSIS portal on MSDN http://msdn.microsoft.com/SQL/bi/integration/default.aspx

For now if you search for "ssis" on the microsoft downloads site you will find the current content. Sample Logging reports, jump start training, Meta Data info, and sample components. More coming over the next few weeks...
http://www.microsoft.com/downloads/search.aspx?displaylang=en

Thank you and I hope everyone enjoys winding down 2005, or blowing it out, depending on your likes :)

SSIS team

Several sample transforms are now available as well.

For now if you search for "ssis" on the microsoft downloads site you will find them. http://www.microsoft.com/downloads/search.aspx?displaylang=en

Downloads from the SSIS team

Hi, Just a quick note for all that the SSIS team has started to post fresh content for download.

We will be adding some links to various pages so you can easily see things when looking at the the SSIS portal on MSDN http://msdn.microsoft.com/SQL/bi/integration/default.aspx

For now if you search for "ssis" on the microsoft downloads site you will find the current content. Sample Logging reports, jump start training, Meta Data info, and sample components. More coming over the next few weeks...
http://www.microsoft.com/downloads/search.aspx?displaylang=en

Thank you and I hope everyone enjoys winding down 2005, or blowing it out, depending on your likes :)

SSIS team

Several sample transforms are now available as well.

For now if you search for "ssis" on the microsoft downloads site you will find them. http://www.microsoft.com/downloads/search.aspx?displaylang=en

Domain name from URL

Does anyone know how to extract just the domain from a URL in T-SQL? So,
for example, http://www.awebsite.com/pages/thispage.html" would come out as
http://www.awebsite.com, or just www.awebsite.com.
Many thanks for any help.SELECT
substring(REPLACE('http://www.awebsite.com/pages/thispage.html','http://',''
),0,CHARINDEX('/',REPLACE('http://www.awebsite.com/pages/thispage.html','htt
p://','')))
HTH. Ryan
"Chris Pratt" <not@.given.com> wrote in message
news:etv05ZBIGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Does anyone know how to extract just the domain from a URL in T-SQL? So,
> for example, http://www.awebsite.com/pages/thispage.html" would come out
> as http://www.awebsite.com, or just www.awebsite.com.
> Many thanks for any help.
>|||Something like this?
declare @.string varchar(1024)
declare @.UriScheme varchar(16)
set @.string = 'http://www.awebsite.com/pages/thispage.html'
select @.UriScheme = substring(@.string, 0, patindex('%://%', @.string))
set @.string = substring(@.string, patindex('%://%', @.string) + 3, len(@.string
))
select @.UriScheme + '://' + substring(@.string, 0, charindex('/', @.string))
ML
http://milambda.blogspot.com/|||Chris
DECLARE @.fullurl VARCHAR(1000)
SET @.fullurl = 'http://www.cnn.com/articles/sports/show.asp?id=4'
SELECT SUBSTRING(@.fullurl, CHARINDEX('//', @.fullurl)+2,
CHARINDEX('/', SUBSTRING( @.fullurl,
CHARINDEX('//', @.fullurl)+2, LEN(@.fullurl)))-1 )
"Chris Pratt" <not@.given.com> wrote in message
news:etv05ZBIGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Does anyone know how to extract just the domain from a URL in T-SQL? So,
> for example, http://www.awebsite.com/pages/thispage.html" would come out
> as http://www.awebsite.com, or just www.awebsite.com.
> Many thanks for any help.
>|||That worked brilliantly, thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eeh19dBIGHA.2928@.TK2MSFTNGP10.phx.gbl...
> SELECT
> substring(REPLACE('http://www.awebsite.com/pages/thispage.html','http://',
''),0,CHARINDEX('/',REPLACE('http://www.awebsite.com/pages/thispage.html','h
ttp://','')))
> --
> HTH. Ryan
> "Chris Pratt" <not@.given.com> wrote in message
> news:etv05ZBIGHA.1424@.TK2MSFTNGP12.phx.gbl...
>|||That works great (see above posting!), except for two possible scenarios.
The first is where the URL is actually just the domain name anyway - for
example http://www.awebsite.com. You can get round this by forcing a
trailing '/' to the URL string your are testing, so that one is ok.
The other is if the site begins "https" instead of "http", in which case
just "https:" is returned. Would it be possible to cater for this as well?
Many thanks again,
Chris
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eeh19dBIGHA.2928@.TK2MSFTNGP10.phx.gbl...
> SELECT
> substring(REPLACE('http://www.awebsite.com/pages/thispage.html','http://',
''),0,CHARINDEX('/',REPLACE('http://www.awebsite.com/pages/thispage.html','h
ttp://','')))
> --
> HTH. Ryan
> "Chris Pratt" <not@.given.com> wrote in message
> news:etv05ZBIGHA.1424@.TK2MSFTNGP12.phx.gbl...
>