Avatar of stltom
stltom
Flag for United States of America

asked on 

Parameter Dynamic Option Unavailable

I am trying to set up a cascading parameter from two tables.

The problem is, that I cannot select dynamic whenever I am setting up the parameters.  The only option available is static.

I am basically trying to pull a a part number from tbl.pricebook.ItemID and then be able to select one of the serial numbers based on tbl.pricebooklabels.

For each Item ID there are many serial numbers.

However the root cause is that I am unable to select dynamic for my parameters.  It is completely greyed out.

Any help would be greatly appreciated.  Thanks!!!!
DB Reporting ToolsMicrosoft SQL ServerCrystal Reports

Avatar of undefined
Last Comment
stltom

8/22/2022 - Mon