•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 456,519 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,815 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 2025 | Replies: 2
 |
•
•
Join Date: Oct 2007
Posts: 11
Reputation: 
Rep Power: 2
Solved Threads: 1
Newbie Poster
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.
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.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,444
Reputation:
Rep Power: 4
Solved Threads: 87
kindly post your table structure for further details.
Last edited by debasisdas : Oct 5th, 2007 at 2:16 am.
Share your Knowledge.
•
•
Join Date: Oct 2007
Posts: 11
Reputation:
Rep Power: 2
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by debasisdas 
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.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Summation of Datagrid field/Column (VB.NET)
- Getting sum of array (PHP)
- First Attempt at Arrays (Java)
- Help-->SQL Statement in vb6 for getting total of Field (Visual Basic 4 / 5 / 6)
- TopN/Sort Group (VB.NET)
- Creating New Columns From Calucations (MySQL)
- Sum of digits (C++)
- FIeld width zero? (Visual Basic 4 / 5 / 6)
Other Threads in the Oracle Forum
- Previous Thread: SP2-0640 Not connected
- Next Thread: Form from oracle with php
