Newbie question on Reporting Services

The shop I work in is new to SQL Server and this fall we are installing
Sql Server 2005 with Reporting Services. Apparently the application the
database will support will use Reporting Services. A question is
arising on whether the created report(s) is considered a database
object. That is, if one creates and saves off a report in Test, is this
report migrated to production or is the same object in the same
location simply used by production?
Many thanks in advance.
GerryYou deploy reports to the server. If you have a test server and a
development server, the best is to deploy it to test and then when you are
ready, deploy it to production. Reporting services stores the report
metadata in the database. RS is an asp.net application that heavily uses the
database for its object/metadata storage, scheduling etc.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<datapro01@.yahoo.com> wrote in message
news:1156342425.017659.314250@.74g2000cwt.googlegroups.com...
> The shop I work in is new to SQL Server and this fall we are installing
> Sql Server 2005 with Reporting Services. Apparently the application the
> database will support will use Reporting Services. A question is
> arising on whether the created report(s) is considered a database
> object. That is, if one creates and saves off a report in Test, is this
> report migrated to production or is the same object in the same
> location simply used by production?
>
> Many thanks in advance.
> Gerry
>|||Thanks Bruce
Bruce L-C [MVP] wrote:
> You deploy reports to the server. If you have a test server and a
> development server, the best is to deploy it to test and then when you are
> ready, deploy it to production. Reporting services stores the report
> metadata in the database. RS is an asp.net application that heavily uses the
> database for its object/metadata storage, scheduling etc.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <datapro01@.yahoo.com> wrote in message
> news:1156342425.017659.314250@.74g2000cwt.googlegroups.com...
> > The shop I work in is new to SQL Server and this fall we are installing
> > Sql Server 2005 with Reporting Services. Apparently the application the
> > database will support will use Reporting Services. A question is
> > arising on whether the created report(s) is considered a database
> > object. That is, if one creates and saves off a report in Test, is this
> > report migrated to production or is the same object in the same
> > location simply used by production?
> >
> >
> > Many thanks in advance.
> > Gerry
> >

Newbie question about Office version on client machine

Does it matter what version of Office is installed on the clients
machine for opening reports generated by reporting Services?
The reason I am asking is because our users are getting an office
upgrade from 2000 to XP on their machines.No, it does not matter.
"Amit" <amit.gaind@.gmail.com> wrote in message
news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
> Does it matter what version of Office is installed on the clients
> machine for opening reports generated by reporting Services?
> The reason I am asking is because our users are getting an office
> upgrade from 2000 to XP on their machines.
>|||On Mar 20, 10:42 am, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> No, it does not matter.
> "Amit" <amit.ga...@.gmail.com> wrote in message
> news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
>
> > Does it matter what version of Office is installed on the clients
> > machine for opening reports generated by reporting Services?
> > The reason I am asking is because our users are getting an office
> > upgrade from 2000 to XP on their machines.- Hide quoted text -
> - Show quoted text -
thank you.

Newbie Question about install

Where do I find the install for Reporting Services. Is it a separate program
from the SQL Server install?Hi,
You will find your answer here :
http://www.microsoft.com/sql/reporting/default.asp
Eric
"Cary" wrote:
> Where do I find the install for Reporting Services. Is it a separate program
> from the SQL Server install?

Newbie Question

Hi Guys,

I am new to this Reporting Service world. May be its very simple question.

I have create a report in SQL Server 2005 reporting services and want to link this report with aspx page. How I do this. Just want to link report with default.aspx page so when this page open report also open automatically.

Please let me guide how could I do this.

Regards

