Hi,
I have a report with a parameter which asks for a customer code. Once the customercode is eneterd manually, the report shows the details for it.
I want the user to get the customercode dynamically from a dropdownlist that will show all customercodes availablei.e it will get all info from the custmaster table.
When I create a parameter, there is only a way to add default values but these default values dont get refreshed dynamically. If I add a new customer, it doesnt get added automatically to the list. I have to manually add it.
Can anyone tell me how to update the list automatically. Currently my selection formula in parameter looks like below
select {CustomerMaster.custcode} = {?Enter Customer Code}
I have a report with a parameter which asks for a customer code. Once the customercode is eneterd manually, the report shows the details for it.
I want the user to get the customercode dynamically from a dropdownlist that will show all customercodes availablei.e it will get all info from the custmaster table.
When I create a parameter, there is only a way to add default values but these default values dont get refreshed dynamically. If I add a new customer, it doesnt get added automatically to the list. I have to manually add it.
Can anyone tell me how to update the list automatically. Currently my selection formula in parameter looks like below
select {CustomerMaster.custcode} = {?Enter Customer Code}