Is there a way to manually or programmatically set the dataset field's data type?
The reason I am asking this question is that I am trying to sum a column of data in a report. I noticed it is possible to sum a column of data if the datatype of a field in the .rdl file is of type <rd:TypeName>System.Int32</rd:TypeName>.
Whereas it is not possible to sum a column of data in an .rdl file when the datatype of a field is <rd:TypeName>System.String</rd:TypeName> .
When I create a dataset in BIDS 2008, by default, the dataset gives a field a type System.String. I need to be able to change the field type to System.Int32 in order to sum the column.
My datasource is a web service. The results returned by the web service method has a datatype of int as follows:
<xs:element name="Dollars" type="xs:int" minOccurs="0" />
So it seems the dataset created by the reporting services is giving my webservice a type of System.String.
Is there some way of manually changing the type?
View Complete Post