Just drag your field into the group footer area of the group, when you drag a field into a group footer area, SSRS automatically assumes you want a sub-total and...

I might be over simplifying this but have you tried setting the parameter to not allow Nulls or Blanks?

I do understand the issues with your first point, this could be a painful exercise, however, on your second point you should understand that once you use a parameter value...

Not sure quite how secure this is, but if your drill down is a sub-report then you can control the visibility of the sub-report using an expression, so you could...

The short answer to your question is yes, no problem, SSRS reports are all web based and therefore you could call them on a std URL.

For the manual, I use...

Reporting services can very easily duplicate what you describe, it would be a simple job of creating the SQL to get the data (as a c# developer I'm sure you...

Two problems that I'm trying to solve:

1) I have 3 parameter boxes - P1, P2, P3.

The user of the report usually sees them arranged as

P1 P2

P3

and I would like...

The best way to deal with this is to ensure that your dataset always returns a zero value even when there is no data in the column, currently you...

Try changing your table to a memory table rather than disk based.

DECLARE @TempTable Table

INSERT INTO @TempTable

If this works then it points to a permissions issue on creating temp tables on...

I use stored procedures on every report I write, I simply don't have any problems with them at all, and I have to say that I have never entered the...

Not sure what your front end is, however, what you will need to do is to find out how to pass your parameter into SSRS from your Front End, this...

Hi

The difficulty with a matrix is knowing which value you want shown on the page footer, the problem is that one detail cell of course holds many different values according...

I don't use the report builder because this is one of the limitations, the report builder is aimed at end users to create very quick list style reports and from...

Go to the properties of the text box, open up the Visibility area and on the first item (Hidden) create an expression such as:

=IIF(Fields!Country.Value="USA",TRUE,FALSE)

The above will hide the text box...

There "MIGHT" be some way around this, I'll put some thought into it and let you know by the end of today if I come up with anything. I'm...