Architecture changes from RS2000 and RS2005

Where can I find information on the architecture changes from Reporting
Services 2000 and Reporting Services 2005?Not sure what you are looking for. You can check the pre-release
documentation of RS 2005 here:
http://msdn2.microsoft.com/en-us/library/ms228038(en-US,SQL.90).aspx
Generally, reports that work on RS 2000 will also work on RS 2005 (they get
upgrade on-the-fly). For SOAP applications interacting with RS
specificially, the old RS 2000 SOAP namespace is still supported on RS 2005.
However, if you want to take advantage of some of the new functionality, you
will need to use the new RS 2005 SOAP end point.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <David@.discussions.microsoft.com> wrote in message
news:DA305369-16C6-4FFA-B636-914AD510C87F@.microsoft.com...
> Where can I find information on the architecture changes from Reporting
> Services 2000 and Reporting Services 2005?|||Thanks! This helps!
"Robert Bruckner [MSFT]" wrote:
> Not sure what you are looking for. You can check the pre-release
> documentation of RS 2005 here:
> http://msdn2.microsoft.com/en-us/library/ms228038(en-US,SQL.90).aspx
> Generally, reports that work on RS 2000 will also work on RS 2005 (they get
> upgrade on-the-fly). For SOAP applications interacting with RS
> specificially, the old RS 2000 SOAP namespace is still supported on RS 2005.
> However, if you want to take advantage of some of the new functionality, you
> will need to use the new RS 2005 SOAP end point.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:DA305369-16C6-4FFA-B636-914AD510C87F@.microsoft.com...
> > Where can I find information on the architecture changes from Reporting
> > Services 2000 and Reporting Services 2005?
>
>

Approx date of next release

Does anyone have an approximate date of the next release of Reporting
Services?
Thanks in advance.
MarkReporting Services will be shipping along with Yukon. This is sometime in
the second half of next year most likely.
--
| From: "Mark" <mfield@.idonotlikespam.cce.umn.edu>
| Subject: Approx date of next release
| Date: Mon, 25 Oct 2004 08:55:27 -0500
| Lines: 8
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.181
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
| Message-ID: <e#K3FppuEHA.2016@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: x15-238.cce.umn.edu 134.84.15.238
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33045
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Does anyone have an approximate date of the next release of Reporting
| Services?
|
| Thanks in advance.
|
| Mark
|
|
|

applying sum or count funtions to a group

How can I make reporting services to calculate the sum of a value that is
displayed in a group? When I insert the funtion =Sum(Fields!nuAmount.Value)
in the footer of a group, I get the sum considering all values included in a
detail. I only want the sum to be calculated from the group header values
diaplyeddid you get any answer on this quest?
reg.
Kjell Brandes
"FedericAguirre" <FedericAguirre@.discussions.microsoft.com> wrote in message
news:C518AE1F-FFE3-4F16-A007-165420532AB1@.microsoft.com...
> How can I make reporting services to calculate the sum of a value that is
> displayed in a group? When I insert the funtion
=Sum(Fields!nuAmount.Value)
> in the footer of a group, I get the sum considering all values included in
a
> detail. I only want the sum to be calculated from the group header values
> diaplyed|||do some of the calculations on the query side. If you want a count of orders
group by order# then do a count of them on the report.
"FedericAguirre" wrote:
> How can I make reporting services to calculate the sum of a value that is
> displayed in a group? When I insert the funtion =Sum(Fields!nuAmount.Value)
> in the footer of a group, I get the sum considering all values included in a
> detail. I only want the sum to be calculated from the group header values
> diaplyed

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
applied together, one before the other, not at all?
Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:

> Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
> applied together, one before the other, not at all?
> --
>
|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should b
e
applied together, one before the other, not at all?
--Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:

> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
be
> applied together, one before the other, not at all?
> --
>|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
applied together, one before the other, not at all?
--Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
> applied together, one before the other, not at all?
> --
>|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying Encryption Keys in a Web Farm

