Cascading Parameter not working

Hi Friends,

I have 2 parameter One is Office (Listbox) another Account(list box) , where Account list box filling is dependent on the Office selection.

In published report when I select the office from list box the page got refreshed but it not updating the account list, the account list box looks diabled?

I have define the two parameter and for the second parameter here is the query

="SELECT ACCOUNT_ID, ACCOUNT_NUMBER FROM MLGDB2.A_ACCOUNT " &
"where OFFICE_ID =" & Parameters!paramOffice.Value &
"ORDER BY ACCOUNT_ID "

Can any one help me.

Thanks

Novin

Hi Novin

I am not sure you are doing this in the most straight forward manner.
In your situation I would define another dataset e.g. dsAccount with the following query:

SELECT ACCOUNT_ID, ACCOUNT_NUMBER FROM MLGDB2.A_ACCOUNT
where OFFICE_ID = @.paramOffice
ORDER BY ACCOUNT_ID

Then set up the Account parameter to get its data from the dsAccount dataset.

This should refresh correctly.

Cheers
Mark
|||Hi Mark,

Thanks for your reply.

I know the sytext , I m using ODBC driver which does not support @.param ,

To access parameter i need to use Parameters!paramOffice.Value with ODBC.

Thanks
Novin
|||

Hi

The implementation is working it was a silly mistake from my side i have assign wrong data type the the paremeter.

Thanks,

Novin