Been kicking this around for a few days. Maybe ya'll can help.
We have allowed users to create their own subscriptions to SSRS
reports. As a result, I have many subscriptions, most with the same
(or nearly the same) schedule. Consequently, there are too many SQL

For running reports and using an internal exchange server is it best o use a
local or network service account
RE

Is there a way to tell if a report was saved to file or printed from SSRS?
much thanks!

In a SSRS 2005 report that has multiple datasets/tables. Is it
possible to only run or display a particular dataset based on a report
parameter?

Does the matrix support the kind of expression that will allow repurposing
the the output of the matrix 'data' textbox based on the level at which a
secific grouping row is exposed.
More information:

I have a situation where I wish to disable or cause to disappear grouping
level expand links for some groups.
Here is the reason:
I have what I will call a asymetric hierarchy. I'll explain it this way.

I am struggling with the rendering of Web Archive (MHTML) into email.
In the report, the tables are sized correctly for display, but when
rendered as MHTML and placed into an Outlook message, the table widths
are tiny. It seems as though they default to about 4 inches, when in

Please help to figure out. I am new to Reporting Services and I'm using sql server 2000.
Question 1.
How could I display a text(example: name of person) in Linkbutton instead of in a default textbox available in the report? I would like to make this LinkButton triggers a code ...

I'm using IE7, and I opened the URL http://servername/reports, it gives me
blank page. any idea?
thanks,
Sarah

I just installed SP2. I republished my report. When I view the report within
my web application, I now see a print icon. When I click on the print icon, I
get the following error:
An error occurred during printing. (0x80004005)

I have a report that contains customer statistics as of a specified date.
For example:
Customer1    Date1    Stat1    Stat2
                    Date2    Stat1    Stat2

Is there a way to combine multiple reports into one and not lose the
Page Header functionality (this occurs when the subreport feature is
used).
Example:

I need to eliminate white space as much as possible.  I have a table on a
report, and if it all fits on page 1, it will print.  If it will not all fit,
it leaves a bunch of white space, and then prints it on page 2.  I want it to
print as many lines of the table that will fit on ...

I add to my C# solution report (rdl) and I run it locally with
Datatable. I config the paper size on report properies to 210*297 and
I also try on the code:
Me.RptPrev.LocalReport.GetDefaultPageSettings.PaperSize.PaperName =

hello.
I need help with this report permission issue that is driving me nuts.  On
the report server we have certain reports folders that is suppose to ONLY be
visible by departments. Now all the folders and contents can be seen by