Best SSIS scripting tome?

Is The Rational Guide to Scripting SQL Server 2005 Integration Services Beta Preview by Donald Farmer the best way to learn how to use scripting in SSIS as of late 2006? I'm not a .NET developer, although I come from a Java and C++ background.

I already own Professional SQL Server 2005 Integration Server, but that one doesn't cover scripting so much.

Thanks in advance.

Donald is a frequent poster on this site. However, this question might be hard for him (and me) to answer because of conflict of interest issues.

I work with Donald and I can assure you that he is quite knowledgeable in the uses, misuses and intricacies of SSIS.

As one of our primary points of contact with customers he also owns a wealth of experience in typical and interesting uses for scripting.

I hope this helps inform your decision.

|||

I've read that book.. It gives you a nice understanding of the ScriptTask and ScriptComponent ( http://msdn2.microsoft.com/fr-fr/library/ms345171.aspx ) and gives you some tips and advices throughout the book. It covers input/ output variables and how to access them in the ScriptTask etc... The book has some practical realworld scenarios at the end.

However the real power of SSIS is hidden in the CustomComponent, but that's not even mentioned - well atleast imho (it's a lot easier to debug CustomComponents contra ScriptComponent which are nearly impossible)

Overall I was very happy with the chapters, the writing is clear and easy to understand. And if you understand Java it should be easy to get started with.

Best Reporting Services Book

Any suggestions on the best reference book to help with building
simple-moderately difficult reports for a beginner? This looks pretty good
but wonder if it might be too advanced 'Hitchhiker's Guide to SQL Server
2000 Reporting Services'
Thanks!I think that the Hitchhiker book is very good. The tone is conversational,
and I have found much of the material to apply to my own real-world
situations. Actually, you can download the first two chapters for free
(http://www.sqlreportingservices.net/BookSrs2000/preview/default.aspx) . You
may want to try it and see if it works for you.
Another good one is Brian Larson's Microsoft SQL Server 2000 Reporting
Services". I am sure that there are other good books besides those, but
these are the two that I am familiar with.
"Mike Harbinger" wrote:
> Any suggestions on the best reference book to help with building
> simple-moderately difficult reports for a beginner? This looks pretty good
> but wonder if it might be too advanced 'Hitchhiker's Guide to SQL Server
> 2000 Reporting Services'
> Thanks!
>
>

Best Practises for Server Sizing for MS Reporting Services

We are planning to deploy the MS Reporting Services. Unfortunately,
there isn't much guidance on how to effectively size a server.

Here are my questions:

1) In an environment with 1 reporting server (hosting the reporting
data layer, application, and management layer) connecting to 1 or more
SQL servers (over 2 trunked 1Gbps switches connections), what is the
constraining resource when running large reports against a database of
say 4GB in size? CPU, RAM, DISK, or Network speed on the Reporting
Server? Or the Data hosting SQL server? Or does it depend on code?
2) If I have a Duel Core CPU, do I buy 1 CPU license. MS had responded
to the HyperThreading as 2 virtual CPUs with the statement that you buy
CPU licenses based on socket count effectively. This would imply that
if I buy a 4 Duel Core AMD Opteron Proliant 585 (8 CPU cores in 4
packages / sockets), I can run MS Reporting Services Standard Edition.
Is that true?

Any input or direction would be appreciated.

Paul V.You might want to post in microsoft.public.sqlserver.reportingsvcs to
see if you get a better response.

For licensing issues, there is an FAQ, but if it doesn't answer your
question it would probably be best to contact Microsoft directly for a
definite answer:

http://www.microsoft.com/sql/howtobuy/faq.mspx

Simon

Best practices for multiple report developers?

