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.
Free Windows Admin Tool Kit Click here and download it now
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