It's new to me, and funny! Sometimes the old jokes are still the best.:D

You mean, you are answering the ? prompt by typing in the cell address where the actual parameter value is?

Korey, are you doing this successfully on Excel 2007? If so then I need to figure out why mine doesn't work.

Thanks!

I had tested this a few weeks ago and it appears Excel 2007 is different. I could not get a cell reference to work. (I can't look just now but...

Just curious, because I took the Parm out of my SP and have nothing to test with: did you try it without the tick marks?

Thanks

I read the thread from the beginning the day it was started, and my original post says I tried that and it does't work in Excel 2007.

Thanks, now I'm sure I'm in over my head. :w00t:Where do you put all that? In the exec proc_exceltest?

David, you explained it better than I did, but that's exactly the problem I am having. Does anyone know how to do this? Thanks!

20 Years ago I was working with an old flat file accounting system, and they stored the value in one field, and the sign in another. It is not necessary...

Thanks for the article, I set it up in Excel 2007, however I can't find a way to send a parameter through to it or link a parameter to a...

This was a nice presentation, however, I may not be alone in being locked into stored procedures as a data source. The consultant who assisted us in setting up the...

Jack Corbett (9/12/2008)

---

Re-write your query to include the aggregate data as a column and then order by it in the query or use that column to order by.

quote]

Yes, this is...

Hi, I've been learning SSRS by writing the reports we need for the last six months. I have searched endlessly, and can't find a solution to that question. I think...

I have also copied reports by opening the report (if you have access to it), View-Code, copy the HTML, and paste that into the code tab of a brand new...

Figured it out...

format(AVG(FIELDS!SalesAmount.Value),"###,###,##0.##")

😎