I wonder if someone can help clarify this one..?
If Iâ've implemented Reporting Services across a Web Farm, and saved a copy
of the encryption key for each node â' If encryption is broken, which key do I
apply?
Thanks,
MarkThe key is the same for each node. There is only one symmetric key for a
farm. The key is just encrypted differently for each node.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:70EE7611-00DA-40E8-8B0C-31F5D48EE39E@.microsoft.com...
> I wonder if someone can help clarify this one..?
> If I've implemented Reporting Services across a Web Farm, and saved a copy
> of the encryption key for each node - If encryption is broken, which key
do I
> apply?
> Thanks,
> Mark
>|||Thanks Daniel
Does that mean that if I want to recover I run â'rskeymgmt â'a..â' on one (any)
node â' or on all nodes in the Farm?
"Daniel Reib [MSFT]" wrote:
> The key is the same for each node. There is only one symmetric key for a
> farm. The key is just encrypted differently for each node.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> news:70EE7611-00DA-40E8-8B0C-31F5D48EE39E@.microsoft.com...
> > I wonder if someone can help clarify this one..?
> >
> > If I've implemented Reporting Services across a Web Farm, and saved a copy
> > of the encryption key for each node - If encryption is broken, which key
> do I
> > apply?
> >
> > Thanks,
> > Mark
> >
>
>|||You would need to do that to each node that was failing with an error about
not be able to unencrypt data. You should rarely have to use this tool.
Only if any passwords get reset or users that the service are running as
change.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:6865252C-DD9F-425F-8F4A-498139C9BDDC@.microsoft.com...
> Thanks Daniel
> Does that mean that if I want to recover I run 'rskeymgmt -a..' on one
(any)
> node - or on all nodes in the Farm?
>
> "Daniel Reib [MSFT]" wrote:
> > The key is the same for each node. There is only one symmetric key for
a
> > farm. The key is just encrypted differently for each node.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> > news:70EE7611-00DA-40E8-8B0C-31F5D48EE39E@.microsoft.com...
> > > I wonder if someone can help clarify this one..?
> > >
> > > If I've implemented Reporting Services across a Web Farm, and saved a
copy
> > > of the encryption key for each node - If encryption is broken, which
key
> > do I
> > > apply?
> > >
> > > Thanks,
> > > Mark
> > >
> >
> >
> >|||OK - Thanks Daniel - Appreciate your swift response.
"Daniel Reib [MSFT]" wrote:
> You would need to do that to each node that was failing with an error about
> not be able to unencrypt data. You should rarely have to use this tool.
> Only if any passwords get reset or users that the service are running as
> change.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> news:6865252C-DD9F-425F-8F4A-498139C9BDDC@.microsoft.com...
> > Thanks Daniel
> >
> > Does that mean that if I want to recover I run 'rskeymgmt -a..' on one
> (any)
> > node - or on all nodes in the Farm?
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > The key is the same for each node. There is only one symmetric key for
> a
> > > farm. The key is just encrypted differently for each node.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> > > news:70EE7611-00DA-40E8-8B0C-31F5D48EE39E@.microsoft.com...
> > > > I wonder if someone can help clarify this one..?
> > > >
> > > > If I've implemented Reporting Services across a Web Farm, and saved a
> copy
> > > > of the encryption key for each node - If encryption is broken, which
> key
> > > do I
> > > > apply?
> > > >
> > > > Thanks,
> > > > Mark
> > > >
> > >
> > >
> > >
>
>

Applying a .css to a .rdl file

Hello all,

I'm using Reporting Services 2005 and have been developing reports using Visual Studio 2005. There will eventually be a large number of reports, all of which will need to adhere to my company's standard look and feel.

To this end I was wondering if it were possible to apply a .css stylesheet to the contents of a .rdl report?

I've been digging round the web and can't seem to come across a definitive answer either way.

I am fairly new to Reporting Services so apologies in advance if this has been asked before.

Thanks

I believe there is no way of doing this

Application services database in sql server 2000

I need some opinion about coping data tables from auto-generated ASP.NET database into SQL 2000 database.

I'm not sure I understand your question but, if you mean you want to create the application services database in sql server 2000 then you should read this article:

Creating the Application Services Database for SQL Server

Please let me know if that's what you needed.

|||

Thank you!

Append String to Value

