Is this scenario possible?

Transactional Replication.
Box1: Publisher
Box2: Reporting only Subscriber
Box3: Updateable Subscriber
If Box1 modifies data, it obviously goes to both Subscribers. But if box 3
modifies data, will it show up on Box2? If memory serves correctly, it will
not by design. Is there a way to change this?
SQL2K SP3
TIA, ChrisR
it will. I just tried it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <bla@.noemail.com> wrote in message
news:OlbFqjZKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Transactional Replication.
> Box1: Publisher
> Box2: Reporting only Subscriber
> Box3: Updateable Subscriber
> If Box1 modifies data, it obviously goes to both Subscribers. But if box 3
> modifies data, will it show up on Box2? If memory serves correctly, it
will
> not by design. Is there a way to change this?
> --
> SQL2K SP3
> TIA, ChrisR
>
|||I've tried it with no luck. :-( Box2 will not recieve new rows inserted
from Box3.
Any ideas?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#dSrqZkKFHA.3340@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> it will. I just tried it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <bla@.noemail.com> wrote in message
> news:OlbFqjZKFHA.2812@.TK2MSFTNGP15.phx.gbl...
3
> will
>
|||it does work for me however. I am not sure why it is not working for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <bla@.noemail.com> wrote in message
news:%23wE1dPlKFHA.2852@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> I've tried it with no luck. :-( Box2 will not recieve new rows inserted
> from Box3.
> Any ideas?
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:#dSrqZkKFHA.3340@.TK2MSFTNGP14.phx.gbl...
box
> 3
>
|||Is your Box2 a Subscriber of both Box1 and Box3? I only have it set up as a
Subscriber of Box1.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OjssPelKFHA.508@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> it does work for me however. I am not sure why it is not working for you.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <bla@.noemail.com> wrote in message
> news:%23wE1dPlKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> box
it
>
|||Hillary I just got it. I don't know why, but I set up 2 different
Publications for this. One for the Immediate Updating Subscription, and one
for the Non Immediate Updating Subscription. Still not sure why I went that
route.
Once I used only 1 Publication, and configured Immediate Updating in the
Subscription options only, all went as expected.
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OjssPelKFHA.508@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> it does work for me however. I am not sure why it is not working for you.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <bla@.noemail.com> wrote in message
> news:%23wE1dPlKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> box
it
>

Is this possible:Report Db is on a machine and IIS is on an other machine

Can we have Reporting Services having its database on a server and distribution server (http://IISserver/Reports)

on another server?We dont want our database server to have IIS and dont want SqlServer installed on our IIS server

kind regards

Hi aykut

Yes, we can have Database Server and IIS Server on different machines.

|||

And how can we set this up?

We choose db instance first when we run Reporting Services Configuration.

and after that I can not choose a Report Server Virtual Directory other than on Default WebSite.

Should we assume that Reporting Services should be running on the machine which hosts the reports in IIS?

And db is on another server. Should that be the configuration?

regards.

|||

yes aykut

I forgotten to mention this point

we must have Reporting Services running on the machine which hosts the Reports in IIS

Is this considered scale-out?

I picked back up an effort to get our reporting services DR scenario in place and am having some issues. Our corporate approach for production databases is to back-up the database to the local server disk, copy the back-up files to a remote office and restore the databases on remote DR servers. This process is scripted to run overnight so in the case of failure of the production environment we lose at most one day of work.

Now, I would like to set up a parallel scenario for Reporting Services and started with reading a bit of documentation. I read "Moving a Report Server Database to Another Computer" and "Backing Up and Restoring Encryption Keys" and then set to work.

I have two instances of SQL Server 2005 Standard installed as the default instance on two servers, PROD and DR. I backed up the encryption key on PROD and restored it on DR using the Reporting Services Configuration Manager. Then I backed up the PROD/ReportServer and PROD/ReportServerTempDB databases and restored the databases to the DR instance. Next, I connected the DR Reporting Services instance to the newly restored databases and clicked 'Apply'.

I get this warning:

"Setting Connection Info for Reporting Server

You specified a connection to a report server database that contains encryption keys for another report server. If you are configuring a scale-out deployment, that feature is not supported by this edition of Reporting Services. If you want to use this report server database with the currecnt report server instance, remove the existing encryption keys first."

And as you would expect navigating to the DR web application tells me "The report server installation is not initialized."

So, a couple questions?

1) Would this be considered a scale-out installation?
2) Did I miss some configuration step?
3) If I want to continue down this DR scenario do I have to upgrade to Enterprise edition?
4) Are there any suggested DR approaches for Reporting Services 2005?

Thanks in advance for you help.

Calvin

It seems you do not need a scale-out installation. The problem is after you set db connection from PROD to DR, their is an extra key in the RS database that makes RS think you are doing scale-out. Check the Keys table in your ReportServer database on DR. There could be two reasons for this to happen:

1) You configured report server on DR to use RS databases , so that the Keys table contains an entry for DR. Basically you need to decide if you want to access the backup RS db from PROD or DR. You can't access RS from both, for it is a scale-out scenario. Remove the entry you don't need.

