Software Applications Programming Errors and solutions.

 Error on SSRS Report execution Excption information: Exception type: HttpException Exception message: The length of the query string for this request exceeds the configured maxQueryStringLength value. at System.Web.HttpRequest.ValidateInputIfRequiredByConfig() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Solution Go to C:\Program Files\Microsoft SQL Server\MSRSXX.<instance_name>\Reporting Services\ReportServer\ Open the web.config Find the <httpRuntime> element. <?xml version=”1.0" encoding=”utf-8"> <configuration>     <system.web>         ...         <httpRuntime maxRequestLength="100000" executionTimeout="90000" requestValidationMode="2.0" >         ...     </sytem.web> Add or modify the maxQueryStringLength attribute (DefaultValue is 2048). <?xml version=”1.0" encoding=”utf-8"> <configuration>     <system.web>         .

  To display string value line wise in SSRS using Expression you can get help on below code sample. Yon can try in your report. If you want to display line wise from any specific character then you can try this. Here comma used string. Replace(First(Fields!Sting260.Value, "DSTest"), chr(10), ",")