Report Export to Excel Problem
I am using a matrix report to generate below report:(SQL Server 2005) Steps Used to generate: 1) Taken a matrix by giving Column Groups à TestType,ProgramId,TKs and Row Groups à AD 2) Taken a List Control and placed the above matrix in this List and Grouped it by TestType and ProgramI,d to get the data with diff ProgramIds in a different row as below, else the data is getting appended as diff columns. 3) Now to avoid the Excel row limitation, I have used another List Control which is grouped by using expression =Int((RowNumber(Nothing) - 1) /65000) Hence I am getting below output in multiple sheets. Eg: Image1 in Sheet1 and Image2 in Sheet2 Image1 Image2 Now the problem is in continuation to next sheet I am loosing the information for 3-AD2,3-AD3 etc for TK1,TK2. Is there a way to split the sheet based on Program Start after it exceeds 6500 rows?
February 17th, 2011 9:13am

Hi Venkata, Instead of adding new list control for Int((RowNumber(Nothing) - 1) /65000), try adding another group with exp=Int((RowNumber(Nothing) - 1) /65000) and check the checkbox in Pagebreak to List control which you included the matrix control.Nanda
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 12:26am

Thanks Nanda, I tried but failed to get the desired output. Here also i am loosing the content at the break of list, moreover its not splitting to multiple sheet. Is there any other way? Thanks, Venkata
February 18th, 2011 12:57am

Hi Venkata, As you posted, generally in order to place a page break at the end of a specified number of rows in a table, we can add a group by the expression like =Int((RowNumber(Nothing)-1)/25). Since you are using a matrix need to limit the rows of a matrix, we need to get the row number of matrix for grouping. However, the RowNumber function can only returns a running count of the number of rows for the specified scope. Currently, as workaround, we need to create a custom function to achieve it. Please refer to the similar thread at: http://social.msdn.microsoft.com/Forums/eu/sqlreportingservices/thread/ae6292cc-07ed-4f4c-9ebf-7c60a62ed1d7 Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 9:02pm

Hi Venkata, As you posted, generally in order to place a page break at the end of a specified number of rows in a table, we can add a group by the expression like =Int((RowNumber(Nothing)-1)/25). Since you are using a matrix need to limit the rows of a matrix, we need to get the row number of matrix for grouping. However, the RowNumber function can only returns a running count of the number of rows for the specified scope. Currently, as workaround, we need to create a custom function to achieve it. Please refer to the similar thread at: http://social.msdn.microsoft.com/Forums/eu/sqlreportingservices/thread/ae6292cc-07ed-4f4c-9ebf-7c60a62ed1d7 Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
February 25th, 2011 9:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics