0

Hi guys,i was using crystal reports in my vb.net project.I read in some books and in the internet that you can create a grand total for some fields like total cost calculation.And using 'sum' you can calculate the total result.well in my case i can't find 'sum' in my crystal report which is for visual studio 2010.
what is the solution.

2
Contributors
5
Replies
17
Views
4 Years
Discussion Span
Last Post by Nebil
0

Hi,

It is not a type it is a formula in a crystal! e.g. I have a table that has a column "cost", it has 3 rows with cost values of 1, 1, 2 I want my crystal field, TOTCosts, to display the sum of the cost field:=SUM(Costs) my Crystal Field now displays 4 (=1+1+2)

0

I figured out the problem and that is i have a label field that stores a calculated result.Then with a code that result is set with a currency format.That is you can format the result if it's in a string format.
And it's stored in the db with a field of text property.If the field is in a number format it results in a data type mismatch.and crystal reports only sums fields of number data types.
What is the solution.

0

This is the code
bridge asset is in decimal format
bridge asset1 is in string format

bridgeasset1 = Format(bridgeasset, "ETB #,##0.00")
            Label12.Text = bridgeasset1
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.