ssrs 2012 with reportviewer v 10

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

Fraser_Admin

Asked: 2013-01-07

Advertise Here

1 Solution

LVL 25

TempDBACommented: 2013-01-07

Try freezing the header:
http://technet.microsoft.com/en-us/library/ms155082.aspx

LVL 21

Alpesh PatelAssistant ConsultantCommented: 2013-01-07

http://msdn.microsoft.com/en-us/library/bb934257%28v=sql.100%29.aspx

Fraser_AdminAuthor Commented: 2013-01-08

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>

Fraser_AdminAuthor Commented: 2013-01-13

This is what worked for me.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

ssrs 2012 with reportviewer v 10

Join & Write a Comment Already a member? Login.

Featured Post