presuming you are doing this in the context of an SP and you want to immediately get a handle to the inserted column you can do the following.

Add identity column...

Just the local machine

Hi Phil,

I'm using VS2005 which has the control intgrated into it.

For VWD you may need to download the redist package from

http://www.microsoft.com/downloads/details.aspx?FamilyID=cc96c246-61e5-4d9e-bb5f-416d75a1b9ef&DisplayLang=en

I think the above needs .net 3.5 to...

I've found that you can usually get a little bit more control over Reporting Services reports when you add them to a web page via the Reportviewer control.

Not sure if...

If you are trying to add a Reporting Services report, but the rdl file is not available to you, you can recreate/download it from the reportserver.In a browser go to

if you can put up with having to open excel manually, you can simply paste the result + headers...make sure you have the option to copy result headers switched on.

From...

Could you please post the entire query used as the data source?

I've had this error before when using the DateDiff function, so I'm wondering if you are using datediff either...

Hi,

Are you sure that the field in the query is returning a numeric data type?

for example if I use

select '1' as MyNum

union (select '2')

union(select '3')

and try to add a summed...