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.
Do a search on these forums and look for CurrentColumnIndex and/or CurrentRowIndex. I'm sure I've posted sample code like this many times.
KeithDudley said: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.
I don't understand what you mean by this. What filter are you referring to? Are you talking about using Excel's filtering functionality? If so, then the answer is no. Excel has no concept of parent and child rows, so even if you could filter in Excel, it would filter all of the rows, not just the parent rows.
Sorry for the confusion. Can you also review the attachment to see what I am talking about
. Currently when you have multiple parent rows that has childband with mulitiple rows. If you do a sort and filter in excel on column its not giving me the entire column value filter that exists. You will see in the attachment. It only filte the parent that you have filter and displays the child values that belong to the parent. I want to be able to filter the entire column.
When you open the attachment. You have increase the size image, I had to shrink everything because you guy size limitation
Hi Keith,
Okay, so what you are asking about here is Excel functionality, it doesn't really have anything to do with the grid.
I'm no Excel expert, but just as a guess, it looks like Excel must be taking into account the outlining (the expansion indicators). I didn't realize they did that. But if that's what they are doing, and it seems like they must be, then one potential solution might be to remove the outlining from the export.
To do that, just set the OutliningStyle property on the UltraGridExcelExport to None.
This, of course, removes the user's ability to expand and collapse the parent rows in Excel, so that's the trade-off.
Yeah I thought it was slow bus excel moment. That was my first encounter with excel as filter from the top row with parent and child informatiom and not being able to filter the entire colomn. But now I know
Let me try your fix. Brb
Thanks. Everything works. For some reason you have to higglight the excel sheet and then put the filter on. And then it works.