RS2005 visual studio design tool

RS2005 ships with a version of visual studio 2005 for report development.
What if I have visual studio 2005 on my local machine. How can I add the
rs2005 shell locally? Are they any license issues?
ThanksI found that if I install VS 2005 after the report designer I lost the
report designer. My suggestion is to first install VS 2005. Then using the
setup for SQL Server 2005 install the Reporting Services client tools (i.e.
the report designer). This will cause the designer to be installed and
integrated with the VS that you already have installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:AB535062-7477-4798-8027-AC82209C7A1C@.microsoft.com...
> RS2005 ships with a version of visual studio 2005 for report development.
> What if I have visual studio 2005 on my local machine. How can I add the
> rs2005 shell locally? Are they any license issues?
> Thanks|||Fortunatly, I had VS installed already so did not come across this issue.
After installing sql, the report projects are right there in VS and work
well. Damn fine work on this RS stuff - hat off to MS.
--
William Stacey [MVP]
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eFLBnAGAGHA.140@.TK2MSFTNGP12.phx.gbl...
>I found that if I install VS 2005 after the report designer I lost the
>report designer. My suggestion is to first install VS 2005. Then using the
>setup for SQL Server 2005 install the Reporting Services client tools (i.e.
>the report designer). This will cause the designer to be installed and
>integrated with the VS that you already have installed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tcs" <tcs@.discussions.microsoft.com> wrote in message
> news:AB535062-7477-4798-8027-AC82209C7A1C@.microsoft.com...
>> RS2005 ships with a version of visual studio 2005 for report development.
>> What if I have visual studio 2005 on my local machine. How can I add the
>> rs2005 shell locally? Are they any license issues?
>> Thanks
>|||Thanks to you both
"William Stacey [MVP]" wrote:
> Fortunatly, I had VS installed already so did not come across this issue.
> After installing sql, the report projects are right there in VS and work
> well. Damn fine work on this RS stuff - hat off to MS.
> --
> William Stacey [MVP]
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eFLBnAGAGHA.140@.TK2MSFTNGP12.phx.gbl...
> >I found that if I install VS 2005 after the report designer I lost the
> >report designer. My suggestion is to first install VS 2005. Then using the
> >setup for SQL Server 2005 install the Reporting Services client tools (i.e.
> >the report designer). This will cause the designer to be installed and
> >integrated with the VS that you already have installed.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "tcs" <tcs@.discussions.microsoft.com> wrote in message
> > news:AB535062-7477-4798-8027-AC82209C7A1C@.microsoft.com...
> >> RS2005 ships with a version of visual studio 2005 for report development.
> >> What if I have visual studio 2005 on my local machine. How can I add the
> >> rs2005 shell locally? Are they any license issues?
> >>
> >> Thanks
> >
> >
>
>

RS2005 Performance Test Tool

Dear Anyone,

Is there a tool that we can use to simulate the performance of Reporting services?

Our team will be implementing performance tests over the reports we created over the corporate network. in reality, we expect about not more than 500 concurrent users but it could possibly go higher. We would need to do stress testing.

I was wondering if there is a performance tool out there that can simulate numbers of users accessing reports from our server? Any recommendations on how we can test this?

Thanks,

Joseph

Hi,

In my department, we use Opensta.

http://www.opensta.org/

Regards

Ayzan

sql

rs.exe compile error

I am using the rsscripter tool to migrate my reports from the dev machine to
the acceptance machine. I am getting a compile error:
Running script "GlobalReportsLibrary\GLOBAL\rpt_100_PutAway.rdl.rss"
The specified script failed to compile with the following errors:
C:\tempreports> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\vbc.exe" /t:exe
/main:MainModule /utf8output /R:"System.dll" /R:"System.Xml.dll"
/R:"System.Web.Services.dll" /R:"C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\rs.exe" /out:"C:\Documents and Settings\ephisha\Local
Settings\Temp\mchxuwd6.exe" /debug- "C:\Documents and Settings\ephisha\Local
Settings\Temp\mchxuwd6.0.vb" "C:\Documents and Settings\ephisha\Local
Settings\Temp\mchxuwd6.1.vb"
Microsoft (R) Visual Basic Compiler version 8.0.50727.42
for Microsoft (R) .NET Framework version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.
C:\Documents and Settings\ephisha\Local Settings\Temp\mchxuwd6.1.vb(78) :
error BC30456: 'SetReportDataSources' is not a member of
'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
RS.SetReportDataSources(fullpath, dataSources)
~~~~~~~~~~~~~~~~~~~~~~~
Does anyone have any ideas? Thanks.Phill,
Does the fullpath have the .rdl extension, as it only needs the path and
name of the report.
One other method is to create a project in Visual Studio and try to debug it
there. Here are the steps:
In Visual Studio or download Visual Studio Express (Free)
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add:
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Reeves
"Phill" wrote:
> I am using the rsscripter tool to migrate my reports from the dev machine to
> the acceptance machine. I am getting a compile error:
> Running script "GlobalReportsLibrary\GLOBAL\rpt_100_PutAway.rdl.rss"
> The specified script failed to compile with the following errors:
> C:\tempreports> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\vbc.exe" /t:exe
> /main:MainModule /utf8output /R:"System.dll" /R:"System.Xml.dll"
> /R:"System.Web.Services.dll" /R:"C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn\rs.exe" /out:"C:\Documents and Settings\ephisha\Local
> Settings\Temp\mchxuwd6.exe" /debug- "C:\Documents and Settings\ephisha\Local
> Settings\Temp\mchxuwd6.0.vb" "C:\Documents and Settings\ephisha\Local
> Settings\Temp\mchxuwd6.1.vb"
>
> Microsoft (R) Visual Basic Compiler version 8.0.50727.42
> for Microsoft (R) .NET Framework version 2.0.50727.42
> Copyright (c) Microsoft Corporation. All rights reserved.
> C:\Documents and Settings\ephisha\Local Settings\Temp\mchxuwd6.1.vb(78) :
> error BC30456: 'SetReportDataSources' is not a member of
> 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
> RS.SetReportDataSources(fullpath, dataSources)
> ~~~~~~~~~~~~~~~~~~~~~~~
rs.SetReportDataSources("/
> Does anyone have any ideas? Thanks.

RS and J2EE High Level Architecture Question

I am looking for a tool that allows me to generate lists, mailmerged letters
and reports from a J2EE application. Are there strong reasons in favor or
against RS, specifically in regard to integrating via the Web Service API?
Can I wrap RS in a J2EE-based interface and stream reports through the
application server, as opposed to exposing the RS management interface to
the end users?
Thanks for your input.Christian,
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
This is one of the RS strongest points because with RS reports are
web-enabled by default. In other words, once you deploy your report to the
report catalog there is nothing you have to do to expose it over the web.
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
You bet. You can generate RS reports on the server-side your J2EE
application by calling the RS Render SOAP API. In addtion, the Report Server
supports URL addressibility where a HTTP-GET request is generated on the
client side of the application. You should carefully evaluate both SOAP and
URL addressibility to find out which one meets your app requirements better.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>|||Christian,
I don't see why not. the web service methods for RS include the RENDER
method. Since this is a SOAP call which returns a byte array (representing
the rendered report) RS is client agnostic. have at it.
hope this helps.
dlr
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>