In desperation I am seeking to the forum. There are many posts in the Internet on solving this issue and it does not work for me and I am not sure what I am doing incorrectly.
The Issue is: While running the report using info view it is prompting for DB authentication for sub report param value.
I have a prompt in my main report and the parameter value I pass to the sub report Command.In the sub report within the Command I have created a Parameter which I use in my sub report Where clause. This sub report parameter, I have linked it to the main report prompt parameter. The report works fine and I get the data, but whenever I run it from Infoview it is prompting for DB authentication. In my CMC for the report properties for the DB section ,I have chosen "Use same database logon as when report is run" and saved the DB name and Password.
My Environment: CR Designer-2013
Report Server: CR 2011
Business Object Enterprise 11