[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[ODBC SQL Server Driver] Timeout Expired - How to fix

I am running SQL (Selects and Deletes) against a large
table in a database and am getting Timeout Expired. I am
using Enterprise Manager (Right Click on Table and select
Query). Is there a setting that I need to change to allow
a long running query? It works fine in the SQL Query
Analyzer.
SELECT COUNT(*) AS Expr1
FROM CallDetailThe timeout is a property of the connection to the server. Select your
instance in the Enterprise manager, select properties. Then on the
connection tab change the timeout. (Zero means infinite)
Bruce
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:0ee701c39d6b$f0e86750$a401280a@.phx.gbl...
> I am running SQL (Selects and Deletes) against a large
> table in a database and am getting Timeout Expired. I am
> using Enterprise Manager (Right Click on Table and select
> Query). Is there a setting that I need to change to allow
> a long running query? It works fine in the SQL Query
> Analyzer.
> SELECT COUNT(*) AS Expr1
> FROM CallDetail|||Better indexing / design so that the query doesn't take so long? Use Query
Analyzer rather than Enterprise Manager (see http://www.aspfaq.com/2455)?
You could kludge it up by increasing your timeouts, but this is like
bandaging a fever.
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:0ee701c39d6b$f0e86750$a401280a@.phx.gbl...
> I am running SQL (Selects and Deletes) against a large
> table in a database and am getting Timeout Expired. I am
> using Enterprise Manager (Right Click on Table and select
> Query). Is there a setting that I need to change to allow
> a long running query? It works fine in the SQL Query
> Analyzer.
> SELECT COUNT(*) AS Expr1
> FROM CallDetail

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().]SSL Server error

For some reason, I'm no longer able to connect to any database on SQL Server.

If I click on the + sign before a Data Connection in Visual Studio Server Explorer, a Logon dialog opens. Whatever I enter in the dialog results in the following error message:

Connection failed.

Sql State: '0 80001'

Sql Server Error: 18

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().] SSL Server error

Help please.

What version of SQL Server are you using?

Have you tried connecting through some other method, such as using sqlcmd/osql or Management Studio/Query Analyzer?

What errors appear in the server errorlog?

Thanks
Laurentiu

|||

I'm using SQL Server 2000.

I've tried several ways to connect, all unsuccessful.

With Management Studio, I get the following error:

Cannot connect to COMPAC

Additional Information:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error: 0- The token supplied to the function is invalid) (Microsoft SQL Server)

With Query Analyzer

Unable to connect to server COMPAC

Server: Msg 18, level 16, State 1

[Microsoft]]ODBE SQL Server Driver]

[Shared Memory] SSL Security Error

With Enterprise Manager

A connection could not be established to (local)

Reason: SSL Security error

Connection Open (SECDoClientHandshake())

Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the (local) node and try again.

(The Server was running according to SQL Service Manager, and right-clicking said node/properties returned the same error)

Thanks for your consideration.

|||

Is there an error in the server errorlog? Look into MSSQL\Log directory for the latest ERRORLOG files. If there is an error there, please add it to this thread.

I'll move the thread to the data access forum, where someone might be able to help with this issue.

Thanks
Laurentiu

|||

I'm not up on reading the errorlog, so I've posted it at

http://www.e-windowsonline.com/errorlog.html

Thanks again

|||

The errorlogs don′t show anything in this case, the database is started up just fine. Have a look at the articles [1] and [2] at KB. Seems that you are trying to use SSL top connect to the server. Did you make the appropiate settings for SSL ? If you do not want to use SSL you have to disable the enforcement of encryption at the client and server side, otherwise the connection will be refused if not encrypted.

The settgin is stored at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib as of [3].

[1] http://support.microsoft.com/default.aspx?scid=kb;en-us;309398
[2] http://support.microsoft.com/default.aspx?scid=kb;en-us;302409
[3] http://support.microsoft.com/default.aspx?scid=kb;en-us;841695

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

I am moving the thread to the data access forum, because there's no login failure message in the log.

Thanks
Laurentiu

|||

Thanks for your email.

I check the settings at the key referred to and found the following:

ab (Default) REG_SZ (value not set)

ab Protocolorder REG_MULTI_SZ tcp np

and the key contains a folder TDS with:

ab (Default) REG_SZ (value not set)

ab (local) REG_SZ 7.0

ab COMPAC REG_SZ 7.0

Do you see any changes that need to be made?

Thanks

|||

Hi,

It is possilbe that if you enabled client-side 'force encryption' option but the sql server does not support SSL from server-side.

Please open Client Network Utility, (you can run cliconfg.exe from the Run menu). Make sure that 'foce encryption' is not checked.

Thx, -Justin

|||

Mostlikely, this is because your server does not have trusted certificate and client driver is configured to "Force protocol encryption". If you truly need to force encryption, you can take a look at

http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx

Otherwise, you can use cliconfg.exe to turn off "Force protocol encryption". option.