Report Wizard Error on SP

Stepping through the Report Wizard to create a new report, the second step
"Design the Query" I entered my SP name. When I click next I get the
following error.
"There is an error in the query. Line 1: Incorrect syntax near
'STORED_PROCEDURE_NAME""
I ran the SP in Query Analyzer and works fine.
The Shared Data Source tested good for the connection.Mike,
Why I think this happens is that the development environment is parsing
the stored procedure to try and determine the resultset that will be
coming back. If it can't, it just gives up and returns the error
message. I've had this happen on procs that use temp tables primarily.
There are a several of ways to handle this.
1. Don't use the wizzard. Manually build your data source, manually key
in the column names for the result set. Some will advocate never using
the wizzard, but don't throw the baby out witht he bathwater...
2. Try entering the proc exec statement with any required parameters:
exec myproc 0, 'parm2'
once you get through the wizzard, change the data set from using the
Command Type of "Text" to use "StoredProcedure", and specify the
parameter(s)/values on the parameter tab.
3. Modify your procedure to return an empty result set that matches
what is normally returned. default your parameter(s) to Null and add a
check for @.parameter = null in the body of the proc. if it is null,
return the empty result set and return. This will give the wizzard
what it is looking for. One technique that worked for me was to
rewrite the proc so that any SELECT ... INTO statements that create and
populate temp tables are changed to explicit table creates and insert
statements. Using table variables instead of temp tables is also an
option, as the development environment parser seems to ignore them when
trying to determine the result set.
Hope this helps!
Regards,
Clayton

Report server service pack

How can I determine what version of service pack for reporting services is
installed on our servers?
I would deeply appreciate step by step instructions.
TIA...Go to http://yourserver/Reportserver
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> How can I determine what version of service pack for reporting services is
> installed on our servers?
> I would deeply appreciate step by step instructions.
> TIA...|||Thank you Bruce.
What would version 8.00.743.00 refer to?
TIA...
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||That must be RTM (release to Manufacturing, i.e. the first release). That
means you have no service packs installed. Given all the fixes I strongly
recommend applying both service packs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> Thank you Bruce.
> What would version 8.00.743.00 refer to?
> TIA...
> "Bruce L-C [MVP]" wrote:
> > Go to http://yourserver/Reportserver
> >
> > SP1 is Version 8.00.878.00
> > SP2 is Version 8.00.1038.00
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Trisha" <trisha@.nospam.nospam> wrote in message
> > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > How can I determine what version of service pack for reporting
services is
> > > installed on our servers?
> > >
> > > I would deeply appreciate step by step instructions.
> > >
> > > TIA...
> >
> >
> >|||Bruce,
I just googled for 8.00.743.00 and it turns out to be the installation
version.
Thanks
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||Thanks Bruce...
"Bruce L-C [MVP]" wrote:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> > Thank you Bruce.
> >
> > What would version 8.00.743.00 refer to?
> >
> > TIA...
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Go to http://yourserver/Reportserver
> > >
> > > SP1 is Version 8.00.878.00
> > > SP2 is Version 8.00.1038.00
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Trisha" <trisha@.nospam.nospam> wrote in message
> > > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > > How can I determine what version of service pack for reporting
> services is
> > > > installed on our servers?
> > > >
> > > > I would deeply appreciate step by step instructions.
> > > >
> > > > TIA...
> > >
> > >
> > >
>
>|||When you said "both service packs," does that mean that SP2 doesn't include
fixes from SP1?
When I read through the SP2 docs it wasn't clear to me, but it seemed like
if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
installations.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>|||SP2 includes everything that comes with SP1. So installing just SP2 is
sufficient.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||I was a little sloppy with that statement. As Robert said, SP2 is all that
is needed to upgrade with.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:#X0vnASUFHA.228@.TK2MSFTNGP12.phx.gbl:
> I was a little sloppy with that statement. As Robert said, SP2 is all
> that is needed to upgrade with.
>

report server compatability issues

Hello!

I have sql server 2000(sp2) rs installed on one of my mashine and I am using VS,NET 2005 to develop some reports.

At the deploing step I am getting some error:

"Connection could not be made to the report server http://..."

Additional information on error message says:

"The attempt to connect to report server failed.Check your connection information and that report server is a compatible version. (Microsoft.ReportingServices.Designer)."

Can't find any information about this issue. Is there anything I have to do to fix this.

Reports made in VS2005 are not compatible with the 2000 version of Reporting Services. You will need RS2005 to work with VS2005 reports.

|||

I have vs2005 with rs2005 installed and I still get the same problem.

I have been trying anything I could think about, but nothing helps.

Here are my details:

TargetDataSourceFolder: Data Sources

TargetReportFolder: reportserver

TargetServerURL: http://localhost/reportserver

Whats am I doing wrong? The iis is properly installed....

Please help,

Uri