SOAP API Rendering In HTML4.0 Format With Toggle Items

Jul 25, 2007

I have been combing the Internet trying to find a way to use the SOAP API
(ReportExecution2005) web service to render a report to HTML4.0 format with
toggle items. From what I have read, the new web services should provide
ASP.NET server-side postbacks from the toggle item images, but so far I have
seen only the same behavior as was in RS 2000, which was that the toggle item
images pointed back to the ReportServer address. The following is the device
info settings that i have used to get the images to show up on the aspx page:

<DeviceInfo><StreamRoot></StreamRoot><Toolbar>False</Toolbar>
<Parameters>False</Parameters>
<HTMLFragment>False</HTMLFragment>
StyleStream>False</StyleStream>
<Section>0</Section>
DeviceInfo>

If I switch the HTMFragment to True I don't get any toggle item images to
render on the page but the report still shows up, and when I actually set the
StreamRoot paramter to something like this
"http://[server]/[virtualdirectory]/GetImage.aspx?reportpath=[path]&streamid=" to render the toggle item images, I get a http 400 : Bad Request error page.

Can someone please provide some information or sample code on how to render
an HTML4.0 report using the SQL 2005 Reporting Services web service and
getting the toggle item images to render as well as work correctly.

Thanks,

Brian

View 3 Replies


ADVERTISEMENT

Toggle Items In Ad-hoc Report

May 7, 2008



I have built a report using the Report Model but want to be able to collapse rows as is possible with the Toggle and Hidden attributes in normal reports. Can this be done?

Thanks

View 3 Replies View Related

From A Report With Toggle Items, Export To Excel

Feb 26, 2008

I'm not sure if this can be done. There are some threads that say yes and some that say no.

If my report's detail section is hidden unless toggled by group2 is there a way to retain the collapsed entries as collapsed when the report is exp[orted to excel?

Right now when I export to excel the report is all expanded. An export to pdf looks fine but I need to in excel.

I tried this and I must have done something wrong cause it did not work.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2376478&SiteID=1

My orginal report rows are:
Table header

Group1
group2
Details

In details I have the visibilty as hidden, toggle item as group2_item.

I did try creating group3 and set it as the the above thread said.

I'm operating SSRS2000 with SP4.

View 6 Replies View Related

SOAP Endpoint: When Using ROWSETS_ONLY Format - Warning In SQL Creates Corrupter Response

Apr 13, 2007

I have noticed that when I created SOAP endpoint and a webmethod uses ROWSETS_ONLY format €“ if a warning is raised in T-SQL implementing webmethod then response is being terminated.
Either nothing is returned, and calling application (build with VS 2005) gets error €śThe underlying connection was closed€?, or part of response is retuned but terminated in the middle, and calling application gets error €śThere is an error in XML document (1, 8001).€?
This can be caused by any warning, in my case it was €ś€¦NULL values eliminate by aggregate€¦€? warning. It will behave same way with errors.
Is there any way to make SQL Server send a proper response in case of warning? Should this be reported as bug to Microsoft?

View 4 Replies View Related

How To Keep The Toggle Columns Function When I Render A Tabular Report To An Excel Format?

Apr 15, 2008



Hi all,

Currently, I am using the SSRS 2005 and try to toggle the report columns similar to Excel's column grouping function. Users can expand "+" / collapse "-" the columns in the render excel report. It works fine when I excute the tabular report in the web yet the toggle function is missing when I render the report to an Excel report. I am not sure the toggle function will only work for the row items or both as the excel report can keep the toggle function for the row items. Please help.

View 2 Replies View Related

Overriding Visibility Toggle Or Making The Toggle Of Rows Conditional

Sep 28, 2007

