sql server reporting services: ONE REPORT for SEVERAL OUTPUTS -- sql server reporting services

ONE REPORT for SEVERAL OUTPUTS

Jean-Marc PUGIN
11/12/2004 1:45:05 PM

sql server reporting services:

Hi,

I need to know if Reporting Services is bale to run ONE Report in which the
SQL will generate may output (indeed as many as users dependding on their
rights and data perimeter).

I have a report named SALES.RDL for example the list

SUPPLIER REVENUE BENEFIT

What I need is that the Execution/Run of Report SALES generate as many
output files as the number of Salesmen.

Salesmen are stored in a table that will be used inside the query associated
to SALES.RDL.

Any help will be appreciated.

RE: ONE REPORT for SEVERAL OUTPUTS

LBJOHN
11/12/2004 3:02:02 PM

Option 1
Write a datasource using a stored procedure, in the stored procedure, return
as many output tables into SQL database as the number of salesman. Design
reports based on the various output tables.

Option 2
Write a stored procedure, output one big table with groups of Salesman and
corresponding data.
In report design
Use List Data Regions, with Salesman as group. In Preview, the lists would
appear to have multiple reports on the number of Salesman,

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.