Skip to Content
0
Former Member
Dec 19, 2006 at 10:34 PM

No data Found the whole report is suppressed

25 Views

<p>Hello, </p><p>I am trying to create a report with two commands (without link) Command1 would have data in any circumstance as it has the report information (e.g title etc.,) which is stored in database. </p><p>Command2 data is dependent on the parameters passed (eg. emp_date < = begin_dt(parameter) etc.,) </p><p>Now when there is no data returned by command 2 I still need to display data which is returned by Command1 which is not happening. </p><p>&#160;</p><p>To achive this I have created a link and outerjoined the two commands.. it is still not working since the record selection formula is using command2.emp_date< begin_date.. which wud override the outer join. </p><p>Is there any way to achive this. Can anyone please help me with the solution. </p><p>All I want to do is have two queries and display data irrespective of each other. </p><p>Thanks,</p><p>&#160;</p>