How to create a crystal report using three sql tables

Question

0.00/5 (No votes)

See more:

, +

I have created a database contains three tables.
Table Names :
deposits : "dpid","date","custname","description","chqno","duedate","accname","amount"
bank charges : "bankid","date","accountname","description","amount"
Opening Balance : "opbid","date","accountname","amount"
I need to create a crystal report using above three tables.If i selected these three table it shows all the datas correctly like below,

"date","custname","chqno","duedate","amount","bankid","date","amount","opbid","accountname","amoun"

i need opening balance amount in a column and the other two amounts in a column in a date order. And need to substract deopsit amount and bank cahrges amount from opening balance amount. Can anyone help me to find a good answer for this

Posted 11-Aug-14 22:32pm

Mohamed Shakir

Add a Solution

Comments

Herman<T>.Instance 12-Aug-14 4:34am

I do not see any relational fields between the 3 tables....

Mohamed Shakir 12-Aug-14 5:38am

account name is unique to all three tables

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)

Bhagyashree Chaudhari - Member 10473634 · Answer 1 · 2014-08-31T23:33:00

Solution 1

In crystal report , add these three table and join them by account name , after that you need to drag and drop your fields which you want to show in report.

Is it useful for you , let me know.

Thank you.

Posted 31-Aug-14 23:33pm

Bhagyashree Chaudhari - Member 10473634

Gihan Liyanage · Answer 2 · 2014-08-31T23:41:00

Solution 2

Generate a Report using Crystal Reports in Visual Studio 2010[^]

This link is having simple sample how to do Crystal report with VS and SQL, Likewise you can understand what he is doing and you can think bit for next two tables.

Posted 31-Aug-14 23:41pm

Gihan Liyanage

Comments

Gihan Liyanage 15-Sep-14 6:24am

Did you got a solution from my support, I can see you have not accepted any answer.If you are ok with this answer plz accept it. Then any user having same problem can identified it has solved the problem..