I have a dynamic number of datasets which will each be loaded in a grids and eachgrid will be displayed in a tab. Sometimes there might be 4 tabs with 4 grids on it, and sometimes there might be just 1 grid and 1 tab. The problem I am having is getting the PringDialog to print all of my grids.
I can only figure out how to add one grid to a print document, and one print document to a print diolog control. Therefore, the user does not have the option to pring all the data in each of the grids at once.
Similar to several worksheets in excel. If the user prints in Excel, they have to option to print all worksheets.
Thanks.
vrn said:-- Is it possible to print into Excel such that the grids print stacked on a single Excel worksheet?
I beleive the Export method has overloads that take a worksheet and a starting column and row index. So you could create a worksheet, export the grid and use the events of the ExcelExporter (like RowExported) to track the last row the export used, then incremement that and use it as the starting point for the next grid.
vrn said:- Is it possible to print to Excel such that the grid show in different worksheets?
Yes, as above, you can specify a worksheet to the Export method.
vrn said:I am guessing from your previous response in this thread, the answer is no but just want to make sure.
Previously, we were discussing printing. Exporting to Excel is more flexible. :)
Mike, I have a less complex requirement. I have a fixed number of grids on my form, stacked on each other.
-- Is it possible to print into Excel such that the grids print stacked on a single Excel worksheet?
- Is it possible to print to Excel such that the grid show in different worksheets?
I am guessing from your previous response in this thread, the answer is no but just want to make sure.
PS: Searching the forum further, I found this which suggests I could take care of my requirements -> http://forums.infragistics.com/forums/p/2168/14547.aspx#14547
- I have not tried it yet but is this solution what you would recommend?
- Would the solution allow me to put it on more than one worksheet?
Thanks!
Each print operation of the grid creates it's own print job. So there'sno way to print multiple grids in a single document.You should Submit a feature request to Infragistics