We are looking at replacing Crystal Reports with SSRS. However, we would
like to understand the implications of doing so. We want the reports to be
generated at the Server and sent to the client through TCP instead of HTTP.
Is this feasible?

Hi, stupid question....haven't tried it myself, so I'll ask....
I have a client who is using SQL Server 2000, and can't upgrade to 2005
anytime soon.  However, I'd like to use SSRS 2005 instead of SSRS 2000
to build some reports.

I am writing a web application in c# that is attempting to get the
parameters from a report on a Reporting Services 2005 server.
I am using the following code:
SQLReportViewer.ServerReport.ReportServerCredentials = new

In the ReportServer database there is a table named Executionlog, which
contains data on the reports executed. But at any given time, it only seems
to contain data for the last 2 months. How do I change this filter?

Ok, I am stumped.  I am obviously missing something really trivial.  I
have searched this group and don't see my exact problem which is this:
I installed VS 05, SQL 05 so that I could test out the BI Reports
stuff.  I can build reports.  SQL works nicely.  The report builder

any idea on how reports in report manager including snapshots can be
migrated to 2005 ?
/michael

I have a LocalReport, when I'm exporting to a PDF using the following
code:
           Warning[] warnings;
           string mimeType;

I have a production database server on windows 2003 server.  I am
wondering if it is adviseable to install reporting services on a clean
production database server or to install it on its own server.
The cause for my concern is that reporting services requires visual

When I use Visual Studio and the Preview method of viewing a report,
any DrillDowns or Toggles operate quickly and nicely.
However, when I deploy to the server and access the report via IE, the
report behaves slowly, twitchy, and just oddly.  It wants to

We have a SQL Server 2005 application that we deploy most of the time on SQL
Express, not full blown SQL.  We have a Development box here (2 CPU XEON
with 4GB RAM) that has the Developer Edition and an instance of SQL Express
installed.  If I run the same reports, with the same ...

I am missing something very basic.
I cannot see or find the Subtoal Green Triange to get the subtotal
properties window.
I have tried both the table and matrix controls.

I have developed a custom subscription page that integrates with Active
Directory to allow searching for company employees and resolving their email
addresses. While I could certainly build a complete "My subscription" Site I
would like to just change the link to "New ...

I have RS2000 Report Server with a report that contains an image control.
The image control value is a UNC path to an image (ie
\\<server>\images\image.jpg. The <server> is a different server to the
Report Server. I have setup the unattended execution account to be the

I have a report with 2 parameters, start_date and end_date. If I use default
parameters the report runs straight away. I want to have the default values
to save the users typing, but I do not want to run the report until the user
clicks "View Report". How do I do that?

I need to find a conditional sum of sales if fields!Example.value = 0
(And same if fields!Example.value = 1)
How do I do that in reporting services?
Thanks