Thanks Jeffrey, the linked article provided me what I was looking for.
Phil, I knew about the .rdl files. However, I was looking for a way to search all the reports...

My apologies. I missed that line in your post where you mentioned the difference in format. I thought you were talking about the same thing everyone else was talking about....

This doesn't work. Test it for '2012-2-28 5:33:21'.

Oops, sorry Sean.

Thanks Jeff.

Thanks. I see that now.

It didn't occur to me that setting up default email profile will be under Security tab/page!

A little clarification about my question. What I have understood so...

William,

I tried adding version as you mentioned and it worked. Thanks.

After fixing a few typos, I was able to get the expected result.Thanks.

One think I noticed is that, in the profile script, $Host.Name is appended twice. I guess it was...

Thanks for the nice series. I wanted to learn this since a long time. I think that time has arrived now.

I tried the examples in this first article. Everything worked...

Thanks. I realized that requirement and changed the structure of the dataset to the one you mentioned. Actually, this was an existing report in which the stored procedure used to...

With your help, I was able to figure out the final query. Here it is for your review.

SELECTv.Dept, v.Project, ProjDesc, Period01, Period02, Period03,

Period04, Period05, Period06, Total , ROUND(m.StdDev,...

Thanks. I think I know how it should be done but it would require me to go through some trial and error (this pivot/ unpivot command is confusing for me.)....

Here is part of the report:

Jul 11Aug 11Sep 11Oct 11Nov 11Dec 11TotalStd Dev

11-62137404414719.50

-4-10000-51.60

000000.00

888888480.00

00-5000-52.04

The report doesn't have Std Dev column. I exported report to Excel and added Std Dev column. The...

Thanks. Worked perfect!.

Thanks Alastair. I am looking into buying this book.