I'm using SQL Reporting Services 2000 and I've built a pie chart. I'm having
trouble displaying the values in the chart. What I want to do is append a
string to the value that is displayed in the legend. Why doesn't this work?
On the Values tab of Chart Properties -> Data tab -> I double clicked on an
item in the Values listbox.
In the Series label:
= "Fully Patched = " + Sum(Fields!FullyPatched.Value)
In the Value: label:
= Sum(Fields!FullyPatched.Value)
This displays Category 1 in the Legend. The 1 is correct but I'm not sure
where the word Category came from. Also, how do you create a Constant? If
you go to the Edit Expression dialog, You have a choice to choose from
Constants, Globals, ..., but I cannot figure out where to declare and set
these variables.
Thanks,
-ChadOk, I figured out you need to use & instead of +, so:
= Code.strTest & Sum(Fields!FullyPatched.Value) was what I needed.
Now, what about Edit Expression -> Fields: -> Constants? How do I add/use
them?
Thanks,
--Chad

app.config for DLL

I am calling a C# method/DLL from Reporting Services. In the DLL, I am
referencing ConfigurationSettings.AppSettings["DBConnectionString"].
This should go in app.config in the caller's folder. This is fine when
the caller is a regular .NET application, but I don't know where to put
the app.config for Reporting Services.1. During runtime the report is generated under the Report Server host
process so the <appSetting> section in web.config file should work. Try
rendering a report from the Report which has a textbox with the following
expression:
= System.Configuration.Configuration.AppSettings(<your config value>)
Please note that the web.config file already has a configuration section
so you need to add only the <appSettings> element. You should have the same
result when calling this from your DLL since it will be loaded in the RS
application domain.
2. During design time it is a bit trickier. Unfortunately, the current
configuration handler of the Report Designer doesn't seem to recognize
<appSettings>. However, you can render the report in debug mode by hitting
F5. This renders the report under ReportHost.exe. To get the config settings
working, create a ReportHost.exe.config in C:\Program Files\Microsoft SQL
Server\80\Tools\Report Designer and place your configuration section there
(the <configuration> element should be spelled with small "c"), e.g.:
<?xml version="1.0" encoding="utf-8" ?><configuration>
<appSettings>
<add key="serverUrl" value="http://localhost/reportserver" />
</appSettings>
</configuration>
b) To get the Preview tab working you could either check for Nothing and
replace that with a default value, or wrap the ConfigSettings.AppSettings
call to default to some default constant values. Once again, this is only
needed during design time. Your runtime report generation shouldn't need
this hack.
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Bucky" <uw_badgers@.mail.com> wrote in message
news:1103320212.226556.252030@.f14g2000cwb.googlegroups.com...
>I am calling a C# method/DLL from Reporting Services. In the DLL, I am
> referencing ConfigurationSettings.AppSettings["DBConnectionString"].
> This should go in app.config in the caller's folder. This is fine when
> the caller is a regular .NET application, but I don't know where to put
> the app.config for Reporting Services.
>|||Just to clarify...by web.config I meant the Report Server web.config file
located in C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer if default setup settings have been accepted.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:%23wqOlKK5EHA.3728@.TK2MSFTNGP12.phx.gbl...
> 1. During runtime the report is generated under the Report Server host
> process so the <appSetting> section in web.config file should work. Try
> rendering a report from the Report which has a textbox with the following
> expression:
> = System.Configuration.Configuration.AppSettings(<your config value>)
> Please note that the web.config file already has a configuration section
> so you need to add only the <appSettings> element. You should have the
> same result when calling this from your DLL since it will be loaded in the
> RS application domain.
> 2. During design time it is a bit trickier. Unfortunately, the current
> configuration handler of the Report Designer doesn't seem to recognize
> <appSettings>. However, you can render the report in debug mode by hitting
> F5. This renders the report under ReportHost.exe. To get the config
> settings
> working, create a ReportHost.exe.config in C:\Program Files\Microsoft SQL
> Server\80\Tools\Report Designer and place your configuration section there
> (the <configuration> element should be spelled with small "c"), e.g.:
>
> <?xml version="1.0" encoding="utf-8" ?><configuration>
> <appSettings>
> <add key="serverUrl" value="http://localhost/reportserver" />
> </appSettings>
> </configuration>
> b) To get the Preview tab working you could either check for Nothing and
> replace that with a default value, or wrap the ConfigSettings.AppSettings
> call to default to some default constant values. Once again, this is only
> needed during design time. Your runtime report generation shouldn't need
> this hack.
>
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Bucky" <uw_badgers@.mail.com> wrote in message
> news:1103320212.226556.252030@.f14g2000cwb.googlegroups.com...
>>I am calling a C# method/DLL from Reporting Services. In the DLL, I am
>> referencing ConfigurationSettings.AppSettings["DBConnectionString"].
>> This should go in app.config in the caller's folder. This is fine when
>> the caller is a regular .NET application, but I don't know where to put
>> the app.config for Reporting Services.
>

