

The Report Viewer does at least repeat the column headers at the top of each new page. Has it been proposed and shot down by Microsoft? . I would agree that the final publishing of the report in Excel makes sense for the ultimate users of the reports, however, as the person who is running the report is vetting the numbers, it adds a step. The questions begs, though, WHY isn't this functionality being considered for MR in the future? This is a pretty common request and would certainly make using the reports in the viewer easier. Exporting to excel will just add an additional step for the users. There is nothing wrong with excel, I was planning on just distributing the reports via the web link. I was afraid there was no solution, thanks Frank. Is there a "freeze panes" function in management reporter like in excel? I would prefer not to have to tell the users to export to excel then freeze panes to make the reports more user friendly. This will be annoying to the user since they will continually have to scroll up to refer back to what colum they are looking at. I have some longer expense reports and when the user will scroll down, the header scrolls with it. I am converting our Great Plains Reporting took from F9 to Management Reporter and I have not been able to figure out one thing so far. *** If you solve your issue please share the solution to assist others! *** What's wrong with Excel?-įollow me on Twitter: - *** Help Us, Help You.provide enough info so that we don't have to ask for more:) *** Send-MailMessage -From -To -Subject "My Report" -SmtpServer " using Report Viewer or a web browser there isn't currently a way to 'Freeze' the headers that I'm aware of, and as far as I know that functionality isn't going to be added. $workbook.SaveAs($ReportOutput, $xlFixedFormat) $excel = New-Object -ComObject Excel.Application $Stream.Write($RenderOutput, 0, $RenderOutput.Length) $Stream = New-Object System.IO.FileStream($ReportOutput), Create, Write $RenderOutput = $ReportServer.Render($ReportOutputType, #Other variables to hold parameters and output values

$Report = $ReportServer.GetType().GetMethod("LoadReport").Invoke($ReportServer, $null)) $ReportServer = New-WebServiceProxy -Class 'ReportServer' -Namespace 'ReportServer' -Uri $ReportServerUri -UseDefaultCredential $ReportOutput = $ReportOutputDirectory + $ReportOutputFileName $ReportOutputDirectory = "C:\SsrsOutput\" $ReportServerUri = " $ReportPath = "/MyReportPath" You have powershell generate the report, modify the output, and distribute. This solution only works if you can schedule the distribution of the report instead of having on demand access in the SSRS portal. The second way to accomplish this is with powershell. It is a tedious and cumbersome way to get the job done but it works and it is all contained within the report. This solution has you create a text box for each column and place it in the report header. There are a two different solutions that I know of to this problem.
