new to 2005 reporting services

[aaron]

Can you tell me the best way to generate a series of similar reports by
control group that are sent out to the users? Would you use shared data,
subreports, and/or some other method to accomplish this task?

There are few people at work that are new to using sql server reporting
services 2005.
Our first project is to produce a series of reports by two diferrent
control break levels. Thus all the reports for contol group 1 and subgroup 1
reports are together.
All reports for control groug 1 subgroup 2 reports are together.
We are going to export these reports out in a pdf format to each user
group via email. To setup this kind of a strucutre, I am thinking that we
need to use 'shared data' we all use. Is that correct?
We have experience use subreports in crystal reports to meet these same
reporting needs.

[Uri Dimant]

aaron
Can you elaborate a little bit by 'diferrent control break levels.' ?

"aaron" <aa...@discussions.microsoft.com> wrote in message
news:96C003F7-877B-46D5...@microsoft.com...

[aaron]

The control breaks would be groupings. Thus let's say you have 25 regions in
the united states, then region 1 would be a group, region 2 would be a group,
region 3, etc. would be a group.

"Uri Dimant" wrote:

> .
>

[Uri Dimant]

aaron
Can you group SELECT statement and then identify groups by 1...n, I mean
using ROW_NUMBER () OVER )PARTITION BY region ORDER BY state)

"aaron" <aa...@discussions.microsoft.com> wrote in message

news:6F604D12-25CD-4458...@microsoft.com...

[Andrew Karcher [SQL MVP]]

Aaron,

If I understand your question correctly, you have a report that is a report
for a region. So you pass in a parameter which is the region. Now you want
to have that report generated for multiple regions and sent out to users. I
hope I interpreted you correctly. If you have the report above you want to
take a look at Data Driven Subscriptions or Regular Subscriptions. So you
can setup a subscription that will generate the report for Region 1 and
email to a set of users. Then a Region 2 which will be sent to different
set of users.

If that is correct here are some links on subscriptions and data driven
subscriptions:

Subscription and Delivery:
http://msdn.microsoft.com/en-us/library/ms159762.aspx
Create a Subscription: http://msdn.microsoft.com/en-us/library/ms157386.aspx
Create a Data Driven Subscription:
http://msdn.microsoft.com/en-us/library/ms169673.aspx

HTH,
Andrew
SQL Server MVP

"aaron" <aa...@discussions.microsoft.com> wrote in message

news:6F604D12-25CD-4458...@microsoft.com...

[William Vaughn (MVP)]

Correct, but consider that Data-driven subscriptions is an Enterprise only
feature--you know, the version that costs as much as a (nice) bass boat.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________

"Andrew Karcher [SQL MVP]" <akar...@claritycon.com> wrote in message
news:Ol55Z1Li...@TK2MSFTNGP05.phx.gbl...

[aaron]

"William Vaughn:"

Can you do the data-driven solution and NOT e-mail out the reports in the
professional version? If so, can I use visual stusdio.net 2005 or do I need
Visual studio.net 2008?

Just to do the data-driven solution where the reports stay on a server,
what edition do I need to use? Can I use the enterprise version of 2005 or do
I need the enterprise version of 2008?

thanks for letting me know!

[Bruce L-C [MVP]]

Either enterprise 2005 or 2008 will work. No change in data driven
subscriptions has occurred between these versions.

Visual studio is not needed for either RS 2005 or RS 2008. Both come with a
version of VS to host the report designer. Purchasing Visual Studio was only
needed for RS 2000, since then the product has bundled in a specialized
version of Visual Studio.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"aaron" <aa...@discussions.microsoft.com> wrote in message

news:9FE4AF46-5287-4159...@microsoft.com...

[Paul Shapiro]

Just to be clear, it's the Enterprise version of SQL Server you need. There
isn't any enterprise version of visual studio.

"Bruce L-C [MVP]" <bruce_l...@hotmail.com> wrote in message
news:#cDOn0vk...@TK2MSFTNGP05.phx.gbl...

[William Vaughn (MVP)]

Actually, you don't need the Enterprise version if you roll your own
application to launch the reports. Using the ReportViewer control I might
create a PDF version of the report on the fly and build an email message to
hold the created file. This can all be done in code.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________

"aaron" <aa...@discussions.microsoft.com> wrote in message
news:9FE4AF46-5287-4159...@microsoft.com...