Getting started?

Hi,
I'm looking to implement Reporting Services for the first time and have a
couple quiestions, which I hope someone can answer for me. Or database is
SQL Server 2000, currently with sp1. We do have a license for SQL Server
2005 but our business application does not support it yet.
Someone has recommended that we use RS from the SQL 2005 because of it's
better features than the previous version.
Reading the prerequisits for installation I see that SQL Sever 2000 should
be at sp3a, how hard a requisit is this? Can I get by with sp1?
Regarding the report designer, do I really have to have Visual Studio .NET
2003 to use the designer? I don't have it yet so could I get by with Visual
Studio Express?
I guess those are the two biggest questions I have right now.
Thanks in advance,
LinnOn Oct 16, 1:03 pm, "Linn Kubler" <lkub...@.chartwellwisc2.com> wrote:
> Hi,
> I'm looking to implement Reporting Services for the first time and have a
> couple quiestions, which I hope someone can answer for me. Or database is
> SQL Server 2000, currently with sp1. We do have a license for SQL Server
> 2005 but our business application does not support it yet.
> Someone has recommended that we use RS from the SQL 2005 because of it's
> better features than the previous version.
> Reading the prerequisits for installation I see that SQL Sever 2000 should
> be at sp3a, how hard a requisit is this? Can I get by with sp1?
> Regarding the report designer, do I really have to have Visual Studio .NET
> 2003 to use the designer? I don't have it yet so could I get by with Visual
> Studio Express?
> I guess those are the two biggest questions I have right now.
> Thanks in advance,
> Linn
I would suggest upgrading to SP3a, it has added functionality since
SP1 in terms of SQL Server. You might be able to get away w/VS Express
w/Advanced Services temporarily; however, SSRS Express Edition does
not have all the functionality that SSTS Std Edition has (http://
www.microsoft.com/sql/prodinfo/features/compare-features.mspx ). Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1192586314.331811.84030@.e9g2000prf.googlegroups.com...
> On Oct 16, 1:03 pm, "Linn Kubler" <lkub...@.chartwellwisc2.com> wrote:
>> Hi,
>> I'm looking to implement Reporting Services for the first time and have a
>> couple quiestions, which I hope someone can answer for me. Or database
>> is
>> SQL Server 2000, currently with sp1. We do have a license for SQL Server
>> 2005 but our business application does not support it yet.
>> Someone has recommended that we use RS from the SQL 2005 because of it's
>> better features than the previous version.
>> Reading the prerequisits for installation I see that SQL Sever 2000
>> should
>> be at sp3a, how hard a requisit is this? Can I get by with sp1?
>> Regarding the report designer, do I really have to have Visual Studio
>> .NET
>> 2003 to use the designer? I don't have it yet so could I get by with
>> Visual
>> Studio Express?
>> I guess those are the two biggest questions I have right now.
>> Thanks in advance,
>> Linn
>
> I would suggest upgrading to SP3a, it has added functionality since
> SP1 in terms of SQL Server. You might be able to get away w/VS Express
> w/Advanced Services temporarily; however, SSRS Express Edition does
> not have all the functionality that SSTS Std Edition has (http://
> www.microsoft.com/sql/prodinfo/features/compare-features.mspx ). Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Hi Enrique,
Did you mean SSRS Std Edition? Not sure what SSTS is. Assuming that's the
case, I do have SQL Server 2005 Standard Edition, it is the Visual Studio I
don't have currently so was wondering about the free version of that. From
the article you linked it looks like Advanced Services is a component of
Reporting Services out of SQL Server Express Edition.
First hurdle is to install SQL Server 2000 sp3a though.
Thanks for the help,
Linn

Getting started...

Hi.

I am about to move from Crystal to MS Reporting services. I will be using VWD2005 Express.

Are there any 'Getting Started' tutorials and/or web pages specifically dealing with VWD2005 and Reporting services?

Thank you.

Hi,

You would usually be using Businnes Intelligence Development Studio to develop reports.

Check these

http://msdn2.microsoft.com/en-us/express/aa718391.aspx#10

http://msdn2.microsoft.com/en-us/express/aa718391.aspx#11

http://www.databasejournal.com/features/mssql/article.php/3573361

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

Getting started with sql 2000 Reporting Services??