2) For some reason there was an entry for PROD that is left over in Keys table, and you get 2 PROD entries. This makes the RS thinks you are doing scale-out. Simply remove the one that is invalid.

|||

Thanks for your response.

1) When I click the "Change" button on the Encryption Key tab, I see there are two servers listed. So, I believe there are two keys in the database but I don't believe it is as simple as just removing the key I don't need. I want to access the backup RS database from DR but the DataSource connection strings and such are encrypted using the key from PROD. If not by restoring the key using the Configuration Manager, how can I make this happen? Will Reporting Services throw a fit if I manually update the Keys table in the restored RS database in DR to make it use the encryption key from PROD but the instance information from DR? Is this even possible?

2) I believe the two keys are present because I told DR reporting services to "Connect" to the RS database which contained a key from PROD.

Thanks again,

Calvin

|||

I tried it again this morning and got it working. I believe the sequencing is where I went wrong. I'll have to do some testing to figure out what the correct sequence is but at least now I know it does work.

Thanks again,

Calvin

|||When you backup the key on PROD, the key is decrypted using the machine key of PROD and then encrypted using the password you specify. When you restore the key DR, the key is decyrpted using the password and reencyrpted using the machine key of DR. You see the key is always in encrypted form, and is preserved when you move servers.

Is this a sound design for Reporting Services

Hi,
We are looking at deploying Report Services within our organisation
however, we have to support multiple clients, operating systems and
authentication methods, so we are unable to use the in-built Windows
Security or Reporting Services Portal.
To resolve this issue I have designed a WebService that acts as a
facade / proxy to the Reporting Services Web Service and uses a
specifically created Windows Account to authenticate against the Report
Server.
Then the various consumers of our reports (home grown sites plus third
party portals) request the reports from our Web Service which supports
the various authentication methods required (LDAP / Single Sign-on etc)
and manages the various Roles / Permissions for the reports.
The Report Server is then securely tied down to the single Windows
Account that is used by our web service.
Does the above sound like a good solution or has anyone else used a
similar approach?
Thanks
RussPersonally, I am an advocate against building any additional facades on top
of RS. The moment you introduce another "wrapper", you are pretty much
kissing good-bye perhaps 30% of the RS feature set. For example, you can't
use the RS 2005 report viewers, interactive features, etc., plus in many
cases you will find yourself just reinventing the wheel (e.g. to handle
parameters, printing, etc.) Instead, in your case, I would gravitate toward
replacing the default Windows-based authentication with custom
authentication. If your reporting clients can invoke programatically your
web service, they should be able to capture the authentication cookie and
pass it back.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"russ" <russ.1@.excite.com> wrote in message
news:1132222181.477746.69640@.g44g2000cwa.googlegroups.com...
> Hi,
> We are looking at deploying Report Services within our organisation
> however, we have to support multiple clients, operating systems and
> authentication methods, so we are unable to use the in-built Windows
> Security or Reporting Services Portal.
> To resolve this issue I have designed a WebService that acts as a
> facade / proxy to the Reporting Services Web Service and uses a
> specifically created Windows Account to authenticate against the Report
> Server.
> Then the various consumers of our reports (home grown sites plus third
> party portals) request the reports from our Web Service which supports
> the various authentication methods required (LDAP / Single Sign-on etc)
> and manages the various Roles / Permissions for the reports.
> The Report Server is then securely tied down to the single Windows
> Account that is used by our web service.
> Does the above sound like a good solution or has anyone else used a
> similar approach?
> Thanks
> Russ
>|||Hi Teo,
Thanks for the reply. I should have mentioned that we are using 2000
and not 2005 and therefore are unable to use the RS feature set due to
the poor non-IE support.
Cheers
Russ|||Nonetheless, IMO, one should view the RS web service as the ultimate facade
and avoid building additional facades on top of it unless it is absolutely
necessary. There are functionality, security, deployment, and maintenance
tradeoffs once you go for the "facade-on-top-of-facade" approach.
BTW, you can still use URL addressability with non-web clients to get the
full RS 2000 feature set. For example, a COM or .NET application can use the
Web Browser control. That said, given the fact that URL addressability is
deprecated in RS 2005 in favor of SOAP, I would strongly consider moving
forward with RS 2005 and the Report Viewer control if possible.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"russ" <russ.1@.excite.com> wrote in message
news:1132238241.374215.84200@.g14g2000cwa.googlegroups.com...
> Hi Teo,
> Thanks for the reply. I should have mentioned that we are using 2000
> and not 2005 and therefore are unable to use the RS feature set due to
> the poor non-IE support.
> Cheers
> Russ
>|||many thanks for the advice :)
I think a push for 2005 is in ordersql

Is this a permissions issue?

