Eliminate merged and hidden Cells issue from Excel Export of a SSRS report

While working on SSRS reports , i have encountered the merge cell issue when exporting to excel  as shown below



To resolve this all i had to do was ,

1.  Make sure that while designing the report in the report layout, all the report’s rows (header row as well data rows) should start at (0,0) location and there is no additional space on the left-hand side of the report in the design layout. This can be
done by making the Left and Top values under the Location section in the properties window, 0



2.I have removed the header completely as I was using controls like textbox etc which were the root cause for the merge issue.
3.For header names , i have created a parent group with a group name and formatted it in such a way that it looked as a header.I have set the properties such that the header names repeated on each and every page.

WPF:The name does not exist in the namespace error in XAML

When i encountered this problem i have deleted .suo file and restarted my visual studio.Later i rebuilt the solution .The error was gone.

WPF:Dynamically resizing a window in Xaml

Set SizeToContent="WidthAndHeight" on the window and the window will dynamically resize based on its content size.

WPF: .exe does not contain a static Main method suitable for an entry point

This morning while running my WPF application, I ran into the following error: " .exe does not contain a static Main method suitable for an entry point"

If you are getting the same error the solution is simple, you need to make sure that the "Build Action" from App.xaml file for your application is set to "ApplicationDefinition".

Hope this helps somebody out there.