Easy to do without visual studio,5-divided into reports

General report design, such as RDLC, Crystal Report, etc. , you need to install visual Studio. Provides report design interface design report by VS Design report. NET is very handy for developers. But for non-developer, install 4G a vs. and need license, the cost is a little higher. This article provides a second approach that does not use vs.

With the free Report Designer provided by ActiveReports (the green exe executable file), we are able to design the report and start the report design as follows:

who is suitable for reading this article?

• Report Designer
• Product Manager
• Demand Analyst

The necessary environment

• The. NET Framework 4.0 environment is installed
• MS Office Access 2007 and above version number

1th minute: Recognize Report Designer

Double-click "GrapeCity.ActiveReports.Samples.EndUserDesigner.exe" to open the report design interface such as the following

The overall style and visual Studio are easy to get started with, especially familiar with the visual Stuido interface.

This article uses the regional report to realize.

In the regional report. 14 report controls are available, including 6 controls for this article: (see the differences between regional reports and page reports)

• Label: Labels are used to display descriptive text. Can help users describe the data that is displayed in the report.

  
  

  
  

• textbox : A text box is a primary report control. It agrees to display and edit unformatted text directly.

  
  

  
  

• Picture: This control is used to display image files in a report and to control properties such as image size.

  
  

  
  

• Line: Lines visually draw boundaries or highlight specific areas in a report.
• reportinfo: Reportinfo controls allow you to display information such as page numbers, pages, and report dates at high speed.
• Barcode: Bar code is the width of a number of black bars and blanks, according to a certain coding rules, to express a set of information graphic identifier.

2nd clock: Configuring data sources and layouts

The following diagram is a description of the data map for the regional report, which corresponds to a detail of the corresponding report in a database.

After you understand the data mapping relationship. We start with the report design, we first configure the data source, and here we provide the Access relational database (at the top of this article).

By clicking the Database icon in the detail area of the Report Designer

You can open a data source view such as the following:

After the data source has been configured. Select DataSource1. Right-Joins the dataset, which is a SQL statement. You can get a DataTable-like DataSet object.

This blog uses the complete SQL for example below. The data source can be downloaded through this path (after downloading the attachment.) Unzip the file. Obtained nwind_chs_small.mdb file)

So=reccnt&siteid=us%2fdev&p=1&nq=new&qu=select&intlsearch=&boolean=phrase&ig=01 &i=09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?

So=reccnt&siteid=us%2fdev&p=1&nq=new&qu=select&intlsearch=&boolean=phrase&ig=01 &i=09&i=99 "data-mce-style=" color: #0000ff; " >select

Products-reorder quantities, products-discontinued, products-pictures, products-descriptions of products, categories-category names, categories. Description

so=reccnt&siteid=us%2fdev&p=1&nq=new& amp;qu=as&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-href=" http// Search.microsoft.com/default.asp?so=reccnt&siteid=us%2fdev&p=1&nq=new&qu=as&intlsearch= &boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" color: #0000ff; " >as category description, category. Picture

So=reccnt&siteid=us%2fdev&p=1&nq=new&qu=as&intlsearch=&boolean= Phrase&ig=01&i=09&i=99 "data-mce-href=" Http://search.microsoft.com/default.asp?so=RECCNT&siteid =us%2fdev&p=1&nq=new&qu=as&intlsearch=&boolean=phrase&ig=01&i=09&i=99 " data-mce-style= "COLOR: #0000ff;" >as category picture,

               

So=reccnt&siteid=us%2fdev&p=1&nq=new&qu=as&intlsearch=&boolean=phrase&ig=01&i= 09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=reccnt&siteid=us%2fdev&p=1& nq=new&qu=as&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" color: #0000ff; " >as suppliers, suppliers. Contact name, supplier. City, supplier. Address

