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

1. Reporting In Visual Studio 2005An in-depth look at Reporting Internals Vijay Shandilya Software Engineer .NET Elite Team Aithent Technology

2. Agenda • .Net Reporting • Report Viewer Control • Drill-down • Type • Features • Guide Lines • Menu Items • Tools Support • Expressions • Designing Tips

3. .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

4. 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.

5. 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.

6. 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.

7. 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.

8. The Report Viewer Control • Report Menu • Report Parameter

9. The Report Viewer Control • Report Menu • Embedded Images

10. The Report Viewer Control • Report Menu • Report Data Sources

11. The Report Viewer Control • Report Menu • Report Properties

12. 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.

13. The Report Viewer Control • The Tool Box • Text Box • Line • Table • Matrix • Rectangle • List • Image • Sub report • Chart

14. Report Viewer Control Width Page Header Body Page Footer

15. 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

16. Report Viewer Control • Table Properties • Group • Filter • Sorting • Header • Footer Group 1 Table Header Table Detail Table Footer

17. Report Viewer Control • Matrix Properties • Group ,Filter, Sorting • GroupsBeforeRowHeaders • LayoutDirection • Position (SubTotal) Column Data Total Row

18. Report Viewer Control • Rectangle

19. Report Viewer Control • List • Group • Filter • Sorting

20. Report Viewer Control • Image • Source • Value • Action • MIMEType • Sizing

21. Report Viewer Control • SubReport • ReportName • Parameter

22. Report Viewer Control • Expression • Globals • Execution Time • Page Number • Total Pages • Report Folder • Report Name • Parameter • Fields • DataSets

23. Report Viewer Control • Expression • Operators • Arithmetic : +, -, ^, *, /, \, Mod • Comparison : <, <=,=>, >,= ,<> ,Like, Is • Concatenation : & ,+ • Logical : And , Not, Or, Xor, AndAlso, OrElse

24. 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.

25. Use Expression

26. 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

27. Report Viewer Control • vbCrlf • vbTab • Custom Report Items • =Int((RowNumber(Nothing)-1)/10)

28. Resources • www.msdn2.com • www.codeproject.com