Crystal report problem

[Paulson]

Dear friends

I am working on a windows application and I am using
crystal reports in that.I have a table Country and another table State in the database.I want to show the report as follows.

Country(TableName) State(TableName)

India TN
AP
Maharashtra

America California
Los Angeles

But I am not able to get it I am getiing like this


India TN
AP
Maharashtra
California
Los Angeles

India TN
AP
Maharashtra
California
Los Angeles

India TN
AP
Maharashtra
California
Los Angeles

America TN
AP
Maharashtra
California
Los Angeles

America TN
AP
Maharashtra
California
Los Angeles


The country is one main report and in that state is a sub report I want to link these 2 using countryId and want to avoid repeatition of Countryname.

Can anyone of you pls help me?
Thanks for help in advance.

bye Paulson.

[debasisdas]

How are you retrieving from database ?

What is the SQL that you are using ?

[Paulson]

Hey guys

I need to show a crystal report in which name of countries must be a report.State names a sub report within it and citynames
another sub reports within it.I dont think that we can make a subreport in a
subreport. So i made a main report for countries and in that I made 2 sub reports
but for each country all the country names and state names are repeating.

How can I avoid this repeatition ?

Pls help me.

Thanks for any help in advance.

bye Paulson.

[Paulson]

HI ,


Thanks for reply.I used the crystal report wizard option selected the two tables I needed and using the Link options I gave a right join "=" in the Link options.Then I made a subreport and showed the join result in the subreport.
Then I made a main report and showed the countrynames only in the main report.I made the subreport a subreport in main report and linked using the country name.Then it came correctly.My problem is now solved but I got another problem > I need to show another subreport in the state names that has the citynames.I tried subreort within subreporrt but it is not working.
I tried to make 2 subreports in the main report and link using statename and country name but doing so so many columns are repeating.
Do you have any idea how to solve this problem?
Please help me.

Thanks in advance.

bye Paulson.

[IntellectYog]

Hi,

Have added the Filter link of sub report there ? I think after adding it , may solve ur proble.

[Paulson]

Hi,

Have added the Filter link of sub report there ? I think after adding it , may solve ur proble.

Thanks for the reply I will be checking it out and I will reply to you
Thanks for the help.

Paulson.