Cell value becomes 0 after exporting

Question

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

Answer 1

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.

Answer 2

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