Does anyone know if it is possible to author RS 2005 reports using
Visual Studio 2003? I ask because I installed both SQL 2005 and Visual
Studio 2005 recently but support for designing or compiling reports in
VS 2003 has been removed by the installation.

According to msdn http://msdn2.microsoft.com/en-us/library/ms228006 
all I need to do to allow SSIS datasource in the report builder is to
uncomment an extension line with SSIS name in the  rsreportserver.config. But
this not works on my VS2005 (i tried on both Beta2 and RC ...

I am receiving the "expression expected" error when trying to include the
following in an expression for a sql statement.   I don't receive it without
the IIF statement & do if I include it:
"AND (table.field = @Team OR @Team = '(All Teams') " &

I have to parameters they effectively offer 2 methods of finding the same
kind of data.
First the id, second the employee name (with the id as the value)
If a user selects an id then I would like the second parameter's value to

Does anyone know if Report Services 2005 work with Visual Studio 2003?
Thanks,
Jim

I've decided to try developing some custom assemblies for performing
calculations like variance to keep the code in the report simpler.
On page 154 of the WROX RS book it says that RSReportDesigner.config
and RSReportServer.config should have entries in them that are

I have a field "Accept" that can be Null or contain either "Y" or "N". In my
test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null. I
want a count of each case in the footer along with some descriptive text. I
tried the formula

Is there a way to change the point lable color of the font if it's inside of
the chart beside a bar?  I have a chart that shows the percentage of disk
space free.  Once the chart gets less that 25% it runs out of room to put the
point lable percentage beside the bar so it puts it ...

Is there a way that I can perform my aggregate function agains the value in
group row instead of details row?
Because I do not show numeric values in the details but group row.

I want to draw a straight line whose parameter can be set in a
variaty.how to get it?

The bug fix No.883647 - you render a report to a PDF file, the page breaks
are incorrect in SQL Server 2000 Reporting Services. -  Didn't help me. I
still have page breaks problem after I install SP2 and hotfix. I have include
a subreport (with table on it), it has proper page ...

I have just starting to try to use RS and I have some questions. (My
development environment is VS 2003/VB). I use a shared hosting service for
SQL Server 2000 with RS. I built a report in VS 2003 and deployed it to the
RS server I am assigned. Now I want to view that report from ...

I want to display everything on my report on the same screen without having
to go to any other pages.  How can I increase what is shown on the first page
of a report?

I am trying to do alternative color row for my report,
1. On Table - it works
=iif(RowNumber(Nothing) Mod 2 , "#F9F9F9","#EBEBEB" )
2. On Matrix with Value - it works too

This may be a simple question, but when I am adding a web reference to
Reporting Services (using SQL Server 2005), should I pick ReportService.asmx
or ReportService2005.asmx?
In SQL Server 2000, we chose ReportService.asmx (obviously), but in SQL