[Nisha]

Hai all,
Is it possible to fetch the 'Provider ID' from the database and populate it in the Provider ID drop down of the report?

I tried this in OTM by selecting the following:
1. Parameter Type - is 'Dynamic List' and
2. Query Name - i selected from the picklist(already existing one.for eg:SERVPROV)
Finally the provider Id's are displaying in the drop down list but if i select anyone and click Submit button then it shows an Error like this :
REP-300: quoted string not properly terminated

Note:i tried the same in the report builder also but it also shows some error like "Invalid Identifier"

Kindly help me to solve this problem.

thanks & regards,
S.Nisha