SSRS ReportViewer loads endlessly

I would like to share this article, since it really took me more than an hour trying to troubleshoot this issue, going into the backend stored procedure and the data source and setting static parameters till I finally searched online and got into this very comprehensive post which saved my day.

I had just to include the parameters passing between an "IsPostBack" check!!!

MSDN Blogs > Brian Hartman's Report Viewer Blog > Reports Never Stop Loading With VS 2010

SSRS Local parameters

I have just completed the SSRS course and I got a so nice tip to let the SSRS manage my parameters rather than doing it on the web page and linking them to my data source. It is apparent now that I am using rdlc in the local processing mode.

After serveral trials, it truned out that: "In local processing mode, the ReportViewer control does not provide a parameter input area that you can use to pass values used during data processing. ", http://msdn.microsoft.com/en-us/library/ms345248.aspx

Unfortunately!

New day has come!

A very good tip by experience:

Don't try over and over again on a problem when you are tired, just switch over to another task for an adequate time to have your full concentration then return to the initial issue fresh. When you get back and notice how fast the solution blinked in your mind after an organized thinking, you would value how much time you would have wasted if you didn't cut off your trials short for a fresh revissit.

This situation usually happens to me late after a long working day, but a fresh start in the morning usually comes with the solution mich faster!!!

Have a nice day!

First Post!

This is actually more like a trial test than anything else. Although my profession involves managing websites, applications and portals to be accessible through the Internet to everyone, it is my first time to decide to have a real blog for myself. Nevertheless, I made several trials before but they were only for the sake trying things out from a technical perspective.