 Aspose.Report for .NET comes bundled with a very rich user interface for Web and WinForms. Web interface allows you to set alias to fields, set fields to be visible/invisible, display human-readable query statement and supports custom CSS style. It also gives you the ability to show SQL statement window, OrderBy statement window, Select statement window and Where statement window. Aspose.Report's WinForms interface gives you the ability to show/hide SQL statement window, serialize the state of the component and restore the serialized state. The important GUI features of Query Building component can be summarized as follows: - Localize the interface
- Set aliases to the fields
- Set fields to be visible/invisible
- Show Human-Readable query statement
- Apply custom CSS
- Show SQL statement window
- Show Order By statement window
- Show Select statement window
- Show Where statement window
Building Queries in Web Applications  Aspose.Report for .NET control can easily be dragged and dropped on to a web form. The DataTable can be bound to any datasourse. Aspose.Report for .NET supports multiple tables as well as advanced condition input. Parsing of SQL statement, Select statement, Where statement and OrderBy statement is also supported by Aspose.Report for .NET.
Aspose.Report for .NET enables you to work with extremely large DataSets by providing you the ability to generate queries without any data and then use those queries to load data from a database.
The important query building and data filtering features of Query Building component can be summarized as follows: - Set Data Table as Data Source
- Advanced condition input
- Parse SQL statement
- Parse Select statement
- Parse Where Statement
- Parse Order By Statement
- Get Filtered Data View
- Get Filtered Data Table
- Get Filtered Data Set
- Get SQL statement
- Get Select statement
- Get Where statement
- Get Order By statement
- Get Row Filter statement
- Output to webpage
- Output to documents (Word, Excel, PDF etc) by integrating Aspose.Report for .NET with some other Aspose products like Aspose.Words for .NET, Aspose.Cells for .NET and Aspose.Pdf for .NET.
Building Queries in WinForms Applications  Aspose.Report for .NET control can easily be dragged and dropped on to a win form. The DataSet can be bound to any datasourse. Aspose.Report for .NET supports querying from multiple tables joined in a DataSet as well as advanced condition input.
Charting Features  Aspose.Report for .NET provides support for 21 different chart types plus their variants. Aspose.Report for .NET also allows stylish effects including 3D, transparency, gradient, anti-aliasing and background image etc. In addition to this you have the option of creating charts via API, XML or both. You can also export your charts to SWF (Macromedia Flash) very easily. The important charting features of Aspose.Report for .NET can be summarized as follows: -
Choose from 21 most popular chart types and their variants
- Save chart in any .NET supported image format
- Save chart in Macromedia Flash format with click ability
- Load chart from an XML file
- Multiple chart areas
- Combine different chart types on a single chart
- Bind data series to various data sources such as collection,
- SqlDataReader, DataView and DataRowCollection
- Data labels for any data point on the chart
- Primary and secondary X and Y axis
- Automatic or custom axis minimum, maximum and interval
- Automatic axis labels and custom labels
- Customizable major and minor grids and tick marks
- Customizable axis and data point labels
- Customizable legend box
- Chart and axis titles
- 3D effect
- Frame border
- Background image
- Anti-alias
- Transparency
- Gradient
- Custom drawing
- Gloss effect in Pie charts
Supported Chart Types  Following chart types are supported by Aspose.Report for .NET
- Area
- Bar
- Bubble
- Contour
- Candlestick
- Cube
- Curve
- Curve Area
- Doughnut
- Gantt
- High Low Close
- Line
- Open High Low Close
- Pareto
- Pie
- Pyramid
- Point
- Radar
- Scatter
- Step
- Surface.
Report Conversion Features  Aspose.Report for .NET allows you to render your RDL or RDLC reports as images. You can convert your reports to any .NET supported image format. See Working with ReportConverter for more details.
|