Now do a select on SELECT * FROM PRODDTA.F0911 WHERE PRODDTA.F0911.[GLREG#] =0

and see how many records are returned

Add the servers from which you need to fetch the data as linked server using sp_addlinkedserver

Please refer to BOL and prefix the server name before servername.master.. in your stored...

Do you want to Navigate to another page or another report? Another report is pretty much possible.

Glad you finally got it to work.

Thanks

Obviously from your error code it seems like you authentication is failing on the password.

Are you using Integrated Windows Authentication on your Reports Folder?

Also check by doing the following

From Run...

Run eventvwr.msc and check if you are finding any errors on that with respect to your Reporting Server.

SELECT

ID.MNAME, sd.*

FROM

dbo.Import_FULL sd INNER JOIN...

Try using CDATE function for formatting the Date Parameter using the expression while passing to the subreport.

Ok, can you post one of your queries, so that I can what exactly can be done. You can use CASE in your where clause like

WHERE

 CASE WHEN ISNULL(b.surname,'') =''

THEN

   a.Surname

ELSE

b.surname...

Check if your SQL Server Reporting Service is running on the services.msc. Check if you have the required Virtual Directories for your ReportServer and ReportManager on the IIS and that...

Also make sure you do not use WHERE condition. Use AND condition if you are checking more than one condition after the OUTER JOIN. If you are including any condition...

Use a outer join

something like

from table a

left outer join table b ON a.surname = b.surname

in this case irrespective of whethere there is a matching record for a record of table...

It would look something like this

SELECT

DISTINCT Orders.OrderID,

Orders.CustomerID,...

Give this a try

Declare @AppBaseID Int

Declare @AppID Int

Declare @AppEEOID Int

Declare @RBID Int

Declare @AppToReqID Int

Declare @ss VarChar(15) --Social Security Number.

Declare @ErrorNum Int

SET  NoCount ON

SET  Xact_Abort OFF

SET  @ss = 0

 WHILE  @ss Is...

I see the problem use this syntax...

IF @ErrorNum <>0

GO TO ErrHandler

at the bottom, just write a COMMIT TRANSACTION

On the ErrHandler :

ROLLBACK TRANSACTION