iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
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 + "'"; } }}
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname