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 – report has only one dataset). It looks like adding second dataset to use datasource with parameterized string spoils something.
Any advices are welcome.