I am using oracle query in that four fields are number.
I am subtracting that field such as (field1 - field2 -field3 - field4) as DNF
Actually I am creating query in view. While creating this view the last field DNF is created as varchar2(40) automatically.
I am using this view in crystal report 8.5. I want to calculate that field grand total. But in crystal report it showing string, So Crystal Report is not giving sum of option.
So please give me solution.
yogesh_vaidya12 0 Newbie Poster
debasisdas 580 Posting Genius Featured Poster
kindly post your table structure for further details.
yogesh_vaidya12 0 Newbie Poster
kindly post your table structure for further details.
That Four Fields are the function to retrivew the data and in the view description it shows all are number datatypes.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.