I am having the same problem that Cyndi posted on 5/10/06.  I have a group
that has a filter on it.  The group has a footer that has a Sum field.  The
sum field is summing all data for the group, not just the rows that are
displaying.  Has anyone come up with a solution for this ...

I have a dataset which has a ContractNo column which can take a null value. I
cannot carry out the filter on the stored procedure which generates my
dataset.
This dataset is used in a matrix. I need to filter out all rows with a null

Looking for suggestions on some good books for Reporting Services that will
get me up to speed on its functionality. A book with a good index, good for
beginners, good reference book; that will hopefully get me up to speed pretty
quickly on utilizing Reporting Services.

I have a matrix where I am using the inscope function to return different
calculations depending on which group it is in (ie the detail is just the
value and the sub totals are sum(values)).
In for the subtotal group I have used:

I'm created a fix lenght report and i have several subreports. My
problem is that if the subreport has no data, it's not displayed.
I want to display the subreport all the time, any ideas?

Sorry if this is a repeat question.  I've been searching for three hours
trying to find a solution to a simple problem.  Thank you in advance.
I have a report with a list control that has 20 textboxes and three sub
reports.

   I build a test report using SQL Server Business Intelligence
Development Studio. Every thing went well also I can preview of the
report. But when I wanted to deply it by right clicking it its throwing
a message

Is there a way to put code (i.e. an Expression) behind a cell in a
table that will control the background and foreground colors of the
cell itself?
For example (this is pseudocode to indicate what I want to happen)

Is it possible to add additional export types to the list, link to sample
code would be nice.
Select a format (Export)
   XML file with report data

Good day
I am having trouble with getting an Oracle query right for SQL
reporting service.
I wrote a front end to execute the query and it works fine. Now the

I've defined a matrix in a report which looks like this:
                         group by column     group by column
Description                   Data                      Data
Description                   Data                      Data

(This is a repost, under my correct subscriber ID.)
I have a report that I think is not too complex (a matrix inside a list).
With small datasets, all is well.  But with large datasets (the threshold
seems to be around 5500 rows, which should turn out to be about 25 printed

I have about a large number of subscriptions for ONE report that I would like
to bulk delete. Could you please advise if I could run an SQL query on the
database to achieve this? Due to the large number of subscriptions,  I am
finding it impossible to delete the subscriptions ...

What is the syntax to call a SQL server stored procedure from a report?
Say if I wanted to create a custom field that would be based on an
expression that calls the stored proc (which would return a single
value from a single field - a sum in this case).

I have SQL Server Developer Edition 2005 installed on my Compaq Presario
which is running Windows XP Media Edition.  When I try to deploy a report
model I get the error message:
"A connection could not be made to the report server