Hi,
I¡¯ve created a report which utilizes two stored procedures to populate parameter dropdown and fill report itself respectively. Report works fine until I create parameterized connection string. When datasource (not shared) has parameterized connection the parameter dropdown is greyed. I¡¯m getting error: ¡®error during processing of the ConnectString expression of the datasouree ¡®name¡¯¡¯. It works fine when I¡¯m using only one stored procedure (no parameter dropdown stored procedure is executed ¨C report has only one dataset). It looks like adding second dataset to use datasource with parameterized string spoils something.
Any advices are welcome.