Hi all,

I've been developing using MS Web Developer 2005 (Express Edition) and now need to create reports. I've installed MS SQL 2000 Reporting Services on the applicable SQL 2000 server and am now stuck on how to create reports from MS Web Developer 2005. Do i need MS Web Developer 2005 Pro or alternatively Visual Studio .NET 2003 to create dynamic web based reports? If not could someone throw me some pointers please :) as im really having problems getting started on this.

Cheers,

Ryan

Hi,

You can use SQL Server 2005 Express Edition with Advanced Services, which includes Reporting Services.

Check the linkhttp://www.kodyaz.com/content/sqlserver2005servicepack1.aspx for download links.

Eralper

|||

ryanchopps:

Hi all,

I've been developing using MS Web Developer 2005 (Express Edition) and now need to create reports. I've installed MS SQL 2000 Reporting Services on the applicable SQL 2000 server and am now stuck on how to create reports from MS Web Developer 2005. Do i need MS Web Developer 2005 Pro or alternatively Visual Studio .NET 2003 to create dynamic web based reports? If not could someone throw me some pointers please :) as im really having problems getting started on this.

Cheers,

Ryan

Reporting Serverice 2000 can be installed to have the report designer, which works on .Net 2003. So, Visual Studio .Net 2003 can be used to develop the reports.

Getting started with reporting services SQL Server 2005...help

Hi, I'm building a Web aplication which will feed a SQL 2005 reporting service to send information on a report. I've used the SQL Server 2005 Business Intelligence tool but I've created a simple report with no interaction with the web aplication. The serious question is, is there any tutorial or web site with good step by step how to feed a sql server 2005 reporting service from a ASP.Net web application?This is to be made quickly, it may be quite simple, but I'm quite lost into it too!Thanks for helping!

I read from below site, it helps me to understand.

http://www.odetocode.com/Articles/128.aspx

http://www.odetocode.com/Articles/156.aspx

Anyway, if you have any questions about it please let me know. I will help you as much as i can.

Getting Started

Where can I find the report designer installer. I only can find the
reporting services configuration utility.
Thanks
RobOn Feb 28, 8:36 am, "Rob Diamant" <robd...@.hotmail.com> wrote:
> Where can I find the report designer installer. I only can find the
> reporting services configuration utility.
> Thanks
> Rob
Assuming you have SQL Server 2005, you should have been able to
install it as part of the options. Once it is installed: to begin
using it, you will need to open the Microsoft Visual Studio 2005 via
Start->Programs and create a new Report Server project (via File->New-
>Project). If you are wanting to install SQL Server 2005 Express
Advanced, then you will want to download and install MS SQL Server
2005 Express Edition w/Advanced Services & MS SQL Server 2005 Express
Edition Toolkit ()|||Thank,
I had the Server part installed. I was looking for the Visual Studio hint.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1172714406.689803.323620@.m58g2000cwm.googlegroups.com...
> On Feb 28, 8:36 am, "Rob Diamant" <robd...@.hotmail.com> wrote:
>> Where can I find the report designer installer. I only can find the
>> reporting services configuration utility.
>> Thanks
>> Rob
>
> Assuming you have SQL Server 2005, you should have been able to
> install it as part of the options. Once it is installed: to begin
> using it, you will need to open the Microsoft Visual Studio 2005 via
> Start->Programs and create a new Report Server project (via File->New-
>>Project). If you are wanting to install SQL Server 2005 Express
> Advanced, then you will want to download and install MS SQL Server
> 2005 Express Edition w/Advanced Services & MS SQL Server 2005 Express
> Edition Toolkit ()
>

Getting Server name for Analysis Services 2005 Cube for use in SQL Reporting Services

Hi

We have been struggling getting the Servername to include on a SQL Reporting Services report. The Reporting server and the Analysis Services cube will not be on the same server, so the ReportURL option is not of much use to us. Is there any way of getting the servername where the cube is through a MDX Query. If this is not possible any other suggestions.

Andre

I am not sure I understand your scenario. The server name is specified in the data source. What exactly are you trying to do and what's ReportURL option?|||

I will try to make it clearer.

