NetWork Credentials. Please help

I need to see report using ReportViewer. Problem is when I want to see report
as customer it asks for Username and Password. So I need to code in page load
like
Imports Microsoft.Samples.ReportingServices.ReportViewer
Dim rs As ReportingService = New ReportingService
rs.Credentials = New NetworkCredential(username, password, domain)
Dim extensions() As Extension = rs.ListExtensions(ExtensionTypeEnum.Delivery)
Problem is it says "ReportingService" Type not defined. Dont know what I am
missing. Please any one help.Have you addded a Web Reference to the report server web service?
If not, use Project -> Add Web Reference and browse to
http://<server>/reportserver/reportservice.asmx.
Watch what namespace the web reference goes into, you'll need to use
Imports on the namespace or fully qualify the ReportingService type.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 19 Oct 2004 16:35:03 -0700, "LordAli"
<LordAli@.discussions.microsoft.com> wrote:
>I need to see report using ReportViewer. Problem is when I want to see report
>as customer it asks for Username and Password. So I need to code in page load
>like
>Imports Microsoft.Samples.ReportingServices.ReportViewer
> Dim rs As ReportingService = New ReportingService
> rs.Credentials = New NetworkCredential(username, password, domain)
> Dim extensions() As Extension =>rs.ListExtensions(ExtensionTypeEnum.Delivery)
>Problem is it says "ReportingService" Type not defined. Dont know what I am
>missing. Please any one help.

Nested Inner Joins

Hi folks,

I have three tables:

ActivityCalls, UserList, and People

UserList.Username and ActivityCalls.Username are 'INNER JOINED' to determine which user is attached to an activity.

What I want to do is go one step further and look up the People.PersonName from people.

Here's what I have so far but it doesn't seem to work... Am I on the wrong track here?

INNER JOIN (People INNER JOIN UserList ON UserList.User_Username=ActivityCalls.Username)
ON People.Person_ID=UserList.Person_ID

Any help would be greatly appreciated.

Thanks

Nick

Quote:

Originally Posted by nkew

Hi folks,

I have three tables:

ActivityCalls, UserList, and People

UserList.Username and ActivityCalls.Username are 'INNER JOINED' to determine which user is attached to an activity.

What I want to do is go one step further and look up the People.PersonName from people.

Here's what I have so far but it doesn't seem to work... Am I on the wrong track here?

INNER JOIN (People INNER JOIN UserList ON UserList.User_Username=ActivityCalls.Username)
ON People.Person_ID=UserList.Person_ID

Any help would be greatly appreciated.

Thanks

Nick

Hi Nick
This might work:

FROM UserList U
INNER JOIN ActivityCalls A
ON U.User_Username = A.Username
INNER JOIN People P
ON U.User_PersonID = P.Person_ID