Report Builder has a
Report Wizard, Data Wizard, and Web Wizard to automate the creation of reports.
Most often, you can create a report by starting with one of the wizards, and
then refining the report that the wizard creates using the data model view and
the layout view.
To
create a report using report wizard
1. If the Welcome dialog
box appears (the following screen), click Use the Report Wizard and click OK.
If the Welcome dialog box does not appear,
choose File->New->Report. Click Use the Report Wizard and click OK.
2.You will receive the
following screen unless you selected not to display it in the future
previously. Click next
3. Choose the type of
layout you would like to generate from following screen.
Click next
4. Select Report type;
this will affect report layout. you can
see the different layouts by clicking their corresponding buttons and looking
at the sample layout on the left. After you select the type you want and give
Tile of report
Click next
5. Choose a data source
and Click next
6. you need to build the
and placed your query as below and click Next
7.If you did not connect
the database, connect database and click on Next
8. Select the fields you
would like to display in the report in the order you want as shown in the next
screen. Then click Next
9.Select the fields you
would like to display in the report in the order you want as shown in the next
screen. Then click Next
10.If you want change
label of report columns you can change in following screen and click on Next
11.If you choose any
template, fonts, colors, line widths and structure for your report and click Next and click finish you can find report out as below
No comments:
Post a Comment