Apache and SQL Reporting Services

Hi Everyone,
I'm pretty new to reporting services so this might be a dumb question.... A client of mine has asked me to use reporting services to create reports for them but they have apache web servers!!!! Is this even possible? I've seen tons of documentation on reporting services by now but none that says you can use it with Apache? The Apache servers all have .NET 1.1 installed and working but I'm not sure if that's enough to get this working.
Any information you could provide me with would be greatly appreciated...... I want to give my client an educated response to this request and I haven't been able to find much!!
THANKS!!!
PJ

Hi PJ,

The simple reply is you will need IIS installed. RS is not compatible to have Apache instead of IIS.

|||Thanks Brad!! I thought I would get this answer (and I like IIS better anyway so I'm not complaining)!
Thanks Again!
PJ

Apache and Reporting Services

Can Reporting Servers run on Apache?No. It is an ASP.Net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1127394777.321200.26010@.g43g2000cwa.googlegroups.com...
> Can Reporting Servers run on Apache?
>|||Sort of. Not truely as 'on' Apache, but if your front-end web server is
Apache, and you want to forward certain requests to be handled by reporting
services, then yes, you can make it LOOK as if it came from Apache itself
using Apache's Reverse Proxy functionality.
You'll need to have the Proxy module, and the Rewrite module compiled into
Apache, then set up a section in httpd.conf that looks like the following,
assuming your Report Server is named "RepServ" and is running on Port 80:
RewriteRule ^/ReportServer(.*) http://RepServ/ReportServer$1 [P,NC]
ProxyPassReverse /ReportServer http://RepServ/ReportServer
This way, when Apache sees requests for anything going to a 'ReportServer'
directory, it will reverse-proxy the request to the report server (Along
with everything else on the URL string - that's what the weird (.*) and $1
parts are for.), the report server will generate the report, and return it
to the Apache server (Thinking that the Apache server is just another web
browser), then Apache will send the report to the actual user, making it
look as if it came from the Apache server.
It's all smoke and mirrors :)
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1127394777.321200.26010@.g43g2000cwa.googlegroups.com...
> Can Reporting Servers run on Apache?
>|||Hi Bryan,
you might have some trouble getting support for running RS on apache
too.. ;-)
Peter|||I agree, it appears more hassle than it's worth.
--
Regards
<<<Bryan Avery>>
"Peter Nolan" wrote:
> Hi Bryan,
> you might have some trouble getting support for running RS on apache
> too.. ;-)
> Peter
>

Anyone using the SQL Server Reporting Services yet?

If anyone is using the SQL Server Reporting Services already, would you mind posting some comments about your experience with it?

Thanks,

~Bradabout damn time :P

It was a simple install ... very easy to work with once i figured out where the darn designer was hiding.. I think there needs to be better information on where to start the designer up. I spent a few hours looking through documentation. I have to say it will be nice to finally get away from using CR.NET or Access for a reporting solution.

Adminstration aspect is fairly straight forward as long as you read carefully before attempting to expose a report to the public.

Morgan|||i just ordered my copy...waiting to get my hands on it. we have huge reporting needs...not a lot of traffic but lot of different types of reports... :)|||I was using it in beta version & going to use final. My 1st impression could be found onhttp://www.aspalliance.com/339|||How about performance? Does it place a ton of additional load while the reports are running?

thx
bk|||"For eyes" not more than CR reports, but I didn't measure it.|||Just thought I'd post this article I came across at SQLServerCentral (note: you have to have a free membership to read the articles there, and I am in no way affiliatd with the site):Reporting Services Part I: Overview, Architecture and Installation by James Luetkehoelter. He will be following up that article with "Reporting Services Part II: Report Design".

Terri|||Its really bad that SQL Server reporting services needs VS.NET 2003 and not VS.NET 2002...
Is there a work around...|||You need VS.NET 2003 in order to use the Report Designer. The Report Designer is a friendly GUI that creates an report definition file in XML format. You could code this XML file by hand, you could look for a third party's GUI, or you could write one yourself if you are so inclined.

Terri