Report Distribution based on SQL Query in RDL

I need to create multiple reports with each report being sent to the specified user. For example, 3 Managers should each get their own report. A Stored Procedure receives a ManagerID parameter, so I need 3 instances of the report. I also need each report to be sent to its associated Manager:

Mgr ID Manager Name 1 John Q Manager 2 Jane Q Manager 3 Jack O Lantern

I set up a rss file to run the report and can run it multiple times, passing in a different ID value each time, but it will not be data driven because I must hard-code the parameters in the ReportParmaters object of the report for each execution.

Is there a way, either by designing the report in VS2005 or on the Reporting Services server, to accomplish what I'm intending to do?

Did you already have a look on the datadriven subscription option in Reporting Services ? That would exactly fit your needs.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Report Designer RDL Generator APIs

I'm just wondering - is there a way to use MS Report Designer's API's to
generate the actual RDL file with all groupings, sortings, etc., as it is
done using the Report Wizard. I know, there is an example to generate a
simple RDL file, using XmlTextWriter approach to generate a file manualy
from scratch, but when it comes to multiple groupings , it seems too complex
to achive that goal. The idea is to simulate web based report designer,
allow the end user to choose columns, group and sort fields and to generate
a report on fly.
Any ideas?
Thanks.No, nothing about this is documented. However, in RS 2005 there will be two
product, the current Report Designer and Report Builder. Report Builder is
an end user tool. Here are some links (note that RS 2005 comes out in
November).
>>>>>>>>>>
Links originally provided by Robert Bruckner (MS)
RS 2005 feature / editions:
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
Some of the new RS 2005 features are shown in this whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
Product launch will happen in November 2005:
http://www.microsoft.com/presspass/misc/06-07flessner-teched05.mspx
Always a good place to find information about RS 2005 - the blog of our
group program manager:
http://blogs.msdn.com/bwelcker/default.aspx
>>>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:eeqKkblqFHA.3544@.TK2MSFTNGP15.phx.gbl...
> I'm just wondering - is there a way to use MS Report Designer's API's to
> generate the actual RDL file with all groupings, sortings, etc., as it is
> done using the Report Wizard. I know, there is an example to generate a
> simple RDL file, using XmlTextWriter approach to generate a file manualy
> from scratch, but when it comes to multiple groupings , it seems too
> complex to achive that goal. The idea is to simulate web based report
> designer, allow the end user to choose columns, group and sort fields and
> to generate a report on fly.
> Any ideas?
> Thanks.
>

Report Definition Language

Using VS 2005, I have created a piece of software that creates an RDL file using XML. However, although my data (though a DataView control) is showing as it should, and I can update this to create new data, I cannot get the RDL to display a variable which I change and use as a 'header text' to the report. The variable is shown the first time I display the RDL through a ReportViewer Control but remains static thereafter. The interesting thing is that when I view the XML through a third-party viewer, it shows the correct value stored in the variable.

For information, I am using a child form in a MDI to create the data that is fed into another child form that contains the ReportViewer. The MDI has been programmed so that the child forms are not closed and disposed of, but are hidden from view.

Has anyone any initial ideas of what I could do to flush or clear the RDL or any other relevant object?

Are you viewing the RDL in the report designer when this happens? Report Designer has a functionality to cache the data in preview (http://msdn2.microsoft.com/en-us/library/ms157366.aspx). You should be able to click on the refresh button to get new data.