StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » sample report

sample report

Eric Leissler — Fri, 25 Dec 2009 15:10:11 GMT

Hi , Im back on this forum

I just want a sample example to made a sample report.

how il do ?

I made an bo on a sql vue

I made an BBS on this Bo

when i execute, my report is correct but no populate.

Have you a sample exemple because i need to understand the mécanisme .

thanks

bestregards

Eric

RE: sample report

Russell Scott Brown — Fri, 25 Dec 2009 15:10:11 GMT

Thanks!

RE: sample report

Les Pinter — Fri, 25 Dec 2009 08:46:06 GMT

Hi All,

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

RE: sample report

Eric Leissler — Thu, 24 Dec 2009 12:25:26 GMT

Hi les,

I will see your example tomorow a morning

very thanks

best regards

Eric

RE: sample report

Russell Scott Brown — Wed, 23 Dec 2009 20:23:50 GMT

Thanks.

I will vote for an example using SSRS too.

RE: sample report

Les Pinter — Tue, 22 Dec 2009 15:24:50 GMT

Hi Eric,

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

RE: sample report

Greg McGuffey — Tue, 22 Dec 2009 15:03:58 GMT

Thanks Eric!

Happy Holidays to all of you!

RE: sample report

Eric Leissler — Tue, 22 Dec 2009 11:00:14 GMT

hi,

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

best regards

Merry Christmas and Happy New Year to all

Eric

RE: sample report

Russell Scott Brown — Sun, 20 Dec 2009 12:32:49 GMT

Thanks. An explanation in English would be helpful. :)

RE: sample report

Eric Leissler — Sun, 20 Dec 2009 07:42:49 GMT

hi,

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

RE: sample report

Michel Levy — Sun, 20 Dec 2009 06:03:05 GMT

Hi,

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... :sick: )

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...:crying: 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.

RE: sample report

Edhy Rijo — Sat, 19 Dec 2009 11:25:28 GMT

[quote][b]Eric Leissler (12/19/2009)[/b][hr]hi,

excuse me, but i dont understand how to populate my report.

i have a Bo

i have a BBs on my BO

and after, what i have to do?

Thanks
Best regard[/quote]

No problem Eric. Just populate the BO the same way you do for your forms, either you should have a method in the BO that you will call to populate the BO or you will use a Dialog Browser like in StrataFlix to ask the user the filter values to populate the BO.

I know the method used in StrataFlix is not the easiest one (at least it was not for me when I was learning it :D) but at the end once I understood it has been the best way for me since I can have my custom Dialog Browser to filter the report data. I can not explain it in a single phrase how it works because it is link to several classes and logic, but what I did was to put some time into StrataFlix, setup some debugger breaks and follow the code, then start implementing the same logic in my application until it works.

RE: sample report

Eric Leissler — Sat, 19 Dec 2009 05:15:35 GMT

hi,

excuse me, but i dont understand how to populate my report.

i have a Bo

i have a BBs on my BO

and after, what i have to do?

Thanks
Best regard

RE: sample report

Edhy Rijo — Fri, 18 Dec 2009 13:56:32 GMT

Hi Gerard,

Yes, .Net have its own reporting tools which the StrataFlix sample uses, I use Report SharpShooter (RSS) because I need more than what is offered by the .Net like exporting to PDF/Excel, nice preview etc.

Eric, the report engine will use a BBS which internally use a BO, you simply use the BBS as the data source for the report, then populate the BO and execute the report. I am not familiar with the .Net reporting, but what the StrataFlix sample does is use a BrowseDialog to get the data to fill the BO that it is used by the BBS.

Take a look at the "SF Custom Business Binding Source" in the help file, this template will help you create a BBS with its own BO for reporting purpose.

RE: sample report

Ger Cannoll — Fri, 18 Dec 2009 11:05:28 GMT

Hi Edhy. I am currently looking at report writing , but did not realise there was an out of the box mechanism in .net (other than SSRS and Crystal) . Is there something else that comes standard in .net that facilitates creating reports ?

RE: sample report

Eric Leissler — Fri, 18 Dec 2009 10:50:57 GMT

Hi eddy,

I just want en sample report (myreport.rdlc)

I dont understand how to populate this report.

I downloaded stratafix but i dont understand the mecanism .

I search

thanks

Best regard

RE: sample report

Edhy Rijo — Fri, 18 Dec 2009 09:42:57 GMT

Hi Eric,

The StrataFlix sample project have 2 sample reports. You can download it from the "My Account" downloads. Also you can search the forums using the flag "Reports" and that may give you a couple of thread about reports.

Will you be using plain .Net reports or a 3rd party tool?