Our datasource for Reporting services is an Analysis Services Cube. We want to get the servername of the datasouce (or cube) and use it in the report - in a textbox which is part of a table or Matrix. Note the reporting server and Cube may or may not be on the same server as we are rolling this out to a variety of clients.

How do we retrieve the actual servername itself to use in the report. 2 of us have been searching and have not come up with anything as yet.

Andre

|||

Not that easy. Two options come to mind:

1. Use an expression-based connection string (works with a private data sources only) and store the server name in the Report Server web.config file. This sample demonstrates this scenario.

2. Write .NET code in an exernal assembly that retrieves the data source info for the report by calling GetDataSourceContents API.

Getting Server name for Analysis Services 2005 Cube for use in SQL Reporting Services

Hi

We have been struggling getting the Servername to include on a SQL Reporting Services report. The Reporting server and the Analysis Services cube will not be on the same server, so the ReportURL option is not of much use to us. Is there any way of getting the servername where the cube is through a MDX Query. If this is not possible any other suggestions.

Andre

I am not sure I understand your scenario. The server name is specified in the data source. What exactly are you trying to do and what's ReportURL option?|||

I will try to make it clearer.

Our datasource for Reporting services is an Analysis Services Cube. We want to get the servername of the datasouce (or cube) and use it in the report - in a textbox which is part of a table or Matrix. Note the reporting server and Cube may or may not be on the same server as we are rolling this out to a variety of clients.

How do we retrieve the actual servername itself to use in the report. 2 of us have been searching and have not come up with anything as yet.

Andre

|||

Not that easy. Two options come to mind:

1. Use an expression-based connection string (works with a private data sources only) and store the server name in the Report Server web.config file. This sample demonstrates this scenario.

2. Write .NET code in an exernal assembly that retrieves the data source info for the report by calling GetDataSourceContents API.

getting rid of a document map

When i publish a report to our reporting services site, it comes with a document map that I cannot seem to get rid of and is really annoyong to users. How do I stop this from happening and appearing?

look at the values displayed in the document map, find them in the design view, remove the entry in the Document Map property for each object that contains a value.

HTH

Dean

Getting Report Server Running on Local Instance of SQL Express

I have installed SQL 2005 Tools which installed Visual Studio 2005 including SQL Server Reporting Services Designers. I thought this would create a local instance of SQL Server 2005 but it did not. So I installed SQL Server 2005 Express so I could designate it as my local Report Server instance. How do I configure this local instance to be used for Report Server?

RS Configuration Manager

Machine Name: "localmachinename"

Instance Name: greyed out

No report servers were found on the specified machine.

Details: Invalid Namespace

Did you install the Advanced Edition of SQL Server 2005 Express ? If not you wont have the Reporting Server installed. YOu can download the Advanced Services edition from here: http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=de

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||I eventually came to the same conclusion. Thanks

Getting problem when using Dundas chart in subreport

Hi,
I am using Visual Studio 2005 and SQL Server 2005 Reporting Services with
Dundas charts for Reporting. I have creatied one subreport and put this
subreport in List control in main report. I have placed Dundas chart in
subreport. In this way I want to display many dundas charts dynamically.
When I preview the main report it only displays last chart and red X image
is displayed instead of other charts.
I also tried to install SQL Server 2005 SP2 and then I also installed
"cumulative hotfix package for SQL Server 2005 (build 9.0.2153)". But still
same problem.
Do u have any idea about this problem?
Thanks,
....HineshDid you find a solution for that. I have the same problem with dundas chart in a subreport
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Getting Images to render in HTML using Web Service (SOAP)

