3 Different Query

[titigoda]

Hi All,

I am new to CR. I am having one report which will look like this

___________________________________

Query One data
____________________________________

Query two Data

____________________________________

Query three Data

___________________________________


When i try to do this it automatically creats Relation between three query
i.e if Query 1 return 5 record,Query 2 return 5 record,Query 3 return 5 record

Then report is having 125 records but i want only 5 + 5 +5 = 15records

How can i do this ??

Thanks in advance

[jggtz]

You didn't say where your data is (SQL, Access, etc.)
You are letting that crystal choose the JOIN type, check the Links tab in Menu / Database / Database Expert and set the right ones

Other solution could be to build a View or SP, writing your own query or changing the query at run time if you can modify the app that calls the rpt