I would recommend using the ASP.net ReportViewer control. It will make the web app appear much more polished than just linking to the reportmanager.|||If you don not want anything to change programmtically you can also just display the appropiate report in your frame targeting to the URL of you report on the ReportServer interface. (The one that you see if you navigate through the webservice http://Server/reportserver, e.g. http://server/reportserver?Somefolder/Report&Parameter=SomeValue)

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

Greate!! Thanks for your reply.

I pasted a report control on my aspx page but how I link my report with this page. I used the below code but it giving me error message

ReportViewer1.LocalReport.ReportEmbeddedResource = @.\\Business\Business\RPT825.rdl; (This is my local machine path)

and the Error message is

An error occurred during local report processing.|||

Hi Guys,

Please ignore my previous email. I have fixed the above issue. Now I don't know how to pass a parameter value to a report.

I wrote the below line in my aspx page and when I ran this application it gives me a error message

"The rDate parameter is missing a value"

Below is the code that I wrote in my page_load event

ReportViewer1.LocalReport.ReportPath = @."C:\Business\RPT825.rdl";

Could you please let me know how to pass parameter value to a report.

Regards

|||

ReportViewer1.LocalReport.SetParameters( );

Juran

sql

Newbie Question

I've just started messing around with SQL2K5 and Reporting Service. I loaded SQL Server Reporting Pack for IIS. I can't seam to find any detailed details on the pack. Is there an easy way to repoint the 12 reports from the template db to my live IIS ODBC db? Or is it better to just start from scratch and build the reports?

Thanx

I'm not quite sure what you mean here? Are you saying you have 12 reports pointing to your old DB and now you want to point them to your new db? If so just change the datasource of the reports to your new db.

Make sure however the new db has the same table/column names as the datasets already in the reports otherwise the reports will break.

Newbie question

Hi, I am new to reporting services, and I wonder if I am limited to sql queries or can I program reports? This might sound stupid but I have never had to write reports so I am not sure what to look for.

I've been using RS for about 3 months now. You can use SQL queries to populate your datasets, but you can write code to "dynamically" generate those queries.

I'd suggest picking up one of the few RS books out there, like the "Reporting Services in Action" or "Hitchhikers Guide.." books.

|||but does it let you use dataset created at runtime as a source of report?

Newbie Question

After having problems with my first attempt at installing Reporting Services, I did some reading, found the answers I needed and did a re-install. Everything worked fine, however, I did not delete the original web sites from the first install (called Reports and ReportServer) and when I did the re-install then the new sites created were Reports1 and ReportServer1. Is there anyway to rename those to Reports and ReportServer in IIS and then re-configure RS to point to them? I did see a parm for URLRoot which points to ReportServer1 but did not find anything which points to Reports1. Of course, I suppose I could go through another re-install but I would rather not. Thanks in advance for any help!
DaveYou need to change the URLRoot that you mentioned as well as ReportServerUrl
element in RSWebApplication.config. There are also some registry settings
that need to change. I don't remember them off hand, but search for Report1
and ReportServer1 and you should find them.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BD7C402E-745D-4FF2-9677-B547367A5365@.microsoft.com...
> After having problems with my first attempt at installing Reporting
Services, I did some reading, found the answers I needed and did a
re-install. Everything worked fine, however, I did not delete the original
web sites from the first install (called Reports and ReportServer) and when
I did the re-install then the new sites created were Reports1 and
ReportServer1. Is there anyway to rename those to Reports and ReportServer
in IIS and then re-configure RS to point to them? I did see a parm for
URLRoot which points to ReportServer1 but did not find anything which points
to Reports1. Of course, I suppose I could go through another re-install but
I would rather not. Thanks in advance for any help!
> Davesql

Newbie Question

I'm new to Reporting Services 2005. My question is this. Say I create a
report that retrieves data from database "xyz". Assume also that identical
copies of database "xyz" (identical in schema, not in the data it contains)
might be sitting on many different servers, servicing different clients. Is
it a simple matter to simply change the connection string of the report and
have it retrieve data from a different server the database is sitting on?
I guess what I'm really wondering is what sort of data sits in the
'ReportServer' database and does this data need to get moved to the same
ReportServer database on each server I want to run the report against? If
this is not the case, and I'm hoping it's not, what data actually gets
stored in the 'ReportServer' database.
Thanks.
Amos.The ReportServer database stores the metadata and the catalog.
I does not stores the data used by your reports
I your case, changing the connection string should be enough
Med Bouchenafa
"Amos Soma" <amos_j_soma@.yahoo.com> a écrit dans le message de news:
eehPKcEJGHA.984@.tk2msftngp13.phx.gbl...
> I'm new to Reporting Services 2005. My question is this. Say I create a
> report that retrieves data from database "xyz". Assume also that identical
> copies of database "xyz" (identical in schema, not in the data it
> contains) might be sitting on many different servers, servicing different
> clients. Is it a simple matter to simply change the connection string of
> the report and have it retrieve data from a different server the database
> is sitting on?
> I guess what I'm really wondering is what sort of data sits in the
> 'ReportServer' database and does this data need to get moved to the same
> ReportServer database on each server I want to run the report against? If
> this is not the case, and I'm hoping it's not, what data actually gets
> stored in the 'ReportServer' database.
> Thanks.
> Amos.
>

Newbie Problems Configuring Report Server

I have SQL 2005 with SP 1. I am in the reporting services configuration
manager and I am at the point where the following options have green circles
with checkmarks:
Server Status
Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Web Service Identity
Database Setup
Encryption Keys is a blue circle with an exclamation point with the choices
Backup, Restore, Change and Delete. I choose Backup and gave the key a
password and clicked ok but the applied button at the bottom stayed grayed
out.
Below the Encryption Keys button is Initialization and that is in a gray
circle with a checkmark. Since it is gray I can not select it.
What is it that the configuration manager is waiting for me to do?
I tried going into the SQL Server Management Studio to see if I could
connect to the Report Server from there. I get an error message saying
"Cannot connect to RBDS01. The request failed with HTTP Status 400: Bad
Request. (Microsoft.SqlServer.Management.UI.RSClient)
I would appreciate any ideas as to what I need to do so that I can connect
to the Report Server?
Thanks.
Rick Bellefond
RB Data Services
www.rbdata.comIf the "server status" shows green then it is ok that your server is
connecting. encryption is optional it creates automatically so if you want
to change or take backup this can be done using this option.
otherwise it should work seeing the green check mark on "server status" Hope
you are connecting to the same server you configured. ie (RBDS01)
Go to surface area and check for the network enabled in which you are
accesing ie tcp/ip.
Amarnath
"Rick" wrote:
> I have SQL 2005 with SP 1. I am in the reporting services configuration
> manager and I am at the point where the following options have green circles
> with checkmarks:
> Server Status
> Report Server Virtual Directory
> Report Manager Virtual Directory
> Windows Service Identity
> Web Service Identity
> Database Setup
> Encryption Keys is a blue circle with an exclamation point with the choices
> Backup, Restore, Change and Delete. I choose Backup and gave the key a
> password and clicked ok but the applied button at the bottom stayed grayed
> out.
> Below the Encryption Keys button is Initialization and that is in a gray
> circle with a checkmark. Since it is gray I can not select it.
> What is it that the configuration manager is waiting for me to do?
> I tried going into the SQL Server Management Studio to see if I could
> connect to the Report Server from there. I get an error message saying
> "Cannot connect to RBDS01. The request failed with HTTP Status 400: Bad
> Request. (Microsoft.SqlServer.Management.UI.RSClient)
> I would appreciate any ideas as to what I need to do so that I can connect
> to the Report Server?
> Thanks.
>
> Rick Bellefond
> RB Data Services
> www.rbdata.com
>

Newbie Install question

HI,
I am new to Sql Reporting Service and I have a Newbie question. I have VS.Net installed on one Computer and SQL Server installed on a server. When I install SQL RS, Do I install it on both, my development computer and the SQL Server (windows Server)? And what VER can I put on both computers (if I have to install it on both)? Should I put Enterprise on the Server (Sql server and windows server) and Developer on the VS.Net computer? Or can I put Enterprise on both?
Thank you,
AndreWell, that depends on what you want to do. :) If you want the design app
then you have to install RS on the machine with VS. For the server
components you can install on any machine that has access to a SQL machine.
It is not a requirement that SQL and RS be on the same box.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:7D4A0AF2-17B5-447A-9042-FF56434C6353@.microsoft.com...
> HI,
> I am new to Sql Reporting Service and I have a Newbie question. I have
VS.Net installed on one Computer and SQL Server installed on a server. When
I install SQL RS, Do I install it on both, my development computer and the
SQL Server (windows Server)? And what VER can I put on both computers (if I
have to install it on both)? Should I put Enterprise on the Server (Sql
server and windows server) and Developer on the VS.Net computer? Or can I
put Enterprise on both?
> Thank you,
> Andre
>|||Thanks.
Is there any reason that I would need the Server components on my VS.Net machine? Or installing the Server components on the SQL server will do the trick?
FYI
I have both a Sql server running windows server 2003 and IIS, and a Development machine.|||There is no need to put the server components on the VS.Net machine. Some
companies will not allow IIS and SQL on the same box so they will put RS
server components on another machine.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:EAF2855F-B8D7-4074-999F-BB8EB7BE1E36@.microsoft.com...
> Thanks.
> Is there any reason that I would need the Server components on my VS.Net
machine? Or installing the Server components on the SQL server will do the
trick?
> FYI
> I have both a Sql server running windows server 2003 and IIS, and a
Development machine.
>

