What would the desired result be if the state is null? Should selecting either MN or NE bring up NULL values as well as the records that match the...

I know this answer isn't much help to your particular situation, but given SSRS's rendering shortcomings in Firefox, I and my users just always use IE for SSRS, even though...

There are a couple of ways of doing this, but for maximum flexibility I have done it by creating 4 datetime report parameters (a new date range and an old...

In percentage calculations, often you get these errors showing because of divide by zero/null issues. Adding expressions like the following can take care of it (vary depending on what...

Have you looked in the ReportServer error logs? I have found the "execution failed for dataset" message that SSRS provides covers a wide variety of issues, and often the...

Is the formula

( labor amount / (fresh fruits + labor amount + small supplies) ) * 100

Or

( ( labor amount / fresh fruits ) + labor...

If I'm understanding the problem correctly, you might be able to get the field names in your procedure by using joins instead of unions:

SELECT

sub.invoiceamt as Subtotal

grand.invoiceamt...

There are a couple of things that could be the problem. First, I'm not sure you've got the right format for your statement. Try this:

=IIF(Fields!AMOUNT.Value = 0 ,"0",...

When I have used rectangles it has usually been in the report body rather than the header. I place the rectangle, and then position my textboxes in the rectangle...

I'm not sure if the syntax is quite right, but something along these lines might work:

=IIF( (Sum(Fields!DBA_Estimate.Value, "dsStatistics")-(Sum(Fields!DBA_Actual.Value, "dsStatistics")))/60 < 0, "Actual time is more than the estimated time", ...

AFAIK this isn't possible within SSRS. The purpose of subscriptions is to have the report run on a given schedule without manual parameter inputs. If the users insist,...

I have sometimes been able to force report elements to align by putting them in a rectangle. Might that work for you here?

Doug

Is it possibly a collation issue? I notice in your code the parameter is uncapitalized (@paramout), but in the error message it is capitalized:

error:The parameterized query '(@param1 int,@Paramout int...

Is the deploy actually failing, or is it completing and giving you the error? I have the OverwriteDataSources set to False by default. Whenever I deploy a report,...

AFAIK you have to place the textboxes in the rectangle for them to be visible. I think whatever report element is topmost will be what renders, so if the...