Regarding Some parameters of crystal report..

[Former Member]

hi..

have a look on   below image.

i had develop a crystal report with two parameters

like cardcode and item code from  ordr and rdr1

so, what i need is

parameters  values  should pop up  like cfl 

i think it is possible may i know how can i do it. bcz i seen some where..

[Former Member · Accepted solution]

Hi,

In the CR designer, rename the parameters as followed:

CardCode@FROM OCRD

ItemCode@FROM OITM

Beni.

[Former Member · Accepted solution]

HI.Beni  i got the Solution
but i need  Cfl  but here  Drop down list is comming..

May i know why..

I read one pdf file  they asked me to do some changes i done it..

but still  Drop down list is comming is  at parameters...

[former_member197621]

Hi Srinivas,

Try the below example,

Sample  for : BP selection

• @select *  from ocrd - (Allow Multiple Values = Yes)
• @select *  from ocrd -(Allow Multiple Values = No)
• @select cardcode,cardname from ocrd -  (Allow Multiple Values = Yes)
• @select cardcode from ocrd -  (Allow Multiple Values = No)

Sample  for : Item selection

• @select *  from OITM - (Allow Multiple Values = Yes)
• @select *  from OITM -(Allow Multiple Values = No)
• @select itemcode, Itemname from OITM -  (Allow Multiple Values = Yes)
• @select ItemCode from OITM -  (Allow Multiple Values = No)

Same concept for all the tables like OWHS, OACT etc....