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..**
