They come from Active Directory (AD)...

I would recommend not using xp_sendmail and using xpsmtp_send_mail instead. Assuming you are using smtp this is a better solution since you don't have to have outlook loaded on teh...

You can use the alias, the calculation firstname + lastname, or the column number...

so...

order by 'FullName'

order by firstname + ' ' + last name

order by 1

all produce the same result...

Cheers,

Ben

Greetings M Chabot,

Have you found an answer to this? My first thought here is that you could find where in the XML it contains this reference and then you could...

Hmmm...well for whatever reason the report manager is not finding the correct sheet. For my stuff that uses Excel as a source I've run into this several times and its...

Check the sheet name in the worksheet

So have you mapped the drive on the server? If so and you're still receiving this error I would suggest in the excel connection fully declaring the path (eg. \\servername\folder\file.xls)...

The scope parameter is the name of the data set from which the field is being derived.

So your expression should work assuming:

1.) 'ABC' is a field in the data set...

On the report server where this is deployed do you have the 'P' drive mapped to the same location as running it locally?

It worked...so anyone looking to update data sources programatically here are the steps I took:

1.) Make a copy of the a report that uses the data source you wish to...

If you go into properties of the report and select 'Data Sources' what do you see?

I believe it is recommended to install both and do a side-by-side upgrade. The upgrade adviser is good to, it will let you know of any major pitfalls you may...

Good article...

From my perspective I have been a SQL Developer for over 5 years now and don't really *need* a cert to prove anything to anyone. I believe my problem...

Not sure how you can expose the reports w/o using windows authentication but you should be able to integrate the reports by using the report viewer control into your .Net...

Check the MSDN article below that describes how to do this...

http://msdn2.microsoft.com/en-us/library/aa964126.aspx

cheers,

-Ben