Example #1
0
        private void InsertCommonColumns()
        {
            reportGridView.SettingsBehavior.AllowSort = true;
            reportGridView.InsertRightAlignedDataColumn("CustomerNumber", "#");
            reportGridView.InsertHyperlinkColumn("CustomerName", "Customer", "Id", LinkHelper.NavigateUrlFormatToDashboardForCustomer);
            reportGridView.InsertCurrencyColumn("CurrentBalance", "Current");
            reportGridView.InsertCurrencyColumn("MonthOldBalance", "Month 1");
            reportGridView.InsertCurrencyColumn("TwoMonthsOldBalance", "Month 2");
            reportGridView.InsertCurrencyColumn("ThreeMonthsOrOlderBalance", "Month 3+");
            reportGridView.InsertCurrencyColumn("Balance");
            reportGridView.InsertDataColumn("NextCallDate", "Next Call");
            reportGridView.InsertMemoColumn("Note", "Note");
            reportGridView.Columns["Note"].Visible = false;

            if (isReportWithNotes)
            {
                reportGridView.Columns["Note"].Visible = true;

                IsReportWithNotesLiteral.Text    = "true";
                IsReportWithNotesLiteral.Visible = false;
            }

            reportGridView.SettingsBehavior.ProcessFocusedRowChangedOnServer = false;
            reportGridView.SettingsBehavior.ProcessSelectionChangedOnServer  = false;
            reportGridView.EnableCallBacks = true;

            reportGridView.SettingsDetail.ShowDetailRow     = false;
            reportGridView.SettingsDetail.ShowDetailButtons = false;

            reportGridView.InsertDataColumn("Email");
            reportGridView.InsertDataColumn("Contact");
            reportGridView.InsertDataColumn("Phone");
            reportGridView.InsertDataColumn("Cell", "Mobile Phone");


            reportGridView.TotalSummary.Clear();
            reportGridView.InsertTotalSummaryLabelColumn(0);
            reportGridView.InsertTotalSummarySumColumn("CurrentBalance");
            reportGridView.InsertTotalSummarySumColumn("MonthOldBalance");
            reportGridView.InsertTotalSummarySumColumn("TwoMonthsOldBalance");
            reportGridView.InsertTotalSummarySumColumn("ThreeMonthsOrOlderBalance");
            reportGridView.InsertTotalSummarySumColumn("Balance");
        }
Example #2
0
        public override void Export()
        {
            AgedBalancesReport report = ViewState["AgedBalancesReport"] as AgedBalancesReport;

            System.Collections.Generic.IList <AgedBalancesReportRecord> exportRecordWithNotes = new System.Collections.Generic.List <AgedBalancesReportRecord>();

            foreach (AgedBalancesReportRecord rptRecord in report.Records)
            {
                System.Collections.Generic.IList <CustomerNote> cnList = rptRecord.CustNoteList;
                rptRecord.Note = "";
                foreach (CustomerNote cNote in cnList)
                {
                    if (!string.IsNullOrEmpty(cNote.Comment))
                    {
                        rptRecord.Note += "[" + cNote.CreatedByEmployeeName + "][" + cNote.Created.ToShortDateString() + "]";
                        rptRecord.Note += cNote.Comment + System.Environment.NewLine;
                    }
                }

                if (!string.IsNullOrEmpty(rptRecord.Note))
                {
                    rptRecord.CustNoteList.Clear();
                }

                exportRecordWithNotes.Add(rptRecord);
            }

            //init columns
            CffGridView exportGrid = new CffGridView(250);

            if (IsReportWithNotesLiteral.Text.ToLower() == "true")
            {
                exportGrid.SettingsBehavior.AllowSort = true;
                exportGrid.InsertRightAlignedDataColumn("CustomerNumber", "#");
                exportGrid.InsertHyperlinkColumn("CustomerName", "Customer", "Id", LinkHelper.NavigateUrlFormatToDashboardForCustomer);
                exportGrid.InsertCurrencyColumn("CurrentBalance", "Current");
                exportGrid.InsertCurrencyColumn("MonthOldBalance", "Month 1");
                exportGrid.InsertCurrencyColumn("TwoMonthsOldBalance", "Month 2");
                exportGrid.InsertCurrencyColumn("ThreeMonthsOrOlderBalance", "Month 3+");
                exportGrid.InsertCurrencyColumn("Balance");
                exportGrid.InsertDataColumn("NextCallDate", "Next Call");
                exportGrid.InsertMemoColumn("Note", "Note");
                exportGrid.Visible = false;

                exportGrid.InsertDataColumn("Email");
                exportGrid.InsertDataColumn("Contact");
                exportGrid.InsertDataColumn("Phone");
                exportGrid.InsertDataColumn("Cell", "Mobile Phone");

                exportGrid.TotalSummary.Clear();
                exportGrid.InsertTotalSummaryLabelColumn(0);
                exportGrid.InsertTotalSummarySumColumn("CurrentBalance");
                exportGrid.InsertTotalSummarySumColumn("MonthOldBalance");
                exportGrid.InsertTotalSummarySumColumn("TwoMonthsOldBalance");
                exportGrid.InsertTotalSummarySumColumn("ThreeMonthsOrOlderBalance");
                exportGrid.InsertTotalSummarySumColumn("Balance");

                exportGrid.DataSource = exportRecordWithNotes;
                exportGrid.DataBind();
            }



            if (report != null)
            {
                ExcelDocument document = new ExcelDocument();
                document.HSFFGetSheet.SetColumnWidth(8, 400);
                document.WriteTitle(report.Title);

                Hashtable hashtable = new Hashtable();
                hashtable.Add("Client", "ClientName");
                hashtable.Add("Customer", "CustomerName");

                if (IsReportWithNotesLiteral.Text.ToLower() == "true")
                {
                    exportGrid.WriteToExcelDocumentWithReplaceField(document, hashtable);
                }
                else
                {
                    reportGridView.WriteToExcelDocumentWithReplaceField(document, hashtable);
                }

                document.MoveToNextRow();
                document.MoveToNextRow();
                document.AddCell("Date Viewed");
                document.AddCell(report.DateViewed.ToDateTimeString());

                WriteToResponse(document.WriteToStream(), report.ExportFileName);
            }
        }