selecting data with where condition in crystal report

Question

0.00/5 (No votes)

See more:

Hello,

I am fetching data from a single table for BankBook, I have a status column in the tbl_BankBook where status is like 'Income' or 'expenditure', got stuck when I am trying to display data according to my status column.

I have columns having name like date, particulars, bank amount(cr), amount(dr).

I want to place data according to status(Income / expense) column in amount column .
i did it by suppress property , code:- if {tbl_Bank_Book.Status}='Expenditure' then true

i want to implement sum funtion for both amount column according to status. i am failed to sum. it is displaying total
sum not according to status column.

Regards,
Arshad

Posted 21-Jan-11 20:44pm

arshad alam

Updated 23-Jan-11 21:00pm

v3

Add a Solution

Comments

thatraja 22-Jan-11 3:02am

Confusing little bit, Do you mean hide the section(income/expenditure) based on status column value? can you attach screenshot or link of the report in your question? It will help you to get the solution quickly.

arshad alam 22-Jan-11 5:19am

i want to like balance sheet

arshad alam 22-Jan-11 5:19am

opp, i meant to show like a balance sheet

Chris Maunder 22-Jan-11 6:55am

Far better to just edit your original comment than repost a new one.

arshad alam 24-Jan-11 3:03am

check it once more.. i have modified...

Member 10986425 19-Dec-14 13:45pm

same problem here i have vatpercentage column and vatamount column,i want total of vat amount where vat percentage = 12.5 and another total of vatamount where vatpercentage = 5 , retriving records between two dates pls, help me

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Estys · Answer 1 · 2011-01-21T23:34:00

Solution 1

Very quick and dirty :

Select tbl_BankBook.Amount as Expenditure , 0 as Income from tbl_BankBook where tbl_BankBook.Status = 'Expenditure'
UNION
Select 0 as Expenditure , tbl_BankBook.Amount as Income from tbl_BankBook where tbl_BankBook.Status = 'Income'

Check up on PIVOT queries

Cheers

Posted 21-Jan-11 23:34pm

Estys

Updated 23-Jan-11 22:43pm

v2

Comments

arshad alam 24-Jan-11 3:51am

where to write this code ??

Estys 24-Jan-11 4:42am

This would be the query to fetch the data. You could add the SUM() function to it if you like.

arshad alam · Answer 2 · 2011-01-24T01:03:00

Solution 2

i solved my problem, thank you all guys who helped me.
i used Running total Feild by using a formula.

Posted 24-Jan-11 1:03am

arshad alam

Comments

Member 10986425 19-Dec-14 13:47pm

please tell me formula....hows this poossible