Skip to Content
0
Former Member
Dec 11, 2006 at 09:59 AM

crystal where clause logic

33 Views

<p>Hi i am working on crystal 10 and roacle 9i</p><p>&nbsp;</p><p>i am having trouble passing the parameters to subreports</p><p>&nbsp;</p><p>for the main report , i am passing the parameter</p><p>&nbsp;</p><p>CAPA.EFF_START_DT >=User Entered Start Date <br /> AND NVL(CAPA.EFF_END_DT, TO_DATE(&#39;12/31/3000&#39;, &#39;MM/DD/YYYY&#39;))<=User Entered End Date <br /></p><p> but for the main report i just need to pass </p><p>CAPA.EFF_START_DT >=User Entered Start Date</p><p>how can i do that , i know linking the subreports with the main report , but the whereclause for the main report is different from the whereclause for the subreport ,</p><p>Does any body have any suggestion</p><p>&nbsp;</p><p>thanks in advaance</p><p>&nbsp;</p><p>de1209 </p>