Kushal Tutorials - Document

Generate report in Kushal Project using MyFYI reporting Tool.

In the previous Section, you have learnt how to develop an application, in this Section you will learn Adding Reporting Capabilities to Kushal Application.

Reporting is one of the main components of any database application. After all, most of the applications are built ultimately to get the timely report. There are many popular reporting tools such as Crystal Report, Active Reports which are feature rich and widely used along with Visual Studio applications. One of the objectives of Kushal Projects was to keep the development cost minimum. We thus wanted to support a free reporting tool along with Kushal.

Hence, in Kushal, a Reporting tool called MyFYI is included, to create reports. However, that does not stop you including Crystal Report, Active Report or any other reporting tool of your choice.

In the sample project explained in the previous Section, 'Reporting' was not explained since this is an detailed topic by itself.

Now, create a simple Report in MyFYI and then call it from a Kushal Project

To do so, Open MyFYI, Click on 'New Report'

In 'Report Info Tab', select Table

In 'Connection Tab' select SQLite sinceyour database in SQLite

In Connection String Tab, provide Connection Sting for SQLite

Data Source=C:\Projects\Contact_Management\Contact_Management.s3db

You need not select anything in Parameter Tab

Provide SQL statement containing Field names that you want in the report.

Since you are creating an Address Book, you should provide SQL Statement which picks only required fields

Now by clicking on OK, a draft report will be ready.

Align fields in Report designer like the way you want to see them in the output

If you click on Preview tab - Instantly report will be generated.

But you should call this report from Kushal Project. So, save this RDL file with name Contact_Details.

You can call this report from Search Screen which you have already designed. You should add a button for generating a Report called 'Report'. In button properties change action type as "Show report". You should provide rdl file path in 'Report file name Properties'.

Now re-generate project and see how this report is getting generated.

Wow! Congratulations! Generating reports was never so easy.

Thank you for completing the tutorial. In the next topic, you will learn about various features of Kushal, so that you can understand strength of Kushal and give it a try.