I have to tables in one crystal report....

Question

0.00/5 (No votes)

See more:

HI
I have two difrents Table;
but I was show them in one crystal report;
I was show all row in one table
then show an other next.

can you help me?

Posted 12-Jul-11 20:57pm

raheleh_es

Updated 12-Jul-11 21:38pm

v4

Add a Solution

Comments

Syed Salman Raza Zaidi 13-Jul-11 3:12am

You'll have to make joins on related records and create a dataset for the report using the joined query

raheleh_es 13-Jul-11 3:31am

I can't join them becuse have difrent culom and I was show all row in one table then show all row in next table

Syed Salman Raza Zaidi 13-Jul-11 3:34am

can you share the name of columns(ie structure) of both tables and also tell which records to show on report

raheleh_es 13-Jul-11 3:35am

Are you from Iran?

raheleh_es 13-Jul-11 3:36am

CAN YOU GIVE ME AN EXAMPLE?
PLZ

Syed Salman Raza Zaidi 13-Jul-11 3:38am

I am from Pakistan,i can help u but you'll have to share the name of columns(ie structure) of both tables and also tell which records to show on report

raheleh_es 13-Jul-11 3:39am

PLZ GIVE ME YOUR EMAIL

Syed Salman Raza Zaidi 13-Jul-11 3:43am

well email address's are not allowed here :)

raheleh_es 13-Jul-11 3:48am

TABLE1:STUDENT NAME FAMILY CODE(IT,S MY KEY) CITY FATHERNAME
1 2 3 4 5
1 2 4 5 6
3 4 5 6 7
TABLE2:OSTAD NAME_OSTAD FAMILY_OSTAD CODE_OSTAD CITY_OSTAD FATHERNAME_OSTAD

113 123 123 145 25
2222 222 222 222 22
I WAS SHOW THIS IN CRYSTAL REPORT HOW CAN I DO? I'M SORRY FOR DISINGE

raheleh_es 13-Jul-11 3:52am

How can i sent file to yoy in codeproject?

Syed Salman Raza Zaidi 13-Jul-11 3:53am

cant u apply join on Famil_Code and Family_Ostad or Family_Code and Code_OSTAD???

raheleh_es 13-Jul-11 3:55am

No becuse table1 for student and table 2 for ostad and ican not say which student relation to which ostad but i was show all ostad and all student in one crystal

Syed Salman Raza Zaidi 13-Jul-11 4:05am

add me salmanzaidi87 at gmail

raheleh_es 13-Jul-11 4:30am

plz check your mail box

Syed Salman Raza Zaidi 13-Jul-11 5:06am

no email yet

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)

Syed Salman Raza Zaidi · Answer 1 · 2011-07-12T21:59:00

Solution 1

Try this

Select * from student,ostad

if this will not work then you'll have to make a relation between two table

Posted 12-Jul-11 21:59pm

Syed Salman Raza Zaidi

Comments

raheleh_es 13-Jul-11 5:00am

??????????????????????????? are you ok?