Wednesday, 28 August 2013

How to collect records in crystal report using record selection formula to concatenate records

How to collect records in crystal report using record selection formula to
concatenate records

What i want is to collect records using record selection formula on the
basis of criteria selection.
If i have 2 criteria's then i have 4 combinations using criteria
selection. e.g.
if(cri1 <> 'ALL' and cri2 <> 'ALL') then record fetched
else if(cri1 = 'ALL' and cri2 <> 'ALL') then record fetched
else if(cri <> 'ALL' and cri = 'ALL') then record fetched
else if(cri = 'ALL' ; cri = 'ALL') then record fetched

(cri1 and cri2 are parameter fields used in crystal report)
In the same way for 3 criteria's, i will have 8 combinations. That is, for
n criteria's i will be having '2' to the power of 'n' combinations That
means for 10 criteria's i will be having 2 to the power of 10 combinations
(i.e. 1024) combinations.
Well i want to know whether is there any way to collect data in much
simpler way for n number of criteria's. Because for more than 3 criteria's
it will be very confusing to collect the records.
** Please help on this..**

No comments:

Post a Comment