gsbharathi
asked on
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.
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.
One of your fields is most likely not a numeric field type, have you checked them in the table.
ASKER
In the table the datatype is numeric(11,2) and it is a not null field I am using Oracle database.
Hmmm how did you use the function i.e. sum(blah,blah)
ASKER
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..
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
Questions Asked 9
Last 10 Grades Given
Question Grading Record 0 Answers Graded / 0 Answers Received
Anthony
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
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
ASKER
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(wit
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)/a
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..
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(wit
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)/a
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..
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.