Decision point -- need grid export info

Glayaar — Thu, 16 Dec 2010 01:32:29 GMT

Unfortunately, currently our WebGrid report customization is still limited.

I could not found any method to automatically resize the cells to comfort to a paper change.

You could modify the header and date in the PDF report, however there is a predefined size for the date section and setting a different format may result in clipping issue.

In order to escape the HTML character and forcing quote, you could use the Export event handler to modify the exported data. Here is a Expert event handler which modify the header and date when exporting as PDF, and forcing quote in the cell Name when exporting as Text:

protected void wgTest_Export(object sender, ExportEventArgs e)
{
    if (e.ReportInfo.ReportType.ToLower() == "pdf")
    {
        e.ReportInfo.DynReportCaptions.DateCaption = "Date ";
        e.ReportInfo.DynReportCaptions.DateCaptionFormat = "yyyy";

        e.Table.Caption = "Custom table header";
    }
    else if (e.ReportInfo.ReportType.ToLower() == "text")
    {
        for (int i = 0; i < e.Table.Rows.Count; i++)
        {
            WebGridCell tempCell = e.Table.Rows[i].Cells.GetNamedItem("Name");
            tempCell.Text = "'" + tempCell.Text + "'";
        }
    }
}

Decision point -- need grid export info

artem.pushkin — Wed, 15 Dec 2010 19:07:45 GMT

Hello,

I must decide shortly if my company should buy your web suite. I need some information about the way data export works in WebGrid.

I have a grid with about 20 columns. When I create a PDF export report it tries to fit all columns onto a letter size paper therefore making them too thin and unreadable. Is there a way to make columns wider? Preferably they should be automatically sized so that no text would wrap around. This would require bigger page size but I was unable to change it.

Is PDF report format customizable in any way? I would like to be able to set custom header and date at least.

Exporting to TXT seems to make a CSV file but values are not enclosed in quotes. Is there a way to force quotes around values?

I also noticed that special HTML characters are not unescaped in reports. E. g. '&' is displayed as '&', is there a workaround?

Best regards,

Artem Pushkin

Intersoft Community - WebGrid Enterprise - Decision point -- need grid export info

Decision point -- need grid export info

Decision point -- need grid export info