so=reccnt&siteid=us%2fdev&p=1&nq=new&qu=from&intlsearch=&boolean=phrase&ig=01& I=09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1 &nq=new&qu=from&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" COLOR: # 0000FF; " >from (Supplier

So=reccnt&siteid=us%2fdev&p=1&nq=new&qu=inner&intlsearch=&boolean=phrase&ig=01 &i=09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p= 1&nq=new&qu=inner&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" color : #0000ff; " >inner

so=reccnt&siteid=us%2fdev&p=1&nq=new&qu=join&intlsearch=&boolean=phrase&ig=01& I=09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1 &nq=new&qu=join&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" COLOR: # 0000FF; " >join

               

so=reccnt&siteid=us%2fdev&p=1&nq=new&qu=join&intlsearch=&boolean=phrase&ig=01& I=09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1 &nq=new&qu=join&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" COLOR: # 0000FF; " >join

               

So=reccnt&siteid=us%2fdev&p=1&nq=new&qu=on&intlsearch=&boolean=phrase&ig=01&i= 09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=reccnt&siteid=us%2fdev&p=1& nq=new&qu=on&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" color: #0000ff; " >on products. Category ID = category. Category ID)

so=reccnt&siteid=us%2fdev&p=1&nq=new&qu=desc&intlsearch=&boolean=phrase&ig=01& I=09&i=99 "data-mce-href=" http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1 &nq=new&qu=desc&intlsearch=&boolean=phrase&ig=01&i=09&i=99 "data-mce-style=" COLOR: # 0000FF; " >desc

Since then, the data source configuration has finished, finished the report design, the following start to understand the report design requirements.

3rd minute: report Design requirements

• We want the result of the report to be similar to the following layout, report header, report data detail, report footer, which is similar to the overall style and the RDLC report
• At the same time, you can also present two-dimensional code, picture presentation format, report generation time, Report page and other information.
• Considering the lowest cost of future system migrations, we want to be able to reuse the lowest cost---a one-time, well-designed report in the WinForm, WPF, ASP. NET, and HTML5 platforms.

  
  

  
  

4th minute: Drag report Control Design Report

Multiple designer buttons have been added at the bottom of Report Designer. These buttons enable high-speed access to the Layout wizard, which brings many additional conveniences to the report template design.

Self-aligning line (snap Lines): Drag a control on the report design interface, and when the control is aligned with another control (or the boundary of a report area), the control that is dragged and the control that is aligned with it (or the boundary of a region of the report) appears with its own active snaplines. Make it easier for users to layout controls freely.

self-active grid alignment (Snap to Grid): Drag a control on the report design interface. The control aligns itself with its recent grid lines, which can be turned on or off according to the settings.

similar to Excel's own active scrolling feature (Excel-like Auto scrolling): Drag a control on the report design interface, when the dragged area is beyond the current display of the design interface, the design interface will move in accordance with the direction you drag, Until the edge of the report design interface.

pan mode: when you switch to panning mode, a hand cursor is displayed, and you can drag the report's design interface freely by pressing the left mouse button.

self-active dimension line (Dimension lines): When you drag a control on the report design interface, change the size of the control, the edge of the control automatically appears on its own dimension line, and the distance between the control and the report boundary is clearly known through the dimension line.

Report Control Dialogs: provides an easy way to set the related properties of a report control.

The Regional report layout displays three areas by default: header, detail, and footer.

You can add or remove headers and footers. Report header and end of report, you can also add 32 levels of grouped headers and footers (right-click on the report and select Insert .) Ability to insert report Header/Report footer and group header/group footer. ）。 Drag the controls in these areas to display the report data.

The report layout is saved in RPX format.

From a data field, drag a field to a report, such as a vendor name, contact, address, city, and so on

For line, barcode, and picture, you need to drag it from the left-hand toolbar.

Barcode and picture need to change the data ---TheDataField field in the Properties dialog box.

5th minute: Preview results, print, export

Preview the effects of viewing report results such as the following

export : In the design tool. file ---Export-Multiple file formats (HTML, PDF, Excel, etc.) can be exported.

Printing function. Print directly from the toolbar's Print button

What, do you have the impulse to design a report?

Green Report Design tool (decompression can be used, including C # source code)

Database (Download the attachment, unzip the file, get the Nwind_chs_small.mdb file)

Online documentation

In addition, the Green Report Designer provides the source code for you and your small partner to customize, such as the company logo and other personalized requirements.

(source code compilation is required to install ActiveReports installation authorization)

This article is used in C #. NET Green Edition, if need vb.net source code green design, please leave a message, announce your mailbox, send to you separately.

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

Easy to do without visual studio,5-divided into reports