Hi All I have created a Stored proc to get the all user rights on a server b
y
database. I am going to use this SP in my reporting services 2005. I
created a user with public rights in all Databases on my server. For some
reason unless I grant this user SA rights, it will not return any rows. whe
n
I give him SA rights all rows return correctly. I am attaching my code can
someone see why SA rights are the only rights that seem to work?
TIA,
Joe
Here is the code!
/*
if exists (select * from sysobjects where id =
object_id('SOX_Audit..Temp_DBO_Audit') )
DROP table SOX_Audit..Temp_DBO_Audit
create table SOX_Audit..Temp_DBO_Audit (DBNAme varchar(50),DbFixedRole
varchar(25),MemberName varchar(50),MembersIS Varbinary(85))
if exists (select * from sysobjects where id =
object_id('SOX_Audit..Temp_Users_Audit') )
DROP table SOX_Audit..Temp_Users_Audit
create table SOX_Audit..Temp_Users_Audit (DbFixedRole varchar(25),MemberName
varchar(50),MembersIS Varbinary(85))
*/
delete Temp_DBO_Audit
delete Temp_Users_Audit
declare @.DBName varchar(50), @.str varchar(100)
Declare crsCall cursor for
select name from master..sysdatabases
open crsCall
fetch Next from CrsCall
into @.DBName
while @.@.fetch_status=0
begin
select @.str = 'use ['+@.DBNAMe+']'+ Char(13) +
'insert into SOX_Audit..Temp_Users_Audit exec sp_helprolemember '
--select @.str
exec (@.str)
insert into SOX_Audit..Temp_DBO_Audit
select @.DBNAme, DbFixedRole, MemberName, MembersIS
from SOX_Audit..Temp_Users_Audit
delete SOX_Audit..Temp_Users_Audit
fetch Next from CrsCall
into @.DBName
end
close crsCAll
deallocate crsCAll
select DBName, dbFixedRole, MemberName from SOX_Audit..Temp_DBO_Auditjaylou (jaylou@.discussions.microsoft.com) writes:
> Hi All I have created a Stored proc to get the all user rights on a
> server by database. I am going to use this SP in my reporting services
> 2005. I created a user with public rights in all Databases on my
> server. For some reason unless I grant this user SA rights, it will not
> return any rows. when I give him SA rights all rows return correctly.
> I am attaching my code can someone see why SA rights are the only rights
> that seem to work?
That is indeed a permissions issue. In SQL 2005, you are not permitted
to see metadata in the same way as you were in previous versions of SQL
Server. Essentially, you need permissions to view metadata. Sometimes
that is implicit. If you have SELECT permissions on a table, you also
have VIEW DEFINITION on the table.
The hour is late, and I don't know on the top of my head which exact
privileges that are needed to view this kind of information. Then
again, to be permitted to the information your procedure retrieves,
you should have fairly hefty privileges.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Is this a limitation of Reporting Services...?

I am beginning to wonder if the behavior I am running into is a possible
limitation of Reporting Services. This is related to exporting a report to
.pdf that contains an embedded image. I have seen some discussion on this,
but have been unable to glean a solution from the existing threads.
My problem is that when I embed an image into my reports, it looks ok
in Visual Studio, but when I export to .pdf, it is blocky and distorted. My
graphics guy has put the image into ten different formats with different
resolutions, but they all render the same way.
What is the Microsoft recommeded format and resolution for image rendering
to .pdf? He designed the logo and can put it in whatever format I need, I
just don't know what to tell him. I found something on Image Device
Information Settings,
that lists 96 dpi as the best, but we tried that with the same results. It
also said something about the tif format, but when I tried to import the .tif
file, .tif was not listed as an image format in the wizard.
And yes, I have upgraded to SP1.I have posted this same message 7 times and still have not received an
answer. I am beginning to think that I am either invisible, or I have found
a limitation of Reporting Services. If that is the case, I would love for
someone to tell me so. I have spent more hours than I can count trying to
resolve this...
PLEASE HELP ME!!!!!!!!!!!!!!!!!|||OK, so I read this to see if I can help. I don't have a clue what your
problem is. Either repost with the problem to this thread or better yet,
repost with a good description in the subject. Depending on the subject
people with different expertise will jump in.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lisa" <Lisa@.discussions.microsoft.com> wrote in message
news:9FB5F4A6-75FD-4DAD-9B73-B7F63CCE92F1@.microsoft.com...
> I have posted this same message 7 times and still have not received an
> answer. I am beginning to think that I am either invisible, or I have
found
> a limitation of Reporting Services. If that is the case, I would love for
> someone to tell me so. I have spent more hours than I can count trying to
> resolve this...
> PLEASE HELP ME!!!!!!!!!!!!!!!!!|||Here is my original post, which I was replying to in the one you saw...but
maybe you couldn't see the original...
My problem is that when I embed an image into my reports, it looks ok
in Visual Studio, but when I export to .pdf, it is blocky and distorted. My
graphics guy has put the image into ten different formats with different
resolutions, but they all render the same way.
What is the Microsoft recommeded format and resolution for image rendering
to .pdf? He designed the image and can put it in whatever format I need, I
just don't know what to tell him. I found something on Image Device
Information Settings, that lists 96 dpi as the best, but we tried that with
the same results. It also said something about the tif format, but when I
tried to import the .tif file, .tif was not listed as an image format in the
wizard.
And yes, I have upgraded to SP1.
Thanks so much for your help!
Lisa
"Bruce L-C [MVP]" wrote:
> OK, so I read this to see if I can help. I don't have a clue what your
> problem is. Either repost with the problem to this thread or better yet,
> repost with a good description in the subject. Depending on the subject
> people with different expertise will jump in.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lisa" <Lisa@.discussions.microsoft.com> wrote in message
> news:9FB5F4A6-75FD-4DAD-9B73-B7F63CCE92F1@.microsoft.com...
> > I have posted this same message 7 times and still have not received an
> > answer. I am beginning to think that I am either invisible, or I have
> found
> > a limitation of Reporting Services. If that is the case, I would love for
> > someone to tell me so. I have spent more hours than I can count trying to
> > resolve this...
> >
> > PLEASE HELP ME!!!!!!!!!!!!!!!!!
>
>

