Reporting in visual studio 2005 an in depth look at reporting internals
Download
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


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