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
Nevermind I found the headerplacement property. Is there a way we can add the filter on each parent row in excel. That way when the excel is open, the user only have to just click the row filter without adding the filter to the parent rows in excel.
Nevermind I found the header[lacement property. Is there a way we can add the filter on each parent row in excel. That way when the excel is open, the user only have to just click the row filter without adding the filter to the parent rows in excel.
Cant find the header placement property in the designer, can you point me to the property or how to set the property in code
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.
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.