Greetings,
I have five rows in a group header.
The top row is a true header row with details that will always be there and will always be visible.
The bottom four rows have their Visibility.Hidden property set to 'TRUE'.
All four of the bottom rows are assigned the same Visibility.ToggleItem.
Of the four bottom rows, any or all of them may not have data at any one time.
I want to find a way of allowing the rows to toggle from hidden to visible, but if one or all of the rows have a field item whose value is 0 then that row must remain invisible regardless of whether it is toggled.

I am still working on this puzzle, but if someone can provide me with an easy solution while I struggle, I would greatly appreciate it.

Thanks!

View 4 Replies View Related

Blank Pages While Rendering Matrix In PDF Format

Jun 1, 2007

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content. The number of blank pages after each page with content is equal to the number of times the matrix would scroll into a new page.



This problem occurs only when I try to generate the whole report in PDF. No blank pages appear when I render subreports into PDFs individually.



Please help!!

View 1 Replies View Related

Image Size When Rendering In EMF Output Format

Feb 8, 2007

Hello folks,

A while back I wrote a .NET assembly with a COM wrapper to provide an interface between Report Services and legacy MS Access applications. Basically, it returns the byte arrays from the .render method (output format emf) to be written into an Access image control.

This worked flawlessly on any 8.5"x11" RS report we threw at it on the first two Report Services I tried it against. When we set up a third Report Service at another facility, the same reports were coming out with the physical dimension metrics on the emf as10"x13", so the Access version of the report is clipped significantly on the edges.

I trapped the output into a System.Drawing.Image object in the .NET assembly and put a watch on it. The two servers that work as I expected show HorizontalResolution and VerticalResolution as 96.0946, while the one that doesn't has these values as 81.2799. The PhysicalDimension property shows 21542.3672 x 27939.4316 on the working servers and 25531.25 x 33031.25 Otherwise, the properties of the images seem to be identical. The PhysicalDimension values I see are completely consistent with the size units of 0.01 mm, as the the emf documentation indicates. The resolution of 96 is consistent with the "Windows default" values of 96 dpi. The ratio of the resolutions is correct for an 85% scaling factor for the "misbehaving" Report Service.

I have not been able to find any reason for the differences between the Report Services, and I have not been able to figure out how to control it. I tried setting DpiX and DpiY as 96 in the DeviceInfo for the render call with no change in the behavior of either server.

Can anybody enlighten me on what is happening and what I need to do to get consistent behavior between the servers? Or why the DpiX and DpiY settings for the emf rendering extension don't seem to work?

Thanks,
Tim Bailey
Energy Laboratories, Inc.

View 4 Replies View Related

Reporting Services :: Image In SSRS In PNG Format - PDF Rendering

Nov 4, 2015

I have a image in SSRS which is of PNG in format. when I preview the image it is coming as expected but if I  export that to PDF the image is having the black color back ground. One more point to be noted here is my actual image file is having a small shading in it which is not visible properly, but the same back ground is coming with full black color line in the PDF form.

Another issue is : I have 3 sub reports in my SSRS report. In the preview I can see the data is coming in order of sub reports but if I export it to PDF the second sub-report data is coming at the end of the report and first and 3rd sub reports are fine. But If I have only one record for 2nd sub-report the order is same in both the Preview page as well as in the PDF format.

View 4 Replies View Related

Reporting Services :: RDL Report Rendering For HTML Format Fails

May 13, 2015

We are facing an issue where the report rendering for specific report parameters is failing with an exception 

Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.CalculateDetailCell(PageItem topItem, Int32 colIndex, Boolean collect, PageContext pageContext)

[code]....

The server is running in Native mode. We tried restarting the services and also verified the disk space. Neither of them worked. The ExecutionLog3 table in the "ReportServer" database shows a rrenderingError as the report execution status. Report rendering with Excel format works fine.We enabled verbose logs and they are shared here. URL....

View 7 Replies View Related

Reporting Services :: SSRS 2005 Custom Report Rendering Format Not Working?

Jun 3, 2015