Newbie Authentication

Have Server2003, IIS6 with multiple websites, sql2000, and just installed
reporting services. After making my first simple report with graph to see how
this works (XP pro), I published to the server. But, I was the only one able
to see it using the server name. So, I changed the permissions on the
reportServer and reports under IIS Default website to allow IUSR_serverName
to read/execute and enabled anonymous access with IUSR_serverName.
Now, if I want to deploy update to report to web I have to take off the new
IUSR permissions and then put them back. And, only folks within the company
could get to the report - dns is done at the firewall.
So, I made a virtual directory under IIS within the web called Reports, and
made sure the permissions on the virtual directory were set to read/execute.
Now, if I use a dial-up and a url similar to below, I'm told the user
doesn't have permissions to view the page.
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
I've probably done a thousand things wrong - anybody willing to enlighten me?
Thanks so much.Have you found the answer to the issue? I'm interested to hear what
your status is because I'm having the same problem as well.
Thanks
janetb <janetb@.discussions.microsoft.com> wrote in message news:<16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com>...
> Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> reporting services. After making my first simple report with graph to see how
> this works (XP pro), I published to the server. But, I was the only one able
> to see it using the server name. So, I changed the permissions on the
> reportServer and reports under IIS Default website to allow IUSR_serverName
> to read/execute and enabled anonymous access with IUSR_serverName.
> Now, if I want to deploy update to report to web I have to take off the new
> IUSR permissions and then put them back. And, only folks within the company
> could get to the report - dns is done at the firewall.
> So, I made a virtual directory under IIS within the web called Reports, and
> made sure the permissions on the virtual directory were set to read/execute.
> Now, if I use a dial-up and a url similar to below, I'm told the user
> doesn't have permissions to view the page.
> http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> I've probably done a thousand things wrong - anybody willing to enlighten me?
> Thanks so much.|||Angela,
Nope. I've tried a bunch of different settings at this point. Including
the
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExternalURL>
setting, but nothing has worked. I've posted at: aspfree; sqlteam,
sqljunkies, ms, sqlmagazine - nobody is answering. Even watched a few more
ms webcams. Frankly, I probably won't be able to use the product if I can't
find a solution.
I'll do my best to come back and let you know if somebody helps me out.
jb
"Angella" wrote:
> Have you found the answer to the issue? I'm interested to hear what
> your status is because I'm having the same problem as well.
> Thanks
> janetb <janetb@.discussions.microsoft.com> wrote in message news:<16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com>...
> > Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> > reporting services. After making my first simple report with graph to see how
> > this works (XP pro), I published to the server. But, I was the only one able
> > to see it using the server name. So, I changed the permissions on the
> > reportServer and reports under IIS Default website to allow IUSR_serverName
> > to read/execute and enabled anonymous access with IUSR_serverName.
> >
> > Now, if I want to deploy update to report to web I have to take off the new
> > IUSR permissions and then put them back. And, only folks within the company
> > could get to the report - dns is done at the firewall.
> >
> > So, I made a virtual directory under IIS within the web called Reports, and
> > made sure the permissions on the virtual directory were set to read/execute.
> >
> > Now, if I use a dial-up and a url similar to below, I'm told the user
> > doesn't have permissions to view the page.
> >
> > http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> >
> > I've probably done a thousand things wrong - anybody willing to enlighten me?
> >
> > Thanks so much.
>|||"janetb" <janetb@.discussions.microsoft.com> wrote in message
news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> reporting services. After making my first simple report with graph to see
how
> this works (XP pro), I published to the server. But, I was the only one
able
> to see it using the server name. So, I changed the permissions on the
> reportServer and reports under IIS Default website to allow
IUSR_serverName
> to read/execute and enabled anonymous access with IUSR_serverName.
> Now, if I want to deploy update to report to web I have to take off the
new
> IUSR permissions and then put them back. And, only folks within the
company
> could get to the report - dns is done at the firewall.
> So, I made a virtual directory under IIS within the web called Reports,
and
> made sure the permissions on the virtual directory were set to
read/execute.
> Now, if I use a dial-up and a url similar to below, I'm told the user
> doesn't have permissions to view the page.
>
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> I've probably done a thousand things wrong - anybody willing to enlighten
me?
> Thanks so much.
>
Having the same problem, too. Any updates?
Thanks!
Ken|||Ken,
Nothing concrete yet, but I'm at least talking to folks on the Minsasi
website and on SQL magazine. If I get anything concrete, I'll post here for
both you and Angela.
Thanks,
Janet
"Ken" wrote:
> "janetb" <janetb@.discussions.microsoft.com> wrote in message
> news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> > Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> > reporting services. After making my first simple report with graph to see
> how
> > this works (XP pro), I published to the server. But, I was the only one
> able
> > to see it using the server name. So, I changed the permissions on the
> > reportServer and reports under IIS Default website to allow
> IUSR_serverName
> > to read/execute and enabled anonymous access with IUSR_serverName.
> >
> > Now, if I want to deploy update to report to web I have to take off the
> new
> > IUSR permissions and then put them back. And, only folks within the
> company
> > could get to the report - dns is done at the firewall.
> >
> > So, I made a virtual directory under IIS within the web called Reports,
> and
> > made sure the permissions on the virtual directory were set to
> read/execute.
> >
> > Now, if I use a dial-up and a url similar to below, I'm told the user
> > doesn't have permissions to view the page.
> >
> >
> http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> >
> > I've probably done a thousand things wrong - anybody willing to enlighten
> me?
> >
> > Thanks so much.
> >
> Having the same problem, too. Any updates?
> Thanks!
> Ken
>
>|||Great! I'll certainly do the same. Thanks so much, Janet!
Ken
"janetb" <janetb@.discussions.microsoft.com> wrote in message
news:3FAAD6BF-4273-46B9-BF2D-285C92824312@.microsoft.com...
> Ken,
> Nothing concrete yet, but I'm at least talking to folks on the Minsasi
> website and on SQL magazine. If I get anything concrete, I'll post here
for
> both you and Angela.
> Thanks,
> Janet
> "Ken" wrote:
> > "janetb" <janetb@.discussions.microsoft.com> wrote in message
> > news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> > > Have Server2003, IIS6 with multiple websites, sql2000, and just
installed
> > > reporting services. After making my first simple report with graph to
see
> > how
> > > this works (XP pro), I published to the server. But, I was the only
one
> > able
> > > to see it using the server name. So, I changed the permissions on the
> > > reportServer and reports under IIS Default website to allow
> > IUSR_serverName
> > > to read/execute and enabled anonymous access with IUSR_serverName.
> > >
> > > Now, if I want to deploy update to report to web I have to take off
the
> > new
> > > IUSR permissions and then put them back. And, only folks within the
> > company
> > > could get to the report - dns is done at the firewall.
> > >
> > > So, I made a virtual directory under IIS within the web called
Reports,
> > and
> > > made sure the permissions on the virtual directory were set to
> > read/execute.
> > >
> > > Now, if I use a dial-up and a url similar to below, I'm told the user
> > > doesn't have permissions to view the page.
> > >
> > >
> >
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> > >
> > > I've probably done a thousand things wrong - anybody willing to
enlighten
> > me?
> > >
> > > Thanks so much.
> > >
> >
> > Having the same problem, too. Any updates?
> >
> > Thanks!
> > Ken
> >
> >
> >

