emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

Effectively using subqueries

Hi, I have searched through this forum and haven't found the answer to a problem I am having so I figured I will post it.

My SQL statement:

Select * FROM tblData WHERE LastName=
(SELECT tblData.LastName FROM tblData GROUP BY tblData.LastName HAVING (Count(tblData.LastName)>1))"

What I am trying to do: I am trying to make an SQL filter that I can apply to my form in order to only show records with duplicate last names. The sub query returns names that are already in the table. I then compare what is found to be duplicate with the original table in order to just show only the duplicate records. Everything works fine as long as there is only one name thats duplicated.

When there are multiple duplicate names then I run into an error.

When the statement is put into a string and executed in VBA I get this error:

"Run-time error '3021': No current record."

When the statement is put into a query and run against the DB I get this error:

"At most one record can be returned by this subquery"

So yeah, any help would be greatly appreciated. Am I going about this all wrong or am I just forgetting something? Thanks for any help.It is because ur subquery returns more than one value when u have more than one duplicates.This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.Check the code below.

Select distinct t.* FROM tblData t
inner join
( SELECT LastName FROM tblData
GROUP BY LastName
HAVING (Count(*)>1)
) as tm
on t.LastName=tm.LastName|||I understand what you did and it works fine when I run it as a query, but when I try and apply it as a filter it doesn't work. It just returns all records.