Stand alone report designer - Adding columns in a Storedprocedure causing error

[Suresh]

I am using a standalone report templates to display the data from SQL data source with using stored procedure. If I  add the columns in the select statement of stored procedure causing the below error.

Designer details,

For datasource since we are passing connection string dynamically we cannot refresh the configuration manually from report designer. In that case how do we resolve this issue?

Thanks in advance

[Suresh]

 This is resolved now. In report templates we are using two different data sources with two stored procedures. One is calling other one internally which is causing this issue. 

Thanks.