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