How to create crystal report using two tables with single parameter

Question

0.00/5 (No votes)

See more:

i know how to create a crystal report using parameter.but i dont no idea to link two parameters field to one id.

table 1                       table 2
acno                          acno
name                          repayment amount                        
date                          repayment date                          
loan amount                   bal
loan int

What I have tried:

please give me a idea friends...................................................................................................................................................

Posted 3-Mar-18 3:29am

Pasupathy Msc

Updated 3-Mar-18 4:42am

OriginalGriff

v2

Add a Solution

1 solution

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)

OriginalGriff · Accepted Answer · 2018-03-03T04:43:00

Solution 1

Try:

SQL

SELECT * FROM Table1 t1 
JOIN Table2 t2 ON t1.acno = t2.acno

Other than that, we have no idea what you are trying to achieve, so you will need to look up SQL Joins[^] and modify the query yourself.

Posted 3-Mar-18 4:43am

OriginalGriff

Comments

Pasupathy Msc 4-Mar-18 2:30am

thank u chief
and i have another doubt.

i have receipt form. i need to send the value for report form.like retrieve parameter value from another form how can i do this

OriginalGriff 4-Mar-18 4:10am

Open a new question, and explain in more detail - we can't tell much from trivial explanations and we really do need to know exactly what you are doing and where you are stuck. There are a *HUGE* number of different things you could be doing which all fit under the broad banner of "i need to send the value for report form.like retrieve parameter value from another form" and we can't tell which. So show us relevant code fragments, explain in detail - the better the question, the better the answer!