I have to create Sum() in SSRS for my report. My field data type is TEXT and i can not create sum function in ssrs. I can not make change to data type since it is linked table in access database. Is there any way to sum text data type???.
actually, i have some data which are number. however, in access 97 thousands numbers are defined as text data type. SSRS was not converting text datatype to number in sum function. So, i converted text data type to int. and then Sum() thousands numbers.