Creating a report from scratch is a lengthy process, and while FlexReport Designer reduces the amount of code you need to write, you still have to walk through all the individual steps. That’s where Report Wizard comes in: for simple reports, you can easily step through the tabs and have a finished report in no time. For more complex reports, the basics are covered and you can focus on the more complex tasks. Let’s look at the individual components of a report.
Coding these items manually would be a long, unnecessarily tedious process. The Designer will go a long way in assisting with layout and themes, but when you’re creating a basic report and know the answers to these questions at the start, the Wizard allows you to deploy a full report in only 5 steps.
Choose your data provider from a list of available providers and set the path to your datasource and click Next. Select the data provider. Select the database. Choose the table, view, or stored procedure, and then click Next: Select the datasource. The data provider was easy to choose; the connection string is automatically set, with no manual coding; and all tables, views, and stored procedures are listed in a single window. Alternately, you can provide a SQL Query on your own, if you want data from multiple tables, or have any special requirements: Write a SQL query.
This step's greatest advantage is that you can set grouping at a very early stage of report design. As you make additional edits in the Designer, your groups and details will be clear. Simply drag the fields from Available to Groups and Detail. Select data fields to display. Select a grouping field.
Basic, ungrouped reports have three layout options:
If your report needs grouping by a field, you'll get more options:
Let's choose a report grouped by CategoryID. Good news: you're 90% finished!
Name your report. That's it! Now you can view your report in Preview: Preview your report. The report you see is ready to use. The Header and Detail sections are automatically styled and distinguished; groups are well-identified; the layout of the report is neatly arranged; and the theme is attractive. If you have further requirements—such as adding calculations to your report—you can go back to the Design View and modify the report. For more information on FlexReport features, refer to FlexReport for WinForms documentation.