Hello to Evryone,
i am using the software to making a crystal report from it. i have one main report and there is subreport in the main report. i set the three parameters in the sub report data but when i run the main report and then click on Sub report the report shows one record repetedly more times. i set the record selection also and use Command for that.
day({Command.order_date})={?Day} and
month({Command.order_date})={?Month} and
year({Command.order_date})={?Year}
and
{Command.ordsr_no} = {?Pm-Command.ordsr_no}
and
{Command.prtdtl} = {?Pm-Command.prtdtl}
and
{Command.ctgry} = {?Pm-Command.ctgry}
i use this in the record selection of the sub report but repeted data display. so which way i solve the my problem ? or guide in some way.....
also i use command like :
SELECT compdtl.coname,purord.ctgry, purord.ordsr_no, Munim003.dbo.gdmast.gdname, xxx.dbo.gdmast.gdcode, glmast.glname, purord.order_date, purord.postflag, purord.rate, purord.unit, purord.itqty, purord.amount, purord.order_no, purord.prt_invdt, purord.consdocqty, glmast.gladd1, glmast.gladd2, glmast.glcity, glmast.glpin,
purord.PreCarriageBy, purord.NET_AMOUNT, purord.TTX1P, purord.TTX1A, purord.TTX2P, purord.TTX2A, purord.TTX3P,purord.TTX3A, purord.TTX4P, purord.TTX4A,purord.TTX5A, purord.TTX6P, purord.TTX6A, purord.TTX7P, purord.TTX7A, purord.TTX8P, purord.TTX8A, purord.TTX9A, purord.TTX10P, purord.TTX10A, purord.TTX11P,
purord.TTX11A, purord.TTX12P, purord.TTX12A, purord.total_amt, purord.particular, purord.TTX9P, purord.EditUserId, purord.EntryUserid, purord.prtdtl, purord.bchcd,purord.terms, purord.tranterms,purord.itdetail FROM xxx.dbo.purord AS purord INNER JOIN xxx.dbo.glmast AS glmast ON purord.pcode = glmast.glcode INNER JOIN
xxx.dbo.gdmast ON glmast.glcode = purord.pcode CROSS JOIN Munim003.dbo.compdtl AS compdtl
ORDER BY purord.postflag
OR it is possible to use that Parameter used in Command as Where Condition because Record display in sub report based on that parameter [? Pm-Command.ordsr_no].
Thanks and Regards...
Mitesh