Lock Report Header

I know this question was asked back in 2004 and haven't seen any updates on
it...
Is it possible to lock the report column headers - as in Excel - so as you
scroll, you'll always see the column title/header?
Thanks!!I believe you are looking for either "repeat header on each page" or "header
should remain visible when scrolling" on the table properties.
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:FF3F5EA6-3322-4F32-BCD5-1F35FD562FFD@.microsoft.com...
>I know this question was asked back in 2004 and haven't seen any updates on
> it...
> Is it possible to lock the report column headers - as in Excel - so as you
> scroll, you'll always see the column title/header?
> Thanks!!|||A thousand thank you's , Jason...!!
Don't know how I didn't see that earlier...
"jason" wrote:
> I believe you are looking for either "repeat header on each page" or "header
> should remain visible when scrolling" on the table properties.
>
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:FF3F5EA6-3322-4F32-BCD5-1F35FD562FFD@.microsoft.com...
> >I know this question was asked back in 2004 and haven't seen any updates on
> > it...
> >
> > Is it possible to lock the report column headers - as in Excel - so as you
> > scroll, you'll always see the column title/header?
> >
> > Thanks!!
>

Local ReportViewer - Printing margins off by ~1/8 inch

I am printing my reports from my local report viewr, and the margins are
off by 1/8 inch if I include a header. It looks like printing shifts the
contents of the report 1/8 inch to the right, borking everything.
1. Report has a "header" area. Without this header, the printing is fine.
2. Report body is 7" wide
3. Margins are .75" (6/8) inch on all sides
4. Print Preview mode displays the report properly, centered
5. Output is similarly skewed on all printers (tried 4)
6. This is using the VS SP1 version of the RS dll's.
Setting the margins to Left: 0.625, Right: 0.875 (5/8&7/8) actually causes
it to print centered, so I know it is paying attention. When I do this, the
print layout mode shows the contents shifted to the left 1/8", as expected.
I assume that people print using this control, or at least it was tested,
so has anyone else seen this or is it a confirmed bug?
Thanks,
// Andrew Backer
P.S. In a related bug, if I include the header then the local viewer __insists__
on rendering the page at 8.5 inches wide, regardless of the fact that the
body is still 7". This doesn't seem to affect printing, but without the
header it only renders at the body width, 7", rather than giving me 1.5"
of blank spaceCheck the "Spacing" property under the Layout Tab of the Report Properties
window.
Set it to "0in".

LoadReport() - SoapException - Help needed

Hi Experts,

getting the Error:

Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/LoadReport

when calling LoadReport().

I can access the ReportServer and ReportManager through Browser and get perfect results.

I also can querying the WebService through a DataSet (XML-Data-Provider) in a Report Project.

VS 2005; SQL SERVER 2005; IIS6; Windows Server 2003. RS is configured on DefaultWebSite(Port 80)

rsExec = new rsExecService.ReportExecutionService();

rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;

rsExec.Url = http://pserver01/ReportServer/ReportService2005.asmx;

// Render arguments

byte[] result = null;

string reportPath = "/ObjectsRpt/Sales";

string format = "PDF";

string historyID = null;

string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

// Prepare report parameter.

rsExecService.ParameterValue[] parameters = new rsExecService.ParameterValue[1];

parameters[0] = new rsExecService.ParameterValue();

parameters[0].Name = "SalesOrderNumber";

parameters[0].Value = "SO43659";

string encoding;

string mimeType;

string extension;

rsExecService.Warning[] warnings = null;

string[] streamIDs = null;

rsExecService.ExecutionInfo execInfo = new rsExecService.ExecutionInfo();

rsExecService.ExecutionHeader execHeader = new rsExecService.ExecutionHeader();

rsExec.ExecutionHeaderValue = execHeader;

// Next line will cause the Error, when API tries to call Invoke

execInfo = rsExec.LoadReport(reportPath, historyID);

Help wanted

Thanx Ronny

Your code looks good. What happens when you browse http://pserver01/ReportServer/ReportService2005.asmx?|||

Hi Theo,

Browser opens with the XML-Definition.

If i put this URL in VS when adding a Web-Reference i also get the correct Definition of the Web-Services.

Any other suggestions?

Ronny

|||

I assume the URL line to be actually:

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

|||

Hi Teo,

it is like you assumed.

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

i added a watch and url is correct!

?

Ronny

|||If you run the code locally on the server using localhost as server name, does it work?|||

Hi Teo,

no, not with localhost and also not with the IP-Address..

No Entry in logs-Folder (RS or IIS), Configuration-Files looking good..

Any other ideas?

Ronny

|||It looks like IIS is rejecting the remote request. Intercepting the response with utilities like tcpTrace or SOAPTrace will help determining the cause.|||You are binding the proxy to the wrong endpoint (you are binding it to the management endpoint). Change the URL to http://pserver01/ReportServer/ReportExecution2005.asmx|||

Hello John, thanx for the great hint! - It's working fine now!

Ronny

LoadReport() - SoapException - Help needed

Hi Experts,

getting the Error:

Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/LoadReport

when calling LoadReport().

I can access the ReportServer and ReportManager through Browser and get perfect results.

I also can querying the WebService through a DataSet (XML-Data-Provider) in a Report Project.

VS 2005; SQL SERVER 2005; IIS6; Windows Server 2003. RS is configured on DefaultWebSite(Port 80)

rsExec = new rsExecService.ReportExecutionService();

rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;

rsExec.Url = http://pserver01/ReportServer/ReportService2005.asmx;

// Render arguments

byte[] result = null;

string reportPath = "/ObjectsRpt/Sales";

string format = "PDF";

string historyID = null;

string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

// Prepare report parameter.

rsExecService.ParameterValue[] parameters = new rsExecService.ParameterValue[1];

parameters[0] = new rsExecService.ParameterValue();

parameters[0].Name = "SalesOrderNumber";

parameters[0].Value = "SO43659";

string encoding;

string mimeType;

string extension;

rsExecService.Warning[] warnings = null;

string[] streamIDs = null;

rsExecService.ExecutionInfo execInfo = new rsExecService.ExecutionInfo();

rsExecService.ExecutionHeader execHeader = new rsExecService.ExecutionHeader();

rsExec.ExecutionHeaderValue = execHeader;

// Next line will cause the Error, when API tries to call Invoke

execInfo = rsExec.LoadReport(reportPath, historyID);

Help wanted

Thanx Ronny

Your code looks good. What happens when you browse http://pserver01/ReportServer/ReportService2005.asmx?|||

Hi Theo,

Browser opens with the XML-Definition.

If i put this URL in VS when adding a Web-Reference i also get the correct Definition of the Web-Services.

Any other suggestions?

Ronny

|||

I assume the URL line to be actually:

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

|||

Hi Teo,

it is like you assumed.

rsExec.Url = "http://pserver01/ReportServer/ReportService2005.asmx";

i added a watch and url is correct!

?

Ronny

|||If you run the code locally on the server using localhost as server name, does it work?|||

Hi Teo,

no, not with localhost and also not with the IP-Address..

No Entry in logs-Folder (RS or IIS), Configuration-Files looking good..

Any other ideas?

Ronny

|||It looks like IIS is rejecting the remote request. Intercepting the response with utilities like tcpTrace or SOAPTrace will help determining the cause.|||You are binding the proxy to the wrong endpoint (you are binding it to the management endpoint). Change the URL to http://pserver01/ReportServer/ReportExecution2005.asmx|||

Hello John, thanx for the great hint! - It's working fine now!

Ronny