Hi Trent,

I am about to start working on some reports for my 1st SF project, for now I will used the free version of Report SharpShooter and honestly I have no idea where to start even to create the report and use the BBS with it.

Do you think you guys could put together a simple quick sample report in StrataFlix using Report SharpShooter?

You already included 3 reports using MS report, but I am really stuck on this and would like to use Report SharpShooter instead.

Edhy Rijo

LOL!

Hi Ivan,

How would you handle a report for a One 2 Many relation like (Customers->Orders->OrderItems)?

Do we have to create a BSS for each table?

P.S.

Sorry I keep asking about this, but I have not other experience with report writers except for VFP.

Edhy Rijo

Yes.  You will create a BBS for each each table in question.  StrataFlix actually shows you how to do this.  If you look at the movie profile report or the people profile report, you will see that each BO that will be used has its own reporting BO and BBS.  The root object will then have the private fields for each of the BBS classes that need to be exposed.

For example, in the People Profile Report, the PeopleBO is the root BO for this report.  If you look at this class, you will see that there are two additional exposed child tables: MovieCast and PeopleImages.  These are children tables of PeopleBO.  If I were to have a grandchild, for example, if MovieCast had another child, then I would open up the MovieCastBO and add all of the BBS classes that are children of this class. 

Also, look at the properties of the exposed BBS classes and you will see how the filter is applied to each child BO so that it syncs up with the parent record.

Thanks Trent.

I will review those classes in detail. 

Also I noticed that in Ivan's sample the RSS preview window is created and in StrataFlix you have a custom Preview Form to handle all reports and it looks like a better approach.  Would you guys consider adding a RSS version report to StrataFlix using the same nice logic as the existing MS reports?

Edhy Rijo

Hey Edhy.

Have a look at the Report Sharp-Shooter samples, there are a lot of things demonstrated there. Check the CustomDesignerViewer folder.

In short, you just add a new form to your project and drop a Perpetuum ReportViewer control in it.

Have a look at the same sample attached.

Hope it helps.

Thanks Ivan,

It does help a lot.  I will check the samples as suggested, and the attached sample is very clear.

Edhy Rijo

Great to hear that.