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 for SQL Server System Integration Services Flat File Import

I am new to SSIS...

I have a very simple package that has a flat file source object and an ole db destination object in the data flow. All works fine.

If I change a row in the flat file to make it fail how do I make the program continue and go to the next row?

The ole db destination does not have a Error Output properties like the flat file source does.

Thanks

Check the Properties of the Data Flow Task (or other task you're using for dealing with the flat file) in the Control Flow tab, there is an attribute MaximumErrorCount, which is default to 1.

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 Object transfer

Hi,

I'm new to Integration Services and I have a problem when I try to make a simple transfer of tables and views between 2 DB.

The idea is to copy tables and views from DB1 to DB2.

If the object exists in the target DB, it must be dropped, then created and the data must be copied.

The problem occurs when a new object is created in the source DB and thus does not exist in the target DB. This throws an error because the system cannot drop an object wich does not exist.

What is the workaround ?

The idea is to execute this package every hour to have a cached DB. In this case, replication is not a solution.

Thanks in advance,

Patrice.

This issue is a bug in SQL Server 2005 RTM. Hopefully it will be fixed in one of the SP releases in the near future.

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

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 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:reporting services gets: Connection could not be made to reportserver

When I try to deploy the sample reports solution to the local IIS on this
win2003 server, the message "A connection could not be made to the report
server http://a1900/Reportserver" appears.
I do this by:
1. Loading the SampleReports.sln into the vb.net IDE.
2. Right-clicking on the SampleReports solution, then selecting Properties,
then setting 'TargetServer URL'=http://a1900/Reportserver (it also fails
when I set it to 'http://localhost/ReportServer'
3. Right-clicking on the SampleReports solution, then selecting 'Deploy'.
4. No errors during the build phase.
The IIS Manager window shows in the left pane:
iis information services
- a1900 (local computer)
-FTP Sites
--...
-Web Sites
-- Default Web Site
--_vti_bin
--reports
-- reportServer
etc.
-Web Service Extensions
...
The IIS is on the same machine that I operate on and has entries of 'Default
Web Site\Reportserver' and 'Default Web Site\Reports'. The 'Default Website'
has 'Permissions' set to 'Full control' for administrators, as which I am
logged in.
I notice that the 'Reports' and 'ReportServer' entries do not have the blue
globe icon (?) that most of the other IIS folder entries have. Perhaps
that's the cause of my problem.
Do I have to add Web service extensions for Reporting Services?
Perhaps the Reporting services installation did not go right?
How do I find the correct url for the target server?
Where do I have to look.
What books to read?
Any help is greatly appreciated.
Thanks.Some questions & answers:
"Do I have to add Web service extensions for Reporting Services? "
No.
"How do I find the correct url for the target server?"
You are using the correct URL. To test it manually, navigate to the
following path:
http://localhost/ReportServer/ReportService.asmx
This is the webservice that the "Deploy" option uses based upon the
"TargetServer" property you set in the Project settings.
You should receive a SOAP response (XML) w-hen you navigate to that
URL. If you do not get this, then you may have an IIS configuration
problem. Because of the security configurations needed, I generally
just reinstall Reporting Services to make sure the Virtual Directory
and permissions are setup properly. In IIS 6, you should see what
looks like a cog/gear as the symbol for the ReportServer virtual
directory. The globes are for websites (DefaultWeb and such) which
isnt required.
One other thing to check is if your DefaultWebsite is using port 80,
and accepts "(All Unassigned)" IP addresses. Anything unusual in
these IIS settings may indicate part of your problem.
I hope this helps a bit...
~Lance Hunt
http://weblogs.asp.net/lhunt/