integrating crystal reports into.net 2.0 applications reggie gentle, data management group

Integrating Crystal Reports Into .Net 2.0 Applications

Reggie Gentle, Data Management Group

Best Practices and .Net 2.0 CompatibilityModifying Database Log On Info at RuntimeModifying Record Selection and ParametersModifying the Report ViewerUsing the Crystal Reports EngineQ&A

Topics

The Real World

Typical Usage Scenarios we have used this SDKFull Client ApplicationsDepartmental Web SolutionsLimited Usage / Very Fast Reports Delivered via WebQuick Hit / Evaluation Prototype Development

Best Practices Keep reports short and the files size small Ensure the report is achieving its best performance by “pushing the

query to the database” Avoid letting the Crystal Report Viewer handle the parameter prompts Understand the difference between Managed and Unmanaged

reporting

.Net 2.0 Compatibility Compatibility with Visual Studio 2005

Best Practices and Gotcha’s

Modifying Database Log On Info at Runtime

Business Case Client: US Navy Environment: Various ASP and .Net Applications Challenge: Deploying web applications in a highly, secured and

process documented environment, developers had to make report data sources dynamic when moving from development, test, and production.

Solution: Dynamically change the database login information at runtime based on the server environment it is running. This allows one unmodified code line to exist on all environments.

By Named Tableusing CrystalDecisions.Shared;…TableLogOnInfos infos = new TableLogOnInfos();TableLogOnInfo info = new TableLogOnInfo();ConnectionInfo conn = new ConnectionInfo();

conn.ServerName = "(local)";conn.DatabaseName = “MyDatabase";conn.UserID = "sa";conn.Password = "@ww@rr3"; info.ConnectionInfo = conn;info.TableName = "Customer";infos.Add(info);

crystalReportViewer1.LogOnInfo = infos;

Using The Crystal Reports Engineusing CrystalDecisions.CrystalReports.Engine;MyReport myReport = new MyReport();ConnectionInfo conn = new ConnectionInfo();

conn.ServerName = "(local)";conn.DatabaseName = “MyDatabase";conn.UserID = "sa";conn.Password = "@ww@rr3";

TableLogOnInfo tableLogOnInfo;Tables tables = myReport.Database.Tables;Foreach ( Table t in tables ){

tableLogOnInfo = t.LogOnInfo;tableLogOnInfo.ConnectionInfo = conn;t.ApplyLogOnInfo( tableLogOnInfo );

Modifying Log On Info DemoDemo using Winforms

Modifying Record Selection and Parameters

Business Case Client: FBI Academy Environment: Web Application Challenge: Integrating reports in a contextual way where the reports

data reflects the same records that the user is interacting with in the application. This allows the user run a report without leaving the application and supply parameters to it.

Solution: Call reports from within the application and pass filters that restrict the data.

Modifying Record Selection SelectionFormula property of the CrystalReportViewer

…String SelFromula = “{Customer.ID} = 2”;CrystalReportViewer1.SelectionFormula = selForumla;…

Modifying Parameters Discrete parameters Ranged parameters Ranged and Discrete parameters

Modifying Discrete ParametersParameterFields fields = new ParameterFields();ParameterField field = new ParameterField();ParameterDiscreteValue dvalue = new ParameterDiscreteValue();

field.Name = "OrderDate";DateTime d = DateTime.Parse("9/1/2006");dvalue.Value = "9/1/2006";field.CurrentValues.Add(dvalue);

fields.Add(field);crystalReportViewer1.ParameterFieldInfo = fields;

Modifying Ranged ParametersParameterFields fields = new ParameterFields();ParameterField field = new ParameterField();ParameterRangedValues rvalue = new ParameterRangedValues();

field.Name = "OrderAmount";

rvalue.StartValue = 500;rvalue.EndValue = 2500;field.CurrentValues.Add(rvalue);

fields.Add(field);crystalReportViewer1.ParameterFieldInfo = fields;

Modifying The Report Viewer

Business Case Client: FBI Academy Environment: Web Application Challenge: One goal of integrated reports is to blend the report

viewer with the application. It is thus desirable to turn off certain viewer buttons and change other attributes to achieve this.

Solution: When calling reports, modify viewer attributes.

Showing and Hiding buttons Properties of the CrystalReportViewer

• ShowCloseButton• ShowExportButton• ShowGoToPageButton• ShowGroupTreeButton• ShowPageNavigateButtons• ShowRefreshButton• ShowTextSearchButton• ShowZoomButton• ShowPrintButton

Using Viewer Methods Methods of the CrystalReportViewer

• PrintReport()• RefreshReport()• ExportReport()• GetCurrentPageNumber()• ShowFirstPage()• ShowLastPage()• ShowNextPage()• ShowPreviousPage()

Modifying The ReportViewer DemoDemo using Winforms and Web

Using the CrystalReports Engine

Business Case Client: OEM Software Environment: Hosted Web Application Challenge: Provide customized reports for each clients reports. Solution: Dynamically modify the report using the CrystalReports

engine to change the reports header as well as modify calculations.

Customizing report at runtime Formatting sections Customizing report formulas

Using the CrystalReports Engine

CrystalReport Engine DemoDemo using Winforms

Questions Reggie Gentle, Consultant, Data Management Group I will repeat questions to ensure everyone can hear

Contact information Email: Reggie.Gentle@DataManagementGroup.com

integrating crystal reports into.net 2.0 applications reggie gentle, data management group

Documents

intro networks webinar with reggie smith april 2009

howard carter – senior consultant hcarter@microsoft reggie...

reggie dupre brwiv

managing customizations and change in an epm …...managing...

2 reggie dyson show big flyer and multimedia pages

gentle leader - zooplus.fr from beaphar gentle... · gentle...

reggie bush

gentle, fast and effective crystal soaking by acoustic...

full page fax print - reggie birch decoys

keynote - reggie bradford - oowbr 2016

reggie codrington's epk

the blueprint for black sovereignty by bro. reggie

yoga schedule - crystal springs resortyoga schedule...

date: place:...

more than our owner an mffl - dallas...

reggie brown florida tomato assoc gave harvard report

engage prague 2016: reggie bradford, oracle

emergency evacuation procedures reggie long r3long@ucsd.edu...

reggie costume design

entering into the per ankh by bro. reggie