Cell value becomes 0 after exporting
Hi, 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. Shine
November 17th, 2012 4:11am
Hi Gopal, 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. Cheers, Arun Gangumalla Please mark as answered if it resolves your issue or helpful.
November 19th, 2012 2:19am
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 Shine
November 20th, 2012 5:33am