Solved

ssrs 2012 with reportviewer v 10

Posted on 2013-01-07
4
930 Views
Last Modified: 2013-01-13
I have a vs 2010 web application (asp.net) which is using reportviewer control v 10.  My report is one page long but as the user is viewing it and scrolling down I want the column headers to lock in place.  In my old environment (vs 2008 & ssrs 2005) it seemed to add a vertical scroll bar to acheive this.  I imported the ssrs report into the 2012 enviroment so maybe there is an option I'm missing.  Can someone lead me in the right direction?

Thanks
0
Comment
Question by:Fraser_Admin
  • 2
4 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 38752281
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38753573
0
 

Accepted Solution

by:
Fraser_Admin earned 0 total points
ID: 38754566
Found the solution.

Inside the rld (code view) Had to set <page><InteractiveHeight=0in>.  This forces it to stay on one page.

Then in the aspx page for the reportviewer control I had to set the following..
SizeToReportContent="false" AsyncRendering="true".  I also had the cssclass="fullheight" on the ReportViewer.


As soon as I set SizeToReoprtContent="false" my scrollbar appeared again to keep the headers locked.  

The following is also in the head section of the page.

<style type="text/css">  
     .fullheight{margin-bottom:60px;}
</style>
<script language="JavaScript" type="text/JavaScript">
        window.onload = function resize() {
           var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");
           var docheight = document.body.clientHeight;
           if (viewer != null) {
                viewer.style.height = (docheight - 70) + "px";
           }
         }
</script>
0
 

Author Closing Comment

by:Fraser_Admin
ID: 38771565
This is what worked for me.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question