+1 Absolutely add it. Not only can we vote on them but we will get visiability into issues that we have not personally experienced yet.

As Jeff showed there are many ways to do this. I only provided one possibility.

I've been a silent observer on this site for along time and finally feel that I...

Maybe something like this

with cte (ID, somefield) as

(

select ID, FieldName from TableA

)

select TableB.Field

from TableB

join cte

on cte.ID = TableB.ID

Looks like a permissions issue to me - "current user does not have permissions on that object". Check that the user you are executing as has permissions to the funciton...

+1 I also checked 0. Got an error when I ran it.

I got the answer correct but the question is very misleading. The name of the column is Column1 not col1 as it's referred to in the answers. So really the...

Have you tried connecting using the port number - MSSQLSERVER\NamedInstance,port number.

Have you tried setting the EA using the RsConfig Utility http://msdn.microsoft.com/en-us/library/ms156302.aspx.

Do Not click on the link from dba-vb. IE will start opening mulitple pages and become unresponsive. A reboot will be required.

Hi Marvin

Could you please also send me the script to backup one database at a time like Shri asked for or post it here. I would really appreciate it.

Thanks,

Lynn

Here is a TechNet article that explains the what and how to backup reporting services

http://technet.microsoft.com/en-us/library/ms155814.aspx

I hope I'm understanding your problem correctly. Do you have all subreports within the same tablix? If so that is the problem. In SSRS 2008 each subreport needs to be...

Select your table so you can see the column/row selectors

Right click in the "ALL" selector (the top left corner), then click properties

This birngs up the Table Properties dialog

There you can...

If you are using SQL Server Reporting Services then this service needs to be running else you can stop it.

Thanks. We'll give option 2 a try.