<div>
It's either the join or the relationship of the data between the two queries. <br />
Can you post your combined query along with some data showing the results you get and the results you want?
</div>


It's either the join or the relationship of the data between the two queries.
Can you post your combined query along with some data showing the results you get and the results you want?

<div>
I can't post the query here sorry.. I am using a &nbsp;0..n = 1.1 &nbsp;relationship between the two queries.<br />
<br />
current output:<br />
<br />
Received &nbsp; &nbsp; &nbsp;320<br />
<br />
<br />
Required output:<br />
<br />
Received &nbsp; &nbsp; &nbsp; &nbsp;275
</div>


I can't post the query here sorry.. I am using a  0..n = 1.1  relationship between the two queries.

current output:

Received      320


Required output:

Received        275

<div>
If you use 0..n, it'll always pull more data.<br />
Try 1..1 -- 1..1 in both side.
</div>


If you use 0..n, it'll always pull more data.
Try 1..1 -- 1..1 in both side.

<div>
I tried the above cardinality and the output is &nbsp;still as above..
</div>


I tried the above cardinality and the output is  still as above..

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have report where we are joining 2 queries. But the issue is &nbsp;it is pulling more data.<br />
<br />
Any help what might be causing this..
</div>
</div>


Hi,

I have report where we are joining 2 queries. But the issue is  it is pulling more data.

Any help what might be causing this..

Cognos Report Join issue

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.