Transcript ASP+ HTTP Runtime

Reporting
In
Visual Studio 2005
An in-depth look at Reporting Internals
Vijay
Shandilya
Software Engineer
.NET Elite Team
Aithent Technology
Agenda



.Net Reporting
Report Viewer Control
Drill-down







Type
Features
Guide Lines
Menu Items
Tools Support
Expressions
Designing Tips
.Net Reporting



Two way to reporting in .Net
 Crystal Report (Requires additional licenses.)
 Report Viewer Control (new component added)
ReportViewer Control
 The ReportViewer Web server control
 The ReportViewer Windows Forms control
ReportViewer Web server control
 Local processing mode
 Remote processing mode
Processing Mode


Local processing mode
 Refers to report processing that is performed by the
ReportViewer control within the client application.
 All report processing is performed as a local process
using data that your application provides.
Remote processing mode
 Refers to report processing that is performed by a SQL
Server 2005 Reporting Services report server.
 In remote processing mode, the ReportViewer control is
used as a viewer to display a predefined report that is
already published on a Reporting Services report server.
 All processing from data retrieval to report rendering is
performed on the report server.
Report Definition Language




A report definition contains data retrieval and
layout information for a report.
Report Definition Language (RDL) is an XML
representation of this report definition.
RDL is an open schema; can extend RDL
with additional attributes and elements.
In RDLC here ‘C’ stand for Client Side.
Kind of Reports

Freeform reports


Multicolumn reports


Data exploration through links
Interactive reports


Present data in contiguous columns.
Drill through reports


Composed of data regions & report items.
Include links, bookmarks, document maps.
Simple reports

Include a single table or chart.
Reporting Features





Expressions for calculating and aggregating data, and/or to
support conditional formatting.
Actions to support links, bookmarks, and document maps in
HTML reports.
Parameters, filters, sorting, and grouping functionality so that
you can retrieve and organize the data with precision.
Support for adding custom code assemblies so that you can
provide dynamic functionality or special features in a report.
Run-time functionality so that users can navigate a large report,
search for specific data, export the report to a file, print the
report, and more.
The Report Viewer Control

Report Menu
 Report Parameter
The Report Viewer Control

Report Menu

Embedded Images
The Report Viewer Control

Report Menu
 Report Data Sources
The Report Viewer Control

Report Menu

Report Properties
Add Code, Reference, Class, Assembly


Type the methods to be used within the report.
Code must be written in Microsoft Visual
Basic.
References.


Lists the assemblies that the report references.
Classes.

Lists the instance classes that are used by the
report.
The Report Viewer Control

The Tool Box









Text Box
Line
Table
Matrix
Rectangle
List
Image
Sub report
Chart
Report Viewer Control
Page Header
Body
Page Footer
Width
The Report Viewer Control

Text Box
 Format : To format string
 HideDuplicate : To hide duplicate in a scope
 Padding : Pad left or right space
 Value : Value of text box
 WritingMode : Horizontal Or Vertical
Report Viewer Control

Table Properties





Group
Filter
Sorting
Header
Footer
Table Header
Table Detail
Table Footer
Group 1
Report Viewer Control

Matrix Properties




Group ,Filter, Sorting
GroupsBeforeRowHeaders
Column
LayoutDirection
Position (SubTotal)
Row
Data
Total
Report Viewer Control

Rectangle
Report Viewer Control

List
 Group
 Filter
 Sorting
Report Viewer Control

Image
 Source
 Value
 Action
 MIMEType
 Sizing
Report Viewer Control

SubReport


ReportName
Parameter
Report Viewer Control

Expression

Globals








Execution Time
Page Number
Total Pages
Report Folder
Report Name
Parameter
Fields
DataSets
Report Viewer Control

Expression

Operators




Arithmetic : +, -, ^, *, /, \, Mod
Comparison : <, <=,=>, >,= ,<> ,Like, Is
Concatenation : & ,+
Logical : And , Not, Or, Xor, AndAlso, OrElse
Report Viewer Control

Expression

Common Function








Text : Trim, LCase, Replace, Split, Format etc.
Date & Time : CDate, DateDiff, DatePart, Month etc.
Math : Abs, Min, Max, Rnd, Pow, Sqrt etc.
Inspection : IsNumeric, IsNothing, IsDate etc.
Program Flow : Choose, IIf, Switch
Aggregate : Avg, Count, CountDistinct, CountRow
Conversion : CDate, CChar, CInt, CBool
Miscellaneous : Previous, RowNumber etc.
Use Expression
Report Viewer Control



Property:
 PrintOnLastPage
 PrintOnFirstPage
Margin:
 Set Left : 0.5
 Set Right : 0.5
To Show Total on Footer
 Create a textbox which has total field.
 Hide it to report body OR create Fore Ground Color as
the back ground color.
 Use Report.Items(“txtTotal”).value to show total on the
footer
Report Viewer Control




vbCrlf
vbTab
Custom Report Items
=Int((RowNumber(Nothing)-1)/10)
Resources


www.msdn2.com
www.codeproject.com