I had previously posted a Crystal Reports example using a BBS; the attached is the SSRS version. The mechanism for adding a detail line in an .rdlc is a little strange you have to add a table, then drop textboxes on the detail row and select the fields for each.

Les

I will see your example  tomorow  a morning

very thanks

best regards

Eric

I will vote for an example using SSRS too.

Russ Brown (Using C#2010/SQL Server 2008)

   I should have built this example sooner; but better late than never. I did an example with Crystal Reports, which I use often and like. 

   In this example, I created a customer list ordered and grouped by Country, then built the report with the first 100 customers. In my example, the only form, Form1, is entirely occupied by a CrystalReportViewer. Here's the code:

      customersBO1  .fillTop100();

      rptCustomers rpt = new rptCustomers();
      rpt.SetDataSource(customersBO1.CurrentDataTable);

      TextObject t = rpt.ReportDefinition.ReportObjects["Title"] as TextObject;
      t.Text = "Customer Listing";
      crystalReportViewer1.ReportSource = rpt;

   Crystal has some peculiarities (like having to create an instance of a TextObject that points into the report, then assigning a text string to thë isntance. I wish they permitted a syntax like rpt.Title = "Customer Listing", or even rpt.ReportDefinition.ReportObjects["Title"] = "Customer Listing"; but unfortunately, that's not how it works.

   However, SF works equally well with SSRS. Let me know if you'd like a sample done with SSRS, or help on some specific issue.

Les

I this tha Michel will post an english help as soon as possible

best regards

Merry Christmas and Happy New Year to all

Eric

verry big thanks for Michel

I understand now the mecanism of report, bbs bo .

It's running veriy well now

I just think, if the help strata was made like the Michel LEVY explication, a lot of french developpers whoud make the developpent with strataframe !

best regards

Eric

I've sent to Eric (private mail) a step-by-step "How to?" (in french). As soon I 'll translate it in english, i'll put it on the forum.

Gerard, we used only native tools from Visual Studio 2008 and StrataFrame. with VS2005, i used Report SharpShooter, but VS2008 greatly improved the reporting. No need to other tools if you want to export in pdf or excel sheets, I found the VS2008 reports really nice, and much simpler than ReportSharpShhoter (and of course than Crystal... )

The trouble in designing a report with VS2008 comes with the fact that VS automatically adds a BindingSource (a native one, not a SF customBBS) on the form where you build your report.
If you do all in code, there is no problem, because you define the data source for your report in the code.
But if you put your CustomBBSs in your toolbox, end then drop visually the cusBBS on the form and link it to your report in the same way (visually), ah... then VS2008 says "he, and MY data sources?" and you need to check again that your cusBBS is always the datasource selected for the report, and you may delete this native binding source from you report.

And what Eric was missing to populate the BO was how to "call" the fill method defined on the BO, from the form through the cusBBS. And as all our BOs are sub-classed from a BO class where reside all our generic fill methods, he didn't see how to retrieve these methods from the cusBBS.