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
Thanks. Everything works. For some reason you have to higglight the excel sheet and then put the filter on. And then it works.
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
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.
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,
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.