Saturday, November 17, 2012 9:11 AM
Im having a matrix control inside a list. In one of the cell( out side the column and row group) Im calculating a value using Custom code.
And I am getting the correct value when I take the report. But when I exported this report to excel or pdf then that particular value is showing as zero. I tried formatting the Textbox but same result. Any one has got the same issue ? please help.
- Edited by Shine Gopal Saturday, November 17, 2012 11:10 AM
Monday, November 19, 2012 7:19 AM
with reference to your post, created a sample report with sample custom code and tried exporting into excel format in test environment. please refer below for details and procedure. in case if you are doing some calculation in the footer please check whether you are passing numeric or integer datatype if not can you use cint() as shown in the screenshot below while passing for custom code function.
Please mark as answered if it resolves your issue or helpful.
Tuesday, November 20, 2012 10:12 AM
Hi Thank you for your time ,
I resolved my problem by assigning the value of the custom code to a variable and using the variable value in the cell. Below was my custom code used to find the sum of column groups.
I was calling the code.GetTotalMSLCount() directly from the cell.
DIM Shared TotalMSLCount as Integer Public Function SumMSLCount(ByVal MslCount as Integer) TotalMSLCount =TotalMSLCount +MslCount End Function Public Function GetTotalMSLCount as Integer Return TotalMSLCount End Function