Does infragistics have a reporting control like the standard Microsoft Report viewer control.
When I export the Ultragrid which have two bands. I hate how it looks. It keeps each of the headers on the For Band[1], which i hate.
How to just export just the first band to one sheet, and the second band to the second, and then link them.
Exporting the ultragrid to excel is powerful when there is only one band from what i see.
but if there is multiple bands it looks weird.
Review attachment to look at the view. Is there a better way. I prefer to only export band[0] to one sheet, and band [1] to sheet two, and then some how link them. Can some one send me a small tutorial. I am struggling with this last requirement
Hi,
KeithDudley said:Does infragistics have a reporting control like the standard Microsoft Report viewer control.
No, not for WinForms at this time.You should Submit a feature request to Infragistics.
The UltraGridExcelExporter exports the grid to Excel in a hierarchy, just as it appears on the screen. You can handle the events of the exporter and manipulate the CurrentWorkSheet, CurrentColumnIndex and CurrentRowIndex, but there I don't think there is any way to link data from one sheet to another like you are describing.
If you don't want the headers to repeat every time there is a break, then you can set the HeaderPlacement property on the Override. Support for the HeaderPlacement property when exporting was just added to the UltraGridExcelExporter recently, though, so this will only work if you have a pretty recent version of the controls and you may also need the latest service release.
Another option is to handle the HeaderExporting event and Cancel it for all but the first instance of the headers for band 0.
I currently have the volume 11.1 of infragistics controls. Is there another version already?
Can you send me an example of you guys handling the event of the exporter while manipulating the CurrentColumnIndex and CurrentRowIndex.