Two crystal reports developers are about to join me writing reports for
Reporting Services. Neither has used RS before and I don't believe either
has ever used Visual Studio.
I am concerned about what will happen when they build/deploy a project.
Will we end up with multiple unwanted folders and data sources? I thought
maybe we could all use copies of the same solution but I also want to use
SourceSafe and i dont want to worry about checking different versions in on
top of each other.
I would really like something like Visual InterDev 6 where multiple
developers connect their own solutions to a web application and all of the
resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a good
way to do this with the Report Designer?
Any thoughts or links regarding multi-developer coordination issues would be
greatly appreciated.I always use shared data sources. Once a shared data source is deployed it
is not overwritten unless you explicitly do so. When you deploy it will try
to deploy the data source, see that one is there and just give you a warning
that it was not deployed.
If you decide on the folder structure and name your projects the same, then
you should not have a problem (as long as you don't name the reports the
same.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:EF163B30-8423-4F02-8B09-FC9C50D6A070@.microsoft.com...
> Two crystal reports developers are about to join me writing reports for
> Reporting Services. Neither has used RS before and I don't believe either
> has ever used Visual Studio.
> I am concerned about what will happen when they build/deploy a project.
> Will we end up with multiple unwanted folders and data sources? I thought
> maybe we could all use copies of the same solution but I also want to use
> SourceSafe and i dont want to worry about checking different versions in
> on
> top of each other.
> I would really like something like Visual InterDev 6 where multiple
> developers connect their own solutions to a web application and all of the
> resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a
> good
> way to do this with the Report Designer?
> Any thoughts or links regarding multi-developer coordination issues would
> be
> greatly appreciated.|||Is it possible for the Report Designer to "download" or otherwise learn about
the available shared data sources or is the only way to add the *.RDL file to
the project?
Thanks!
PS: Sorry for all the duplicates, I goofed up while trying to sign up for
passport at the same time as writing my question.
"Bruce L-C [MVP]" wrote:
> I always use shared data sources. Once a shared data source is deployed it
> is not overwritten unless you explicitly do so. When you deploy it will try
> to deploy the data source, see that one is there and just give you a warning
> that it was not deployed.
> If you decide on the folder structure and name your projects the same, then
> you should not have a problem (as long as you don't name the reports the
> same.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Al" <Al@.discussions.microsoft.com> wrote in message
> news:EF163B30-8423-4F02-8B09-FC9C50D6A070@.microsoft.com...
> > Two crystal reports developers are about to join me writing reports for
> > Reporting Services. Neither has used RS before and I don't believe either
> > has ever used Visual Studio.
> >
> > I am concerned about what will happen when they build/deploy a project.
> > Will we end up with multiple unwanted folders and data sources? I thought
> > maybe we could all use copies of the same solution but I also want to use
> > SourceSafe and i dont want to worry about checking different versions in
> > on
> > top of each other.
> >
> > I would really like something like Visual InterDev 6 where multiple
> > developers connect their own solutions to a web application and all of the
> > resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a
> > good
> > way to do this with the Report Designer?
> >
> > Any thoughts or links regarding multi-developer coordination issues would
> > be
> > greatly appreciated.
>
>|||If you've made shared data sources you should have an .rds file which
is the actual data source.
Once it's been migrated to the rs server it doesnt' get updated unless
it's deleted or someone explicitly updates it, so for developing local,
we've just emailed the rds to each other. ( you can find it in My
documents/Visual Studio Projects/ProjectName... or if you're using
source safe they should be able to grab a copy from there)|||On Shared Data Sources, there is also a flag in the Properties
Pages/Configuration Properties/General for "OverwriteDataSources" which
defaults to False. Just make sure no one sets that to True or else you WILL
overwrite your data sources in deployments.
"Al" wrote:
> Is it possible for the Report Designer to "download" or otherwise learn about
> the available shared data sources or is the only way to add the *.RDL file to
> the project?
> Thanks!
> PS: Sorry for all the duplicates, I goofed up while trying to sign up for
> passport at the same time as writing my question.
>
> "Bruce L-C [MVP]" wrote:
> > I always use shared data sources. Once a shared data source is deployed it
> > is not overwritten unless you explicitly do so. When you deploy it will try
> > to deploy the data source, see that one is there and just give you a warning
> > that it was not deployed.
> >
> > If you decide on the folder structure and name your projects the same, then
> > you should not have a problem (as long as you don't name the reports the
> > same.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Al" <Al@.discussions.microsoft.com> wrote in message
> > news:EF163B30-8423-4F02-8B09-FC9C50D6A070@.microsoft.com...
> > > Two crystal reports developers are about to join me writing reports for
> > > Reporting Services. Neither has used RS before and I don't believe either
> > > has ever used Visual Studio.
> > >
> > > I am concerned about what will happen when they build/deploy a project.
> > > Will we end up with multiple unwanted folders and data sources? I thought
> > > maybe we could all use copies of the same solution but I also want to use
> > > SourceSafe and i dont want to worry about checking different versions in
> > > on
> > > top of each other.
> > >
> > > I would really like something like Visual InterDev 6 where multiple
> > > developers connect their own solutions to a web application and all of the
> > > resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a
> > > good
> > > way to do this with the Report Designer?
> > >
> > > Any thoughts or links regarding multi-developer coordination issues would
> > > be
> > > greatly appreciated.
> >
> >
> >

Best practices for an installation of SQL Server 2000 Reporting Se

Hi,
Where would one install SQL Service 2000 Reporting Services? I though about
installing them on a Web Server (with NO local SQL Server installed on) and
connection remote to a SQL Server 2000. Does this approach make sense?
I donâ't have a good feeling installing the Web Services on a Database Server
where I have to install IIS and the .NET Framework as well.
Best regards,
DanielThis will work fine. One point to keep in mind is that you have to have a
SQL Server license on the box with RS.
What I do is have SQL Server just for RS on the box. The data the reports
are based on reside on a different box. My feeling is why not have SQL
Server for the object caching that RS uses it for be on the same box. I have
to pay for it anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
> Hi,
> Where would one install SQL Service 2000 Reporting Services? I though
> about
> installing them on a Web Server (with NO local SQL Server installed on)
> and
> connection remote to a SQL Server 2000. Does this approach make sense?
> I don't have a good feeling installing the Web Services on a Database
> Server
> where I have to install IIS and the .NET Framework as well.
> Best regards,
> Daniel|||Bruce,
Thanks for your answer! Just to make sure I got your point. You suggest to
have both (SQL Server and RS) installed on the same computer? Am I also right
that this constellation would only require on SQL Server license?
And one more question: Can RS be installed on a computer with NO SQL Server
installed? I had some troulbe installing RS on my Web Server where on SQL
Server is installed on. The installation skipped the part where I am supposed
to select the SQL Server but told me all is fine :-( This problem though
could have been caused by the Terminal Services which I had not disabled
(Will try tomorrow).
Thanks!
Daniel
"Bruce L-C [MVP]" wrote:
> This will work fine. One point to keep in mind is that you have to have a
> SQL Server license on the box with RS.
> What I do is have SQL Server just for RS on the box. The data the reports
> are based on reside on a different box. My feeling is why not have SQL
> Server for the object caching that RS uses it for be on the same box. I have
> to pay for it anyway.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
> > Hi,
> >
> > Where would one install SQL Service 2000 Reporting Services? I though
> > about
> > installing them on a Web Server (with NO local SQL Server installed on)
> > and
> > connection remote to a SQL Server 2000. Does this approach make sense?
> >
> > I don't have a good feeling installing the Web Services on a Database
> > Server
> > where I have to install IIS and the .NET Framework as well.
> >
> > Best regards,
> >
> > Daniel
>
>|||From a licensing perspective there is no difference. You have to have a SQL
Server license for the box that has Reporting Services. Reporting Services
uses SQL Server for it's object storage. For instance, all reports are
stored in the database. You will not see any rdl files on the server. It
uses SQL Server for other objects as well. So, RS has to have SQL Server
somewhere. If you use a SQL Server that is somewhere other than the box you
are installing RS on you have to use the command line install and specify
where SQL Server can be found. I have not done this myself. I assume the
info on how to do this is in the readme. If you use the setup program it
plans that SQL Server is on the box you are installing RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:E02F3FE4-EDD4-4A35-AD4D-D772A811424A@.microsoft.com...
> Bruce,
> Thanks for your answer! Just to make sure I got your point. You suggest to
> have both (SQL Server and RS) installed on the same computer? Am I also
> right
> that this constellation would only require on SQL Server license?
> And one more question: Can RS be installed on a computer with NO SQL
> Server
> installed? I had some troulbe installing RS on my Web Server where on SQL
> Server is installed on. The installation skipped the part where I am
> supposed
> to select the SQL Server but told me all is fine :-( This problem though
> could have been caused by the Terminal Services which I had not disabled
> (Will try tomorrow).
> Thanks!
> Daniel
>
> "Bruce L-C [MVP]" wrote:
>> This will work fine. One point to keep in mind is that you have to have a
>> SQL Server license on the box with RS.
>> What I do is have SQL Server just for RS on the box. The data the reports
>> are based on reside on a different box. My feeling is why not have SQL
>> Server for the object caching that RS uses it for be on the same box. I
>> have
>> to pay for it anyway.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
>> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
>> > Hi,
>> >
>> > Where would one install SQL Service 2000 Reporting Services? I though
>> > about
>> > installing them on a Web Server (with NO local SQL Server installed on)
>> > and
>> > connection remote to a SQL Server 2000. Does this approach make sense?
>> >
>> > I don't have a good feeling installing the Web Services on a Database
>> > Server
>> > where I have to install IIS and the .NET Framework as well.
>> >
>> > Best regards,
>> >
>> > Daniel
>>|||Thank you Bruce,
this is good to know!
Daniel
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:%238AtkHJYFHA.2796@.TK2MSFTNGP09.phx.gbl...
> From a licensing perspective there is no difference. You have to have a
> SQL Server license for the box that has Reporting Services. Reporting
> Services uses SQL Server for it's object storage. For instance, all
> reports are stored in the database. You will not see any rdl files on the
> server. It uses SQL Server for other objects as well. So, RS has to have
> SQL Server somewhere. If you use a SQL Server that is somewhere other than
> the box you are installing RS on you have to use the command line install
> and specify where SQL Server can be found. I have not done this myself. I
> assume the info on how to do this is in the readme. If you use the setup
> program it plans that SQL Server is on the box you are installing RS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:E02F3FE4-EDD4-4A35-AD4D-D772A811424A@.microsoft.com...
>> Bruce,
>> Thanks for your answer! Just to make sure I got your point. You suggest
>> to
>> have both (SQL Server and RS) installed on the same computer? Am I also
>> right
>> that this constellation would only require on SQL Server license?
>> And one more question: Can RS be installed on a computer with NO SQL
>> Server
>> installed? I had some troulbe installing RS on my Web Server where on SQL
>> Server is installed on. The installation skipped the part where I am
>> supposed
>> to select the SQL Server but told me all is fine :-( This problem though
>> could have been caused by the Terminal Services which I had not disabled
>> (Will try tomorrow).
>> Thanks!
>> Daniel
>>
>> "Bruce L-C [MVP]" wrote:
>> This will work fine. One point to keep in mind is that you have to have
>> a
>> SQL Server license on the box with RS.
>> What I do is have SQL Server just for RS on the box. The data the
>> reports
>> are based on reside on a different box. My feeling is why not have SQL
>> Server for the object caching that RS uses it for be on the same box. I
>> have
>> to pay for it anyway.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in
>> message
>> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
>> > Hi,
>> >
>> > Where would one install SQL Service 2000 Reporting Services? I though
>> > about
>> > installing them on a Web Server (with NO local SQL Server installed
>> > on)
>> > and
>> > connection remote to a SQL Server 2000. Does this approach make sense?
>> >
>> > I don't have a good feeling installing the Web Services on a Database
>> > Server
>> > where I have to install IIS and the .NET Framework as well.
>> >
>> > Best regards,
>> >
>> > Daniel
>>
>|||" If you use a SQL Server that is somewhere other than the box you
are installing RS on you have to use the command line install and specify
where SQL Server can be found."-Bruce
Are you absolutely 100% certain this is the case?
I'm certainly stuck trying to install enterprise RS on the web server
pointing to a SQL server DB on another sql server(2000). Problem is the
install ends "successfully" but then throws an activivation error. No
resolution for this error in sight.
However if I MUST use the commend line too to configure RS across servers
this may explain the activiation error. I don't remember finding anything
documented telling me I must use this command line approach.
Please verify this is true. Thanks! Could save a lot of headaches...

Best Practices (Forms/Letters)

I have a rather large number of already existing forms and letters (in paper
format) that I need to recreate in Reporting Services. After reading a few
posts with regards to formatting etc I have noted that several recommend not
using Text Boxes/Labels but rather tables.
As I'm very new to RS could somebody please advise as to the best possible
way to go about creating these.
Often there is a few lines of text then something that needs to be populated
from the database then another few lines of text etc.
Any help on this would be greatly appreciated.On Sun, 3 Apr 2005 18:03:02 -0700, "Nat Johnson"
<NatJohnson@.discussions.microsoft.com> wrote:
>I have a rather large number of already existing forms and letters (in paper
>format) that I need to recreate in Reporting Services. After reading a few
>posts with regards to formatting etc I have noted that several recommend not
>using Text Boxes/Labels but rather tables.
>As I'm very new to RS could somebody please advise as to the best possible
>way to go about creating these.
>Often there is a few lines of text then something that needs to be populated
>from the database then another few lines of text etc.
>Any help on this would be greatly appreciated.
>
Nat,
Can you explain more about what you are trying to do (ignoring what
the appropriate software might or might not be).
On the face of it, I suspect that Reporting Services may not be the
optimal solution. But I would prefer to better understand your
objective. Forms, for example, in my terminology are used to collect
data from users. I assume that is not part of your aim?
Andrew Watt
MVP - InfoPath|||The company I work for are creating an application which includes an SQL
database. I have to use RS for the reports that are required. Most of the
reports are the traditional style (eg lineflow looking) but others are
letters or forms that the system will automatically print out if a certain
condition is met.
The forms that will be printed will have parts that will be populated from
the database. The web team for the project are creating the online forms. I
have to make my forms similar to theirs for printing out as once the parts
are populated from db they need to be printed so a user can take them to a
site for hand completion.
Most of the letters that need to be printed out need to get data from the
db. And will be automatically printed by the system when a condition is met.
The normal reports that need to be created are not the problem. My question
really relates to the forms and letters and the formatting of these.
Let me know if this helps you anymore or not.
cheers
Nat
"Andrew Watt [MVP - InfoPath]" wrote:
> On Sun, 3 Apr 2005 18:03:02 -0700, "Nat Johnson"
> <NatJohnson@.discussions.microsoft.com> wrote:
> >I have a rather large number of already existing forms and letters (in paper
> >format) that I need to recreate in Reporting Services. After reading a few
> >posts with regards to formatting etc I have noted that several recommend not
> >using Text Boxes/Labels but rather tables.
> >
> >As I'm very new to RS could somebody please advise as to the best possible
> >way to go about creating these.
> >
> >Often there is a few lines of text then something that needs to be populated
> >from the database then another few lines of text etc.
> >
> >Any help on this would be greatly appreciated.
> >
> Nat,
> Can you explain more about what you are trying to do (ignoring what
> the appropriate software might or might not be).
> On the face of it, I suspect that Reporting Services may not be the
> optimal solution. But I would prefer to better understand your
> objective. Forms, for example, in my terminology are used to collect
> data from users. I assume that is not part of your aim?
> Andrew Watt
> MVP - InfoPath
>|||You should be able to render to PDF and print the PDF documents.
If the documents are to be completed by hand that ought to work for
you.
Almost certainly there will be some tweaking involved to get the
appearance that everybody is happy with.
Andrew Watt
MVP - InfoPath
On Mon, 4 Apr 2005 13:05:03 -0700, "Nat Johnson"
<NatJohnson@.discussions.microsoft.com> wrote:
>The company I work for are creating an application which includes an SQL
>database. I have to use RS for the reports that are required. Most of the
>reports are the traditional style (eg lineflow looking) but others are
>letters or forms that the system will automatically print out if a certain
>condition is met.
>The forms that will be printed will have parts that will be populated from
>the database. The web team for the project are creating the online forms. I
>have to make my forms similar to theirs for printing out as once the parts
>are populated from db they need to be printed so a user can take them to a
>site for hand completion.
>Most of the letters that need to be printed out need to get data from the
>db. And will be automatically printed by the system when a condition is met.
>The normal reports that need to be created are not the problem. My question
>really relates to the forms and letters and the formatting of these.
>Let me know if this helps you anymore or not.
>cheers
>Nat
>"Andrew Watt [MVP - InfoPath]" wrote:
>> On Sun, 3 Apr 2005 18:03:02 -0700, "Nat Johnson"
>> <NatJohnson@.discussions.microsoft.com> wrote:
>> >I have a rather large number of already existing forms and letters (in paper
>> >format) that I need to recreate in Reporting Services. After reading a few
>> >posts with regards to formatting etc I have noted that several recommend not
>> >using Text Boxes/Labels but rather tables.
>> >
>> >As I'm very new to RS could somebody please advise as to the best possible
>> >way to go about creating these.
>> >
>> >Often there is a few lines of text then something that needs to be populated
>> >from the database then another few lines of text etc.
>> >
>> >Any help on this would be greatly appreciated.
>> >
>> Nat,
>> Can you explain more about what you are trying to do (ignoring what
>> the appropriate software might or might not be).
>> On the face of it, I suspect that Reporting Services may not be the
>> optimal solution. But I would prefer to better understand your
>> objective. Forms, for example, in my terminology are used to collect
>> data from users. I assume that is not part of your aim?
>> Andrew Watt
>> MVP - InfoPath

Best Practice promotion of RDL from Dev to Test then onto Prod

I have been tasked with creating our promotion procedures for all
reports in Reporting Services. Can anyone give me any tips or point
me to any references that will help me with this.
Ideally I would develop the report in a dev environment against dev
data.
It would go through our quality assurance process against test data
where both the data and report layout would be verified.
Then promoted to production.
Any help is most appreciated.
Thanks.I have also been working on the deployment issue and do not have a good
process. I would also like to go this on a single SQL server. Any thoughts?
"Brian H" wrote:
> I have been tasked with creating our promotion procedures for all
> reports in Reporting Services. Can anyone give me any tips or point
> me to any references that will help me with this.
> Ideally I would develop the report in a dev environment against dev
> data.
> It would go through our quality assurance process against test data
> where both the data and report layout would be verified.
> Then promoted to production.
> Any help is most appreciated.
> Thanks.
>|||Where I work, we have seperate Dev, Staging, and Production
environments for SQL as well as the Sql Reporting servers.
Deployment consists of simply publishing Stored Procedures and RDS, and
RDL files in each environment, testing, then promoting to the next
until you reach Production.
Was there something more specific you were looking for? Do you have
any hardware constraints that might factor-in?
Regarding using a single Sql Server, I'm not entirely sure how you
might do this, since you still need a seperate ReportServer &
ReportServerTempDB instance for each environment. There may be a place
to reconfigre Sql Reporting to use different DB names so that the
different DB instances can be referenced.
Beware that all DB instances on a server share the same MASTER
database. This can be an issue when applying Service Packs, because
deployment to one target DB will still affect all DB instances via the
common MASTER database as occurs in SP-1. However, you may be able to
work around this by creating multiple database Instances on the same
server. I'm not a DBA, but I think they will have seperate MASTER
databases in that case.
I hope this helps a bit,
Lance Hunt
http://weblogs.asp.net/lhunt/

Best Practice for Report Projects Related To Application Solutions

Hello Reporting Services Gurus!

I'm about to start on my first reporting services project, but before I mess it up, I'm looking for some guidance on how best to achieve my mission. Here's what I'm looking to achieve:

I have a datacentric application (SQL Server 2005 Express w/ Advanced Services backend) in which I want to build about 50 "canned" reports for the end users. I want to build the reports utilizing server mode so I can take advantage of some of Reporting Services advanced features. I'm not sure what the best practice would be to build the reporting services project. Is it better to include the report project as another project within the application solution? Or, should I build the report project independent of the application solution? What are the pros and cons of doing it either way? How does including the report project build if it's included in the application solution? How would a ClickOnce deployment deploy the report project to the report server?

My ultimate goal would be to have an "off-the-shelf" software solution that includes an installation package consisting of the application project and report project. Is it even possible due to the Reporting Services architecture to achieve an install in this manner with ClickOnce, Windows Installer, or Installshield? Or, is building the report project indepedent of the application project and deploying the reports to the report server "manually" (i.e. deploy within the report server project) the only solution?

Any help would be greatly appreciated!

Tony

I haven't received any feedback yet, so I thought I'd try bumping it back to the top of the thread.

Thanks for any help!

Best Practice for Domain Account for SQL Services?

Hello,

I've done some searching, but have found no definite answer yet. Our SQL 2005 servers are members of Active Directory Services. We want to run SQL services using an ADS account.

I see 7 SQL services in the SQL Server Configuration Manager: Integration Services, FullText Search, SQL Server, Analysis Services, Reporting Services, Browser, and Agent.

Question: Is it a bad move to run them all using the same domain account? I mean, wouldn't this give, say the Browser service, more privileges than it needs by allowing its account access to the same resources as, for example, the Agent service? What I'm concerned about is a vulnerability in one service compromising another service.

I would like to be able to use one domain account for all 7 services on two SQL servers, but I have a feeling this is a poor choice.

What is the best method for running SQL services using a domain account?

Thanks,

-Tony

Perhaps these articles will help you in your decison process:

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

Often, SQL Agent needs a higher level of access to network resources than the SQL Server Service. It is a good practice to provide the minimum level of access to local and network resources as is required for the task. It would not be unusual to have multiple domain accounts for the various SQL Services. In fact, for those services that require network resources, some folks will have separate domain accounts for each server. I have seen every SQL Agent service running under a unique account -the theory is if one server is compomised, unique accounts protect the remaining servers from compromise.

It is a balance between amount of security desired vs. amount of effort required to maintain that security. (As always...)

Best option for reporting database

I have a SQL server with a lot of stress on it and I want to get the load
from reporting services of this database. So I need to replicate the database
to another server.
The maximum latency for my reports is 15 minutes so I think mirroring with
snapshots is not an option.
Another possibility is log shipping but what whit my log backups? And what
with the load replication is causing on my database server?
Any advice is appreceated.
Regards
That depends on your load. I would use transactional replication. You may
see a 5% increase in cpu utilization.
http://www.zetainteractive.com - Shift Happens!
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
"Zekske" <Zekske@.discussions.microsoft.com> wrote in message
news:A7F65ED4-75D4-4BFE-9EFE-C0959DFFF518@.microsoft.com...
>I have a SQL server with a lot of stress on it and I want to get the load
> from reporting services of this database. So I need to replicate the
> database
> to another server.
> The maximum latency for my reports is 15 minutes so I think mirroring with
> snapshots is not an option.
> Another possibility is log shipping but what whit my log backups? And what
> with the load replication is causing on my database server?
> Any advice is appreceated.
> Regards
|||Log backup's do not consume too much of CPU. So you can think of Log Shipping
too...
"Zekske" wrote:

> I have a SQL server with a lot of stress on it and I want to get the load
> from reporting services of this database. So I need to replicate the database
> to another server.
> The maximum latency for my reports is 15 minutes so I think mirroring with
> snapshots is not an option.
> Another possibility is log shipping but what whit my log backups? And what
> with the load replication is causing on my database server?
> Any advice is appreceated.
> Regards

Best Method to Document Database?

I have SQL Server 2005 Developer edition. What is the best way to create a
data dictionary for an existing database? Does reporting services or other
tools provide canned reports that include all objects including keys,
constraints etc? Do I need to write my own queries to generate the meta
data or do I need to use another vendor's custom app?
txOn Wed, 22 Feb 2006 12:03:34 -0800, Simon Shutter wrote:

> I have SQL Server 2005 Developer edition. What is the best way to create
a
> data dictionary for an existing database? Does reporting services or othe
r
> tools provide canned reports that include all objects including keys,
> constraints etc? Do I need to write my own queries to generate the meta
> data or do I need to use another vendor's custom app?
> tx
Personally, I'd use another vendors too... ApexSQL Doc is what I'm
currently evaluating|||Simon Shutter wrote:
> I have SQL Server 2005 Developer edition. What is the best way to create
a
> data dictionary for an existing database? Does reporting services or othe
r
> tools provide canned reports that include all objects including keys,
> constraints etc? Do I need to write my own queries to generate the meta
> data or do I need to use another vendor's custom app?
> tx
You might want to try SchemaToDoc at http://www.schematodoc.com. It's
output is a Word document that includes information about your tables
(primary keys), fields (type, size, defaults, nullable), indexes, check
constraints, foreign key constraints, stored procedures, and views. It
also lets you annotate your tables and fields, and include those
annotations in the Word output.

Best Method to Document Database?

I have SQL Server 2005 Developer edition. What is the best way to create a
data dictionary for an existing database? Does reporting services or other
tools provide canned reports that include all objects including keys,
constraints etc? Do I need to write my own queries to generate the meta
data or do I need to use another vendor's custom app?
txOn Wed, 22 Feb 2006 12:03:34 -0800, Simon Shutter wrote:
> I have SQL Server 2005 Developer edition. What is the best way to create a
> data dictionary for an existing database? Does reporting services or other
> tools provide canned reports that include all objects including keys,
> constraints etc? Do I need to write my own queries to generate the meta
> data or do I need to use another vendor's custom app?
> tx
Personally, I'd use another vendors too... ApexSQL Doc is what I'm
currently evaluating|||Simon Shutter wrote:
> I have SQL Server 2005 Developer edition. What is the best way to create a
> data dictionary for an existing database? Does reporting services or other
> tools provide canned reports that include all objects including keys,
> constraints etc? Do I need to write my own queries to generate the meta
> data or do I need to use another vendor's custom app?
> tx
You might want to try SchemaToDoc at http://www.schematodoc.com. It's
output is a Word document that includes information about your tables
(primary keys), fields (type, size, defaults, nullable), indexes, check
constraints, foreign key constraints, stored procedures, and views. It
also lets you annotate your tables and fields, and include those
annotations in the Word output.

Best Method to Document Database?

I have SQL Server 2005 Developer edition. What is the best way to create a
data dictionary for an existing database? Does reporting services or other
tools provide canned reports that include all objects including keys,
constraints etc? Do I need to write my own queries to generate the meta
data or do I need to use another vendor's custom app?
tx
On Wed, 22 Feb 2006 12:03:34 -0800, Simon Shutter wrote:

> I have SQL Server 2005 Developer edition. What is the best way to create a
> data dictionary for an existing database? Does reporting services or other
> tools provide canned reports that include all objects including keys,
> constraints etc? Do I need to write my own queries to generate the meta
> data or do I need to use another vendor's custom app?
> tx
Personally, I'd use another vendors too... ApexSQL Doc is what I'm
currently evaluating
|||Simon Shutter wrote:
> I have SQL Server 2005 Developer edition. What is the best way to create a
> data dictionary for an existing database? Does reporting services or other
> tools provide canned reports that include all objects including keys,
> constraints etc? Do I need to write my own queries to generate the meta
> data or do I need to use another vendor's custom app?
> tx
You might want to try SchemaToDoc at http://www.schematodoc.com. It's
output is a Word document that includes information about your tables
(primary keys), fields (type, size, defaults, nullable), indexes, check
constraints, foreign key constraints, stored procedures, and views. It
also lets you annotate your tables and fields, and include those
annotations in the Word output.

Best Design for reports over time

Hi everyone,
I am designing a reporting system for the internet using Reporting
Services. Is there a way to access the historical snapshots
programmatically? We are displaying the reports in the browser by
linking to them in the url, but that brings up the current month's
report. We want to be able to run the report monthly(different data)
and generate a snapshot, then link to the snapshots from the custom
ASP.Net application.
Can we do this? Is is there a better way?
Thanks in advance,
ShawnJust render a history snapshot and look at the generated URL. The URL will
look like this:
http://ServerName/Reports/Pages/Report.aspx?ItemPath=%SomeReport&HistoryID=2005-05-11T22:25:40
The HistoryID identifies the history snapshot in UTC time.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"sysdesigner" <sysdesigner@.discussions.microsoft.com> wrote in message
news:7B7A9AA3-2EBB-45D2-85B2-AD58FE3A5A09@.microsoft.com...
> Hi everyone,
> I am designing a reporting system for the internet using Reporting
> Services. Is there a way to access the historical snapshots
> programmatically? We are displaying the reports in the browser by
> linking to them in the url, but that brings up the current month's
> report. We want to be able to run the report monthly(different data)
> and generate a snapshot, then link to the snapshots from the custom
> ASP.Net application.
>
> Can we do this? Is is there a better way?
>
> Thanks in advance,
> Shawn
>
>

Best configuration for Analysis Services

I am looking for opinions on what server configuration is best for Analysis
Services 2000.
Should we emphasize CPU speed/multiple CPUS, RAM?
We have a SAN attached via a Gigabit LAN.
Thanks.See if this helps
http://www.microsoft.com/technet/tr...ze/ANSvcsPG.asp
There is a section on hardware resources, as Tom Chester has quoted multiple
places, Analysis Services is very heavy on RAM and SQL2K AS can only use
3gb.
Ray Higdon MCSE, MCDBA, CCNA
--
"Bruce Lester" <bruce_lester@.email.com> wrote in message
news:wDy_b.391402$na.741449@.attbi_s04...
> I am looking for opinions on what server configuration is best for
Analysis
> Services 2000.
> Should we emphasize CPU speed/multiple CPUS, RAM?
> We have a SAN attached via a Gigabit LAN.
> Thanks.
>

Best and worst scenarios for Notification Services

Hi,

I am just looking for the best and worst scenarios to implement Notification services...This is more to come up with a design guildelines

I Would be more interested in the worst sceanrios :) Please share your inputs based on your experiences...

Regards,

Anjana

I'm not really sure that I understand what you mean by worst case scenario. Do you mean situations where SQLNS is not the best tool for the job? Or do you mean specific configurations that would cause SQLNS to perform poorly.

In either case, I guess, that's going to largely depend on the situation.

|||

I meant where SQLNS should not be used...

For example let's take three cases

News Alerts (changes with reasonable freqeuncy, and alerts must reach the subscriber in reasonable time)

Weather changes alerts(changes very frequently,and alerts can reach the subscriber in reasonable time)

Stock market alerts (changes very frequently and alert needs to be sent immedaitely to the subscriber with no delay).

In the above scenarios are there any scenarios where NS might perform a bit poorly?

Regards,

Anjana

|||

SQLNS is very good at matching lots of event data with lots of subscriber/subscription data and generating lots of events. It is designed to be "internet scalable" where you may not know just how many subscribers, subscriptions, or even events that you maybe processing over a given time period. It's equally as good for smaller applications, too.

For smaller, purely in-house notification applications, sometimes Query Notifications are a better choice. It just depends on what you're trying to accomplish.

For cases where sub-second notifications are required, SLQNS is *not* the best tool. The generator fires on a regular basis to evaluate whether there has been any activities that it needs to process. Same for the distributor. If you must be notified immediately, that is without a possible 2 second delay, SLQNS is not for you.

HTH...

Beginning

Hi, im a Beginner and I have to start next week with create and programming
some Reports with Reporting Services. Can anyone give me some good stuff
where I find the first lessons what I have to do etc. Perphaps some links or
e idea for some good books!? The installation wasn't a problem, it's about
the programming.
Thanks very much for your help!
schueppi/SwitzerlandOn Thu, 7 Apr 2005 23:35:06 -0700, "schueppi"
<schueppi@.discussions.microsoft.com> wrote:
>Hi, im a Beginner and I have to start next week with create and programming
>some Reports with Reporting Services. Can anyone give me some good stuff
>where I find the first lessons what I have to do etc. Perphaps some links or
>e idea for some good books!? The installation wasn't a problem, it's about
>the programming.
>Thanks very much for your help!
>schueppi/Switzerland
There was a series of 5 webcasts about a month ago. I included a link
from my blog, http://www.tfosorcim.org/archives/000340.html.
The webcasts are ideal for getting your head round SQL Reporting
Services 2000.
Once you have watched those, you will be in a better position to
understand the Reporting Services Books Online, link from here:
http://www.tfosorcim.org/archives/000352.html.
Andrew Watt
MVP - InfoPath

Beginners questions about Reporting Services Admin

I'm looking at the Properties tab of a report In the Report Manager. If I go
into 'New Role Assignment', I see a 'Group or user name:' textbox.
Do I understand this correctly?: Any name I enter for a new role must match
an existing SQL Server user or group? (If so I would expect some sort of
lookup/selection list, which is the main cause for my confusion.)No, this has nothing to do with SQL Server. RS is an asp.net application and
it uses roles to manage who gets to run a report, create subscriptions, etc.
Assuming that you are using integrated security (the default) then what you
are doing is assigning a user or group to a particular role. If you are in
the local administrators group for the server (not SQL Server, but the
server RS is running on) then you are automatically part of the Content
Manager role.
When you create a datasource then you deal with the credentials for
retrieving the data for the report.
So, two different things which is good. Remember, you can connect to many
different sources for the data for the reports and they can all be using
different credentials for retrieving that data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:18CD1BB0-50CD-422B-8A8B-2770B1B7CBFB@.microsoft.com...
> I'm looking at the Properties tab of a report In the Report Manager. If I
> go
> into 'New Role Assignment', I see a 'Group or user name:' textbox.
> Do I understand this correctly?: Any name I enter for a new role must
> match
> an existing SQL Server user or group? (If so I would expect some sort of
> lookup/selection list, which is the main cause for my confusion.)|||Ok, admittedly I am not a security expert. I should have said Windows, not
SQL Server. Let me rephrase the question.
Are you saying in the New Role Assignment window, the name I enter in the
'Group or user name' box must match exactly an existing Windows group or
user?
(And again I say that I am rather confused that it is a textbox rather than
a selection list.)
"Bruce L-C [MVP]" wrote:
> No, this has nothing to do with SQL Server. RS is an asp.net application and
> it uses roles to manage who gets to run a report, create subscriptions, etc.
> Assuming that you are using integrated security (the default) then what you
> are doing is assigning a user or group to a particular role. If you are in
> the local administrators group for the server (not SQL Server, but the
> server RS is running on) then you are automatically part of the Content
> Manager role.
> When you create a datasource then you deal with the credentials for
> retrieving the data for the report.
> So, two different things which is good. Remember, you can connect to many
> different sources for the data for the reports and they can all be using
> different credentials for retrieving that data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:18CD1BB0-50CD-422B-8A8B-2770B1B7CBFB@.microsoft.com...
> > I'm looking at the Properties tab of a report In the Report Manager. If I
> > go
> > into 'New Role Assignment', I see a 'Group or user name:' textbox.
> >
> > Do I understand this correctly?: Any name I enter for a new role must
> > match
> > an existing SQL Server user or group? (If so I would expect some sort of
> > lookup/selection list, which is the main cause for my confusion.)
>
>|||Yes, you are mapping a Windows user/group to a RS role. What I do is I
create a local group on the box specifically for this. I add individual
users and domain groups to that local group. I then assign that group to a
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:6C2052BC-4ACE-4D8F-84A5-A9316D86F0B7@.microsoft.com...
> Ok, admittedly I am not a security expert. I should have said Windows,
> not
> SQL Server. Let me rephrase the question.
> Are you saying in the New Role Assignment window, the name I enter in the
> 'Group or user name' box must match exactly an existing Windows group or
> user?
> (And again I say that I am rather confused that it is a textbox rather
> than
> a selection list.)
> "Bruce L-C [MVP]" wrote:
>> No, this has nothing to do with SQL Server. RS is an asp.net application
>> and
>> it uses roles to manage who gets to run a report, create subscriptions,
>> etc.
>> Assuming that you are using integrated security (the default) then what
>> you
>> are doing is assigning a user or group to a particular role. If you are
>> in
>> the local administrators group for the server (not SQL Server, but the
>> server RS is running on) then you are automatically part of the Content
>> Manager role.
>> When you create a datasource then you deal with the credentials for
>> retrieving the data for the report.
>> So, two different things which is good. Remember, you can connect to many
>> different sources for the data for the reports and they can all be using
>> different credentials for retrieving that data.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:18CD1BB0-50CD-422B-8A8B-2770B1B7CBFB@.microsoft.com...
>> > I'm looking at the Properties tab of a report In the Report Manager.
>> > If I
>> > go
>> > into 'New Role Assignment', I see a 'Group or user name:' textbox.
>> >
>> > Do I understand this correctly?: Any name I enter for a new role must
>> > match
>> > an existing SQL Server user or group? (If so I would expect some sort
>> > of
>> > lookup/selection list, which is the main cause for my confusion.)
>>|||I'm still having problems. I was under the impression that access was
controlled solely by RS itself. I know you suggested created a dedicated
group. However, I started small, with a single network ID that had
absolutely no presence on this particular machine.
I created a server role consisting of all the 'View' options. I started by
assigning the test id this 'read-only' role at the site level and then worked
down to the report. (It appears that I have to assign security at all the
levels, site-folder-report, before the user can see the actual report. Is
that right?)
However, once the Test ID finally had access to the report and started it, I
got the error message: An error has occured during report processing.
Cannot create a connection to data source 'DataSource11'. For more
information about this error navigate to the report server on the local
server machine, or enable remote errors.'
I really can't find anything in the error logs that seems relevant and I'm
not sure I understand some of the other references to this problem on this
group. Any suggestions?
"Bruce L-C [MVP]" wrote:
> Yes, you are mapping a Windows user/group to a RS role. What I do is I
> create a local group on the box specifically for this. I add individual
> users and domain groups to that local group. I then assign that group to a
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:6C2052BC-4ACE-4D8F-84A5-A9316D86F0B7@.microsoft.com...
> > Ok, admittedly I am not a security expert. I should have said Windows,
> > not
> > SQL Server. Let me rephrase the question.
> >
> > Are you saying in the New Role Assignment window, the name I enter in the
> > 'Group or user name' box must match exactly an existing Windows group or
> > user?
> >
> > (And again I say that I am rather confused that it is a textbox rather
> > than
> > a selection list.)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, this has nothing to do with SQL Server. RS is an asp.net application
> >> and
> >> it uses roles to manage who gets to run a report, create subscriptions,
> >> etc.
> >> Assuming that you are using integrated security (the default) then what
> >> you
> >> are doing is assigning a user or group to a particular role. If you are
> >> in
> >> the local administrators group for the server (not SQL Server, but the
> >> server RS is running on) then you are automatically part of the Content
> >> Manager role.
> >>
> >> When you create a datasource then you deal with the credentials for
> >> retrieving the data for the report.
> >>
> >> So, two different things which is good. Remember, you can connect to many
> >> different sources for the data for the reports and they can all be using
> >> different credentials for retrieving that data.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:18CD1BB0-50CD-422B-8A8B-2770B1B7CBFB@.microsoft.com...
> >> > I'm looking at the Properties tab of a report In the Report Manager.
> >> > If I
> >> > go
> >> > into 'New Role Assignment', I see a 'Group or user name:' textbox.
> >> >
> >> > Do I understand this correctly?: Any name I enter for a new role must
> >> > match
> >> > an existing SQL Server user or group? (If so I would expect some sort
> >> > of
> >> > lookup/selection list, which is the main cause for my confusion.)
> >>
> >>
> >>
>
>|||I am experiencing the same issue as B.Chernick.
Just as B.Chernick explains, I have also created a Test user that
access the report, but gets errors during processing.
However, I noticed that if I gave my Test user domain adminstrator
privileges (which is not possible in the production environment) I am
able to view the report without any difficulty. This leads me to
believe that there is a permissions issue someplace along the line.
Any ideas?

Beginner's question

I just installed SQL Server 2005, Office 2007, and the add-in, but when I check services.msc, I don't see the SQL Server Analysis Services. Does anyone know how I can get this to load? Also, when I run the server configuration utility in the DM add-in folder, do you know what I should put in the server name to get it to run off my hard disk and not a server? local host doesn't seem to work. Thanks in advance!

Which edition of SQL Server 2005 did you install? If you installed the express edition, Analysis Services is not included in that edition. To access Data Mining features, you can install an eval edition of SQL Server 2005 from http://technet.microsoft.com/en-us/sqlserver/bb462637.aspx

The DM Addins needs Analysis Server to run and cannot run off a local file from your hard drive. You'll need Analysis Server installed to use the addins from Office.

|||I have the evaluation version, but don't know how to set it up to have my hard drive as the server. Do you know how I can get the SQL analysis services to run so that it will appear in services.msc?
|||While installing the evaluation edition, did you select Analysis Services as as installation option? You can go to Add/Remove Programs, find Microsoft SQL Server 2005, select Modify and check the list of products installed. Analysis Services should be one of the options.|||Thanks a lot for you help. If I had 50 products and 60,000 different customers with different assortments of products per customers (basket), do you know how microsoft's associate function can help determine the association rules that have the highest probability of occurring? Thanks again.
|||Are you referring to the PredictAssociation function? Or just how to setup the mining model to do a market-basket analysis?|||Market-basket analysis would be great. Is there any way to get it to give the probabilities of Product C given that Product A and B are also sold, or will it just be able to do the probability of product B given that A is sold? Thanks
|||

It does both. The Association Rules algorithm uses all rules that "fire" for the input set. For example if you had rules such as

A->C

A,B->C

A,D->C

and you had A,B, and D in your input, all three rules would "fire". The resultant probability is based on the probability of the rules, and may not match any one in particular.

|||So would I just select the 50,000 clients and 50 products and then run the associate function? Do you know how long it would take for the associate or clustering feature to run with this amount of data on a local hard drive?
|||

The amount of time to perform such an operation is not long. However, reading your original question - "the association rules with the highest probability of occurring", the answer is simply those rules whose LHS itemsets have the highest support. Take for example you have rules

A -> C

A,B -> D

A,B -> C

A, B, C -> E

Say you have 50,000 cases and you have support(A)=5,000, support (A,B) = 2,000, support(A,B,C) = 1000.

The probability given any input case of each rule firing would then be

10% A->C

4% A,B->D

4% A,B->C

2% A,B,C->E

Beginner: How to group data?

Hello,
Thanks for reviewing my question. I am new to reporting services and
experimented with a couple of reports. I have the following data in a table:
# name slot
1 A1 1
1 B1 2
1 C1 3
2 A2 1
2 B2 2
2 C2 3
I would like to output in this fashison:
1 2
-- --
1 A1 A2
2 B1 B2
3 C1 C2
Should I be looking to use a Matrix objecjt? Do I need to use JOINs to
group rows/columns even though all my data I need is in my table?
Many Thanks
PeterA follow up:
I am not familar with how the reporting mechanism groups the data. I have a
long list of data already contained in a table.
Current list
1 Book A Action
1 Book B Drama
2 Book C Novel
2 Book D Action
Desired output
1 2
Action Book A Book D
Drama Book B
Novel Book C
Can I output the data in the desired output or do I have to do queries with
cross joins or something of that sort?
Many Thanks
Peter
"Peter" wrote:
> Hello,
> Thanks for reviewing my question. I am new to reporting services and
> experimented with a couple of reports. I have the following data in a table:
> # name slot
> 1 A1 1
> 1 B1 2
> 1 C1 3
> 2 A2 1
> 2 B2 2
> 2 C2 3
> I would like to output in this fashison:
> 1 2
> -- --
> 1 A1 A2
> 2 B1 B2
> 3 C1 C2
> Should I be looking to use a Matrix objecjt? Do I need to use JOINs to
> group rows/columns even though all my data I need is in my table?
> Many Thanks
> Peter
>