IS this a Bug?

before reporting to MS -Connect , i just want clarify

I have a table

Create table Permssions(

GroupPermissionID int ,

List smallint,

[View] smallint,

Manage smallint)

i opened this table in Management studio and entered 1 in all columns when i try to do save and exit

"No row was updated

the data in row 1 was not committed.

Error Source : .Net SqlClient Dataprovider

Error Message : Conversion failed when converting the varchar value 'List' to datatype int

Correct the error and retry or press escape to cancel the changes "

basically the problem was with the List Column name.

Madhu

Hi Madhu,

yes I think so - it is problem with the column name 'List'; but if you run sql the data will be inserte.

CU

tosc

|||

yes i did try that... but Management studio has problem with it

Madhu

|||

yes, the management studio has a problem -> .Net SqlClient Dataprovider

tosc

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?
No. Standard Edition and up.
Regards
Mike
"ad" wrote:

> Hi,
> Is there reporting service in Sql2005 express?
>
>
|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...[vbcol=seagreen]
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>
|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to[vbcol=seagreen]
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
used
>
|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> license
> to
> used
>
|||In the article http://www.microsoft.com/sql/spotlig...dsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
need
>
|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:

>In the article http://www.microsoft.com/sql/spotlig...dsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>need
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?No. Standard Edition and up.
Regards
Mike
"ad" wrote:

> Hi,
> Is there reporting service in Sql2005 express?
>
>|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...[vbcol=seagreen]
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
>|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
used[vbcol=seagreen]
>|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> license
> to
> used
>|||In the article http://www.microsoft.com/sql/spotli...ndsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
need[vbcol=seagreen]
>|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:

>In the article http://www.microsoft.com/sql/spotli...ndsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>need
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?No. Standard Edition and up.
Regards
Mike
"ad" wrote:
> Hi,
> Is there reporting service in Sql2005 express?
>
>|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
> > Hi,
> > Is there reporting service in Sql2005 express?
> >
> >
> >|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> > No. Standard Edition and up.
> >
> > Regards
> > Mike
> >
> > "ad" wrote:
> >
> > > Hi,
> > > Is there reporting service in Sql2005 express?
> > >
> > >
> > >
>|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> > If I develop my web application with VS2005, and my Web Application
used
> > Reporting Service.
> >
> > Can I bundle reporting service in the install package to my customer?
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> > > No. Standard Edition and up.
> > >
> > > Regards
> > > Mike
> > >
> > > "ad" wrote:
> > >
> > > > Hi,
> > > > Is there reporting service in Sql2005 express?
> > > >
> > > >
> > > >
> >
> >
>|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> reporting services is an add-on and anyone having a valid SQL Server
> license
>> can use it without ptoblems. And for the case of bundling, you might need
> to
>> bundle the reports alone. If the customer has a valid SQL Server then
>> they
>> can install RS and deploy your solution.
>> --
>> HTH,
>> Vinod Kumar
>> MCSE, DBA, MCAD, MCSD
>> http://www.extremeexperts.com
>> Books Online for SQL Server SP3 at
>> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
>> > If I develop my web application with VS2005, and my Web Application
> used
>> > Reporting Service.
>> >
>> > Can I bundle reporting service in the install package to my customer?
>> >
>> >
>> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>> > > No. Standard Edition and up.
>> > >
>> > > Regards
>> > > Mike
>> > >
>> > > "ad" wrote:
>> > >
>> > > > Hi,
>> > > > Is there reporting service in Sql2005 express?
>> > > >
>> > > >
>> > > >
>> >
>> >
>>
>|||In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> > But if my customer have only the express version my Sql 2005,
> > Can they install RS in they web site?
> > "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
> > :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> >> reporting services is an add-on and anyone having a valid SQL Server
> > license
> >> can use it without ptoblems. And for the case of bundling, you might
need
> > to
> >> bundle the reports alone. If the customer has a valid SQL Server then
> >> they
> >> can install RS and deploy your solution.
> >>
> >> --
> >> HTH,
> >> Vinod Kumar
> >> MCSE, DBA, MCAD, MCSD
> >> http://www.extremeexperts.com
> >>
> >> Books Online for SQL Server SP3 at
> >> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> >>
> >> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> >> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> >> > If I develop my web application with VS2005, and my Web Application
> > used
> >> > Reporting Service.
> >> >
> >> > Can I bundle reporting service in the install package to my customer?
> >> >
> >> >
> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> >> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> >> > > No. Standard Edition and up.
> >> > >
> >> > > Regards
> >> > > Mike
> >> > >
> >> > > "ad" wrote:
> >> > >
> >> > > > Hi,
> >> > > > Is there reporting service in Sql2005 express?
> >> > > >
> >> > > >
> >> > > >
> >> >
> >> >
> >>
> >>
> >
> >
>|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> No, Express is not enough to have a valid RS license. If you are using RS,
>> you have to use Standard Edition or better.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
>> > But if my customer have only the express version my Sql 2005,
>> > Can they install RS in they web site?
>> > "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
>> > :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> >> reporting services is an add-on and anyone having a valid SQL Server
>> > license
>> >> can use it without ptoblems. And for the case of bundling, you might
>need
>> > to
>> >> bundle the reports alone. If the customer has a valid SQL Server then
>> >> they
>> >> can install RS and deploy your solution.
>> >>
>> >> --
>> >> HTH,
>> >> Vinod Kumar
>> >> MCSE, DBA, MCAD, MCSD
>> >> http://www.extremeexperts.com
>> >>
>> >> Books Online for SQL Server SP3 at
>> >> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>> >>
>> >> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> >> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
>> >> > If I develop my web application with VS2005, and my Web Application
>> > used
>> >> > Reporting Service.
>> >> >
>> >> > Can I bundle reporting service in the install package to my customer?
>> >> >
>> >> >
>> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>> >> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>> >> > > No. Standard Edition and up.
>> >> > >
>> >> > > Regards
>> >> > > Mike
>> >> > >
>> >> > > "ad" wrote:
>> >> > >
>> >> > > > Hi,
>> >> > > > Is there reporting service in Sql2005 express?
>> >> > > >
>> >> > > >
>> >> > > >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

