Crystal report Drill down tab won't print(WPF)

Question

The issue is when I open a drill down report in runtime I will see the view I want but when I select print it only prints the main page every time.
I have found that exporting to a PDF works. we need the runtime in our software application to allow the drill down level to print not the main report page

Any help would be greatly appreciated, thanks

version of the SDK : 13.0.15.1840

Rajanikant Hawaldar · Answer

using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Windows; using System.Windows.Controls; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Diagnostics; using System.IO; using Npgsql; using DealerBuilt.Data; using DealerBuilt.Data.Omnis; using DealerBuilt.Models.Crystal; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using NpgsqlTypes; using DealerBuilt.Logging.File; using CrystalViewer.Models; namespace CrystalViewer { /// /// Interaction logic for MainWindow.xaml /// public partial class CrystalWindow : Window { private string _userName; private long _lySetupLocationId _slSetupLocationId _acSetupLocationId; private string _newParameterProfileName = null ; private List string > _availableCategories; private Data _data; private UserAccess _userAccess; private List _reportUsers; private List _profiles = new List (); private long [] _releaseSeqs = new long [0]; private GridLength _leftPanelWidth = new GridLength(235); private ReportDocument _currentlyDisplayedReport; private CrystalReport _currentlyDisplayedReportModel; private string _basePath; private SAPBusinessObjects.WPF.Viewer.ReportAlbum currentReportAlbum = null ; private ILog Log = new LogFile( CrystalViewer.{user}.log ); public CrystalWindow( long acSetupLocationId long lySetupLocationId long slSetupLocationId string userName UserAccess userAccess) { Log.Debug($ acSetupLocationId=[{acSetupLocationId}] lySetupLocationId=[{lySetupLocationId}] slSetupLocationId=[{slSetupLocationId}] userAccess=[{userAccess.ToString()}] ); _userAccess = userAccess; var connectionDatas = DealerData.GetConnectionDatas(); _data = new Data(connectionDatas); Log.Debug($ Database=[{_data.GetConnection().Database}] ); InitializeComponent(); Initialize(acSetupLocationId lySetupLocationId slSetupLocationId userName); } public CrystalWindow( string connectionString long acSetupLocationId long lySetupLocationId long slSetupLocationId string userName) { // for testing _userAccess = new UserAccess( true ); Log.Debug($ acSetupLocationId=[{acSetupLocationId}] lySetupLocationId=[{lySetupLocationId}] slSetupLocationId=[{slSetupLocationId}] userName=[{userName}] ); _data = new Data(connectionString.CheckSSL()); Log.Debug($ Database=[{_data.GetConnection().Database}] ); InitializeComponent(); Initialize(acSetupLocationId lySetupLocationId slSetupLocationId userName); } public SAPBusinessObjects.WPF.Viewer.SearchEventHandler Search; public void Initialize( long acSetupLocationId long lySetupLocationId long slSetupLocationId string userName) { Log.Debug( Starting Initialize()... ); if ( string .IsNullOrWhiteSpace(_data.ConnectionString)) { throw new Exception( Internal error: invalid connection string ); } _userName = userName; _lySetupLocationId = lySetupLocationId; _slSetupLocationId = slSetupLocationId; _acSetupLocationId = acSetupLocationId; _availableCategories = new List string >(); ReportImportPanel.Visibility = Visibility.Hidden; ReportViewer.ViewerCore.ReuseParameterWhenRefresh = false ; ReportViewer.ViewChange += ReportViewerOnViewChange; ReportViewer.Owner = this ; ReportViewer.ClickPage += reportViewer_ClickPage; using (var dbConn = _data.GetOpenConnection()) { if (!Catalog.IsColumnPresent( crreportsetup  releaseseq  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = ALTER TABLE crreportsetup ADD COLUMN releaseseq int8; ; cmd.ExecuteNonQuery(); } } if (!Catalog.IsColumnPresent( crreportsetup  isauthorized  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = ALTER TABLE crreportsetup ADD COLUMN isauthorized bool; ; cmd.ExecuteNonQuery(); } } if (!Catalog.IsTablePresent( crparameterprofiles  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = @CREATE TABLE public .crparameterprofiles ( seq bigserial NOT NULL profilename text NOT NULL reportseq int8 NOT NULL username text CONSTRAINT crparameterprofiles_pkey PRIMARY KEY (seq) ) WITH (OIDS=FALSE); CREATE INDEX crparameterprofiles_reportseq_idx ON public .crparameterprofiles USING btree (reportseq);; cmd.ExecuteNonQuery(); } } else { if (!Catalog.IsIndexPresent( crparameterprofiles_reportseq_idx  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = @ CREATE INDEX crparameterprofiles_reportseq_idx ON public.crparameterprofiles USING btree (reportseq); ; cmd.ExecuteNonQuery(); } } } if (!Catalog.IsTablePresent( crparametervaluelistitems  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = @CREATE TABLE public .crparametervaluelistitems ( seq bigserial NOT NULL parameterseq int8 NOT NULL minvalue text isminvalueincluded bool NOT NULL maxvalue text ismaxvalueincluded bool NOT NULL singularvalue text CONSTRAINT crparametervaluelistitems_pkey PRIMARY KEY (seq) ) WITH (OIDS=FALSE); CREATE INDEX crparamlistvals_paramseq ON public .crparametervaluelistitems USING btree (parameterseq);; cmd.ExecuteNonQuery(); } } if (!Catalog.IsTablePresent( crparametervalues  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = @CREATE TABLE public .crparametervalues ( seq bigserial NOT NULL profileseq int8 NOT NULL parametername text NOT NULL isvaluelist bool NOT NULL minvalue text isminvalueincluded bool NOT NULL maxvalue text ismaxvalueincluded bool NOT NULL singularvalue text CONSTRAINT crparametervalues_pkey PRIMARY KEY (seq) ) WITH (OIDS=FALSE); CREATE INDEX crparametervalues_profileseq_idx ON public .crparametervalues USING btree (profileseq);; cmd.ExecuteNonQuery(); } } else { if (!Catalog.IsIndexPresent( crparametervalues_profileseq_idx  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = @ CREATE INDEX crparametervalues_profileseq_idx ON public.crparametervalues USING btree (profileseq); ; cmd.ExecuteNonQuery(); } } } if (!Catalog.IsTablePresent( crsubreports  dbConn)) { using (var cmd = dbConn.CreateCommand()) { cmd.CommandText = @CREATE TABLE public .crsubreports ( seq bigserial NOT NULL category text NOT NULL name text NOT NULL filename text NOT NULL CONSTRAINT crsubreports_pkey PRIMARY KEY (seq) ) WITH (OIDS=FALSE);; cmd.ExecuteNonQuery(); } } _basePath = GetBasePath(dbConn); GetUsers(dbConn); RefreshReportList(dbConn); } if (_userAccess.GrantAdmin) { buttonAdmin.Visibility = buttonSubreportSetup.Visibility = buttonOptions.Visibility = buttonUpdate.Visibility = Visibility.Visible; } } private string GetBasePath(NpgsqlConnection openConnection) { using (var cmd = openConnection.CreateCommand()) { cmd.CommandText = @ SELECT pref_value FROM mnapp_preference WHERE pref_name = 'PathToCRFolder' ; var o = cmd.ExecuteScalar(); return o == null ? null : ( string )o; } } private void reportViewer_ClickPage( object sender SAPBusinessObjects.WPF.Viewer.PageMouseEventArgs e) { try { var f = e.ObjectInfo; if (f.ObjectType == SAPBusinessObjects.WPF.Viewer.ObjectType.DatabaseField && ! string .IsNullOrWhiteSpace(f.Hyperlink)) { Process.Start(f.Hyperlink.Substring(0 f.Hyperlink.LastIndexOf(    StringComparison.Ordinal)) f.Hyperlink.Substring(f.Hyperlink.LastIndexOf(    StringComparison.Ordinal) + 1)); } } catch (Exception ex) { Log.Exception(ex); } } private void RefreshReportList(NpgsqlConnection openConnection) { buttonRefreshReportList.IsEnabled = false ; if (GetCategories(openConnection)) { GetReports(openConnection); } else { // todo: display standard error message standardize w/ Omnis MessageBox.Show( Unable to determine report categories ); } buttonRefreshReportList.IsEnabled = true ; } private enum NodeType { UserReport PresentSystemReport ReportCategory AvailableSection Import } private class NodeObject { public NodeType Type { get ; set ; } public object Tag { get ; set ; } public NodeObject(NodeType type object tag) { Type = type; Tag = tag; } public override string ToString() { switch (Type) { case NodeType.PresentSystemReport: case NodeType.UserReport: return ((CrystalReport)Tag).ToString(); case NodeType.AvailableSection: return App Store ; case NodeType.Import: return Import ; default : return Tag.ToString(); } } } private bool GetCategories(NpgsqlConnection openConnection) { _availableCategories.Clear(); CategoryComboBox.Items.Clear(); try { TreeViewReports.Items.Clear(); using (var cmd = openConnection.CreateCommand()) { cmd.Parameters.AddParameterWithValue( IsUserAdmin  _userAccess.GrantAdmin); cmd.Parameters.AddParameterWithValue( Username  _userName); cmd.CommandText = @ SELECT DISTINCT s.reportgroup FROM crreportsetup AS s WHERE COALESCE(s.isauthorized true )= true AND (@IsUserAdmin= true OR (CASE WHEN (SELECT COUNT(*) FROM crreportauth a INNER JOIN crreportsetup g on a.report_seq = g.seq WHERE g.reportallowtabusers= true AND g.reportgroup=s.reportgroup AND a.username=@Username)>0 THEN 1 ELSE 0 END = 0 AND reportallowtabusers= true ) OR EXISTS(SELECT 1 FROM crreportauth AS a WHERE a.report_seq=s.seq AND a.username=@Username AND a.report_auth= 'ALLOW' )) AND NOT EXISTS(SELECT 1 FROM crreportauth AS a WHERE a.report_seq=s.seq AND a.username=@Username AND a.report_auth= 'DENY' ) ORDER BY s.reportgroup ; using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { var iconfile =  ; var group = dr[ reportgroup ].ToString(); switch (group) { case Accounting : if (!_userAccess.GrantAccounting) { continue ; } iconfile = IconBooks.png ; break ; case Sales : if (!_userAccess.GrantSales) { continue ; } iconfile = IconSales.png ; break ; case Inventory : if (!_userAccess.GrantInventory) { continue ; } iconfile = IconInventory16.png ; break ; case Service : if (!_userAccess.GrantService) { continue ; } iconfile = IconTools16.png ; break ; case Management : if (!_userAccess.GrantManagement) { continue ; } iconfile = IconManagement.png ; break ; case Parts : if (!_userAccess.GrantParts) { continue ; } iconfile = IconGears.png ; break ; case Month End : if (!_userAccess.GrantMonthEnd) { continue ; } iconfile = IconCalendar.png ; break ; case Commissions : if (!_userAccess.GrantCommissions) { continue ; } iconfile = IconMoney.png ; break ; case Financial Statements : if (!_userAccess.GrantFinancialStatements) { continue ; } iconfile = IconBank.png ; break ; default : iconfile = question-white.png ; break ; } var item = new TreeViewItem(); item.Header = GetNodeStackPanel(NodeType.ReportCategory group iconfile group); TreeViewReports.Items.Add(item); _availableCategories.Add(group); CategoryComboBox.Items.Add(group); } } } if (_userAccess.GrantAdmin) { var importItem = new TreeViewItem(); importItem.Header = GetNodeStackPanel(NodeType.Import null  folder-import.png  Import ); TreeViewReports.Items.Add(importItem); } var newitemsfolder = new TreeViewItem(); newitemsfolder.Header = GetNodeStackPanel(NodeType.AvailableSection null  IconStarUnlit.png  App Store ); newitemsfolder.IsEnabled = false ; // todo TreeViewReports.Items.Add(newitemsfolder); return true ; } catch (Exception ex) { MessageBox.Show(ex.Message Error loading categories ); return false ; } } // TODO: method sets class field as well as getting users. Rename or separate concerns private void GetUsers(NpgsqlConnection openConnection) { using (var cmd = openConnection.CreateCommand()) { _reportUsers = new List (); cmd.CommandText = @ SELECT u.firstname u.lastname u.username FROM mn_user AS u WHERE u.active = 1 ORDER BY u.username ; using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { var name = dr[ username ].ToString(); _reportUsers.Add( new ReportUser(name)); } } cmd.CommandText = @ SELECT a.report_seq a.username FROM crreportauth AS a WHERE a.report_auth = 'ALLOW' ORDER BY a.username ; var dict = new Dictionary string  long []>(); using (var dr = cmd.ExecuteReader()) { var isFirstIteration = true ; string currentUsername = null ; var reportSeqs = new List long >(); while (dr.Read()) { var username = dr[ username ].ToString(); if (isFirstIteration) { isFirstIteration = false ; currentUsername = username; } else { if (username != currentUsername) { dict.Add(currentUsername reportSeqs.ToArray()); currentUsername = username; reportSeqs.Clear(); } } reportSeqs.Add(dr.GetInt64(dr.GetOrdinal( report_seq ))); } if (currentUsername == null && reportSeqs.Count > 0) { throw new Exception( Internal error ); } if (currentUsername != null ) { dict.Add(currentUsername reportSeqs.ToArray()); } } foreach (var reportUser in _reportUsers) { if (dict.ContainsKey(reportUser.Name)) { reportUser.AccessibleReportIds = dict[reportUser.Name]; } } } } // TODO: method sets class field as well as getting reports. Rename or separate concerns public void GetReports(NpgsqlConnection openConnection) { _profiles.Clear(); foreach (TreeViewItem parentitem in TreeViewReports.Items) { var folder = (NodeObject)((StackPanel)parentitem.Header).Tag; using (var cmd = openConnection.CreateCommand()) { cmd.Parameters.AddParameterWithValue( UserName  _userName); if (folder.Type == NodeType.ReportCategory) { var categoryName = folder.ToString(); cmd.Parameters.AddParameterWithValue( ReportGroup  categoryName); cmd.Parameters.AddParameterWithValue( IsUserAdmin  _userAccess.GrantAdmin); cmd.Parameters.AddParameterWithValue( Username  _userName); cmd.CommandText = @ SELECT s.seq COALESCE(s.releaseseq 0)::int8 AS releaseseq s.reporttitle s.reportpath s.reportdescription COALESCE(s.reportenabled FALSE) AS reportenabled COALESCE(s.reportallowtabusers FALSE) AS reportallowtabusers COALESCE(s.isauthorized FALSE) AS isauthorized FROM crreportsetup AS s WHERE s.reportgroup = @ReportGroup AND COALESCE(s.isauthorized true ) = true AND ( @IsUserAdmin = true OR s.reportallowtabusers = true OR ( EXISTS (SELECT 1 FROM crreportauth AS a WHERE a.report_seq = s.seq AND a.username = @Username AND a.report_auth = 'ALLOW' ) AND NOT EXISTS (SELECT 1 FROM crreportauth AS a WHERE a.report_seq = s.seq AND a.username = @Username AND a.report_auth = 'DENY' ) ) ) ORDER BY s.reporttitle ; try { try { var reportList = new List (); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { var reportSeq = dr.SafeLongParse( seq ); var reportTitle = dr.SafeStringParse( reporttitle ); var report = new CrystalReport(reportSeq reportTitle dr.SafeStringParse( reportdescription ) dr.SafeStringParse( reportpath ) dr.SafeLongParse( releaseseq ) categoryName); report.Enabled = dr.SafeBoolParse( reportenabled ); report.AllowTabUsers = dr.SafeBoolParse( reportallowtabusers ); report.IsAuthorized = dr.SafeBoolParse( isauthorized ); report.Description = dr.SafeStringParse( reportdescription ); reportList.Add(report); _profiles.Add( new ReportAccessItem(reportSeq reportTitle)); } } parentitem.Items.Clear(); foreach (var report in reportList) { // Do not add report if the report is not enabled if (!report.Enabled && !_userAccess.GrantAdmin) { continue ; } var item = new TreeViewItem { Margin = new Thickness(0 2 0 0) Padding = new Thickness(3) //IsEnabled = !report.Enabled && _userAccess.GrantAdmin }; if (!report.Enabled && _userAccess.GrantAdmin) { item.Opacity = 0.5; } StackPanel p; if (report.ReleaseId == 0) { //ReportPencil.png p = GetNodeStackPanel(NodeType.UserReport report dealer_report.png  report.Name); } else { //Report.png p = GetNodeStackPanel(NodeType.PresentSystemReport report db_report.png  report.Name); } item.Header = p; item.MouseDoubleClick += item_MouseDoubleClick; // Add report description(if there is one) as tooltip. if (! string .IsNullOrEmpty(report.Description)) { item.ToolTip = report.Description; } parentitem.Items.Add(item); } } catch (NpgsqlException ex) { if (ex.GetErrorCode() == 42703 ) { MessageBox.Show( System update required. Please contact DealerBuilt support.  Unable to continue  MessageBoxButton.OK MessageBoxImage.Error); return ; } } } catch (Exception ex) { Log.Exception(ex); MessageBox.Show( There was a problem gathering reports:

+ ex.Message +

+ ex.StackTrace Unable to continue  MessageBoxButton.OK MessageBoxImage.Error); return ; } } else if (folder.Type == NodeType.AvailableSection || folder.Type == NodeType.Import) { continue ; } else { Log.Error($ GetReports failed to process the folder.Type=[{folder.Type.ToString()}] ); MessageBox.Show( There was an error getting report categories. Please contact DealerBuilt support if the problem persists.  Internal Error  MessageBoxButton.OK MessageBoxImage.Error); return ; } } } using (var cmd = openConnection.CreateCommand()) { cmd.CommandText = @ SELECT releaseseq FROM crreportsetup WHERE coalesce(releaseseq 0) > 0 AND isauthorized = true ; var releaseSeqs = new List long >(); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { releaseSeqs.Add(dr.GetInt64(dr.GetOrdinal( releaseseq ))); } } _releaseSeqs = releaseSeqs.ToArray(); } } private void item_MouseDoubleClick( object sender MouseButtonEventArgs e) { try { ExecuteSelectedReport(); } catch (Exception ex1) { Log.Exception(ex1); } } private StackPanel GetNodeStackPanel(NodeType nodetype object nodeitem string imagefilename string text) { var n = new NodeObject(nodetype nodeitem); var p = new StackPanel { Orientation = Orientation.Horizontal }; var im = new Image { Source = new BitmapImage( new Uri(@ /CrystalViewer;component/Images/ + imagefilename UriKind.Relative)) }; im.Width = im.Height = 16; im.Margin = new Thickness(0 0 6 0); p.Children.Add(im); var tb = new TextBlock { Text = text }; p.Children.Add(tb); p.Tag = n; return p; } private NodeObject GetSelectedNodeObject() { return (NodeObject)((StackPanel)((TreeViewItem)TreeViewReports.SelectedItem).Header).Tag; } private void treeViewReports_SelectedItemChanged( object sender RoutedPropertyChangedEventArgs object > e) { try { var shownothing = false ; if (TreeViewReports.SelectedItem != null ) { var t = GetSelectedNodeObject(); switch (t.Type) { case NodeType.PresentSystemReport: case NodeType.UserReport: ReportViewer.Visibility = Visibility.Visible; ReportImportPanel.Visibility = Visibility.Hidden; webBrowserMain.Visibility = Visibility.Hidden; var cr = (CrystalReport)t.Tag; // todo: if admin buttonOptions.IsEnabled = true ; buttonRun.IsEnabled = true ; if (_userAccess.GrantAdmin) { TreeViewReports.ContextMenu = TreeViewReports.Resources[ ReportContext ] as ContextMenu; } break ; case NodeType.AvailableSection: ReportViewer.Visibility = Visibility.Hidden; ReportImportPanel.Visibility = Visibility.Hidden; webBrowserMain.Navigate( http://localhost/AppStore?r= + string .Join(   _releaseSeqs)); webBrowserMain.Visibility = Visibility.Visible; TreeViewReports.ContextMenu = null ; break ; case NodeType.Import: ReportViewer.Visibility = Visibility.Hidden; webBrowserMain.Visibility = Visibility.Hidden; ReportImportPanel.Visibility = Visibility.Visible; TreeViewReports.ContextMenu = null ; break ; default : shownothing = true ; break ; } } else { shownothing = true ; } if (!shownothing) { return ; } // Show nothing TreeViewReports.ContextMenu = null ; ReportViewer.Visibility = Visibility.Visible; webBrowserMain.Visibility = Visibility.Hidden; ReportImportPanel.Visibility = Visibility.Hidden; buttonRun.IsEnabled = buttonOptions.IsEnabled = false ; } catch (Exception ex1) { Log.Exception(ex1); } } private void buttonRun_Click( object sender RoutedEventArgs e) { try { ExecuteSelectedReport(); } catch (Exception ex1) { Log.Exception(ex1); } } private void ExecuteSelectedReport() { Cursor = Cursors.Wait; try { var selectednode = (NodeObject)((StackPanel)((TreeViewItem)TreeViewReports.SelectedItem).Header).Tag; switch (selectednode.Type) { case NodeType.UserReport: case NodeType.PresentSystemReport: DisplayReport((CrystalReport)selectednode.Tag); break ; } } catch (Exception ex) { Log.Exception(ex); MessageBox.Show(ex.Message Failed to display report ); } Cursor = null ; } private ReportDocument GetReportDocument(CrystalReport report) { var ret = new ReportDocument(); ret.Load(report.Path OpenReportMethod.OpenReportByTempCopy); return ret; } private void DisplayReport(CrystalReport report) { ReportDocument activeReport; try { activeReport = GetReportDocument(report); } catch (CrystalReportsException cre) { if (cre.InnerException.HResult == -2147467259) { Log.Exception(cre); MessageBox.Show(cre.InnerException.Message Failed to display report ); return ; } throw ; } catch (Exception ex) { Log.Exception(ex); MessageBox.Show(ex.Message Unable to load report ); return ; } if (!SetDataConnection(activeReport)) { MessageBox.Show( Could not create a connection to the report database ); return ; } try { using (var dbConnection = _data.GetOpenConnection()) { report.Parameters = _data.GetParameters(dbConnection report).ToArray(); report.ParameterProfiles = _data.GetParameterProfiles(dbConnection report _userName).ToArray(); long selectedStoredParameterProfileId = 0; bool setParameterValues = true ; if (activeReport.DataDefinition.ParameterFields.Count > 0) { for (var i = 0; i { foreach (var param in report.Parameters) { if (activeReport.DataDefinition.ParameterFields[i].Name == param.Name) { if (param.Prompt != null && param.Prompt.Trim() !=  ) { try { activeReport.DataDefinition.ParameterFields[i].PromptText = param.Prompt; break ; } catch { } } } } } var parametersWindow = new ParametersWindow(report _data _userName); parametersWindow.Owner = this ; Cursor = null ; bool ? dialogResult = parametersWindow.ShowDialog(); if (dialogResult != null && dialogResult == true ) { if (parametersWindow.Result == ParameterWindowResult.Run) { setParameterValues = true ; } else { setParameterValues = false ; if (parametersWindow.Result == ParameterWindowResult.CreatePrivate || parametersWindow.Result == ParameterWindowResult.CreatePublic || parametersWindow.Result == ParameterWindowResult.Edit) { if (parametersWindow.NewParameterSetName != null ) { _newParameterProfileName = parametersWindow.NewParameterSetName; } } } selectedStoredParameterProfileId = parametersWindow.SelectedStoredParametersId; } else { return ; } } if (!ProcessParameters(activeReport report selectedStoredParameterProfileId setParameterValues)) { return ; } ReportViewer.ViewerCore.ReportSource = activeReport; _currentlyDisplayedReport = activeReport; _currentlyDisplayedReportModel = report; btnPrint.IsEnabled = true ; } } catch (Exception ex) { Log.Exception(ex); MessageBox.Show(ex.Message Failed to display report ); return ; } } /// /// Sets the Crystal Report data connection to the PostgreSQL server connection /// /// AT-417; Cloud Jira; Removes the dependency on odbcad32.exe connection setup per user terminal /// /// private bool SetDataConnection(ReportDocument report) { try { ConnectionInfo connInfo = new ConnectionInfo { ServerName = $ Driver={{PostgreSQL ANSI}};Server={_data?.ConnectionDatas?[0]?.Host};Port={_data?.ConnectionDatas?[0]?.Port};CA={(_data.ConnectionString.Contains( Prefer ) ?  prefer  :  disable )};  DatabaseName = _data?.ConnectionDatas?[0]?.DatabaseName UserID = _data?.ConnectionDatas?[0]?.Username Password = _data?.ConnectionDatas?[0]?.Password }; TableLogOnInfo tableLogOnInfo = new TableLogOnInfo { ConnectionInfo = connInfo }; foreach (Table table in report.Database.Tables) { table.LogOnInfo.ConnectionInfo.ServerName = connInfo.ServerName; table.LogOnInfo.ConnectionInfo.DatabaseName = connInfo.DatabaseName; table.LogOnInfo.ConnectionInfo.UserID = connInfo.UserID; table.LogOnInfo.ConnectionInfo.Password = connInfo.Password; table.ApplyLogOnInfo(tableLogOnInfo); } report.DataSourceConnections[0].SetConnection(connInfo.ServerName connInfo.DatabaseName connInfo.UserID connInfo.Password); return true ; } catch (Exception ex) { Log.Exception(ex); return false ; } } // TODO: rename this to what it actually does - StartsWithIgnoreCase private bool StartsWithIgnoreCase( string s string prefix) { return s.StartsWith(prefix StringComparison.InvariantCultureIgnoreCase); } private bool ProcessParameters(ReportDocument reportDocument CrystalReport report long selectedStoredParameterProfileId bool setValues) { var parameterFields = reportDocument.ParameterFields; var usingStoredProfile = selectedStoredParameterProfileId > 0; try { //This always throws an exception but is a needed work-around for some reports not showing default parameter options properly. int defaultXmlExportSelection = reportDocument.DefaultXmlExportSelection; } catch (Exception) { } try { using (var dbConnection = _data.GetOpenConnection()) { var storedProfileValues = new Dictionary string  ParameterValues>(); var legacyParameterSetups = new Dictionary string  LegacyParameterSetup>(); using (var cmd = dbConnection.CreateCommand()) { if (usingStoredProfile) { cmd.Parameters.AddParameterWithValue( ProfileId  selectedStoredParameterProfileId); cmd.CommandText = @ SELECT p.seq p.parametername p.singularvalue p.isvaluelist FROM crparametervalues AS p WHERE p.profileseq=@ProfileId ; using (var da = new NpgsqlDataAdapter(cmd)) { DataTable dtParameterValues = new DataTable(); da.Fill(dtParameterValues); if (dtParameterValues != null && dtParameterValues.Rows.Count > 0) { foreach (DataRow dr in dtParameterValues.Rows) { var pseq = dr[ seq ]; var pname = dr[ parametername ].ToString(); var pvalue = dr[ singularvalue ].ToString(); if (! bool .Parse(dr[ isvaluelist ].ToString())) { if (storedProfileValues.ContainsKey(pname)) { storedProfileValues[pname].AddValue(pvalue); } else { var pvalues = new ParameterValues(); pvalues.AddValue(pvalue); storedProfileValues.Add(pname pvalues); } } else { using (var cmd2 = dbConnection.CreateCommand()) { cmd2.CommandText = @ SELECT singularvalue FROM crparametervaluelistitems WHERE parameterseq=@parameterseq ; cmd2.Parameters.AddWithValue( parameterseq  pseq); using (var da2 = new Npgsql.NpgsqlDataAdapter(cmd2)) { DataTable dtParameterValueItems = new DataTable(); da2.Fill(dtParameterValueItems); if (dtParameterValueItems != null && dtParameterValueItems.Rows.Count > 0) { foreach (DataRow dr2 in dtParameterValueItems.Rows) { pvalue = dr2[ singularvalue ].ToString(); if (storedProfileValues.ContainsKey(pname)) { storedProfileValues[pname].AddValue(pvalue); } else { var pvalues = new ParameterValues(); pvalues.AddValue(pvalue); storedProfileValues.Add(pname pvalues); } } } } } } } } } } // Legacy parameter setups cmd.Parameters.AddParameterWithValue( ReportId  report.ReportId); cmd.CommandText = @ SELECT p.param_name p.param_default_id p.param_dynamic p.param_dynamic_table_column FROM crreportparams AS p WHERE p.report_seq=@ReportId ; using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { legacyParameterSetups.Add(dr.String( param_name ) new LegacyParameterSetup((LegacyParameterDefaultOption)dr.Long( param_default_id ) dr.String( param_dynamic_table_column ))); } } } //var parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields; List string > namesDone = new List string >(); for (var i = 0; i { ParameterDiscreteValue discreteVal = null ; var name = parameterFields[i].Name ??  ; var parameterFieldDefinition = reportDocument.DataDefinition.ParameterFields[name]; var promptText = parameterFields[i].PromptText ??  ; if (usingStoredProfile) { if (storedProfileValues.ContainsKey(name)) { if (setValues) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue) { if (!namesDone.Contains(name)) { reportDocument.SetParameterValue(name storedProfileValues[name]); namesDone.Add(name); } } } } } // Prompt Text = automatic value if (StartsWithIgnoreCase(promptText #UserLySetupLocationId )) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue) { if (!namesDone.Contains(name)) { reportDocument.SetParameterValue(name _lySetupLocationId); namesDone.Add(name); } } } else if (StartsWithIgnoreCase(promptText #UserSlSetupLocationId )) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue) { if (!namesDone.Contains(name)) { reportDocument.SetParameterValue(name _slSetupLocationId); namesDone.Add(name); } } } else if (StartsWithIgnoreCase(promptText #UserAcSetupLocationId )) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue) { if (!namesDone.Contains(name)) { reportDocument.SetParameterValue(name _acSetupLocationId); namesDone.Add(name); } } } /* Current user\'s [Login ID] - String Current user\'s [Full Name] - String Current company [DBA Name] - String Current company [Legal Name] - String Current company [location] - Integer */ // Name = defaults else if (StartsWithIgnoreCase(name #AcSetupLocationId )) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue) { if (!namesDone.Contains(name)) { discreteVal = new ParameterDiscreteValue() { Value = GetAcSetupLocations(dbConnection) }; parameterFields[i].DefaultValues.Clear(); parameterFields[i].DefaultValues.Add(discreteVal); namesDone.Add(name); } } } else if (StartsWithIgnoreCase(name #LySetupLocationId )) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue) { if (!namesDone.Contains(name)) { discreteVal = new ParameterDiscreteValue() { Value = GetLySetupLocations(dbConnection) }; parameterFields[i].DefaultValues.Clear(); parameterFields[i].DefaultValues.Add(discreteVal); namesDone.Add(name); } } } else if (StartsWithIgnoreCase(name #SlSetupLocationId )) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue) { if (!namesDone.Contains(name)) { discreteVal = new ParameterDiscreteValue() { Value = GetSlSetupLocations(dbConnection) }; parameterFields[i].DefaultValues.Clear(); parameterFields[i].DefaultValues.Add(discreteVal); namesDone.Add(name); } } } else { parameterFields[i].DefaultValues.Clear(); } /* Current user\'s [Login ID] - String Current user\'s [Full Name] - String Current company [DBA Name] - String Current company [Legal Name] - String Current company [location] - Integer Today\'s Date - Date Yesterday\'s Date - Date First day of this month - Date Last day of this month - Date First day of previous month - Date Last day of previous month - Date Beginning of this year - Date End of this year - Date Beginning of last year - Date End of last year - Date */ var pvalues = new ParameterValues(); if (legacyParameterSetups.ContainsKey(name)) { switch (legacyParameterSetups[name].LegacyParameterDefaultOption) { case LegacyParameterDefaultOption.NotSet: break ; case LegacyParameterDefaultOption.CurrentUserLoginIdString: pvalues.Add( new ParameterDiscreteValue { Value = _userName Description = Current User Login Id }); break ; case LegacyParameterDefaultOption.CurrentUserFullNameString: pvalues.Add( new ParameterDiscreteValue { Value = GetUsersFullName(dbConnection) Description = Current User Full Name }); break ; case LegacyParameterDefaultOption.CurrentCompanyDbaNameString: pvalues.Add( new ParameterDiscreteValue { Value = GetCompanyDbaName(dbConnection) Description = Current Store Name }); break ; case LegacyParameterDefaultOption.CurrentCompanyLegalNameString: pvalues.Add( new ParameterDiscreteValue { Value = GetCompanyLegalName(dbConnection) Description = Current Company Legal Name }); break ; case LegacyParameterDefaultOption.CurrentCompanyLocationInteger: pvalues.Add( new ParameterDiscreteValue { Value = _lySetupLocationId Description = Current Store Location ID }); break ; case LegacyParameterDefaultOption.ShowListOfAuthorizedCompanyLocationsInteger: pvalues = GetLySetupLocations(dbConnection); break ; case LegacyParameterDefaultOption.CurrentServiceLocationInteger: pvalues.Add( new ParameterDiscreteValue { Value = _slSetupLocationId Description = Current Service Location ID }); break ; case LegacyParameterDefaultOption.ShowListOfAuthorizedServiceLocationsInteger: pvalues = GetSlSetupLocations(dbConnection); break ; case LegacyParameterDefaultOption.TodaysDateDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Today Description = Today's Date }); break ; case LegacyParameterDefaultOption.YesterdaysDateDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Today.AddDays(-1) Description = Yesterday's Date }); break ; case LegacyParameterDefaultOption.FirstDayOfThisMonthDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.ToString( MM/01/yyyy )) Description = First Day Of This Month }); break ; case LegacyParameterDefaultOption.LastDayOfThisMonthDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.AddMonths(1).ToString( MM/01/yyyy )).AddDays(-1) Description = Last Day Of This Month }); break ; case LegacyParameterDefaultOption.FirstDayOfPreviousMonthDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.AddMonths(-1).ToString( MM/01/yyyy )) Description = First Day Of Previous Month }); break ; case LegacyParameterDefaultOption.LastDayOfPreviousMonthDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.ToString( MM/01/yyyy )).AddDays(-1) Description = Last Day Of Previous Month }); break ; case LegacyParameterDefaultOption.BeginningOfThisYearDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.ToString( 01/01/yyyy )) Description = Beginning Of This Year }); break ; case LegacyParameterDefaultOption.EndOfThisYearDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.AddYears(1).ToString( 01/01/yyyy )).AddDays(-1) Description = End Of This Year }); break ; case LegacyParameterDefaultOption.BeginningOfLastYearDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.AddYears(-1).ToString( 01/01/yyyy )) Description = Beginning Of Last Year }); break ; case LegacyParameterDefaultOption.EndOfLastYearDateTime: pvalues.Add( new ParameterDiscreteValue { Value = DateTime.Parse(DateTime.Today.ToString( 01/01/yyyy )).AddDays(-1) Description = End Of Last Year }); break ; case LegacyParameterDefaultOption.ValueString: break ; case LegacyParameterDefaultOption.ValueInteger: break ; case LegacyParameterDefaultOption.CCPADisclousureMessage: pvalues.Add( new ParameterDiscreteValue { Value = GetDisclousureMessage(dbConnection) Description = CCPA Disclosure Message }); break ; } } if (usingStoredProfile && _newParameterProfileName != null && _newParameterProfileName.Trim() !=  ) { if (storedProfileValues.ContainsKey(name)) { if (!setValues) { foreach (var storedProfileValue in storedProfileValues[name]) { bool exists = false ; foreach (var pvalue in pvalues) { if (((ParameterDiscreteValue)pvalue).Value.ToString() == ((ParameterDiscreteValue)storedProfileValue).Value.ToString()) { exists = true ; break ; } } if (!exists) { pvalues.Add( new ParameterDiscreteValue { Value = ((ParameterDiscreteValue)storedProfileValue).Value Description = _newParameterProfileName }); } } } } } /* param_default_id 0 [Not Set] 1 Current user's [Login ID] - String 2 Current user's [Full Name] - String 3 Current company [DBA Name] - String 4 Current company [Legal Name] - String 5 Current company [location] - Integer 6 Show list of authorized company locations - Integer 7 Current service location - Integer 8 Show list of authorized service locations - Integer 9 Today's Date - Date 10 Yesterday's Date - Date 11 First day of this month - Date 12 Last day of this month - Date 13 First day of previous month - Date 14 Last day of previous month - Date 15 Beginning of this year - Date 16 End of this year - Date 17 Beginning of last year - Date 18 End of last year - Date 19 String Value - String 20 Integer Value - Integer */ if (pvalues.Count > 0) { if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue) { bool allowUserToChange = false ; foreach (var param in report.Parameters) { if (param.Name == parameterFieldDefinition.Name) { allowUserToChange = param.AllowUserToChange; break ; } } if (allowUserToChange) { if (parameterFieldDefinition.EnableAllowEditingDefaultValue) { if (!namesDone.Contains(name)) { parameterFields[i].DefaultValues.Clear(); parameterFields[i].DefaultValues.AddRange(pvalues); namesDone.Add(name); } } } else { if (!namesDone.Contains(name)) { parameterFieldDefinition.ApplyCurrentValues(pvalues); namesDone.Add(name); } } } } } } } catch (Exception ex) { Log.Exception(ex); } return true ; } private void Focus_Attained() { MessageBox.Show( heyyyyyy ); } private class LegacyParameterSetup { public LegacyParameterDefaultOption LegacyParameterDefaultOption { get ; set ; } public string DynamicColumn { get ; set ; } public LegacyParameterSetup(LegacyParameterDefaultOption defaultOption string dynamicColumn) { LegacyParameterDefaultOption = defaultOption; DynamicColumn = string .IsNullOrWhiteSpace(dynamicColumn) ? null : dynamicColumn; } } private enum LegacyParameterDefaultOption { NotSet = 0 CurrentUserLoginIdString = 1 CurrentUserFullNameString = 2 CurrentCompanyDbaNameString = 3 CurrentCompanyLegalNameString = 4 CurrentCompanyLocationInteger = 5 ShowListOfAuthorizedCompanyLocationsInteger = 6 CurrentServiceLocationInteger = 7 ShowListOfAuthorizedServiceLocationsInteger = 8 TodaysDateDateTime = 9 YesterdaysDateDateTime = 10 FirstDayOfThisMonthDateTime = 11 LastDayOfThisMonthDateTime = 12 FirstDayOfPreviousMonthDateTime = 13 LastDayOfPreviousMonthDateTime = 14 BeginningOfThisYearDateTime = 15 EndOfThisYearDateTime = 16 BeginningOfLastYearDateTime = 17 EndOfLastYearDateTime = 18 ValueString = 19 ValueInteger = 20 CCPADisclousureMessage = 21 } public void goToPage_Click( object sender SAPBusinessObjects.WPF.Viewer.PageMouseEventArgs e) { MessageBox.Show(e.ObjectInfo.Text); } private ParameterValues GetAcSetupLocations(NpgsqlConnection dbConnection) { using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = @ SELECT locationid::int8 companyname FROM acsetup ORDER BY locationid ; using (var dr = dbCommand.ExecuteReader()) { var defaultValues = new ParameterValues(); while (dr.Read()) { defaultValues.Add( new ParameterDiscreteValue { Value = dr.GetInt64(dr.GetOrdinal( locationid )) Description = dr[ companyname ].ToString() }); } return defaultValues; } } } private ParameterValues GetLySetupLocations(NpgsqlConnection dbConnection) { using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = @ SELECT locationid::int8 coconame FROM lysetup ORDER BY lpad(locationid 2 '0' )::int2 ; using (var dr = dbCommand.ExecuteReader()) { var defaultValues = new ParameterValues(); while (dr.Read()) { defaultValues.Add( new ParameterDiscreteValue { Value = dr.GetInt64(dr.GetOrdinal( locationid )) Description = dr[ coconame ].ToString() }); } return defaultValues; } } } private ParameterValues GetSlSetupLocations(NpgsqlConnection dbConnection) { using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = @ SELECT locationid name FROM slsetup ORDER BY lpad(locationid::text 2 '0' )::int2 ; using (var dr = dbCommand.ExecuteReader()) { var defaultValues = new ParameterValues(); while (dr.Read()) { defaultValues.Add( new ParameterDiscreteValue { Value = dr.GetInt64(dr.GetOrdinal( locationid )) Description = dr[ name ].ToString() }); } return defaultValues; } } } private string GetUsersFullName(NpgsqlConnection dbConnection) { using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = SELECT ltrim(rtrim(firstname || ' ' || lastname)) AS fullname FROM mn_user WHERE username = @username LIMIT 1; ; dbCommand.Parameters.AddWithValue( username  _userName); return dbCommand.ExecuteScalar().ToString(); } } private string GetCompanyDbaName(NpgsqlConnection dbConnection) { using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = SELECT coconame FROM lysetup WHERE locationid = @locationid LIMIT 1; ; dbCommand.Parameters.AddWithValue( username  _lySetupLocationId.ToString()); return dbCommand.ExecuteScalar().ToString(); } } private string GetCompanyLegalName(NpgsqlConnection dbConnection) { using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = SELECT legalname FROM lysetup WHERE locationid = @locationid LIMIT 1; ; dbCommand.Parameters.AddWithValue( username  _lySetupLocationId.ToString()); return dbCommand.ExecuteScalar().ToString(); } } private string GetDisclousureMessage(NpgsqlConnection dbConnection) { string disclousureMessage = string .Empty; using (var dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandText = SELECT pref_value FROM mnapp_preference WHERE pref_name = 'CCPAReportDisclosure' ; var value = dbCommand.ExecuteScalar(); if (value != DBNull.Value) { disclousureMessage = value.ToString(); } } return disclousureMessage; } private void buttonAdmin_Click( object sender RoutedEventArgs e) { try { var accessWindow = new AccessWindow(_data _reportUsers _profiles _userName _userAccess); accessWindow.Owner = this ; bool ? result = accessWindow.ShowDialog(); if (result != null && result == true ) { _reportUsers = accessWindow.ReportUsers; _profiles = accessWindow.ReportAccessItems; } using (var db = _data.GetOpenConnection()) { GetUsers(db); } } catch (Exception ex1) { Log.Exception(ex1); } } private void buttonRefreshReportList_Click( object sender RoutedEventArgs e) { try { using (var db = _data.GetOpenConnection()) { RefreshReportList(db); } } catch (Exception ex1) { Log.Exception(ex1); } } private static void SaveFile(Stream saveFile string localFilePath) { const int bufferSize = 65536; // 64K using (var outfile = new FileStream(localFilePath FileMode.Create)) { byte [] buffer = new byte [bufferSize]; int bytesRead = saveFile.Read(buffer 0 bufferSize); while (bytesRead > 0) { outfile.Write(buffer 0 bytesRead); bytesRead = saveFile.Read(buffer 0 bufferSize); } } } private void ButtonReportFileSelect_OnClick( object sender RoutedEventArgs e) { try { var reportPath = Tools.GetUserReportPath(); if (reportPath == null ) return ; ReportFilePath.Text = reportPath; } catch (Exception ex1) { Log.Exception(ex1); } } private void ButtonImport_OnClick( object sender RoutedEventArgs e) { try { string reportGroup =  ; string sourcePath = ReportFilePath.Text; if (CategoryComboBox.SelectedValue != null && CategoryComboBox.SelectedValue.ToString().Trim() !=  ) { reportGroup = CategoryComboBox.SelectedValue.ToString(); } else if (CategoryComboBox.Text != null && CategoryComboBox.Text.Trim() !=  ) { reportGroup = CategoryComboBox.Text; } else { MessageBox.Show( Please select a report category  Required Field Missing  MessageBoxButton.OK MessageBoxImage.Stop); return ; } var destinationPath = _basePath.TrimEnd( \.ToCharArray()) +  \  + reportGroup.TrimEnd( \ .ToCharArray()) +  \ + System.IO.Path.GetFileName(sourcePath); if (sourcePath.ToLower() != destinationPath.ToLower()) { try { if (!Directory.Exists(_basePath.TrimEnd( \.ToCharArray()) +  \  + reportGroup.TrimEnd( \.ToCharArray()))) { Directory.CreateDirectory(_basePath.TrimEnd( \.ToCharArray()) +  \  + reportGroup.TrimEnd( \.ToCharArray())); } if (sourcePath.ToLower() != destinationPath.ToLower()) //Don't copy if the destination matches the source. { File.Copy(sourcePath destinationPath); } } catch (Exception ex) { MessageBox.Show(ex.Message Unable to copy report file  MessageBoxButton.OK MessageBoxImage.Error); return ; } } using (var dbConn = _data.GetOpenConnection()) { try { using (var cmd = dbConn.CreateCommand()) { cmd.Parameters.AddParameterWithValue( ReportPath  destinationPath); cmd.Parameters.AddParameterWithValue( ReportTitle  ReportTitle.Text); cmd.Parameters.AddParameterWithValue( ReportDescription  ReportDescription.Text); cmd.Parameters.AddParameterWithValue( ReportGroup  reportGroup); cmd.CommandText = @ INSERT INTO crreportsetup (reportpath reporttitle reportdescription reportgroup reportenabled) VALUES (@ReportPath @ReportTitle @ReportDescription @ReportGroup true ) ; cmd.ExecuteNonQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message Unable to import report file  MessageBoxButton.OK MessageBoxImage.Error); return ; } RefreshReportList(dbConn); } } catch (Exception ex1) { Log.Exception(ex1); } } private void EditReport_Click( object sender RoutedEventArgs e) { try { EditSelectedReport(); } catch (Exception ex1) { Log.Exception(ex1); } } private void UpdateReport_Click( object sender RoutedEventArgs e) { try { UpdateSelectedReport(); } catch (Exception ex1) { Log.Exception(ex1); } } private void EditSelectedReport() { var sno = GetSelectedNodeObject(); var s = new ReportOptionsWindow(_data (CrystalReport)sno.Tag _availableCategories _reportUsers); s.Owner = this ; s.ShowDialog(); sno.Tag = s._report; } private void UpdateSelectedReport() { var reportPath = Tools.GetUserReportPath(); if (reportPath != null ) { var report = (CrystalReport)GetSelectedNodeObject().Tag; var reportGroup = report.CategoryName; var filename = System.IO.Path.GetFileName(report.Path); var destinationPath = _basePath.TrimEnd( \.ToCharArray()) +  \  + reportGroup.TrimEnd( \ .ToCharArray()) +  \ + filename; try { if (destinationPath.ToLower() != reportPath.ToLower()) { File.Copy(reportPath destinationPath true ); MessageBox.Show( Report updated  Success  MessageBoxButton.OK MessageBoxImage.Information MessageBoxResult.OK); } else { MessageBox.Show( Report not updated. Source file path is the same as destination file path.  Success  MessageBoxButton.OK MessageBoxImage.Information MessageBoxResult.OK); } } catch (Exception ex) { MessageBox.Show(ex.Message Unable to copy report file  MessageBoxButton.OK MessageBoxImage.Error); return ; } } } private void DeleteReport_Click( object sender RoutedEventArgs e) { try { var report = (CrystalReport)GetSelectedNodeObject().Tag; var question = string .Format( Delete {0}?  report.Name); if (MessageBox.Show(question Delete Report  MessageBoxButton.YesNo MessageBoxImage.Question) == MessageBoxResult.Yes) { using (var db = _data.GetOpenConnection()) { DeleteReport(db report.ReportId); RefreshReportList(db); } } } catch (Exception ex1) { Log.Exception(ex1); } } private void DeleteReport(NpgsqlConnection openConnection long reportId) { try { _data.DeleteProfiles(openConnection reportId); // todo: everything to the end of the try should be in the same tranaction as the above profile deletion string path; using (var command = openConnection.CreateCommand()) { command.Parameters.AddWithValue( ReportId  reportId); command.CommandText = @ DELETE FROM crreportsetup WHERE seq=@ReportId RETURNING reportpath ; path = ( string )command.ExecuteScalar(); } //File.Delete(path); //Per Sherri she does not want the .rpt file itself to be deleted just remove from the viewer. } catch (Exception ex) { MessageBox.Show( The following error occured while attempting to delete the selected report:

+ ex.Message Report Not Deleted  MessageBoxButton.OK MessageBoxImage.Error MessageBoxResult.OK); } } private void ReportViewerOnViewChange( object sender RoutedEventArgs routedEventArgs) { try { if (routedEventArgs != null && routedEventArgs.OriginalSource != null ) { currentReportAlbum = (SAPBusinessObjects.WPF.Viewer.ReportAlbum)routedEventArgs.OriginalSource; } else { currentReportAlbum = null ; } if (_newParameterProfileName == null ) return ; using (var connection = _data.GetOpenConnection()) { using (var transaction = connection.BeginTransaction()) { try { using (var cmd = connection.CreateCommand()) { long profileId = 0; cmd.Parameters.AddParameterWithValue( ProfileName  _newParameterProfileName); cmd.Parameters.AddParameterWithValue( UserName  _userName); cmd.Parameters.AddParameterWithValue( ReportSeq  _currentlyDisplayedReportModel.ReportId); cmd.CommandText = @ SELECT seq FROM crparameterprofiles WHERE (reportseq = @ReportSeq) AND (username = @UserName) AND (profilename = @ProfileName) LIMIT 1; ; object ob = cmd.ExecuteScalar(); if (ob != null && ob.ToString() !=  ) { long .TryParse(ob.ToString() out profileId); } if (profileId //INSERT crparameterprofiles { cmd.CommandText = @ INSERT INTO crparameterprofiles (profilename username reportseq) VALUES (@ProfileName @UserName @ReportSeq) RETURNING seq; ; ob = cmd.ExecuteScalar(); if (ob != null && ob.ToString() !=  ) { long .TryParse(ob.ToString() out profileId); } } //else //UPDATE crparameterprofiles (not necessary) cmd.Parameters.AddParameterWithValue( ProfileId  profileId); cmd.Parameters.AddParameterWithValue( ParameterName  NpgsqlDbType.Text  ); cmd.Parameters.AddParameterWithValue( IsValueList  NpgsqlDbType.Boolean false ); cmd.Parameters.AddParameterWithValue( SingularValue  NpgsqlDbType.Text  ); cmd.Parameters.AddParameterWithValue( MinValue  NpgsqlDbType.Text  ); cmd.Parameters.AddParameterWithValue( IsMinValueIncluded  NpgsqlDbType.Boolean false ); cmd.Parameters.AddParameterWithValue( MaxValue  NpgsqlDbType.Text  ); cmd.Parameters.AddParameterWithValue( IsMaxValueIncluded  NpgsqlDbType.Boolean false ); cmd.Parameters.AddParameterWithValue( paramvalueId  NpgsqlDbType.Bigint 0); for (var i = 0; i { long paramvalueId = 0; var parameterField = _currentlyDisplayedReport.ParameterFields[i]; if (parameterField.CurrentValues.Count == 0) continue ; bool isList = parameterField.CurrentValues.Count > 1; cmd.Parameters.SetValue( ParameterName  parameterField.Name); cmd.CommandText = @ SELECT seq FROM crparametervalues WHERE (profileseq = @ProfileId) AND (parametername = @ParameterName) LIMIT 1; ; ob = cmd.ExecuteScalar(); if (ob != null && ob.ToString() !=  ) { long .TryParse(ob.ToString() out paramvalueId); } if (paramvalueId //INSERT crparametervalues and crparametervaluelistitems { cmd.CommandText = @ INSERT INTO crparametervalues (profileseq parametername isvaluelist singularvalue minvalue isminvalueincluded maxvalue ismaxvalueincluded) VALUES (@ProfileId @ParameterName @IsValueList @SingularValue @MinValue @IsMinValueIncluded @MaxValue @IsMaxValueIncluded) RETURNING seq; ; } else //UPDATE crparametervalues and crparametervaluelistitems { cmd.Parameters.SetValue( paramvalueId  paramvalueId); cmd.CommandText = @ UPDATE crparametervalues SET isvaluelist = @IsValueList singularvalue = @SingularValue minvalue = @MinValue isminvalueincluded = @IsMinValueIncluded maxvalue = @MaxValue ismaxvalueincluded = @IsMaxValueIncluded WHERE (seq = @paramvalueId) RETURNING seq; ; } if (!isList) { // Singular value cmd.Parameters.SetValue( IsValueList  isList); cmd.Parameters.SetValue( MinValue  0); cmd.Parameters.SetValue( IsMinValueIncluded  true ); cmd.Parameters.SetValue( MaxValue  0); cmd.Parameters.SetValue( IsMaxValueIncluded  true ); cmd.Parameters.SetValue( SingularValue  ((ParameterDiscreteValue)parameterField.CurrentValues[0]).Value); ob = cmd.ExecuteScalar(); if (ob != null && ob.ToString() !=  ) { long .TryParse(ob.ToString() out paramvalueId); } cmd.Parameters.SetValue( paramvalueId  paramvalueId); cmd.CommandText = @ DELETE FROM crparametervaluelistitems WHERE (parameterseq = @paramvalueId); ; cmd.ExecuteNonQuery(); } else { // Value list cmd.Parameters.SetValue( IsValueList  isList); cmd.Parameters.SetValue( MinValue  0); cmd.Parameters.SetValue( IsMinValueIncluded  false ); cmd.Parameters.SetValue( MaxValue  0); cmd.Parameters.SetValue( IsMaxValueIncluded  false ); cmd.Parameters.SetValue( SingularValue   ); ob = cmd.ExecuteScalar(); if (ob != null && ob.ToString() !=  ) { long .TryParse(ob.ToString() out paramvalueId); } cmd.Parameters.SetValue( paramvalueId  paramvalueId); cmd.CommandText = @ DELETE FROM crparametervaluelistitems WHERE (parameterseq = @paramvalueId); ; cmd.ExecuteNonQuery(); for (var j = 0; j { cmd.CommandText = @ INSERT INTO crparametervaluelistitems (parameterseq singularvalue minvalue isminvalueincluded maxvalue ismaxvalueincluded) VALUES (@paramvalueId @SingularValue @MinValue @IsMinValueIncluded @MaxValue @IsMaxValueIncluded) ; cmd.Parameters.SetValue( paramvalueId  paramvalueId); cmd.Parameters.SetValue( MinValue  0); cmd.Parameters.SetValue( IsMinValueIncluded  false ); cmd.Parameters.SetValue( MaxValue  0); cmd.Parameters.SetValue( IsMaxValueIncluded  false ); cmd.Parameters.SetValue( SingularValue  ((ParameterDiscreteValue)parameterField.CurrentValues[j]).Value); cmd.ExecuteNonQuery(); } } } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show( The following error occured while attempting to save report parameters:

+ ex.Message Profile not saved  MessageBoxButton.OK MessageBoxImage.Error MessageBoxResult.OK); return ; } } } _newParameterProfileName = null ; } catch (Exception ex1) { Log.Exception(ex1); } } private void buttonOptions_Click( object sender RoutedEventArgs e) { try { EditSelectedReport(); } catch (Exception ex1) { Log.Exception(ex1); } } private void WebBrowserMain_OnNavigating( object sender NavigatingCancelEventArgs e) { try { string scheme = null ; try { scheme = e.Uri.Scheme; } catch { return ; } if (scheme == install ) { using (var connection = _data.GetOpenConnection()) { using (var cmd = connection.CreateCommand()) { cmd.Parameters.AddParameterWithValue( ReleaseSeq  long .Parse(e.Uri.Host)); cmd.CommandText = @ UPDATE crreportsetup SET isauthorized= true WHERE releaseseq=@ReleaseSeq ; cmd.ExecuteNonQuery(); GetReports(connection); } } webBrowserMain.Navigate( http://localhost/AppStore?r= + string .Join(   _releaseSeqs)); } else if (scheme == uninstall ) { using (var connection = _data.GetOpenConnection()) { using (var cmd = connection.CreateCommand()) { cmd.Parameters.AddParameterWithValue( ReleaseSeq  long .Parse(e.Uri.Host)); cmd.CommandText = @ UPDATE crreportsetup SET isauthorized= false WHERE releaseseq=@ReleaseSeq ; cmd.ExecuteNonQuery(); GetReports(connection); } } webBrowserMain.Navigate( http://localhost/AppStore?r= + string .Join(   _releaseSeqs)); } else if (scheme != http ) { e.Cancel = true ; } } catch (Exception ex1) { Log.Exception(ex1); } } private void Control_OnMouseDoubleClick( object sender MouseButtonEventArgs e) { try { if (LeftPanel.Visibility == Visibility.Collapsed) { ColumnDefinitionLeft.Width = _leftPanelWidth; ColumnDefinitionLeft.MinWidth = 235; LeftPanel.Visibility = Visibility.Visible; RectangleCollapsed.Visibility = Visibility.Hidden; return ; } _leftPanelWidth = ColumnDefinitionLeft.Width; ColumnDefinitionLeft.Width = new GridLength(0); ColumnDefinitionLeft.MinWidth = 0; LeftPanel.Visibility = Visibility.Collapsed; RectangleCollapsed.Visibility = Visibility.Visible; } catch (Exception ex1) { Log.Exception(ex1); } } private void TreeViewReports_OnMouseLeftButtonDown( object sender MouseButtonEventArgs e) { try { var treeView = sender as TreeView; if (treeView != null && treeView.SelectedItem != null ) { var item = (TreeViewItem)treeView.SelectedItem; item.IsSelected = false ; treeView.Focus(); } } catch (Exception ex1) { Log.Exception(ex1); } } private void TreeViewReports_OnPreviewMouseRightButtonDown( object sender MouseButtonEventArgs e) { try { var treeViewItem = VisualUpwardSearch(e.OriginalSource as DependencyObject); if (treeViewItem == null ) return ; treeViewItem.Focus(); e.Handled = true ; } catch (Exception ex1) { Log.Exception(ex1); } } static TreeViewItem VisualUpwardSearch(DependencyObject source) { while (source != null && !(source is TreeViewItem)) source = VisualTreeHelper.GetParent(source); return source as TreeViewItem; } private void buttonSubreportSetup_Click( object sender RoutedEventArgs e) { try { var w = new SubreportWindow(_availableCategories _data _basePath); w.Owner = this ; w.ShowDialog(); } catch (Exception ex1) { Log.Exception(ex1); } } private void Focus_Attained( object sender RoutedEventArgs e) { } private void btnPrint_Click( object sender RoutedEventArgs e) { try { try { if (currentReportAlbum != null ) { try { currentReportAlbum.PrintReport(); } catch { ReportViewer.ViewerCore.PrintReport(); } } else if (_currentlyDisplayedReport != null ) { doPrint(_currentlyDisplayedReport); } } catch { if (_currentlyDisplayedReport != null ) { doPrint(_currentlyDisplayedReport); } else if (currentReportAlbum != null ) { currentReportAlbum.PrintReport(); } } } catch (Exception ex1) { Log.Exception(ex1); } } private void doPrint(ReportDocument reportDocument) { using (System.Windows.Forms.PrintDialog dialog = new System.Windows.Forms.PrintDialog()) { dialog.AllowCurrentPage = true ; dialog.AllowSelection = true ; dialog.AllowSomePages = true ; dialog.AllowPrintToFile = true ; if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { reportDocument.PrintToPrinter(dialog.PrinterSettings new System.Drawing.Printing.PageSettings(dialog.PrinterSettings) false ); } } } } public class MyParameterType : ParameterDiscreteValue { public MyParameterType( int i) { Value = i; } public override string ToString() { return five ; } } }