How to work with dynamic Cascading parameter on SAP B1 9.2?

[former_member608333]

Hi all,

pic2.jpgpic1.jpg
I am making a report which has dynamic cascading parameters. On Crystal report staging it is working fine, it is given options to select from the list of values but when I trying to run this with SAP business one 9.2 preview external crystal reports it didn't give me the selection list. I attaching Photos with the question, Hope, I am clearing my point here if any want to ask another question, Please feel free to ask or is there a way around to get this done.

Please suggest how to do correctly,

Thanks in advance,

OSAMA HILAL

[former_member608333]

Hi Santos,
Great to hear your answer, but I am using the dynamic cascading parameter which works between parameters values like my first parameter is Tax_type and second is Business Partner. The behaviour of these parameters is first they ask for tax_type filter data accordingly by the given value and then ask for a second which works on the already filtered from the first parameter. Hope, I am clearing my point here,
Or
If I use Static parameter prompt, The first token is
Tax_type@Select distinct U_Tax from DBO.[@CPRR]

it is absolutely working fine but when I am trying to put my second static prompt

BP@Select Distinct b.Code,b.Name from DBO.[@CPRR]a inner join DBO.[@OCPR]b on a.Code=b.Code where (a.U_tax=@Tax_type)
It exceeded the limit of the prompt, is there any around to get this done.

Please feel free to ask any question. pic3.jpg

[HectorSantos]

Hello

There is a thing called tokens for SAP Business One in Crystal Reports. There are used to have dynamic parameters. You should create the parameter with this structure: <parameter_name>@<SQL_Expression>

For example, for VendorNames the parameter could be named

Vendors@Select * from OSLP

Hope these helps