At the current rate over the past few days, probably sometime later tonight...

more likely by the end of the weekend.

-Luke.

yeah just try navigating this site with NoScript blocking all of it... you can't get anywhere.

Any chance you could post up either your RDl or an image of your design environment?

More than likely you're using 10 point font in a row that could...

My guess is that's the issue right there. If you don't have permissions on...

Mh (5/1/2009)

---

I have a matrix report(dashboard report), with appointment counts for each day. If we click on the appointment counts, all the details should show up. I have created this...

Click on the posts, page x of y bit.

-Luke.

Oh right... silly me... Sorry I didn't test the syntax cause I didn't have any test data.

The start and end dates will not be in the same scope as the...

Yeah, I missed a space before the as...

AVG(CAST( ' + @SearchTerm + 'AS decimal))

should be

AVG(CAST( ' + @SearchTerm + ' AS decimal))

yes it's possible. It's all just a matter of what you want the .cmd file to do and if you really need to do it that way... We...

You will not be able to do this without creating some dynamic SQL inside the procedure...

Something like this might work...

ALTER PROCEDURE SA_STPR_Reports_AverageSales

@startDate datetime,

@endDate datetime,

@SearchTerm varchar(255)

AS

BEGIN

DECLARE @sql NVARCHAR(4000)

SELeCT @sql = '

SELECT...

Any chance you could post some more code? like what your function does?

Check out the following for what I'm tlaking about...

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

But I'd think just a simple select should get...

Hey Barry, good to see you back, hope all is well.

-Luke.

I am told I was in the theater, but I was only 2 mo old so I can't say I actually remember it.

-Luke.

Kit G (4/30/2009)

---

After all... Reasons why Star...

You're code looks ok. I created a winforms app to test it and it seems to work properly, but that is with .net 2005 and SSRS 05 instead of...