Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Data report function problem

I am creating a data report and i have a simple query which shows all the data i.e amount and such fields
and i want the sum of the amount filed. and in the footer i used a report function and used the sum and assigned the amount field for sum
but while viewing the report i am getting data type mismatch and i am not able to view the report.
0
gsbharathi
Asked:
gsbharathi
1 Solution
 
xSinbadCommented:
One of your fields is most likely not a numeric field type, have you checked them in the table.
0
 
gsbharathiAuthor Commented:
In the table the datatype is numeric(11,2) and it is a not null field I am using Oracle database.
0
 
xSinbadCommented:
Hmmm how did you use the function i.e. sum(blah,blah)
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
gsbharathiAuthor Commented:
I have added a report function and in the properties for the report i have chosed rptFuncSum  for Function type property and  in the datafield property i have chosen the column whose sum is required i hope i am going in a proper way..
0
 
Anthony PerkinsCommented:
Do you need any help maintaining your questions or are you planning to leave all your question open?  For the record:

Questions Asked 9
Last 10 Grades Given  
Question Grading Record 0 Answers Graded / 0 Answers Received

Anthony
0
 
mlmccCommented:
Do you know which field is giving the problem?

You might try building a report yo simply show each record without trying to do any summaries to ensure you are getting the data you expect.

If you don't see anything ad the summaries one at a time until you get the error.

mlmcc
0
 
gsbharathiAuthor Commented:
mlmcc:
 The query i have written contatins a case statement this is the query

select distinct iid,
rtrim(vcbankID) AS BankNumber,
amount as TotalAmount,
amount-nvl(withdrewamt,0) as CaseAmount,
CASE WHEN (amount=0) THEN 0
     ELSE to_number(((amount-nvl(withdrewamt,0)) *100)/amount)
          END as PrctAmoount,
nvl(withdrewamt,0) as withdrewamt,
CASE WHEN nvl( withdrewamt,0)=0 THEN 0
      WHEN (amount=0) THEN 0
          ELSE (nvl(withdrewamt,0)*100)/amount
          END as PrctIncurred
from bankdetails

I am able to get the sum of total amount but not able to get the sum of caseamount and prctamount


acoerkins:
 The questions i have asked are still unsolved i think i got answer for one question only till now..

0
 
twalgraveCommented:
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- refund/PAQ
Please leave any comments here within the
next seven days.
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now