Print Aggregate=sum in footer

[Lloyd Johnson]

In viewing the RadGridView, my columns are totaling into the footer as expected.  When I Print, though, the footer appears but all columns are blank. I am using ToPrintFriendlyGrid.

I've found old posts that addressed this issue but nothing lately.

Can you help?

Thanks!

[Stefan Nenchev]

Hello Lloyd,

I believe the approach of printing the RadGridView that you are using is quite old and it is not using any of the Telerik Document Library classes. I suggest you consider the newer approaches available - Print Preview with RadSpreadSheet(the demo can be found in the SDK Samples Browser or on Github) or the GridView Print and Print Preview(available in the WPF Demos Application).

I hope the information will be helpful.

Regards,
Stefan Nenchev
Telerik by Progress

[Lloyd Johnson]

As suggested, I have changed my code so that I am using 'Print Preview with RadSpreadSheet'.  This is now working correctly, but I cannot find sample code to show me how to change the Print Settings.  I need to print in Landscape and on Letter instead of A4 paper and adjust the margins.

Can you point me to documentation that shows how to do this?

Thanks!

[Stefan Nenchev]

Hello Lloyd,

The Orientation and Margins can be controlled by setting the WorksheetPageSetup settings of each individual Worksheet within the Workbook that the RadSpreadSheet contains. I suggest you have a look at the RadSpreadProcessing documentation for more information. As a certain Workbook can contain multiple Worksheets, you can iterate over them and set their settings:

private static RadSpreadsheet CreateSpreadsheet(RadGridView grid)
        {
            var workbook = CreateWorkBook(grid);

            return new RadSpreadsheet()
            {
                Workbook = CreateWorkBook(grid)
            };
        }

        private static Workbook CreateWorkBook(RadGridView grid)
        {
            Workbook book = null;

            using (var stream = new MemoryStream())
            {
                if (grid != null)
                {
                    grid.ExportToXlsx(stream, new GridViewDocumentExportOptions()
                    {
                        ShowColumnFooters = grid.ShowColumnFooters,
                        ShowColumnHeaders = grid.ShowColumnHeaders,
                        ShowGroupFooters = grid.ShowGroupFooters,
                        ExportDefaultStyles = true
                    });
                }

                stream.Position = 0;

                book = new XlsxFormatProvider().Import(stream);
            }

            foreach (var item in book.Worksheets)
            {
                (item as Worksheet).WorksheetPageSetup.PageOrientation = Telerik.Windows.Documents.Model.PageOrientation.Landscape;
                (item as Worksheet).WorksheetPageSetup.Margins = PageMargins.WideMargins;
            }

            return book;
        }

I have modified the SDK sample for your reference. Please have a look at the attached project.

Regards,
Stefan Nenchev
Telerik by Progress

[Lloyd Johnson]

Just what I needed, Stefan.

Thanks!