I'm trying to add a custom report format to ssrs 2005 as per this [URL] I've added the code snippets in the example to three different ssrs 2005 server RSReportServer.config files but it does not work i.e do not show up in the export drop down when rendering report.

I've tried starting and stopping reporting services and it still does not works.

I've also modified the existing csv extension  with different options to see if it works but to no avail.However it works with SSRS2008 R2 . In fact it works right after I saved the config file, no restart needed.For SSRS2005 the file is in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer. I checked the registry setting  just to make sure I'm looking at the correct installation 'HKEY_LOCAL_MACHINE', 'SOFTWAREMicrosoftMicrosoft SQL Server90ToolsClientSetup', 'SQLPath' The three ssrs2005 instances are in three different physical servers and the problem is with all of them so it is not an isolated incident. I've dbowner rights to all three servers. The server versions are 9.0.4060, 9.0.4035 and 9.0.4053

View 11 Replies View Related

Reporting Services :: Image Not Sized Correctly When Rendering Report In WORDOPENXML Format

Sep 18, 2015

In an asp.net app I'm creating email attachments from ssrs reports and am rendering them In Word and Excel using the WORDOPENXML and EXCELOPENXML format extensions.  When I render the report in excel, the image is sized correctly, however, when I render the same report in word, its very small.  I will attach a screenshot of each, and in the word screenshot, I will select the image so you can see the image control's outline (the control's actual size).  Notice the image inside of the border is very small.  How can I resolve this?

first, excel:

and now in word:

View 3 Replies View Related

Summing Invoice Items - The Multi-part Identifier Items.TAX Could Not Be Bound

Apr 17, 2007

Hi: I'm try to create a stored procedure where I sum the amounts in an invoice and then store that summed amount in the Invoice record.  My attempts at this have been me with the error "The multi-part identifier "items.TAX" could not be bound"Any help at correcting my procedure would be greatly appreciate. Regards,Roger Swetnam  ALTER PROCEDURE [dbo].[UpdateInvoiceSummary]    @Invoice_ID intAS    DECLARE @Amount intBEGIN    SELECT     Invoice_ID, SUM(Rate * Quantity) AS Amount, SUM(PST) AS TAX    FROM         InvoiceItems AS items    GROUP BY Invoice_ID    HAVING      (Invoice_ID = @Invoice_ID)    Update Invoices SET Amount = items.Amount    WHERE Invoice_ID =@Invoice_IDEND

View 3 Replies View Related

SQL Server 2012 :: Identify Sets That Have Same Items (where Set ID And Items In Same Table)

Feb 25, 2015

I am struggling to come up with a set-based solution for this problem (i.e. that doesn't involve loops/cursors) ..A table contains items (identified by an ItemCode) and the set they belong to (identified by a SetId). Here is some sample data:

SetIdItemCode
1A
1B
24
28
26
310
312
410

[code]....

You can see that there are some sets that have the same members:

- 1 and 10
- 2 and 11
- 7, 8 & 9

What I want to do is identify the sets that have the same members, by giving them the same ID in another column called UniqueSetId.

View 8 Replies View Related

Reporting Services :: Group And Sum Items / Sub-items Into One Record

Apr 10, 2015

I'm having an issue creating a report that can group & sum similar items together (I know in some ways, the requirement doesn't make sense, but it's what the client wants).

I have a table of items (i.e. products).  In some cases, items can be components of another item (called "Kits").  In this scenario, we consider the kit itself, the "parent item" and the components within the kit are called "child items".  In our Items table, we have a field called "Parent_Item_Id".  Records for Child Items contain the Item Id of the parent.  So a sample of my database would be the following:

ItemId | Parent_Item_Id | Name | QuantityAvailable
----------------------------------------
1 | NULL | Kit A | 10
2 | 1 | Item 1 | 2
3 | 1 | Item 2 | 3
4 | NULL | Kit B | 4
5 | 4 | Item 3 | 21
6 | NULL | Item 4 | 100

Item's 2 & 3 are child items of "Kit A", Item 5 is a child item of "Kit B" and Item 6 is just a stand alone item.

So, in my report, the client wants to see the SUM of both the kit & its components in a single line, grouped by the parent item.  So an example of the report would be the following:

Name | Available Qty
--------------------------
Kit A | 15
Kit B | 25
Item 4 | 100

How I can setup my report to group properly?

View 6 Replies View Related

Either Rendering Tiff Images In SRS Report Viewer Or Converting Tiff To Jpg Or Gif And Then Rendering

Jun 19, 2007

First of all, this is not in reference to using SRS (SQL Reporting Services) to render a report and then use one of the extensions to render the complete report as a pdf, tiff, excel etc. We have an opportunity to render a list of claims and then embed the supporting docs for each of the claims within the report. We don't have an issue referencing jpg and gif images via URLs and then rendering them within the report after the grid information. We do have an issue rendering tiff images within the report.



You can insert an image object into SRS at design time and have it render and you can convert a complete report to a tiff image but I cannot find a way to be able to render a tiff image when running the report. All you get is the red "x".



My question is has anyone encountered the same issue and, if so, what did you do to resolve the issue?



Thank you,



J Z

View 3 Replies View Related

DELETE Items Where Count(items) &>1

May 12, 2006

I cannot find an easy way to DELETE items which are > 1 time in my table (i am working with MS SQL 2000)


idserialisOk
-------------------
2AAA1
3BBB0
5dfds0
6CCC1
7fdfd 0
8AAA0
9CCC0


I want to DELETE each Row IN



SELECT doublons.serial, Count(doublons.serial) AS 2Times
FROM doublons
GROUP BY doublons.serial
HAVING Count(doublons.serial)>1



and WHERE isOK = 0

in my exemple , after deleting, my table must look like



idserialisOk
-------------------
8AAA1
9CCC1
3BBB0
5dfds0
7fdfd0



thank you for helping

View 10 Replies View Related

DTS And SOAP Web Service

Feb 3, 2007

Hi,I have a client that needs to issue soap calls to a third-party webservice from within a DTS package. Is this even possible? I'velooked everywhere and found the sqlxml, but that looks like itprovides a soap web service, not consumes one.Right now, we are consuming the same web service in an ASP.NETapplication and would love to use the same code, but am really justlooking for the best solution. Basically, the only firm requirementsare that the client needs to provide a text file of items that need tobe posted to the third-party via their web service. Right now, we usedts for the client to upload other text files, that's why I was hopingto use the same procedure, but if we need to go another route, I'msure I can convince them.Any suggestions?Trey

View 1 Replies View Related

Troubleshooting SOAP

Jul 20, 2005

Hi,This is the first time I use SOAP. Dont really know the exact pictureyet. Hope you can shed some lights on me.May I know where should I start troubleshooting if I get the followinerror message when running SOAP on Windows 2003, SQL Server 2000 ?Error Code: 0 Error Source= Microsoft VBScript runtime error ErrorDescription: ActiveX component can't create object:'MSSOAP.SOAPClient' Error on Line 1. The step failed.Thanks.

View 2 Replies View Related

SOAP/Native XML Web Services

Apr 3, 2008

Anyone have experience with using SOAP/Native XML Web Services in SQL Server 2005 to expose data to external web clients? Any issues/pitfalls?

-A

View 2 Replies View Related

Possible SOAP Version Mismatch

Feb 6, 2007

Getting this error after installing certificate. Happens when trying to access https://machinename/reports

Possible SOAP version mismatch: Envelope namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting http://schemas.xmlsoap.org/soap/envelope/. SQL Server Reporting Services 2005 on Windows Server 2003 R2.

Was working fine before adding the certificate.

Any thougts on how to fix?

Thanks in advance,

Dan

View 1 Replies View Related

How To Read Soap File

May 8, 2007

Hi all,



I am sending request to the third party server EX:"Http://somesight.sight.net/company.asp?AC="1000"&Item="200"&DT=05/08/2007" I am getting file in soap format


<?xml version="1.0" encoding="UTF-8" standalone="no" ?>

- <SOAP-ENV:Envelope xmlnsOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">


- <SOAP-ENV:Body>


- <mtreamIResponse xmlns:m="uri:EXmsg">


<Success>false</Success>
</mtreamImageResponse>

- <SOAP-ENV:Fault>


<faultcode>SOAP-ENV:Error</faultcode>

<faultstring>No matching items were found.</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

My question is how to read this line <faultstring>No matching items were found.</faultstring> . I need to capture the message in the variable.

Thanks for your help in advance





View 1 Replies View Related

SQL Soap Endpoint Header

May 14, 2007

I created my SOAP endpoint in SQL 2005 sp 2, I worte an ASP.NET 2.0 app to consume the exposed webmethod but how do you add the soap headers in the asp.net app?
Basically I want to expose the application name property to set it to determine the actual caller in SQL Profiler. Can it be done without modifying the generated proxy code in ASP.net or is there a workaround ?

Thanks
J

View 4 Replies View Related

Reporting Services With Out SOAP

Aug 31, 2007

Is it possible to render a report with out usieng the SOAP API. I need to use a WCF web service instead of the ASMX web service that is made availible in SSRS. I would like to be able to to create a WCF that calls reporting services via a class library and not the web service interface.

Thanks for help

Jon

View 9 Replies View Related

How To Pass In SOAP Header For XML Datasource

Apr 3, 2006

Hi,



I have created a simple webservice with a soap header and am trying to
access it using an xml datasource in reporting services. The query
works but I have no idea how to pass in a value for the UID on the host
header. Any help? what XML would I add for the header?



This is what I have no that allows me to pass in parameters through the editor.

<Query>

<Method Namespace="http://tempuri.org/" Name="HelloPerson2"/>

<SoapAction>http://tempuri.org/HelloPerson2</SoapAction>

</Query>



Here is the code for the webservice:

/// <summary>

/// Summary description for WebService

/// </summary>

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class WebService : System.Web.Services.WebService {



public WebService () {



//Uncomment the following line if using designed components

//InitializeComponent();

}



[Serializable]

public class PersonHeader : SoapHeader

{

private int _uid;

public int UID

{

get { return _uid; }

set { _uid = value; }

}

}



public PersonHeader userCredentials;



[WebMethod]

[SoapHeader("userCredentials")]

public Person HelloPerson2(string firsName, string lastName)

{

Person person = new Person();

//person.FirstName = "John";

//person.LastName = "Smith";

person.FirstName = firsName;

person.LastName = lastName;

person.UID = userCredentials.UID;

return person;

}



[Serializable]

public class Person

{

public Person()

{

}

private string _firstName;

public string FirstName

{

get { return _firstName; }

set { _firstName = value; }

}

private string _lastName;

public string LastName

{

get { return _lastName; }

set { _lastName = value; }

}

private int _uid=1000;

public int UID

{

get { return _uid; }

set { _uid = value; }

}

}

}

View 7 Replies View Related

ReportViewer Control And SOAP Version

Dec 19, 2006

We have just upgraded from an embedded browser hosted RS2000 system to the Microsoft.ReportViewer.Winforms control for RS2005 in our applications, and have encountered a SOAP / firewall problem again.

We were using an embedded browser to display the reports, as some of our client sites block or strip the SOAP wrapper from SOAP 1.1 commands that the old RS2000 control tried to use when the data passes through their firewall. We have no control over, or visability of their firewall configuration, as this is part of their own site security.

Is RS2005 still using the same older version of SOAP, or has it been moved up to version 1.2, which I believe does not trigger as many alarm bells in some firewall systems.

We have no problems makeing web service calls to our own applications through the firewall, so its only the report viewer control that gives us these problems.

I have not been able to explicitly clarify this down to the SOAP version, but it looks too close the our previous firewall problem to be anything else - comments invited !!!!!

As an aside, is there any way to trace the inbound request through IIS to ReportServer so I can see what hits the report server ? The IIS logs alone show a request has been made, but no qualifying data, and the report server logs only seem to show processing once the request has been accepted. What I want to to is see the inbound request, and then the outbound error message being returned so I can confirm my suspicions.

I have posted a similar thread on google groups for reporting services.





View 1 Replies View Related

SOAP Endpoint Access Using InfoPath &&amp; SPD

Nov 28, 2007

I posted this in the Sharepoint Designer forum, but did'nt get an answer...so trying here...Below is my soap endpoint in sql2005...works fine for InfoPath to consume the service...but when SharePoint Designer attempts to retieve data I get

"The server returned a non-specific error when trying to get data from the data source."

In SPD I can connect to the service and see the methods and parameters...but never get any data returned...wondering if it's in my endpoint setup. BTW-using Windows security by default in SQL2005...I've tried different types of logins without success...

/****** Object: Endpoint [getSCMADataEndpoint] Script Date: 11/28/2007 10:38:43 ******/

CREATE ENDPOINT [getSCMADataEndpoint]

AUTHORIZATION [SCMAadministrator]

STATE=STARTED

AS HTTP (PATH=N'/getscmadatawebservice', PORTS = (CLEAR), AUTHENTICATION = (), SITE=N'scmasvr01', CLEAR_PORT = 80, COMPRESSION=DISABLED)

FOR SOAP (

WEBMETHOD 'GetCourseInfo'( NAME=N'[SCMA].[dbo].[prGetCourseInfo]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseLectures'( NAME=N'[SCMA].[dbo].[prGetCourseLectures]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseLecturesInstr'( NAME=N'[SCMA].[dbo].[prGetCourseLecturesInstr]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseObjectives'( NAME=N'[SCMA].[dbo].[prGetCourseObjectives]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseRosterInfo'( NAME=N'[SCMA].[dbo].[prGetCourseRosterInfo]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetSCMAAccounts'( NAME=N'[SCMA].[dbo].[prLookupSCMA_accounts]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetSCMAAccounts_FieldNames'( NAME=N'[SCMA].[dbo].[prLookupSCMA_Accounts_FieldNames]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'SCMA', NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)

View 4 Replies View Related

Outbound SOAP Notification For DML Events

Jan 11, 2008

I'm using a SQL-2005 DB to manage TFS Build Information. I need to create a SOAP web service call in response to an INSERT in the Builds table.
I am, however, thoroughly confused about the most efficient way to do this. The best I can come up with is to create a CLR function that takes the build number from the DB Insert statement, creates the XML and sends the msg to my already published (and already being used) WebService. The CLR function would be called in a trigger set of by the insert.

I don't suppose there is a native way to generate outbound SOAP msgs based upon DML events?

View 3 Replies View Related

Tracing HTTP/SOAP Endpoints

Mar 23, 2008

Has anyone worked out how to trace SOAP/HTTP Endpoints in SQL 2005 SP 2?

I'm not having a particular problem, just want to know how things work, such as which layer is responsible for the HTTP Authentication. I've traced the HTTP.sys stack using logman.exe (see http://www.thelastpickle.com/2008/03/22/tracing-sql-soap-endpoints-through-httpsys/) .

I cannot see any SQL Profiler events, and I've tried setting trace 7801 and 7803 as described in http://www.sqljunkies.com/Article/5CCAC423-1407-4A36-AF71-ED6A67D9646A.scuk#_Toc52964195 but they do not result in any logging.

thanks
Aaron

View 3 Replies View Related

Webservice And Access To SOAP Envelope

Dec 1, 2005

The web serivce for blogging to Community Server requires the username and password to be specified in the SOAP Header and not the body, I however can't access the soap header. How can I achieve this?

View 1 Replies View Related

Toggle All

Aug 1, 2006

I have seen other places where this question is asked, but I am still not seeing the answer clearly. If I have many groups that are collapsed and I want to expand them all at the same time, it there a way to accomplish this? Many talk about a param that can be passed in, but even if you have the parameter set, this is only for the initail state, is it not?

View 19 Replies View Related

Web Service Task And Authentication Using Soap Headers

Jan 17, 2006

I've tried creating several Web Service Tasks and had no problems until I came across one that requires authentication. I have a standalone program to handle this Web Service, but I'm experimenting with SSIS to see if I can replace it.

Anyone know how to handle this?

Thanks
-- Scott

View 2 Replies View Related

Error Opening Pdf Report Called Via SOAP

Oct 9, 2007

We've been opening pdf reports using SOAP for some time now and all of the sudden we're getting errors when the user is on IE6. IE7 is fine.

The error we're getting is from the Acrobat reader is:

"There was an error opening the document. The file cannot be found"

Here's the code that opens the report:


Dim report As Byte() = Nothing

Dim rs As report_engine2.ReportExecutionService = New report_engine2.ReportExecutionService

'credentials

rs.Credentials = New System.Net.NetworkCredential(rs_login, rs_password)

rs.PreAuthenticate = True

Dim reportpath As String = rs_folder & report_name

Dim zoom As String = "False"

Dim deviceInfo As String = Nothing

Select Case format

Case "HTML4.0", "HTML3.2"

deviceInfo = "<DeviceInfo>"

deviceInfo &= "<Toolbar>False</Toolbar>"

deviceInfo &= "<Parameters>False</Parameters>"

deviceInfo &= "<HTMLFragment>True</HTMLFragment>"

deviceInfo &= "<StyleStream>False</StyleStream>"

deviceInfo &= "<Section>0</Section>"

deviceInfo &= "<Zoom>" & zoom & "</Zoom>"

deviceInfo &= "</DeviceInfo>"

Case Else

deviceInfo = "<DeviceInfo></DeviceInfo>"

End Select



'array of parameters

Dim parameters(0) As report_engine2.ParameterValue '0 means one parameter in the report

Dim paramValue As report_engine2.ParameterValue = New report_engine2.ParameterValue

paramValue.Name = param1_name

paramValue.Value = param1_value

parameters(0) = paramValue

'variables for the remaining paramters

Dim historyID As String = Nothing

Dim credentials As report_engine2.DataSourceCredentials = Nothing

Dim showHideToggle As String = Nothing

Dim extension As String = GetExtension(mimeType)

Dim warnings() As report_engine2.Warning = Nothing

Dim reportHistoryParameters() As report_engine2.ParameterValue = Nothing

Dim streamIDS() As String = Nothing

Dim execInfo As New report_engine2.ExecutionInfo

Dim execHeader As New report_engine2.ExecutionHeader

rs.ExecutionHeaderValue = execHeader

execInfo = rs.LoadReport(reportpath, historyID)

rs.SetExecutionParameters(parameters, "en-us")

Try

'execute the report

report = rs.Render(format, deviceInfo, "", mimeType, "", warnings, streamIDS)

'set the filename

Dim fileName As String = savefilename & "." & extension

'write the report back to the response object

response.Clear()

response.ContentType = mimeType

'add the file name to the response if it is not a web browser format.

If mimeType <> "text/html" Then

response.AddHeader("Content-Disposition", "attachment; filename=" & fileName)

End If



'send the byte array containing the report

HttpContext.Current.Response.BinaryWrite(report)

HttpContext.Current.Response.End()

Catch ex As Exception

End Try



This used to work just fine until about a week ago. We're not sure if there was a MS update that caused this behavior. If the user saves the report to a local disk instead of opening it, they can save it successfully and open it later.

Any thoughts on where to go with this one?

Regards

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved