Shulou(Shulou.com)06/02 Report--

This article is about how to use Devexpress's report controls to implement data reports. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

We will describe how to use Devexpress's report controls to implement data reports, and we will implement data reports in the following steps:

Create a project and add a report

Bind report data

Design report format

Add a report control

Show preview results

The first step has been introduced in the first blog, so let's start directly from the second step of binding report data.

1. Bind report data

First, click add report data Source (Add Report Data Source) as shown in the picture.

Next, click DataBase to enter the data source selection interface. By default, the data connection that exists in this project is selected, and we choose the first item to add the Access data source ourselves.

Then fill in the name of the data source, and the data connection will be saved in this project, and we can call this connection elsewhere.

Now to add data to the data source, the first way is to enter the SQL statement directly in the input box, and the second is to click Run Query Builder to open the data selection interface. We will use the second method to get the data.

The picture introduces the functions of each part. After selecting the data, we can click the first button in the lower left corner to preview the corresponding data.

Finally, after the data is selected, we will see the data source we added in Components in Report Explorer. In Field List, we can drag and drop the corresponding parameters to the report design view.

two。 Design report format

Go back to the report design interface and follow the picture steps to open Report Editor.

Add headers (ReportHeader) and footers (PageFooter) to the Report Editor, and you can also modify parameters for other parts of the report here.

3. Add a report control

Next, drag and drop five XRLabel controls and two XRLine to the design view, modify each parameter according to your preference, and then drag and drop vipid, vipcard, vipname and givetime from Field List to the design view and arrange them.

Then we add the page number in PageFooter, drag XRPageInfo from the control bar to PageFooter, and change the Format (display format) to "Page {0} of {1}".

We can see the structure of the whole report in Report Explorer.

4. Show preview results

Click the Preview button below Design view to preview the report.

Since we modified it on the basis of the previous blog, we clicked on the preview, print and edit buttons to see the results.

Preview

Print (print directly)

Editing

We can also export it to the following format in the preview interface.

Export to Excel tabl

Thank you for reading! On "how to use Devexpress report controls to achieve data reports" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.