I have created a web app that uses the reporting services Web Service to
pull reports from the SQL Server.
The web server is on one machine, SQL Server on another and I use the web
service to get the reports. I do not use URLs in any way in order to keep as
much information hidden as possible.
I have been able to list all reports, select a report, get back the
parameters required, set the parameter values and render reports using
ReportingService.Render
HOWEVER...
The reports that work do not include charts (graphics). When I render a
report using my app, if it has no chart I can view it in HTML, PDF, TIF,
Excel and MHTML. If it has a chart then for PDF, Excel and TIF all is fine.
If I try to use HTML or MHTML I get a big empty space where my charts should
be.
In reading the BOL under ReportingService.Render Method
I found this: "StreamIds
[out] The stream identifiers. These IDs are passed to the RenderStream
method. You can use them to render the external resources (images, etc.)
that are associated with a given report. "
I have found this topic:
ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_ref_soapapi_service_lz_49f6.htm
ReportingService.RenderStream Method
I read the code, and I have tried to implement it as in the BOL. I am able
to write the images onto the web-server hard-drive, and the image place
holder properties no longer point to my SQL server (which they did at first)
but I still don't get an image.
For example, my image is actually at:
http://sandy.murdocks.on.ca/1/reports/temp/C_79_S
It is there and it works. Now my report opens in a new window since I do the
final call to open it like this:
Response.AddHeader("Content-Disposition", "attachment; filename=" &
fileName)
Response.BinaryWrite(data)
When I right click on the image place holder I get this:
file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/QPIH2VE9/1/Reports/Temp/C_79_S
The images don't seem to get from being written on the drive, to being
picked up for display.
My code for writing the images looks like this:
If format = "HTML4.0" Then
For Each streamid In streamIDs
image = rs.RenderStream(strpath, "HTML4.0", streamid,
Nothing, Nothing, parameters, Nothing, Nothing)
Dim stream As System.IO.FileStream = _
System.IO.File.OpenWrite(Application("TempReports") &
streamid)
stream.Write(image, 0, CInt(image.Length))
stream.Close()
Next
End If
Sandy Murdock MCPlook at my previuos post:
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&query=rome&lang=en&cr=US&guid=&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=a830cc14-9b06-496b-b1f4-e55ab3611f0b
Antonio
"Roger Twomey" wrote:
> I have created a web app that uses the reporting services Web Service to
> pull reports from the SQL Server.
> The web server is on one machine, SQL Server on another and I use the web
> service to get the reports. I do not use URLs in any way in order to keep as
> much information hidden as possible.
> I have been able to list all reports, select a report, get back the
> parameters required, set the parameter values and render reports using
> ReportingService.Render
> HOWEVER...
> The reports that work do not include charts (graphics). When I render a
> report using my app, if it has no chart I can view it in HTML, PDF, TIF,
> Excel and MHTML. If it has a chart then for PDF, Excel and TIF all is fine.
> If I try to use HTML or MHTML I get a big empty space where my charts should
> be.
> In reading the BOL under ReportingService.Render Method
> I found this: "StreamIds
> [out] The stream identifiers. These IDs are passed to the RenderStream
> method. You can use them to render the external resources (images, etc.)
> that are associated with a given report. "
> I have found this topic:
> ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_ref_soapapi_service_lz_49f6.htm
> ReportingService.RenderStream Method
> I read the code, and I have tried to implement it as in the BOL. I am able
> to write the images onto the web-server hard-drive, and the image place
> holder properties no longer point to my SQL server (which they did at first)
> but I still don't get an image.
> For example, my image is actually at:
> http://sandy.murdocks.on.ca/1/reports/temp/C_79_S
> It is there and it works. Now my report opens in a new window since I do the
> final call to open it like this:
> Response.AddHeader("Content-Disposition", "attachment; filename=" &
> fileName)
> Response.BinaryWrite(data)
> When I right click on the image place holder I get this:
> file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/QPIH2VE9/1/Reports/Temp/C_79_S
> The images don't seem to get from being written on the drive, to being
> picked up for display.
> My code for writing the images looks like this:
> If format = "HTML4.0" Then
> For Each streamid In streamIDs
> image = rs.RenderStream(strpath, "HTML4.0", streamid,
> Nothing, Nothing, parameters, Nothing, Nothing)
> Dim stream As System.IO.FileStream = _
> System.IO.File.OpenWrite(Application("TempReports") &
> streamid)
> stream.Write(image, 0, CInt(image.Length))
> stream.Close()
> Next
> End If
>
> Sandy Murdock MCP
>
>|||Thank you!
I was able to take your solution and from it build one that works for me. I
was stuck.
Thanks.
"Antonio Rome" <AntonioRome@.discussions.microsoft.com> wrote in message
news:61BF34C8-98DB-4388-8E06-F5F8C1F22BBE@.microsoft.com...
> look at my previuos post:
>
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&query=rome&lang=en&cr=US&guid=&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=a830cc14-9b06-496b-b1f4-e55ab3611f0b
> Antonio
>
> "Roger Twomey" wrote:
> > I have created a web app that uses the reporting services Web Service to
> > pull reports from the SQL Server.
> >
> > The web server is on one machine, SQL Server on another and I use the
web
> > service to get the reports. I do not use URLs in any way in order to
keep as
> > much information hidden as possible.
> >
> > I have been able to list all reports, select a report, get back the
> > parameters required, set the parameter values and render reports using
> > ReportingService.Render
> >
> > HOWEVER...
> >
> > The reports that work do not include charts (graphics). When I render a
> > report using my app, if it has no chart I can view it in HTML, PDF, TIF,
> > Excel and MHTML. If it has a chart then for PDF, Excel and TIF all is
fine.
> > If I try to use HTML or MHTML I get a big empty space where my charts
should
> > be.
> >
> > In reading the BOL under ReportingService.Render Method
> > I found this: "StreamIds
> > [out] The stream identifiers. These IDs are passed to the RenderStream
> > method. You can use them to render the external resources (images, etc.)
> > that are associated with a given report. "
> >
> > I have found this topic:
> > ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_ref_soapapi_service_lz_49f6.htm
> > ReportingService.RenderStream Method
> >
> > I read the code, and I have tried to implement it as in the BOL. I am
able
> > to write the images onto the web-server hard-drive, and the image place
> > holder properties no longer point to my SQL server (which they did at
first)
> > but I still don't get an image.
> >
> > For example, my image is actually at:
> > http://sandy.murdocks.on.ca/1/reports/temp/C_79_S
> >
> > It is there and it works. Now my report opens in a new window since I do
the
> > final call to open it like this:
> > Response.AddHeader("Content-Disposition", "attachment; filename=" &
> > fileName)
> > Response.BinaryWrite(data)
> >
> > When I right click on the image place holder I get this:
> >
file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/QPIH2VE9/1/Reports/Temp/C_79_S
> >
> > The images don't seem to get from being written on the drive, to being
> > picked up for display.
> >
> > My code for writing the images looks like this:
> >
> > If format = "HTML4.0" Then
> > For Each streamid In streamIDs
> > image = rs.RenderStream(strpath, "HTML4.0", streamid,
> > Nothing, Nothing, parameters, Nothing, Nothing)
> >
> > Dim stream As System.IO.FileStream = _
> > System.IO.File.OpenWrite(Application("TempReports") &
> > streamid)
> >
> > stream.Write(image, 0, CInt(image.Length))
> > stream.Close()
> > Next
> > End If
> >
> >
> > Sandy Murdock MCP
> >
> >
> >|||I've been rendering chart images successfully for a report using the
ReportingService web services for a few weeks now. Today I had to add a
parameter to the report and now after I call my render method and loop
through the returned streamId's to get the images, I get the exception:
"rsStreamNotFound The stream cannot be found. The stream identifier that is
provided to an operation cannot be located in the report server database."
Why would this be happening?! I'm looping through the very streamId's that
the render method just returned to me!
Thanks in advance, Brian Parker

Getting Field List to display in Reporting Services 2005

In VS2005 Report Designer how do you get the field list to display. In VS2003, The field list for the data sets shows on the left side of the screen under the toolbox without having to do anything. In 2005 I don't know how to make it appear at all. Any help, thanks in advance.

Ctrl-Alt+D or from the last item on the View menu, select Datasets.

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

The last item on my view menu is greyed out "property pages". Is that the item you are referring to? Datasets does not show anyplace.

When I click the Ctrl-Alt+D the system just displays the hourglass and does nothing.

|||Sorry Mary, I was too quick to respond. Your suggestion worked perfectly. I now have my dataset field list. How do I code a function for a report? I need to get info from a dataset and create a concatenated string. I know how to do it but I need to code the function in report designer.

Getting Error while connecting to Reporting Server

Hello,

I am trying to connect to my Reporting server. I get the following error message. Does any one get the same error and work around?

TITLE: Connect to Server

Cannot connect to RAJUVENKAT.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OK

Thanks!
Raju

Can you look in the ReportServer_<timestamp>.log file and see if there is any more information on what the error might be?

Also, have you run the RS configuration tool to see if there are any configuration problems?

-Daniel