Hi Trent,



First, I know this could be a long topic and as such, I would ask you to take your time responding and also I know this is not directly related to SF, but you have done great things with RSS and I hope you can share some tricks with us.



I got to a point in Report Sharp Shooter (RSS) where I find myself doing many repetitive things per report and probably I am missing something in how to properly take advantage of RSS to handle many reports.



Up to now I have been doing one or two reports per form and I do the following:

- Add a ReportManager control, BBS for my reports and add my reports (using InlineReports). So far I have a Master Report which I use with all reports, so at least I don't have to do that all the time.

- For each report I have to create the following classes:

ReportDataSource.vb

ReportBBS.vb

ReportBO.vb

Of course using the SF Custom BBS wizard, these steps are easy, and I follow the same class patter used in StrataFlix.



Now I want to create a Report Center form to manage and allow End User to run reports, but don't know how would I handle the following:

- Sync my report manager table with data to run the reports, in other words if I have several reports records, when the user select a report, how to tell the ReportManager which report to run? can this be added on the fly or should I create all reports definition in the ReportManager?



- How would I optimize the process so I can re-use and run the same report from several forms?



- RSS saves the report definition in an rst file, should this file be included in the project?



I created my own preview form which works really great with a lot of functionality I added. For now I do not allow End User to make modifications to the report, but I did manage to add the feature for me to design a report while previewing, this way with the data from the BSS it is easier to design the report layout while previewing it.



Any other tip you can offer?



Thanks.

Edhy Rijo