running and exporting report through code (C#)

Hello ,All
I am new to the reporting services and my question maybe stupid .
I created some report and published it on the server.
Now my question is : does it possible at all to run this report from my
client (in C# )and to export the result to CSV format also from client
Is there any web service that I can use which is calling for my report ?
Please ,help me to understand this .
Thanks a lot.
SmugliyYes, Reporting Services provide a set of Web Services API that you can call
to generate report. Form your client app project (Win Form App), set web
reference to the reporting services and look into its Render() methods. You
can also learn more aboubt this from SQL Server2005 Book on Line.
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>|||Thanks a lot ,Norman
"Norman Yuan" wrote:
> Yes, Reporting Services provide a set of Web Services API that you can call
> to generate report. Form your client app project (Win Form App), set web
> reference to the reporting services and look into its Render() methods. You
> can also learn more aboubt this from SQL Server2005 Book on Line.
>
> "Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
> news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> > Hello ,All
> > I am new to the reporting services and my question maybe stupid .
> >
> > I created some report and published it on the server.
> > Now my question is : does it possible at all to run this report from my
> > client (in C# )and to export the result to CSV format also from client
> > Is there any web service that I can use which is calling for my report
> > ?
> > Please ,help me to understand this .
> > Thanks a lot.
> > Smugliy
> >
> >
> >
>|||Your other option is URL integration. It too will work. It allows you to
pick the rendering format. One point with either URL or web services. By
default CSV is in unicode format, if you don't want this then you can also
tell Reporting Services that you want it in ASCII format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>sql

Running a Report deployed on Reporting Server from C#

I have a report deployed on reporting serice. I am using reporting web service.

How can we call the report, assign parameters and execute it on a webpage

Are you using the full-blown version of Visual Studio 2005? If so, use a report viewer.

I'm not sure what a "reporting web service" is.

|||ReportExecution2005.asmx|||

Is that a link? If so it isn't clickable.

|||

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.aspx

I was refereing to the Reporting Services Web Service

Its ReportExecutionService

|||

Ok. Either I'm very mistaken or you are quite confused. That is the service which allows reports to render and generate.

I don't think there is any claim in this document that is made that would indicate that you can use this service directly to view reports from a webpage.

What I was getting at is you most likely want to create a .net web application and use the report viewer within Visual Studio 2005.

|||

Yeah i was gonna do that approach, get the bytes from webserivces render and using response to write to the page

Do u know how we can use the reportviwer to use the bytes returned from the webserivce

|||

Yes. In a nutshell, you do the following:

1. Create a C# .Net web application.

2. Drag and drop a report viewer to the application.

3. Set the report viewer properties properly to point to the report.

|||

Here's code I used from my application to generate a report, and get the byte stream. You'll note code in there that is used by HTML reports to point to the location of the images returned from the report service (all of which need to be saved to disk in my case). However, you can probably do all of this via stream directly to the output stream as well. Ignore my application-specific code:

Code Snippet

// load the report meta data and execution data

ReportExecutionService res = new ReportExecutionService();

res.Credentials = System.Net.CredentialCache.DefaultCredentials;

res.Url = application.ReportServer + "ReportExecution2005.asmx";

ReportingService2005 rs = new ReportingService2005();

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

ReportService2005.DataSourceCredentials[] credentials = null;

ReportService2005.ReportParameter[] availableParameters = rs.GetReportParameters(reportPath, null, false, null, credentials);

string outputID = IdGenerator.GetRandomStringId(20, null, null, true, true);

string outputFileName = outputID + "." + ext;

bool gecko = false;

if (request != null && request.UserAgent != null && request.UserAgent.ToLower().Contains("firefox"))

{

gecko = true;

}

string deviceInfo = "/" + site.RewriteUrl(application.VirtualPathRoot + "/Content/Resource.aspx?type=tmp") + "&filename=" + outputID + "_" + (gecko ? "Gecko" : "") + "";

deviceInfo = deviceInfo.Replace("&s=" + site.Key, "&amp;s=" + site.Key);

string historyID = null;

string encoding = null;

string mimeType = null;

string extension = null;

ReportExecution2005.Warning[] warnings = null;

string[] streamIDs = null;

ExecutionInfo execInfo = new ExecutionInfo();

ExecutionHeader execHeader = new ExecutionHeader();

res.ExecutionHeaderValue = execHeader;

execInfo = res.LoadReport(reportPath, historyID);

string sessionId = res.ExecutionHeaderValue.ExecutionID;

// add all execution parameters

PrepareReportServerExecutionParameters(res, reportParameterCollection, format, parameters, availableParameters, application, site);

// execute the report to a file

byte[] result = res.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);

FileStream stream = null;

try

{

stream = File.Create(application.TempFolder + outputFileName, result.Length);

stream.Write(result, 0, result.Length);

}

finally

{

if (stream != null)

{

stream.Close();

}

}

if (streamIDs != null && streamIDs.Length > 0)

{

for (int i = 0; i < streamIDs.Length; i++)

{

string encodingImage;

string mimeTypeImage;

System.IO.FileStream fs = null;

try

{

byte[] image = res.RenderStream("HTML4.0", streamIDs[i], null, out encodingImage, out mimeTypeImage);

fs = System.IO.File.OpenWrite(application.TempFolder + outputID + "_" + streamIDs[i]);

fs.Write(image, 0, Convert.ToInt32(image.Length));

}

catch (Exception e)

{

Log.Error(site, "Error rendering image stream for report (" + reportParameterCollection.ReportToken + "). " + e.Message + " " + e.StackTrace);

}

finally

{

if (fs != null)

{

fs.Close();

}

}

}

}

The "PrepareReportServerExecutionParameters()" method adds parameters to the report as follows:

Code Snippet

ReportExecution2005.ParameterValue parameter = new ReportExecution2005.ParameterValue();

parameter.Name = name;

parameter.Value = value;

reportServerParameterValues.Add(parameter);

The "reportServerParameterValues" collection is eventually funnelled into this call:

Code Snippet

res.SetExecutionParameters(reportParameters, "en-us");

I hope that all helps!

Michael

Running a Report deployed on Reporting Server from C#

I have a report deployed on reporting serice. I am using reporting web service.

How can we call the report, assign parameters and execute it on a webpage

Are you using the full-blown version of Visual Studio 2005? If so, use a report viewer.

I'm not sure what a "reporting web service" is.

|||ReportExecution2005.asmx|||

Is that a link? If so it isn't clickable.

|||

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.aspx

I was refereing to the Reporting Services Web Service

Its ReportExecutionService

|||

Ok. Either I'm very mistaken or you are quite confused. That is the service which allows reports to render and generate.

I don't think there is any claim in this document that is made that would indicate that you can use this service directly to view reports from a webpage.

What I was getting at is you most likely want to create a .net web application and use the report viewer within Visual Studio 2005.

|||

Yeah i was gonna do that approach, get the bytes from webserivces render and using response to write to the page

Do u know how we can use the reportviwer to use the bytes returned from the webserivce

|||

Yes. In a nutshell, you do the following:

1. Create a C# .Net web application.

2. Drag and drop a report viewer to the application.

3. Set the report viewer properties properly to point to the report.

|||

Here's code I used from my application to generate a report, and get the byte stream. You'll note code in there that is used by HTML reports to point to the location of the images returned from the report service (all of which need to be saved to disk in my case). However, you can probably do all of this via stream directly to the output stream as well. Ignore my application-specific code:

Code Snippet

// load the report meta data and execution data

ReportExecutionService res = new ReportExecutionService();

res.Credentials = System.Net.CredentialCache.DefaultCredentials;

res.Url = application.ReportServer + "ReportExecution2005.asmx";

ReportingService2005 rs = new ReportingService2005();

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

ReportService2005.DataSourceCredentials[] credentials = null;

ReportService2005.ReportParameter[] availableParameters = rs.GetReportParameters(reportPath, null, false, null, credentials);

string outputID = IdGenerator.GetRandomStringId(20, null, null, true, true);

string outputFileName = outputID + "." + ext;

bool gecko = false;

if (request != null && request.UserAgent != null && request.UserAgent.ToLower().Contains("firefox"))

{

gecko = true;

}

string deviceInfo = "/" + site.RewriteUrl(application.VirtualPathRoot + "/Content/Resource.aspx?type=tmp") + "&filename=" + outputID + "_" + (gecko ? "Gecko" : "") + "";

deviceInfo = deviceInfo.Replace("&s=" + site.Key, "&amp;s=" + site.Key);

string historyID = null;

string encoding = null;

string mimeType = null;

string extension = null;

ReportExecution2005.Warning[] warnings = null;

string[] streamIDs = null;

ExecutionInfo execInfo = new ExecutionInfo();

ExecutionHeader execHeader = new ExecutionHeader();

res.ExecutionHeaderValue = execHeader;

execInfo = res.LoadReport(reportPath, historyID);

string sessionId = res.ExecutionHeaderValue.ExecutionID;

// add all execution parameters

PrepareReportServerExecutionParameters(res, reportParameterCollection, format, parameters, availableParameters, application, site);

// execute the report to a file

byte[] result = res.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);

FileStream stream = null;

try

{

stream = File.Create(application.TempFolder + outputFileName, result.Length);

stream.Write(result, 0, result.Length);

}

finally

{

if (stream != null)

{

stream.Close();

}

}

if (streamIDs != null && streamIDs.Length > 0)

{

for (int i = 0; i < streamIDs.Length; i++)

{

string encodingImage;

string mimeTypeImage;

System.IO.FileStream fs = null;

try

{

byte[] image = res.RenderStream("HTML4.0", streamIDs[i], null, out encodingImage, out mimeTypeImage);

fs = System.IO.File.OpenWrite(application.TempFolder + outputID + "_" + streamIDs[i]);

fs.Write(image, 0, Convert.ToInt32(image.Length));

}

catch (Exception e)

{

Log.Error(site, "Error rendering image stream for report (" + reportParameterCollection.ReportToken + "). " + e.Message + " " + e.StackTrace);

}

finally

{

if (fs != null)

{

fs.Close();

}

}

}

}

The "PrepareReportServerExecutionParameters()" method adds parameters to the report as follows:

Code Snippet

ReportExecution2005.ParameterValue parameter = new ReportExecution2005.ParameterValue();

parameter.Name = name;

parameter.Value = value;

reportServerParameterValues.Add(parameter);

The "reportServerParameterValues" collection is eventually funnelled into this call:

Code Snippet

res.SetExecutionParameters(reportParameters, "en-us");

I hope that all helps!

Michael

Running 2000 and 2005 Reporting services on a single server

I've got SQL server 2000 running on a W2003 server and I want to install SQL Server 2005 and reporting services. Is there a way to run both of then. I'd like to have access to both for development purposes.
Thanks,
Just be sure to install in a different instance.
I am running both on same server. SQL 2005 instance is referenced by localhost\SQL2005 & http://localhost/reportserver$sql2005/
Virtual PC is a good option for this too.
There's a section in Books On Line called Working with Multiple versions of SQL Server that could help.|||Thanks I'll give it a shot

Run RS Script file from SSIS package

Hi!

I have a Reporting Services script file used to publish my reports. Is there anyway I can run it from a SSIS package?

Thank you!

Run rs.exe from an execute process task.

Run reports on SQL 2000 databases with RS 2005?

All our databases are running on SQL 2000, with no migration to SQL
2005 planned at this time.
We do not currently use Reporting Services. A deployment of Reporting
Services 2005 is in the pipeline.
My question is, will I need to install RS 2005 on a SQL 2000 server to
be able to report on my 2000 databases? Or will it work to install RS
2005 on SQL2005 and report on SQL 2000 databases?
Thanks for helping a neophyte.The box that run RS 2005 must have a SQL Server 2005 license. You can use
SQL 2000 as the object/metadata store or you can use SQL 2005. RS reports
off of many many different types of data (SQL Server 2000, 2005, Sybase,
Oracle, etc). The does not need to and in many cases does not reside on the
same box as RS.
Even when you install RS it does not have to have the database on the same
machine(it must have a database for its object/metadata store, it just does
not have to be on the same machine) However, even if the database resides
elsewhere you have to have a license on whatever box you install RS 2005.
My preference is to have SQL Server 2005 on the box with RS even if it is
only used for RS and all the data being reported off of is elsewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>|||Yes, this will work:
"Or will it work to install RS 2005 on SQL2005 and report on SQL 2000
databases?"
Steve MunLeeuw
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>

Run reports on specific reports server

If I have a web farm can I specify which web server the report should
be processed on?
ie. I have two reporting servers, but one of my servers is closer to
the database than the other (better WAN connection string). Can I
specify which web server the report is processed on?
Similar to in Seagate Info, where from Info desktop I can specify
which APS server to run the report on at run-time.
If not, is this functionality planned for a future update on the
product?
Also is client side printing coming out any time soon?
Regards,
Tom Olthoff
OT Solutions, Inc.can ou access your reportserver through another HTTP port or header name?
instead-of accessing your report through
http://myweb.company.com/reportserver change it to
http://mycloserweb.company.com/reportserver or
http://myweb.company.com:8180/reportserver
but you have to do this in your client application.
or, maybe you can use a redirector (or URL rewriter).
"OT Solutions, sales" <OTSolutions@.shaw.ca> a écrit dans le message de news:
df21d456.0412051703.19c8b627@.posting.google.com...
> If I have a web farm can I specify which web server the report should
> be processed on?
> ie. I have two reporting servers, but one of my servers is closer to
> the database than the other (better WAN connection string). Can I
> specify which web server the report is processed on?
> Similar to in Seagate Info, where from Info desktop I can specify
> which APS server to run the report on at run-time.
> If not, is this functionality planned for a future update on the
> product?
> Also is client side printing coming out any time soon?
> Regards,
> Tom Olthoff
> OT Solutions, Inc.

Run Reporting services from a netwrok share

I have reporting services installed on server A. I want to have iis on server
B point to the report manager on server A. I created a netwrok share on
server A and have iis pointed to this share. When I try to browse the report
manger I get:
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Execution permission cannot be acquired
Is it possible to do what I am trying? Is there an easier way?No, you cannot do this. If you want to have report manager on a different
box than the database you can do that but you have to purchase an additional
license. If you want a web farm you can do that. You cannot use any network
file sharing to accomplish anything. The reason is, Report Manager is a
asp.net application. The reports do not exist as files, they are all stored
in the database (search for *.rdl on the server and you will not see any).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"lykerd" <lykerd@.discussions.microsoft.com> wrote in message
news:775ED6F2-F21A-4DA1-A3AE-5C09A3FFA94B@.microsoft.com...
>I have reporting services installed on server A. I want to have iis on
>server
> B point to the report manager on server A. I created a netwrok share on
> server A and have iis pointed to this share. When I try to browse the
> report
> manger I get:
> Description: An error occurred during the processing of a configuration
> file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: Execution permission cannot be acquired
> Is it possible to do what I am trying? Is there an easier way?

Run Once Schedule

In SQL 2005 Reporting Services, on the page that you use to set a schedule
for a subscription, there is an option to run a report once. Is there a way
through the web service interface to invoke this specific schedule? Do you
use the NoRecurrence object?
(The options are: Hour, Day, Weekly, Monthly, Once)The quick answer is YES, everything that is done in the ReportManager
uses the web service interface. I would check the BOL for the specific
details.
"Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> In SQL 2005 Reporting Services, on the page that you use to set a schedule
> for a subscription, there is an option to run a report once. Is there a way
> through the web service interface to invoke this specific schedule? Do you
> use the NoRecurrence object?
> (The options are: Hour, Day, Weekly, Monthly, Once)
Bret Updegraff, MCAD,MCSD,MCDBA
Microsoft MVP - SQL Server
Crowe Chizek and Company LLC
President - Indianapolis Professional Association for SQL Server
Join our SQL Server Community http;//www.IndyPASS.org
317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com|||Excuse the ignorance. Whats the BOL? If you means sql books online then I
have already checked there and I couldn't find it...I wanted to look in the
source for the SubscriptionsProperties.aspx page but it is compiled and I
haven't bothered to run reflector against it.
"Bret Updegraff" wrote:
> The quick answer is YES, everything that is done in the ReportManager
> uses the web service interface. I would check the BOL for the specific
> details.
>
> "Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
> news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> > In SQL 2005 Reporting Services, on the page that you use to set a schedule
> > for a subscription, there is an option to run a report once. Is there a way
> > through the web service interface to invoke this specific schedule? Do you
> > use the NoRecurrence object?
> >
> > (The options are: Hour, Day, Weekly, Monthly, Once)
>
> --
> Bret Updegraff, MCAD,MCSD,MCDBA
> Microsoft MVP - SQL Server
> Crowe Chizek and Company LLC
> President - Indianapolis Professional Association for SQL Server
> Join our SQL Server Community http;//www.IndyPASS.org
> 317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com
>|||OK. The answer wasn't in the BOL. Pfft. The SQL BOL is very light when it
comes to the web service and what it can and can't do.
I got "unlazy" and pulled out my reflector and deconstructed the
SubscriptionProperties page (All the report services pages are compiled
pages). Needless to say, my answer I was looking for wasn't on that page but
in a custom class that they were using to construct the schedule portion of
the subscription.
(Specifically Microsoft.ReportingServices.UI.ScheduleControl within the
ReportingServicesWebUserInterface.dll)
The method that most caught my interest was TaskToScheduleDefinition() since
I was using the scheduledefinition object inherently. The short answer is:
DO NOT set the Schedule.Item and to leave it null. Only set the
StartDateTime on the schedule object.
I tested this theory that I picked up from looking at the disassembled code
and my Subscriber object worked perfectly with the schedule object set as
described above.
Here is the code from the reporting services assembly if your interested.
This is from SQL 2005 of course and only has to do with setting the schedule
object and not the rest of the code needed to set up a full subscription:
internal static ScheduleDefinition TaskToScheduleDefinition(Task task)
{
ScheduleDefinition definition1 = new ScheduleDefinition();
definition1.StartDateTime = task.StartDateTime;
definition1.EndDate = task.EndDate;
definition1.EndDateSpecified = false;
if (task.EndDate != DateTime.MinValue)
{
definition1.EndDateSpecified = true;
}
switch (task.Trigger.RecurrenceType)
{
case RecurrenceType.Once:
{
return definition1;
}
case RecurrenceType.Minutes:
{
MinuteRecurrence recurrence1 = new MinuteRecurrence();
recurrence1.MinutesInterval = ((Minutes)
task.Trigger.TriggerData).MinutesInterval;
definition1.Item = recurrence1;
return definition1;
}
case RecurrenceType.Daily:
{
DailyRecurrence recurrence2 = new DailyRecurrence();
recurrence2.DaysInterval = (int) ((Daily)
task.Trigger.TriggerData).DaysInterval;
definition1.Item = recurrence2;
return definition1;
}
case RecurrenceType.Weekly:
{
WeeklyRecurrence recurrence3 = new WeeklyRecurrence();
Weekly weekly1 = (Weekly) task.Trigger.TriggerData;
recurrence3.DaysOfWeek =ScheduleControl.UintToDaysOfWeek(weekly1.DaysOfWeek);
recurrence3.WeeksInterval = (int) weekly1.WeeksInterval;
recurrence3.WeeksIntervalSpecified = true;
definition1.Item = recurrence3;
return definition1;
}
case RecurrenceType.MonthlyDate:
{
MonthlyRecurrence recurrence4 = new MonthlyRecurrence();
Monthly monthly1 = (Monthly) task.Trigger.TriggerData;
recurrence4.Days =Monthly.GetDayRange(monthly1.DaysOfMonth);
recurrence4.MonthsOfYear =ScheduleControl.UintToMonthsOfYear(monthly1.Months);
definition1.Item = recurrence4;
return definition1;
}
case RecurrenceType.MonthlyDOW:
{
MonthlyDOWRecurrence recurrence5 = new
MonthlyDOWRecurrence();
MonthlyDOW ydow1 = (MonthlyDOW) task.Trigger.TriggerData;
recurrence5.DaysOfWeek =ScheduleControl.UintToDaysOfWeek(ydow1.DaysOfWeek);
recurrence5.MonthsOfYear =ScheduleControl.UintToMonthsOfYear(ydow1.Months);
recurrence5.WhichWeek =ScheduleControl.UintToWhichWeek(ydow1.Week);
recurrence5.WhichWeekSpecified = true;
definition1.Item = recurrence5;
return definition1;
}
}
return definition1;
}
"Steven Molen" wrote:
> Excuse the ignorance. Whats the BOL? If you means sql books online then I
> have already checked there and I couldn't find it...I wanted to look in the
> source for the SubscriptionsProperties.aspx page but it is compiled and I
> haven't bothered to run reflector against it.
> "Bret Updegraff" wrote:
> > The quick answer is YES, everything that is done in the ReportManager
> > uses the web service interface. I would check the BOL for the specific
> > details.
> >
> >
> > "Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
> > news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> >
> > > In SQL 2005 Reporting Services, on the page that you use to set a schedule
> > > for a subscription, there is an option to run a report once. Is there a way
> > > through the web service interface to invoke this specific schedule? Do you
> > > use the NoRecurrence object?
> > >
> > > (The options are: Hour, Day, Weekly, Monthly, Once)
> >
> >
> > --
> > Bret Updegraff, MCAD,MCSD,MCDBA
> > Microsoft MVP - SQL Server
> > Crowe Chizek and Company LLC
> > President - Indianapolis Professional Association for SQL Server
> > Join our SQL Server Community http;//www.IndyPASS.org
> > 317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com
> >
> >

RTF or HTML Textbox

Is there a possibility with the final Reporting Services 2008 to have
textboxes with RTF or HTML facilities? I didn't found something in the
November CTP.
If yes, will it be possible to display such a report with the Report Viewer
in a WindowsForm as a local report?
Thanks
Peterhttp://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx
This report mentions rich text but that is all it does.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pan" <pan@.discussions.microsoft.com> wrote in message
news:CE2773B3-731A-403A-BD7F-94C5D9C30BB0@.microsoft.com...
> Is there a possibility with the final Reporting Services 2008 to have
> textboxes with RTF or HTML facilities? I didn't found something in the
> November CTP.
> If yes, will it be possible to display such a report with the Report
> Viewer
> in a WindowsForm as a local report?
> Thanks
> Peter|||I am pretty sure it is the second but I cannot find a link to confirm that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pan" <pan@.discussions.microsoft.com> wrote in message
news:B41A760B-8916-4289-A0DB-226B97D9521E@.microsoft.com...
> Thanks a lot. Sometimes it's difficult to find documents. Information on
> SQL
> 2008 is quite hidden...
> For me, it's not so clear if the doc means "Rendering of a complete report
> as an RTF doc" or that what I (and many others) need: "Display data from
> the
> database that is in RTF format in a text box"
> The first option, we had already with version 2005. The second is MISSING
> since a very long time!
>
> "Bruce L-C [MVP]" wrote:
>> http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx
>> This report mentions rich text but that is all it does.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "pan" <pan@.discussions.microsoft.com> wrote in message
>> news:CE2773B3-731A-403A-BD7F-94C5D9C30BB0@.microsoft.com...
>> > Is there a possibility with the final Reporting Services 2008 to have
>> > textboxes with RTF or HTML facilities? I didn't found something in the
>> > November CTP.
>> > If yes, will it be possible to display such a report with the Report
>> > Viewer
>> > in a WindowsForm as a local report?
>> >
>> > Thanks
>> > Peter
>>

RTF Control

Hi,
Is there an RTFcontrol available for Reporting Services 2005 that will:
1. Allow selected text in the control to be Bolded?
2. Allow even justification of text on both left and right edges?
For Access, there is a control from FMS Inc that does that.
I need such a control to be able to move reports to RS.
Thanks.
Alan.Can i know what do u exactly want to do'
"Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
news:ePBwLiTdGHA.4532@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Is there an RTFcontrol available for Reporting Services 2005 that will:
> 1. Allow selected text in the control to be Bolded?
> 2. Allow even justification of text on both left and right edges?
> For Access, there is a control from FMS Inc that does that.
> I need such a control to be able to move reports to RS.
> Thanks.
> Alan.
>|||Sumit,
1. I need to have paragraphs of text in a control that I can format as in a
word processor. The text would come from a database column, with each
product ID having it's own text.
2. I need to be able to make sume words Bold or Italic.
3. I also need the ability to have superscripts, since some of the text will
be used as footnotes.
4. I also need to fully justify the text so that both left and right edges
are even, no jagged right edge.
In Access, I do this with a third-party control called Total Access Memo
from FMSInc. You can see a description of that product at fmsinc.com. I
need its features.
With that product, you enter text in their word-processing-like editor, and
it stores the text in the database column with RTF coding. This formatted
text is then available for reports.
---
Please note that such formatting can be done in Crystal Reports.
That is in fact why I am posting this question.
Client wants to replace Crystal Reports with SQL Reporting Services. They
already have reports formatted as above in Crystak
So I have to be able to duplicate this RTF feature of Crystal. It's an
inherent requirement for a conversion to Reporting Services.
Thanks.
Alan
"Sumit Pilankar" <sumit.pilankar@.gmail.com> wrote in message
news:ecMIvrYdGHA.4720@.TK2MSFTNGP03.phx.gbl...
> Can i know what do u exactly want to do'
>
> "Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
> news:ePBwLiTdGHA.4532@.TK2MSFTNGP02.phx.gbl...
> > Hi,
> >
> > Is there an RTFcontrol available for Reporting Services 2005 that will:
> >
> > 1. Allow selected text in the control to be Bolded?
> >
> > 2. Allow even justification of text on both left and right edges?
> >
> > For Access, there is a control from FMS Inc that does that.
> >
> > I need such a control to be able to move reports to RS.
> >
> > Thanks.
> >
> > Alan.
> >
> >
>

RSWebParts.cab install and Command Line Error

Hi all,
I have SQL Server 2005 installed on one server and WSS 3.0 installed
on another server. I would like to install the reporting services wbe
parts (RSWebParts.cab) to my WSS Server. I have copied the file across
and am using the following command:
:: ***********PARAMS***********
:: stsadm tool
SET STSADMTOOL="C:\Program Files\Common Files\Microsoft Shared\web
server extensions\12\bin\stsadm.exe"
GOTO STOP
:STOP
%STSADMTOOL% -help addwppack
pause;
echo using STSADMTOOL at %STSADMTOOL%
%STSADMTOOL% -o addwppack -force -filename C:\ReportingServices
\RSWebParts.cab
When I run it I get a Command Line Error and it points me in the
direction of stsadm help. I can guarantee you the files are in the
correct location as per the parameters passed in and that I am a local
admin on the server.
This is driving me nuts, can anybody help asap?
Cheers
JimskiI have the same problem.  I am losing faith in Microsoft.  Have you ever found a solution?

RSS Verifying DB version while upgrade

In Reporting Server2005 Configuration, while verifying database version and
trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does not
match your reporting server installation. you must upgrade your reporting
services database.
Please help, can not move forward.
Regards...Piku.This is a multi-part message in MIME format.
--=_NextPart_000_0047_01C6DC0C.4F605770
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
By the error message, it seems you're trying to install the RS 2005 =database to a database instance running SQL Server 2000. This seems to =be possible, but you have to do things differently during setup. This =article might help you in the right direction:
Using SQL 2000 for SSRS 2005 metadata storage
When setting up SQL Server Reporting Services 2005, can you use SQL 2000 =as the host for the reportserver database? Yes, you can (with an obvious =caveat in one scenario).

https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
Kaisa M. Lindahl Lervik
"Piku" <Piku@.discussions.microsoft.com> wrote in message =news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> In Reporting Server2005 Configuration, while verifying database =version and > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 =does not > match your reporting server installation. you must upgrade your =reporting > services database.
> > Please help, can not move forward.
> > Regards...Piku.
--=_NextPart_000_0047_01C6DC0C.4F605770
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

By the error message, it seems you're =trying to install the RS 2005 database to a database instance running SQL Server =2000. This seems to be possible, but you have to do things differently during =setup. This article might help you in the right direction:
Using SQL 2000 for SSRS 2005 =metadata storage
When setting up SQL Server Reporting Services 2005, can you =use SQL 2000 as the host for the reportserver database? Yes, you can (with an =obvious caveat in one scenario).
=https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.a=spx
Kaisa M. Lindahl Lervik
"Piku" wrote in message news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...> =In Reporting Server2005 Configuration, while verifying database version and > =trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does =not > match your reporting server installation. you must upgrade your =reporting > services database.> > Please help, can =not move forward.> > Regards...Piku.

---

--=_NextPart_000_0047_01C6DC0C.4F605770--|||I am installing rss 2005 on a SQL Server 2005 database, please help
"Kaisa M. Lindahl Lervik" wrote:
> By the error message, it seems you're trying to install the RS 2005 database to a database instance running SQL Server 2000. This seems to be possible, but you have to do things differently during setup. This article might help you in the right direction:
> Using SQL 2000 for SSRS 2005 metadata storage
>
> When setting up SQL Server Reporting Services 2005, can you use SQL 2000 as the host for the reportserver database? Yes, you can (with an obvious caveat in one scenario).
>
> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>
> Kaisa M. Lindahl Lervik
>
> "Piku" <Piku@.discussions.microsoft.com> wrote in message news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > In Reporting Server2005 Configuration, while verifying database version and
> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does not
> > match your reporting server installation. you must upgrade your reporting
> > services database.
> >
> > Please help, can not move forward.
> >
> > Regards...Piku|||OK, seems like someone else had the same problem a few weeks ago. His
problem and solution:
I had the same problem.
It was caused by that I had installed reporting services after I had run
SP1 on SQL Server 2005.
Solved it by runing SQL Server 2005 SP1 again.
Hope this helps!
(At the end of this thread:)
http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
Kaisa
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
>I am installing rss 2005 on a SQL Server 2005 database, please help
> "Kaisa M. Lindahl Lervik" wrote:
>> By the error message, it seems you're trying to install the RS 2005
>> database to a database instance running SQL Server 2000. This seems to be
>> possible, but you have to do things differently during setup. This
>> article might help you in the right direction:
>> Using SQL 2000 for SSRS 2005 metadata storage
>>
>> When setting up SQL Server Reporting Services 2005, can you use SQL 2000
>> as the host for the reportserver database? Yes, you can (with an obvious
>> caveat in one scenario).
>>
>> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>>
>> Kaisa M. Lindahl Lervik
>>
>> "Piku" <Piku@.discussions.microsoft.com> wrote in message
>> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
>> > In Reporting Server2005 Configuration, while verifying database version
>> > and
>> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does
>> > not
>> > match your reporting server installation. you must upgrade your
>> > reporting
>> > services database.
>> >
>> > Please help, can not move forward.
>> >
>> > Regards...Piku|||Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
install SQ1 again and see what happens, but have a doubt, SQL2005 instance
already has sp1 though. Thanks and appreciate your very quick response.
"Kaisa M. Lindahl Lervik" wrote:
> OK, seems like someone else had the same problem a few weeks ago. His
> problem and solution:
> I had the same problem.
> It was caused by that I had installed reporting services after I had run
> SP1 on SQL Server 2005.
> Solved it by runing SQL Server 2005 SP1 again.
>
> Hope this helps!
> (At the end of this thread:)
> http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> Kaisa
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> >I am installing rss 2005 on a SQL Server 2005 database, please help
> >
> > "Kaisa M. Lindahl Lervik" wrote:
> >
> >> By the error message, it seems you're trying to install the RS 2005
> >> database to a database instance running SQL Server 2000. This seems to be
> >> possible, but you have to do things differently during setup. This
> >> article might help you in the right direction:
> >> Using SQL 2000 for SSRS 2005 metadata storage
> >>
> >>
> >> When setting up SQL Server Reporting Services 2005, can you use SQL 2000
> >> as the host for the reportserver database? Yes, you can (with an obvious
> >> caveat in one scenario).
> >>
> >>
> >>
> >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> >>
> >>
> >> Kaisa M. Lindahl Lervik
> >>
> >>
> >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> >> > In Reporting Server2005 Configuration, while verifying database version
> >> > and
> >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does
> >> > not
> >> > match your reporting server installation. you must upgrade your
> >> > reporting
> >> > services database.
> >> >
> >> > Please help, can not move forward.
> >> >
> >> > Regards...Piku
>
>|||Actually my BUILD is 2153, which is one hotfix more than sp1
"Piku" wrote:
> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> install SQ1 again and see what happens, but have a doubt, SQL2005 instance
> already has sp1 though. Thanks and appreciate your very quick response.
> "Kaisa M. Lindahl Lervik" wrote:
> > OK, seems like someone else had the same problem a few weeks ago. His
> > problem and solution:
> >
> > I had the same problem.
> > It was caused by that I had installed reporting services after I had run
> > SP1 on SQL Server 2005.
> >
> > Solved it by runing SQL Server 2005 SP1 again.
> >
> >
> > Hope this helps!
> >
> > (At the end of this thread:)
> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> >
> > Kaisa
> >
> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> > >
> > > "Kaisa M. Lindahl Lervik" wrote:
> > >
> > >> By the error message, it seems you're trying to install the RS 2005
> > >> database to a database instance running SQL Server 2000. This seems to be
> > >> possible, but you have to do things differently during setup. This
> > >> article might help you in the right direction:
> > >> Using SQL 2000 for SSRS 2005 metadata storage
> > >>
> > >>
> > >> When setting up SQL Server Reporting Services 2005, can you use SQL 2000
> > >> as the host for the reportserver database? Yes, you can (with an obvious
> > >> caveat in one scenario).
> > >>
> > >>
> > >>
> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> > >>
> > >>
> > >> Kaisa M. Lindahl Lervik
> > >>
> > >>
> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > >> > In Reporting Server2005 Configuration, while verifying database version
> > >> > and
> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40 does
> > >> > not
> > >> > match your reporting server installation. you must upgrade your
> > >> > reporting
> > >> > services database.
> > >> >
> > >> > Please help, can not move forward.
> > >> >
> > >> > Regards...Piku
> >
> >
> >|||OK, don't know what to do about that. :(
Kaisa
"Piku" <Piku@.discussions.microsoft.com> wrote in message
news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> Actually my BUILD is 2153, which is one hotfix more than sp1
> "Piku" wrote:
>> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
>> install SQ1 again and see what happens, but have a doubt, SQL2005
>> instance
>> already has sp1 though. Thanks and appreciate your very quick response.
>> "Kaisa M. Lindahl Lervik" wrote:
>> > OK, seems like someone else had the same problem a few weeks ago. His
>> > problem and solution:
>> >
>> > I had the same problem.
>> > It was caused by that I had installed reporting services after I had
>> > run
>> > SP1 on SQL Server 2005.
>> >
>> > Solved it by runing SQL Server 2005 SP1 again.
>> >
>> >
>> > Hope this helps!
>> >
>> > (At the end of this thread:)
>> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
>> >
>> > Kaisa
>> >
>> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
>> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
>> > >I am installing rss 2005 on a SQL Server 2005 database, please help
>> > >
>> > > "Kaisa M. Lindahl Lervik" wrote:
>> > >
>> > >> By the error message, it seems you're trying to install the RS 2005
>> > >> database to a database instance running SQL Server 2000. This seems
>> > >> to be
>> > >> possible, but you have to do things differently during setup. This
>> > >> article might help you in the right direction:
>> > >> Using SQL 2000 for SSRS 2005 metadata storage
>> > >>
>> > >>
>> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
>> > >> 2000
>> > >> as the host for the reportserver database? Yes, you can (with an
>> > >> obvious
>> > >> caveat in one scenario).
>> > >>
>> > >>
>> > >>
>> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>> > >>
>> > >>
>> > >> Kaisa M. Lindahl Lervik
>> > >>
>> > >>
>> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
>> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
>> > >> > In Reporting Server2005 Configuration, while verifying database
>> > >> > version
>> > >> > and
>> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
>> > >> > does
>> > >> > not
>> > >> > match your reporting server installation. you must upgrade your
>> > >> > reporting
>> > >> > services database.
>> > >> >
>> > >> > Please help, can not move forward.
>> > >> >
>> > >> > Regards...Piku
>> >
>> >
>> >|||I reinstall the sp1 and it worked, doesn,t make any sense as I was already
having the higher build, anyway THANKS.
Now everything thing looks good BUT when I am trying to connect to the
report server by http://servername/reportserver OR
http://servername/reports getting Msg : " The feature: "Scale-out deployment"
is not supported in this edition of Reporting Services.
(rsOperationNotSupported) (rsRPCError"
I have installed One report server one sql server standard edition all on
one machine, then why am I getting this msg, I know only Dev and Entp Edition
supports Scale-Out deployment how to resolve it, please help.
Regards.
"Kaisa M. Lindahl Lervik" wrote:
> OK, don't know what to do about that. :(
> Kaisa
> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> > Actually my BUILD is 2153, which is one hotfix more than sp1
> >
> > "Piku" wrote:
> >
> >> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> >> install SQ1 again and see what happens, but have a doubt, SQL2005
> >> instance
> >> already has sp1 though. Thanks and appreciate your very quick response.
> >>
> >> "Kaisa M. Lindahl Lervik" wrote:
> >>
> >> > OK, seems like someone else had the same problem a few weeks ago. His
> >> > problem and solution:
> >> >
> >> > I had the same problem.
> >> > It was caused by that I had installed reporting services after I had
> >> > run
> >> > SP1 on SQL Server 2005.
> >> >
> >> > Solved it by runing SQL Server 2005 SP1 again.
> >> >
> >> >
> >> > Hope this helps!
> >> >
> >> > (At the end of this thread:)
> >> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> >> >
> >> > Kaisa
> >> >
> >> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> >> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> >> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> >> > >
> >> > > "Kaisa M. Lindahl Lervik" wrote:
> >> > >
> >> > >> By the error message, it seems you're trying to install the RS 2005
> >> > >> database to a database instance running SQL Server 2000. This seems
> >> > >> to be
> >> > >> possible, but you have to do things differently during setup. This
> >> > >> article might help you in the right direction:
> >> > >> Using SQL 2000 for SSRS 2005 metadata storage
> >> > >>
> >> > >>
> >> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
> >> > >> 2000
> >> > >> as the host for the reportserver database? Yes, you can (with an
> >> > >> obvious
> >> > >> caveat in one scenario).
> >> > >>
> >> > >>
> >> > >>
> >> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> >> > >>
> >> > >>
> >> > >> Kaisa M. Lindahl Lervik
> >> > >>
> >> > >>
> >> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> >> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> >> > >> > In Reporting Server2005 Configuration, while verifying database
> >> > >> > version
> >> > >> > and
> >> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
> >> > >> > does
> >> > >> > not
> >> > >> > match your reporting server installation. you must upgrade your
> >> > >> > reporting
> >> > >> > services database.
> >> > >> >
> >> > >> > Please help, can not move forward.
> >> > >> >
> >> > >> > Regards...Piku
> >> >
> >> >
> >> >
>
>|||Same problem here. I am trying to solve this issue since DAYS on the Italian
localized SQL 2005 Workgroup Edition of SQL 2005 on a SBS 2003 R2 PDC. Fresh
install, not upgrade.
I'm trying to install Reporting Services on the default db instance. The db
engine is now at 9.0.2153.
On the Report Server Configuration tool I'm on the "database setting" tab
(I'm translating everything from Italian, so labels could be literally
different).
I can connect to the server. I push the "New..." button. I create a db on
the default SQL instance. Credentials: Current user (running in the
Administrator context). DB Name: ReportServer. Language: either English or
Italian.
The DB gets built. I push the "Apply" button and a "Update the db"? message
appears. I click "OK". The status shows:
GREEN: Verification of the db edition: completed.
YELLOW TRIANGLE: Verification of the db version: "The DATABASE VERSION
C.0.8.40 does not match your reporting server installation. You must upgrade
your reporting services db".
YELLOW TRIANGLE: Creating the update script for the DB version C.0.8.40: No
update script available for this version of the db!
"Piku" wrote:
> I reinstall the sp1 and it worked, doesn,t make any sense as I was already
> having the higher build, anyway THANKS.
> Now everything thing looks good BUT when I am trying to connect to the
> report server by http://servername/reportserver OR
> http://servername/reports getting Msg : " The feature: "Scale-out deployment"
> is not supported in this edition of Reporting Services.
> (rsOperationNotSupported) (rsRPCError"
> I have installed One report server one sql server standard edition all on
> one machine, then why am I getting this msg, I know only Dev and Entp Edition
> supports Scale-Out deployment how to resolve it, please help.
> Regards.
> "Kaisa M. Lindahl Lervik" wrote:
> > OK, don't know what to do about that. :(
> >
> > Kaisa
> >
> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> > > Actually my BUILD is 2153, which is one hotfix more than sp1
> > >
> > > "Piku" wrote:
> > >
> > >> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> > >> install SQ1 again and see what happens, but have a doubt, SQL2005
> > >> instance
> > >> already has sp1 though. Thanks and appreciate your very quick response.
> > >>
> > >> "Kaisa M. Lindahl Lervik" wrote:
> > >>
> > >> > OK, seems like someone else had the same problem a few weeks ago. His
> > >> > problem and solution:
> > >> >
> > >> > I had the same problem.
> > >> > It was caused by that I had installed reporting services after I had
> > >> > run
> > >> > SP1 on SQL Server 2005.
> > >> >
> > >> > Solved it by runing SQL Server 2005 SP1 again.
> > >> >
> > >> >
> > >> > Hope this helps!
> > >> >
> > >> > (At the end of this thread:)
> > >> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> > >> >
> > >> > Kaisa
> > >> >
> > >> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > >> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> > >> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> > >> > >
> > >> > > "Kaisa M. Lindahl Lervik" wrote:
> > >> > >
> > >> > >> By the error message, it seems you're trying to install the RS 2005
> > >> > >> database to a database instance running SQL Server 2000. This seems
> > >> > >> to be
> > >> > >> possible, but you have to do things differently during setup. This
> > >> > >> article might help you in the right direction:
> > >> > >> Using SQL 2000 for SSRS 2005 metadata storage
> > >> > >>
> > >> > >>
> > >> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
> > >> > >> 2000
> > >> > >> as the host for the reportserver database? Yes, you can (with an
> > >> > >> obvious
> > >> > >> caveat in one scenario).
> > >> > >>
> > >> > >>
> > >> > >>
> > >> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> > >> > >>
> > >> > >>
> > >> > >> Kaisa M. Lindahl Lervik
> > >> > >>
> > >> > >>
> > >> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > >> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > >> > >> > In Reporting Server2005 Configuration, while verifying database
> > >> > >> > version
> > >> > >> > and
> > >> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
> > >> > >> > does
> > >> > >> > not
> > >> > >> > match your reporting server installation. you must upgrade your
> > >> > >> > reporting
> > >> > >> > services database.
> > >> > >> >
> > >> > >> > Please help, can not move forward.
> > >> > >> >
> > >> > >> > Regards...Piku
> > >> >
> > >> >
> > >> >
> >
> >
> >|||I forgot to say: when I run the SQL 2005 SP1 install, it works for everything
except the reporting services. That gives "error" and stayis on SP0!
"davideC" wrote:
> Same problem here. I am trying to solve this issue since DAYS on the Italian
> localized SQL 2005 Workgroup Edition of SQL 2005 on a SBS 2003 R2 PDC. Fresh
> install, not upgrade.
> I'm trying to install Reporting Services on the default db instance. The db
> engine is now at 9.0.2153.
> On the Report Server Configuration tool I'm on the "database setting" tab
> (I'm translating everything from Italian, so labels could be literally
> different).
> I can connect to the server. I push the "New..." button. I create a db on
> the default SQL instance. Credentials: Current user (running in the
> Administrator context). DB Name: ReportServer. Language: either English or
> Italian.
> The DB gets built. I push the "Apply" button and a "Update the db"? message
> appears. I click "OK". The status shows:
> GREEN: Verification of the db edition: completed.
> YELLOW TRIANGLE: Verification of the db version: "The DATABASE VERSION
> C.0.8.40 does not match your reporting server installation. You must upgrade
> your reporting services db".
> YELLOW TRIANGLE: Creating the update script for the DB version C.0.8.40: No
> update script available for this version of the db!
>
> "Piku" wrote:
> > I reinstall the sp1 and it worked, doesn,t make any sense as I was already
> > having the higher build, anyway THANKS.
> >
> > Now everything thing looks good BUT when I am trying to connect to the
> > report server by http://servername/reportserver OR
> > http://servername/reports getting Msg : " The feature: "Scale-out deployment"
> > is not supported in this edition of Reporting Services.
> > (rsOperationNotSupported) (rsRPCError"
> >
> > I have installed One report server one sql server standard edition all on
> > one machine, then why am I getting this msg, I know only Dev and Entp Edition
> > supports Scale-Out deployment how to resolve it, please help.
> >
> > Regards.
> >
> > "Kaisa M. Lindahl Lervik" wrote:
> >
> > > OK, don't know what to do about that. :(
> > >
> > > Kaisa
> > >
> > > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > > news:EFB33C14-C348-4457-A3FA-EEAD02FD932D@.microsoft.com...
> > > > Actually my BUILD is 2153, which is one hotfix more than sp1
> > > >
> > > > "Piku" wrote:
> > > >
> > > >> Yes, My scenario is exactly same, sql2k5, sp1 and then rss2005...let me
> > > >> install SQ1 again and see what happens, but have a doubt, SQL2005
> > > >> instance
> > > >> already has sp1 though. Thanks and appreciate your very quick response.
> > > >>
> > > >> "Kaisa M. Lindahl Lervik" wrote:
> > > >>
> > > >> > OK, seems like someone else had the same problem a few weeks ago. His
> > > >> > problem and solution:
> > > >> >
> > > >> > I had the same problem.
> > > >> > It was caused by that I had installed reporting services after I had
> > > >> > run
> > > >> > SP1 on SQL Server 2005.
> > > >> >
> > > >> > Solved it by runing SQL Server 2005 SP1 again.
> > > >> >
> > > >> >
> > > >> > Hope this helps!
> > > >> >
> > > >> > (At the end of this thread:)
> > > >> > http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f94ed9da97f6cf0a/
> > > >> >
> > > >> > Kaisa
> > > >> >
> > > >> > "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > > >> > news:3EDD6003-1110-4BC5-9887-793C480A97C9@.microsoft.com...
> > > >> > >I am installing rss 2005 on a SQL Server 2005 database, please help
> > > >> > >
> > > >> > > "Kaisa M. Lindahl Lervik" wrote:
> > > >> > >
> > > >> > >> By the error message, it seems you're trying to install the RS 2005
> > > >> > >> database to a database instance running SQL Server 2000. This seems
> > > >> > >> to be
> > > >> > >> possible, but you have to do things differently during setup. This
> > > >> > >> article might help you in the right direction:
> > > >> > >> Using SQL 2000 for SSRS 2005 metadata storage
> > > >> > >>
> > > >> > >>
> > > >> > >> When setting up SQL Server Reporting Services 2005, can you use SQL
> > > >> > >> 2000
> > > >> > >> as the host for the reportserver database? Yes, you can (with an
> > > >> > >> obvious
> > > >> > >> caveat in one scenario).
> > > >> > >>
> > > >> > >>
> > > >> > >>
> > > >> > >> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> > > >> > >>
> > > >> > >>
> > > >> > >> Kaisa M. Lindahl Lervik
> > > >> > >>
> > > >> > >>
> > > >> > >> "Piku" <Piku@.discussions.microsoft.com> wrote in message
> > > >> > >> news:8B4C1C74-8DB4-4287-8A95-445EA14A1FF3@.microsoft.com...
> > > >> > >> > In Reporting Server2005 Configuration, while verifying database
> > > >> > >> > version
> > > >> > >> > and
> > > >> > >> > trying to upgrade it Getting Msg : "The DATABASE VERSION C.0.8.40
> > > >> > >> > does
> > > >> > >> > not
> > > >> > >> > match your reporting server installation. you must upgrade your
> > > >> > >> > reporting
> > > >> > >> > services database.
> > > >> > >> >
> > > >> > >> > Please help, can not move forward.
> > > >> > >> >
> > > >> > >> > Regards...Piku
> > > >> >
> > > >> >
> > > >> >
> > >
> > >
> > >