Newbie - Good Doumentation Needed

Our current environment consists of a SQL 2000 server and report server with reporting services. I hope I didn't screw that up but I guess the important thing is, I'm sure it's SQL 2000. I have Visual Studio 2005. I need to edit existing reports on the report server website and create new reports with what I have. I am familiar with writing reports in a report viewer and I am familiar with SQL queries. I need some good documentation to get me started, and I'm having trouble finding it related to SQL 2000/VS2005. I dont have the foggiest of ideas of how to get VS2005 to see my exisitng reports and to get them to hook up with each other. Any advice to get me out the door would be much appreciated. Thanks!!

you can't creat Bi project in VS2005 as long as you don't install the MS Reporting service 2005 but you can create the BI project in VS2003 and just refere to the deployed reports on the reporting server

http://<machine name>/reportserver and use them in your VS2005 web or windows project by report viewer

|||

Since upgrading SQL and SQL reporting services to 2005 is out of the question at this point, does this mean I either need to get Visual Studio 2003 or I'm dead in the water?

Sounds like I'm stuck with my current setup. Correct?

|||

yes you need Visual studio 2003 and create BI project , develop yoour reports then deploy them on the reporting server so you can easily view them in your web or windows application using report viewer control.

Newbee question on Reporting Service

Hi,
I am new to Reporting Service, I came from Crystal Reports background.
Have 2 questions:
(1) The Reports cretated via report designer are not object oriented? They
are not exposed as classes, my concern is that I can not manipulate the
reports programatically.
(2) The Reports do not exposed events? This might sounds related to question
(1), but even in non OO world, reports expose events too, say MS Access.
TIAHi,
Were you able to find out if the reports expose any events? The 'OnInit'
event is the only one I know of. So are there any events similar to MS Access?
Thanks,
Honesto J Manlig
"Danny Ni" wrote:
> Hi,
> I am new to Reporting Service, I came from Crystal Reports background.
> Have 2 questions:
> (1) The Reports cretated via report designer are not object oriented? They
> are not exposed as classes, my concern is that I can not manipulate the
> reports programatically.
> (2) The Reports do not exposed events? This might sounds related to question
> (1), but even in non OO world, reports expose events too, say MS Access.
>
> TIA
>
>