Thanks! I think I see the light now. I appreciate your help.

Thanks. I understand the comment portion. What has me confused/concerned is that a stored procedure with a parameter of data type float will take a non-numeric value like...

Thanks!

I am not sure if this applies to your situation....

I ran into a problem returning data when a stored procedure used an alias for a field. The sproc would...

In the spirit of "Never let the machine win"...

Did you consider modifying the query to generate the number you need. An example

WITH cteAverage AS

(

SELECT

...

Possibly the ability to refer to the value of a specific textbox within SSRS would help here. SUM(ReportItems!TextboxName.Value).

I have had success including the grand total in the dataset definition.

SELECT typeid

, invamt

, (SELECT SUM(invamt) from SomeTable) AS GrandTotal

FROM SomeTable

In this case the expression would be

=IIF(Fields!invamt.Value = 35, SUM(Fields!invamt.Value)/max(Fields!GrandTotal.Value)...

Did you consider setting up the stored procedure to return a 3 field table, with fields Subtotal, GrandTotal, and AdminTotal?

Cascading parameters provide a way to reduce the number of user choices in the parameter drop down box.

Parameter 1 is created as a base. Then it is used as...

This falls into the "make it work" category.....Sometimes they look like numbers but sort like text. I just convert to integer to make sure the sort works correctly.

It appears as if Fields!Month.Value is a text string, since it is sorting alphabetically. Do you have a corresponding date field which would allow you to pull the month...

Since the last page you want is a single page, you should be able to set the "Page break at start" property to True for the first item to appear...

I would use a separate dataset to generate the data. The following query creates 36 months of entries beginning at 1/1/2011.

SELECT (CHOOSE(DATEPART(m,dateadd(month,number,'20110101')),'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC'))

+ (CONVERT(nvarchar(4),DATEPART(yyyy,DATEADD(month,number, '20110101'))))

from master..spt_values

where type =...

FYI..the syntax worked in my environment. Could it be a data problem?

The merged cells in an Excel export from SSRS are generally caused by report titles or text boxes that do not exactly line up with the column breaks in the...