Hi and happy Easter
I've been trying to do something 'simple' all afternoon but can't get it to work :(
I wish to have 2 two parameters, the second connected to the first.
The main report is:
CREATE PROCEDURE `sp_DBR_Batch_Trace`(inSKU varchar(30),inBatch varchar(30))
The first parameter is a select list with find and Not to remember User's choice and is defined as follows:
Select `Item Code`,`Item Code` from `item master`;
The connected parameter is defined as a Radio Button and via sp_ADBR_Batch_Num:
CREATE PROCEDURE `sp_ADBR_Batch_Num`(mydbr_param_prev1 varchar(30))
select batNum,concat(batNum," ","First Used on ",date_format(batDate,"%d/%m/%Y")) from tblBatchOrig where batItem=mydbr_param_prev1 order by batDate desc;
When I key in an Item Code or select one from Find the second connected parameter remains as No parameters available.
However I can run the report and get displayed a correct Item Code and Batch Number. Also when I click the cog wheel to show the parameters I now see the connected parameter radio buttons.
Hope you follow that.