Is there reporting service in Sql2005 express?

Dear Sir,
Is there reporting service in Sql2005 express?On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>Dear Sir,
>Is there reporting service in Sql2005 express?
>
Hi,
I answered your question on
microsoft.private.sqlserver2005.reportingsvcs.
The answer is "No".
Andrew Watt
MVP - InfoPath|||But
In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
It say that there is SQL Server Reporting Services controls in Express
Edition.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >Dear Sir,
> >Is there reporting service in Sql2005 express?
> >
> Hi,
> I answered your question on
> microsoft.private.sqlserver2005.reportingsvcs.
> The answer is "No".
> Andrew Watt
> MVP - InfoPath|||Hi,
Your question was whether there was a reporting service in SQL Server
2005 Express. The answer I gave you is correct.
I can see the graphic you are referring to and it does mention
reporting services controls. The controls referred to are found in
Visual Studio (see, for example, "Create Reports Faster" on
http://www.microsoft.com/sql/express/).
The wizard and controls coming from Visual Studio is also made clear
in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
I hope that helps.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>But
>In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>It say that there is SQL Server Reporting Services controls in Express
>Edition.
>
>
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
>'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
>> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >Dear Sir,
>> >Is there reporting service in Sql2005 express?
>> >
>> Hi,
>> I answered your question on
>> microsoft.private.sqlserver2005.reportingsvcs.
>> The answer is "No".
>> Andrew Watt
>> MVP - InfoPath
>|||Thank,
But I still a little confuse.
Dose it mean that if I use VS 2005, I can use report controls with Sql 2005
express?
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
'?:tfkh515gh1lujll3ovacs7b1blhnp0egs5@.4ax.com...
> Hi,
> Your question was whether there was a reporting service in SQL Server
> 2005 Express. The answer I gave you is correct.
> I can see the graphic you are referring to and it does mention
> reporting services controls. The controls referred to are found in
> Visual Studio (see, for example, "Create Reports Faster" on
> http://www.microsoft.com/sql/express/).
> The wizard and controls coming from Visual Studio is also made clear
> in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
> I hope that helps.
> Andrew Watt
> MVP - InfoPath
> On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >But
> >
> >In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
> >
> >It say that there is SQL Server Reporting Services controls in Express
> >Edition.
> >
> >
> >
> >
> >
> >"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
> >'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
> >> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >>
> >> >Dear Sir,
> >> >Is there reporting service in Sql2005 express?
> >> >
> >> Hi,
> >>
> >> I answered your question on
> >> microsoft.private.sqlserver2005.reportingsvcs.
> >>
> >> The answer is "No".
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >
>|||The new report controls (should be available with Beta 2 of Widbey (VS
2005)) can work both with and without Reporting Services Server. What this
means is that you can create a report and show it in your asp.net web page
or with a winform control without any server piece. If Reporting Services
Server is there it will use it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23tTcTNbPFHA.1392@.TK2MSFTNGP10.phx.gbl...
> Thank,
> But I still a little confuse.
> Dose it mean that if I use VS 2005, I can use report controls with Sql
> 2005
> express?
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
> '?:tfkh515gh1lujll3ovacs7b1blhnp0egs5@.4ax.com...
>> Hi,
>> Your question was whether there was a reporting service in SQL Server
>> 2005 Express. The answer I gave you is correct.
>> I can see the graphic you are referring to and it does mention
>> reporting services controls. The controls referred to are found in
>> Visual Studio (see, for example, "Create Reports Faster" on
>> http://www.microsoft.com/sql/express/).
>> The wizard and controls coming from Visual Studio is also made clear
>> in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
>> I hope that helps.
>> Andrew Watt
>> MVP - InfoPath
>> On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >But
>> >
>> >In the article
>> >http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>> >
>> >It say that there is SQL Server Reporting Services controls in Express
>> >Edition.
>> >
>> >
>> >
>> >
>> >
>> >"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
>> >'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
>> >> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >>
>> >> >Dear Sir,
>> >> >Is there reporting service in Sql2005 express?
>> >> >
>> >> Hi,
>> >>
>> >> I answered your question on
>> >> microsoft.private.sqlserver2005.reportingsvcs.
>> >>
>> >> The answer is "No".
>> >>
>> >> Andrew Watt
>> >> MVP - InfoPath
>> >
>

Is there any way to use fields in a Header and/or Footer sections

I am New to reporting services and do not know most of it but the first
hurdle that i have encountered is of how to use a fields in a header/footer
section. the requirement that i have reports forces me to use fields but RS
does not allow it.
I was wondering if there is any workaround for this limitationYou can do this but you have to use either an aggrate (sum, count) or first.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sirish Saxena" <SirishSaxena@.discussions.microsoft.com> wrote in message
news:6A79C35A-BD05-4E15-B491-938D6BDCD0B0@.microsoft.com...
>I am New to reporting services and do not know most of it but the first
> hurdle that i have encountered is of how to use a fields in a
> header/footer
> section. the requirement that i have reports forces me to use fields but
> RS
> does not allow it.
> I was wondering if there is any workaround for this limitation|||thanks i am trying to print a company logo as this is not a numeric datatype
how would i use a aggregate function....if you can give me an example that
will be a great help.
Also I was thinking more in lines of declaring a vriable and storing a field
value in it and then assigning it to an Image item......the only problem
hereis i do not know how to do declare a variable
"Bruce L-C [MVP]" wrote:
> You can do this but you have to use either an aggrate (sum, count) or first.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sirish Saxena" <SirishSaxena@.discussions.microsoft.com> wrote in message
> news:6A79C35A-BD05-4E15-B491-938D6BDCD0B0@.microsoft.com...
> >I am New to reporting services and do not know most of it but the first
> > hurdle that i have encountered is of how to use a fields in a
> > header/footer
> > section. the requirement that i have reports forces me to use fields but
> > RS
> > does not allow it.
> > I was wondering if there is any workaround for this limitation
>
>|||Is the data you want in a field in the dataset? That is what I thought you
were looking for. Note I said aggragate OR use first. Use the expression
builder and it should suggest using first.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sirish Saxena" <SirishSaxena@.discussions.microsoft.com> wrote in message
news:36C6B519-412D-4F4E-93F1-8AD781BA36AD@.microsoft.com...
> thanks i am trying to print a company logo as this is not a numeric
> datatype
> how would i use a aggregate function....if you can give me an example
> that
> will be a great help.
> Also I was thinking more in lines of declaring a vriable and storing a
> field
> value in it and then assigning it to an Image item......the only problem
> hereis i do not know how to do declare a variable
>
> "Bruce L-C [MVP]" wrote:
>> You can do this but you have to use either an aggrate (sum, count) or
>> first.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Sirish Saxena" <SirishSaxena@.discussions.microsoft.com> wrote in message
>> news:6A79C35A-BD05-4E15-B491-938D6BDCD0B0@.microsoft.com...
>> >I am New to reporting services and do not know most of it but the first
>> > hurdle that i have encountered is of how to use a fields in a
>> > header/footer
>> > section. the requirement that i have reports forces me to use fields
>> > but
>> > RS
>> > does not allow it.
>> > I was wondering if there is any workaround for this limitation
>>|||Ok, i will expllain the whole situation. I i am storing Logos of different
companies in a MS SQL DB, now i want to assign this filed to an Image. The
Image item is in a Header section. Header Section does not allow to refer to
any fields, which is where my problem starts. I do not want to move header to
body as that will print logo at all pages. I have tried First but it errors
out. So again my question is is there any way i can work around this? I was
also thinking if there is any way that i can defined a variable (much like in
VB or C#) ans assign the logo field to this variable and then assign the
variable to the image field, but i do not know how to declare a variable in
Reporting Services and then use it in header section.
ANY HELP WILL BE REALLY APPRECIATED!!!|||What is the error message?
What is the expression you are using that doesn't work?
=First(Fields!fieldname.Value) should work, or you may need
=First(Fields!fieldname.Value, "datasetname") when working with
multiple datasets.|||I know the use of a FIRST and multiple datasets ...my Question is: How to
use a field in Page Header? Reporting Service does not allow to use Fields in
Page Header so, i was wondering if there is any workaround?
"timseal" wrote:
> What is the error message?
> What is the expression you are using that doesn't work?
> =First(Fields!fieldname.Value) should work, or you may need
> =First(Fields!fieldname.Value, "datasetname") when working with
> multiple datasets.
>|||In Bruce's first post, he said you can do this.
If you are having trouble, please be specific. 'Errors out' is not
helpful.|||I had the same problem. Please confirm that the only way to use Fields in the
Page Header is to use an aggregate function. So what you are telling us is
that Reporting Services cannot display a field from a dataset on every page
of the report. Read below.
I am trying to display a calculated field in the Page Header for every page.
I have tried the suggestions written, but the textbox only appears on the
Page Header on the last page of the report.
For example, textbox29 in the body of my report is:
=First(Fields!Next_2_Years.Value, "AnalysisCngEECSalary")
In the Page Header, I just display the textbox:
=ReportItems!textbox29.value
The result only appears on the last page of the report. How can this result
appear on every page of the report? I tried using RepeatWith, but that did
nothing. Please help. Thanks.
--
-RB
:)
"Bruce L-C [MVP]" wrote:
> You can do this but you have to use either an aggrate (sum, count) or first.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sirish Saxena" <SirishSaxena@.discussions.microsoft.com> wrote in message
> news:6A79C35A-BD05-4E15-B491-938D6BDCD0B0@.microsoft.com...
> >I am New to reporting services and do not know most of it but the first
> > hurdle that i have encountered is of how to use a fields in a
> > header/footer
> > section. the requirement that i have reports forces me to use fields but
> > RS
> > does not allow it.
> > I was wondering if there is any workaround for this limitation
>
>

Is there any way to Embed Word object using Reporting Services

Dear all,
We have requirement like we need to embed lots of Word Object in the Report.
I would like to know whether it is possible using Reporting Services.
Thanks & Regards,
AnilOn Feb 28, 8:40 am, Anil <A...@.discussions.microsoft.com> wrote:
> Dear all,
> We have requirement like we need to embed lots of Word Object in the Report.
> I would like to know whether it is possible using Reporting Services.
> Thanks & Regards,
> Anil
Could you give some examples of the word objects?
Enrique Martinez
Sr. SQL Server Developer|||Users are going to Attach MS-Word Document from their machine and those
MS-Word documents needs to be included in the Final Report generated by the
Reporting Services.
"EMartinez" wrote:
> On Feb 28, 8:40 am, Anil <A...@.discussions.microsoft.com> wrote:
> > Dear all,
> >
> > We have requirement like we need to embed lots of Word Object in the Report.
> > I would like to know whether it is possible using Reporting Services.
> >
> > Thanks & Regards,
> > Anil
> Could you give some examples of the word objects?
> Enrique Martinez
> Sr. SQL Server Developer
>

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, ShyamThere are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any videos for reporting servers

Please provide some reference that where i can find videos to learn about Reporting Services.

yes.

Go to Susan site at:

http://blogs.msdn.com/swisowaty/default.aspx

Search there for her great webcast about reporting services.

Good Luck.

Is there any requirement to install the client component of RS?

Hi all,
I only install the client component of reporting service,
at the beginning, when it is install the support file, it
always failed with only an 'error' message. No other
messages.
I check the log file. There is
Internet Information Services 5.0 (IIS) or later is either
not installed, or it is configured in a way that is
incompatible with a Reporting Services installation.
ASP.NET version 1.1 is not installed or is not registered
with your Web server. ASP.Net is required for the Report
Server and the Report Manager components.
and in the stlog file, I notice
<Prerequisite Name="IsIISInstalled" Checked="Metabase"
Item="/" Found="Can not open metabase" Expected="No error"
Result="Fail" />
To only install the client component, should I install IIS
and ASP1.1 and how do I check that every thing is OK to
install it.
Thanks.
Lindayou need Visual studio.Net 2003 and .Net framework 1.1
IIS is not required
"YUKON2005" <anonymous@.discussions.microsoft.com> a écrit dans le message de
news:38d201c471e9$c199d760$a501280a@.phx.gbl...
> Hi all,
> I only install the client component of reporting service,
> at the beginning, when it is install the support file, it
> always failed with only an 'error' message. No other
> messages.
> I check the log file. There is
> Internet Information Services 5.0 (IIS) or later is either
> not installed, or it is configured in a way that is
> incompatible with a Reporting Services installation.
> ASP.NET version 1.1 is not installed or is not registered
> with your Web server. ASP.Net is required for the Report
> Server and the Report Manager components.
> and in the stlog file, I notice
> <Prerequisite Name="IsIISInstalled" Checked="Metabase"
> Item="/" Found="Can not open metabase" Expected="No error"
> Result="Fail" />
> To only install the client component, should I install IIS
> and ASP1.1 and how do I check that every thing is OK to
> install it.
> Thanks.
> Linda
>|||Thank you!
I will check it.
:)

Is there any place I can find the listing of SQL Reporting fuction

Is there any place I can find the listing of SQL Reporting pre-defined fuction?
ThanksUse this as a starting point - it will lead to built-in RS aggregate
functions, various object collections in the ReportObjectModel, etc.:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_6fhv.asp
Besides that, you can use anything available in the VB.NET run-time library:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp
And by default, everything that is contained within the following
namespaces:
* System
* System.Math
* System.Convert
* Microsoft.VisualBasic
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Laipond" <Laipond@.discussions.microsoft.com> wrote in message
news:7B1CB9BF-9902-48B2-BC77-6DFCA3DEAD5A@.microsoft.com...
> Is there any place I can find the listing of SQL Reporting pre-defined
> fuction?
> Thanks|||Thank you Robert
"Robert Bruckner [MSFT]" wrote:
> Use this as a starting point - it will lead to built-in RS aggregate
> functions, various object collections in the ReportObjectModel, etc.:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_6fhv.asp
> Besides that, you can use anything available in the VB.NET run-time library:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp
> And by default, everything that is contained within the following
> namespaces:
> * System
> * System.Math
> * System.Convert
> * Microsoft.VisualBasic
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Laipond" <Laipond@.discussions.microsoft.com> wrote in message
> news:7B1CB9BF-9902-48B2-BC77-6DFCA3DEAD5A@.microsoft.com...
> > Is there any place I can find the listing of SQL Reporting pre-defined
> > fuction?
> >
> > Thanks
>
>

Is there another way to obtain '-all-' the fields?

Hi all,
I'm using a Reporting Services webpart for Sharepoint. I made the reports
using Parameters with the SELECT UNION statement to bring 'ALL' the rows,
something like this:
SELECT priority AS prior, prioridad AS value
FROM dbo.priority
WHERE (priority <> ' ')
UNION
SELECT '-ALL-' AS prior, NULL AS value
ORDER BY priority
This worked excelent..!!, But know that i'm integrating it to the webpart it
doesn´t shows the parameters.
My question is, if there is another way to bring ALL the rows without using
the UNION statement? cause i proved that without it, the parameter appears in
my Reporting Services WebPart in Sharepoint.
Please help me, Masters of the Reporting Services and SQL..!!
--
Greetings from Mexico..!!Currently, this is the way to do this. We will support multi-select
parameters in the SQL 2005 version.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gerardo" <Gerardo@.discussions.microsoft.com> wrote in message
news:954039F6-A83D-478C-B915-F862EF8FB032@.microsoft.com...
> Hi all,
> I'm using a Reporting Services webpart for Sharepoint. I made the reports
> using Parameters with the SELECT UNION statement to bring 'ALL' the rows,
> something like this:
> SELECT priority AS prior, prioridad AS value
> FROM dbo.priority
> WHERE (priority <> ' ')
> UNION
> SELECT '-ALL-' AS prior, NULL AS value
> ORDER BY priority
> This worked excelent..!!, But know that i'm integrating it to the webpart
> it
> doesn´t shows the parameters.
> My question is, if there is another way to bring ALL the rows without
> using
> the UNION statement? cause i proved that without it, the parameter appears
> in
> my Reporting Services WebPart in Sharepoint.
> Please help me, Masters of the Reporting Services and SQL..!!
> --
> Greetings from Mexico..!!|||Thanks a lot, Brian, now i know what to say to my clients.
Cheers.
"Brian Welcker [MSFT]" wrote:
> Currently, this is the way to do this. We will support multi-select
> parameters in the SQL 2005 version.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Gerardo" <Gerardo@.discussions.microsoft.com> wrote in message
> news:954039F6-A83D-478C-B915-F862EF8FB032@.microsoft.com...
> > Hi all,
> >
> > I'm using a Reporting Services webpart for Sharepoint. I made the reports
> > using Parameters with the SELECT UNION statement to bring 'ALL' the rows,
> > something like this:
> >
> > SELECT priority AS prior, prioridad AS value
> > FROM dbo.priority
> > WHERE (priority <> ' ')
> > UNION
> > SELECT '-ALL-' AS prior, NULL AS value
> > ORDER BY priority
> >
> > This worked excelent..!!, But know that i'm integrating it to the webpart
> > it
> > doesn´t shows the parameters.
> >
> > My question is, if there is another way to bring ALL the rows without
> > using
> > the UNION statement? cause i proved that without it, the parameter appears
> > in
> > my Reporting Services WebPart in Sharepoint.
> >
> > Please help me, Masters of the Reporting Services and SQL..!!
> >
> > --
> > Greetings from Mexico..!!
>
>