Thanks all for the input, all very interesting and will definitely stay away from naming with the sp_prefix. I did recompile the new sp with a drop/create. Both Sp's run...

I definitely agree and appreciate the answer, we're under the gun by the client. Issue really is there is about 10 parameters and the one we need locked down is...

Hi Brian,

Thank you for the reply. I am unsure of how or where to even enter the javascript so that it can allow for the pop up

Anyone?

What is GOOGOOGOO ?

How does that help?

Hi guys,

Great responses and ideas. We have clients that have hundreds, sometimes thousands of buildings. We are using the data for a major report and I figure we'd need to...

Thanks. Yes I think it can be handled in .NET (not my area) but I wondered if it could be done in an RDL

The visibility won't work because it will display when dumped to excel. Was hoping there was a filter trick on the group in SSRS but will manipulate the SQL to...

Thanks for this, it's something I have been trying to accomplish for a few weeks with a report that the normal greenbar code couldn't handle.

So it seems that everyone figured out how to do this for 2008, I am still on 2005 and when I try the repeatgroup header it fails to produce the...

Hey Daniel,

Where would you do the truncate...in the stored procedure that the parameter is passed to?

Sorry that should read dollar amount along the left of the y-axis and percentage along the right of the y-axis

Did you ever find a solution to this problem? I have the same thing over and over

Did you ever find a solution for this, I have this issue over and over!