I am making one crystal report using 8.5
I want to select data based on parameter part.
ie. 01 selected, then all rec for part 01 should come,
if i select 02, 03 then all rec for part 2,3 should come.
i define parameter part which can take multiple values.
i gave in edit selection following formula
instr({dbo.part},{part?})>0
if i change part parameter setting to discrete value in crystal report,
i am getting record.
But if allow multiple selection, then report not working.
if i give instr({dbo.part},{part?}[1])>0
then no error but parameter is not displaying in selection.
Data is as follows.
| DOCID |
DESC |
TITLE |
PART |
| RFI1 |
RFI 1 |
TEST 1 |
PART 01,02 |
| RFI2 |
RIF 2 |
TEST 2 |
PART 02,03 |
| RFI3 |
RIF 3 |
TEST 3 |
PART 01,02,03 |
| RFI4 |
RFI 4 |
TEST 4 |
PART 03 |
| RFI6 |
RFI 5 |
TEST 5 |
PART 03,04,05 |
| RFI7 |
RFI 6 |
TEST 6 |
PART 02,04 |
| RFI8 |
RFI 7 |
TEST 7 |
PART 04,01,05 |
Edited by gulkul - 26 Sep 2011 at 3:41am
IP Logged