reporting in visual studio 2005 an in depth look at reporting internals
Download
Skip this Video
Download Presentation
Reporting In Visual Studio 2005 An in-depth look at Reporting Internals

Loading in 2 Seconds...

play fullscreen
1 / 28

Reporting In Visual Studio 2005 An in-depth look at ... - PowerPoint PPT Presentation


  • 158 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Reporting In Visual Studio 2005 An in-depth look at ...' - liam


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
reporting in visual studio 2005 an in depth look at reporting internals

Reporting In Visual Studio 2005An in-depth look at Reporting Internals

Vijay Shandilya

Software Engineer

.NET Elite Team

Aithent Technology

agenda
Agenda
  • .Net Reporting
  • Report Viewer Control
  • Drill-down
    • Type
    • Features
    • Guide Lines
    • Menu Items
    • Tools Support
    • Expressions
    • Designing Tips
net reporting
.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
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
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
Kind of Reports
  • Freeform reports
    • Composed of data regions & report items.
  • Multicolumn reports
    • Present data in contiguous columns.
  • Drill through reports
    • Data exploration through links
  • Interactive reports
    • Include links, bookmarks, document maps.
  • Simple reports
    • Include a single table or chart.
reporting features
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
The Report Viewer Control
  • Report Menu
    • Report Parameter
the report viewer control1
The Report Viewer Control
  • Report Menu
    • Embedded Images
slide10

The Report Viewer Control

  • Report Menu
    • Report Data Sources
the report viewer control2
The Report Viewer Control
  • Report Menu
    • Report Properties
add code reference class assembly
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 control3
The Report Viewer Control
  • The Tool Box
    • Text Box
    • Line
    • Table
    • Matrix
    • Rectangle
    • List
    • Image
    • Sub report
    • Chart
report viewer control
Report Viewer Control

Width

Page Header

Body

Page Footer

the report viewer control4
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 control1
Report Viewer Control
  • Table Properties
    • Group
    • Filter
    • Sorting
    • Header
    • Footer

Group 1

Table Header

Table Detail

Table Footer

report viewer control2
Report Viewer Control
  • Matrix Properties
    • Group ,Filter, Sorting
    • GroupsBeforeRowHeaders
    • LayoutDirection
    • Position (SubTotal)

Column

Data

Total

Row

report viewer control4
Report Viewer Control
  • List
    • Group
    • Filter
    • Sorting
report viewer control5
Report Viewer Control
  • Image
    • Source
    • Value
    • Action
    • MIMEType
    • Sizing
report viewer control6
Report Viewer Control
  • SubReport
    • ReportName
    • Parameter
report viewer control7
Report Viewer Control
  • Expression
    • Globals
      • Execution Time
      • Page Number
      • Total Pages
      • Report Folder
      • Report Name
    • Parameter
    • Fields
    • DataSets
report viewer control8
Report Viewer Control
  • Expression
    • Operators
      • Arithmetic : +, -, ^, *, /, \, Mod
      • Comparison : <, <=,=>, >,= ,<> ,Like, Is
      • Concatenation : & ,+
      • Logical : And , Not, Or, Xor, AndAlso, OrElse
report viewer control9
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.
report viewer control10
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 control11
Report Viewer Control
  • vbCrlf
  • vbTab
  • Custom Report Items
  • =Int((RowNumber(Nothing)-1)/10)
resources
Resources
  • www.msdn2.com
  • www.codeproject.com
ad