Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts

Monday, February 9, 2015

SSRS Report - Multi Value Parameter Throws Error - The status code returned from the server was: 500

Hi All,

Its have been quite a while that i didn't wrote a article. For last few weeks i was working on an assignment of SSRS Reports. 

With Assignment i was able to use the Great features of SQL, but at the same time there were some challenges due to simplicity in navision for Some specific points like Dates, Options, Flow fields etc.

After Developing the Report when i host it on the Report Server and Tried to Run the Report, i faced the Error message -

"Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500"

In the Article below we will see how to resolve the Same.

Sunday, September 7, 2014

How SQL Database / Table & Field Name Changed When we Use Some Special Character in NAV?

Hi All,

One of my NAV Friend while working on SSRS Reports asked a Question. Below is the Query is his words?

"Hey Saurav - When i trying to access table Sales Prepayment % or Field Prepayment % or using a database Named as Demo Database NAV (7-0) i get a different name is SQL instead of Navision. Why there is a change? Which all character get changed? Where i can find this change Character List?" 

So those who Know this, i guess what is below is nothing new for you, but those who still are curious about it should Read Ahead...

Saturday, December 14, 2013

SSRS - Configuration & Issue Resolution.

Hi all,

As per the previous post we have configured the SQL Server Reporting Services.

For getting access to Reporting Manager you need to click URL in Report Manager URL tab.
* You will find it again on Reporting Services configuration Pane.

While navigating to the page you might end up with an error message saying -

"This page might not function correctly because either your browser does not support scripts or active scripting is disabled."

Thursday, December 12, 2013

How to Configure SQL Server Reporting Services

Hi all,

In this post we will see how we can configure SQL Server Reporting Services.