Folks:
I need to use an dynamically generated xpath-query Template with inLine
Schemas (like the one
[URL=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/ssxsdannotations_1u7n.asp]HERE[/URL])
I tried to use the function below, but am getting this error:
ERROR: 500 Internal Server ErrorHResult: 0x80040e14Source: Microsoft XML
Extensions to SQL ServerDescription: XML Parse Error: Unspecified error
, Line: 2, Position: 155
I've been looking for the reason for last 7 hours but without much progress.
Can this be done? is there any other way? Any pointers would be greatly
appreciated.
Thanks in advance!!
Public Function GetEmployeeData()
Dim EmpTmplXML As New MSXML2.DOMDocument40
Dim PostData
EmpTmplXML.async = False
'Load Template from a File for test
EmpTmplXML.Load aspObjServer.MapPath("\xxx\Template\EmpTemplate.xm l")
'In reality it will be something like this
'EmpTmplXML.loadXML <dynamicallyGeneratedTemplateAsString>
Dim objSvrHTTP As New MSXML2.ServerXMLHTTP40
objSvrHTTP.open "POST", "http://localhost/virtualDir", False
objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
objSvrHTTP.send EmpTmplXML
objSvrHTTP.waitForResponse
PostData = objSvrHTTP.responseText
Debug.Print PostData
'Do Something with PostData
Set EmpTmplXML = Nothing
Set objSvrHTTP = Nothing
GetEmployeeData = PostData
End Function
The VB code looks OK, and the error specifically mentions an XML parser
error, which makes me think the error might be in your template rather than
your client code. Can you execute the same template directly from a Template
virtual name? Could you post the template you're trying to execute?
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"AeriesUser" <AeriesUser@.discussions.microsoft.com> wrote in message
news:D2297502-8D5D-42FC-8FEE-8B0C8D9F1088@.microsoft.com...
Folks:
I need to use an dynamically generated xpath-query Template with inLine
Schemas (like the one
[URL=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/ssxsdannotations_1u7n.asp]HERE[/URL])
I tried to use the function below, but am getting this error:
ERROR: 500 Internal Server ErrorHResult: 0x80040e14Source: Microsoft XML
Extensions to SQL ServerDescription: XML Parse Error: Unspecified error
, Line: 2, Position: 155
I've been looking for the reason for last 7 hours but without much progress.
Can this be done? is there any other way? Any pointers would be greatly
appreciated.
Thanks in advance!!
Public Function GetEmployeeData()
Dim EmpTmplXML As New MSXML2.DOMDocument40
Dim PostData
EmpTmplXML.async = False
'Load Template from a File for test
EmpTmplXML.Load aspObjServer.MapPath("\xxx\Template\EmpTemplate.xm l")
'In reality it will be something like this
'EmpTmplXML.loadXML <dynamicallyGeneratedTemplateAsString>
Dim objSvrHTTP As New MSXML2.ServerXMLHTTP40
objSvrHTTP.open "POST", "http://localhost/virtualDir", False
objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
objSvrHTTP.send EmpTmplXML
objSvrHTTP.waitForResponse
PostData = objSvrHTTP.responseText
Debug.Print PostData
'Do Something with PostData
Set EmpTmplXML = Nothing
Set objSvrHTTP = Nothing
GetEmployeeData = PostData
End Function
|||Hi Graeme,
Thank you very much for your respone.
Yes, I can call the template from the template virtualDir and get the XML
data that way, no problem.
Another thing I noticed, even though I change the elements/attributes I want
in the output (by changing the inline schema), the error is still showing the
same line number/position. Perhaps, the xml returned by the sqlxml object is
not a valid one? But I don't know how to debug that.
Here's the template: Thanks again!
--Template Begin--
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<xsd:schemaxmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:ms="urn:schemas-microsoft-com:mapping-schema"
sql:is-mapping-schema="1"
id="InLineSchema1">
<xsd:annotation>
<xsd:appinfo>
<ms:relationship name="EmployeeDepartment" parent="Employees"
parent-key="EmployeeID" child="EmployeeDepartment"
child-key="EmployeeID" />
<ms:relationship name="EmployeeBU" parent="Employees"
parent-key="BargainingUnit" child="BargainingUnit"
child-key="UnitCode" />
<ms:relationship name="AbsenceRecords" parent="Employees"
parent-key="EmployeeNumber" child="ClassifiedAbsenceRecords"
child-key="EmpNumber" />
<ms:relationship name="DepartmentDesc" parent="EmployeeDepartment"
parent-key="DepartmentCode" child="Departments"
child-key="Code" />
<ms:relationship name="LeaveBalance" parent="Employees"
parent-key="EmployeeID" child="LeaveAmount"
child-key="EmployeeID" />
</xsd:appinfo>
</xsd:annotation>
<xsd:element name="Employees" ms:relation="Employees"
type="Employees_type" />
<xsd:complexType name="Employees_type">
<xsd:sequence>
<xsd:element name="EmployeeDepartment" ms:relation="EmployeeDepartment"
ms:relationship="EmployeeDepartment"
type="EmployeeDepartment_type" />
<xsd:element name="BargainingUnit" ms:relation="BargainingUnit"
ms:relationship="EmployeeBU"
type="BargainingUnit_type" />
<xsd:element name="ClassifiedAbsenceRecords"
ms:relation="ClassifiedAbsenceRecords" ms:relationship="AbsenceRecords"
type="ClassifiedAbsenceRecords_type"></xsd:element>
</xsd:sequence>
<xsd:attribute name="EmployeeID" type="xsd:string" />
<xsd:attribute name="SocialSecurityNumber" type="xsd:string" />
<xsd:attribute name="EmployeeNumber" type="xsd:string" />
<xsd:attribute name="FirstName" type="xsd:string" />
<xsd:attribute name="MiddleName" type="xsd:string" />
<xsd:attribute name="LastName" type="xsd:string" />
<xsd:attribute name="Title" type="xsd:string" />
<xsd:attribute name="EmailName" type="xsd:string" />
<xsd:attribute name="AltEmail" type="xsd:string" />
<xsd:attribute name="Extension" type="xsd:string" />
<xsd:attribute name="Address" type="xsd:string" />
<xsd:attribute name="City" type="xsd:string" />
<xsd:attribute name="StateOrProvince" type="xsd:string" />
<xsd:attribute name="Region" type="xsd:string" />
<xsd:attribute name="PostalCode" type="xsd:string" />
<xsd:attribute name="Country" type="xsd:string" />
<xsd:attribute name="HomePhone" type="xsd:string" />
<xsd:attribute name="WorkPhone" type="xsd:string" />
<xsd:attribute name="Birthdate" type="xsd:dateTime" />
<xsd:attribute name="Salary" type="xsd:decimal" />
<xsd:attribute name="Deductions" type="xsd:short" />
<xsd:attribute name="SpouseName" type="xsd:string" />
<xsd:attribute name="EmrgcyContactName" type="xsd:string" />
<xsd:attribute name="EmrgcyContactPhone" type="xsd:string" />
<xsd:attribute name="PhotoPath" type="xsd:string" />
<xsd:attribute name="BargainingUnit" type="xsd:short" />
<xsd:attribute name="HireDate" type="xsd:dateTime" />
<xsd:attribute name="CreateDate" type="xsd:dateTime" />
<xsd:attribute name="LastUpdateTime" type="xsd:dateTime" />
<xsd:attribute name="LastUpdatedBy" type="xsd:string" />
<xsd:attribute name="Active" type="xsd:boolean" />
</xsd:complexType>
<xsd:complexType name="EmployeeDepartment_type">
<xsd:attribute name="EmployeeID" type="xsd:string" />
<xsd:attribute name="DepartmentCode" type="xsd:short" />
<xsd:attribute name="DeptSequence" type="xsd:unsignedByte" />
<xsd:attribute name="DateStarted" type="xsd:dateTime" />
<xsd:attribute name="WorkdayHours" type="xsd:float" />
<xsd:attribute name="BillingRate" type="xsd:decimal" />
<xsd:attribute name="SupervisorID" type="xsd:string" />
<xsd:attribute name="WorkPhone" type="xsd:string" />
</xsd:complexType>
<xsd:complexType name="BargainingUnit_type">
<xsd:attribute name="UnitCode" type="xsd:short" />
<xsd:attribute name="UnitTitle" type="xsd:string" />
<xsd:attribute name="JobType" type="xsd:string" />
<xsd:attribute name="WorkdayHours" type="xsd:float" />
<xsd:attribute name="SickDays" type="xsd:unsignedByte" />
<xsd:attribute name="VacationDays" type="xsd:unsignedByte" />
<xsd:attribute name="FloatingDays" type="xsd:unsignedByte" />
<xsd:attribute name="VacationCarryoverYears" type="xsd:unsignedByte" />
</xsd:complexType>
<xsd:complexType name="ClassifiedAbsenceRecords_type">
<xsd:attribute name="absentRecordID" type="xsd:long" />
<xsd:attribute name="EmpNumber" type="xsd:string" />
<xsd:attribute name="EmpName" type="xsd:string" />
<xsd:attribute name="Department" type="xsd:string" />
<xsd:attribute name="AbsentFromDt" type="xsd:dateTime" />
<xsd:attribute name="AbsentToDt" type="xsd:dateTime" />
<xsd:attribute name="WorkingHours" type="xsd:float" />
<xsd:attribute name="NameOfSubstitute" type="xsd:string" />
<xsd:attribute name="ReasonID" type="xsd:unsignedByte" />
<xsd:attribute name="ReasonText" type="xsd:string" />
<xsd:attribute name="DeductionMonth" type="xsd:unsignedByte" />
<xsd:attribute name="DeductionYear" type="xsd:short" />
<xsd:attribute name="ESignDate" type="xsd:dateTime" />
<xsd:attribute name="SSignDate" type="xsd:dateTime" />
<xsd:attribute name="SupRecommendation" type="xsd:string" />
<xsd:attribute name="PayrollDeductionHours" type="xsd:float" />
<xsd:attribute name="PayrollDeductionRate" type="xsd:float" />
<xsd:attribute name="SchoolYear" type="xsd:short" />
<xsd:attribute name="TimeRecordCreated" type="xsd:dateTime" />
<xsd:attribute name="RecordCreatedBy" type="xsd:string" />
</xsd:complexType>
<xsd:complexType name="Departments_type">
<xsd:attribute name="Code" type="xsd:short" />
<xsd:attribute name="DPTCode" type="xsd:string" />
<xsd:attribute name="Title" type="xsd:string" />
</xsd:complexType>
<xsd:element name="FamilyRelationships" ms:relation="FamilyRelationships"
type="FamilyRelationships_type" />
<xsd:complexType name="FamilyRelationships_type">
<xsd:attribute name="Code" type="xsd:unsignedByte" />
<xsd:attribute name="Relationship" type="xsd:string" />
</xsd:complexType>
</xsd:schema>
<sql:xpath-query xmlns:sql="urn:schemas-microsoft-com:xml-sql"
mapping-schema="#InLineSchema1">
/Employees[@.EmployeeID='DBC72CCC-370F-4A98-8CDB-6F9F056EE04F']
</sql:xpath-query>
</ROOT>
--Template End--
"Graeme Malcolm" wrote:
> The VB code looks OK, and the error specifically mentions an XML parser
> error, which makes me think the error might be in your template rather than
> your client code. Can you execute the same template directly from a Template
> virtual name? Could you post the template you're trying to execute?
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "AeriesUser" <AeriesUser@.discussions.microsoft.com> wrote in message
> news:D2297502-8D5D-42FC-8FEE-8B0C8D9F1088@.microsoft.com...
> Folks:
> I need to use an dynamically generated xpath-query Template with inLine
> Schemas (like the one
> [URL=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/ssxsdannotations_1u7n.asp]HERE[/URL])
> I tried to use the function below, but am getting this error:
> ERROR: 500 Internal Server ErrorHResult: 0x80040e14Source: Microsoft XML
> Extensions to SQL ServerDescription: XML Parse Error: Unspecified error
> , Line: 2, Position: 155
> I've been looking for the reason for last 7 hours but without much progress.
> Can this be done? is there any other way? Any pointers would be greatly
> appreciated.
> Thanks in advance!!
> ----
> Public Function GetEmployeeData()
> Dim EmpTmplXML As New MSXML2.DOMDocument40
> Dim PostData
> EmpTmplXML.async = False
> 'Load Template from a File for test
> EmpTmplXML.Load aspObjServer.MapPath("\xxx\Template\EmpTemplate.xm l")
> 'In reality it will be something like this
> 'EmpTmplXML.loadXML <dynamicallyGeneratedTemplateAsString>
> Dim objSvrHTTP As New MSXML2.ServerXMLHTTP40
> objSvrHTTP.open "POST", "http://localhost/virtualDir", False
> objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
> objSvrHTTP.send EmpTmplXML
> objSvrHTTP.waitForResponse
> PostData = objSvrHTTP.responseText
> Debug.Print PostData
> 'Do Something with PostData
> Set EmpTmplXML = Nothing
> Set objSvrHTTP = Nothing
> GetEmployeeData = PostData
> End Function
> ----
>
>
|||Hmm - that's weird. I can replicate the problem with this simplified
example:
Template (Template.xml):
<?xml version="1.0" ?>
<Catalog>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:ms="urn:schemas-microsoft-com:mapping-schema"
xmlns:sql="urn:schemas-microsoft-com:xml-sql"
id="ProductSchema" sql:is-mapping-schema="1">
<xsd:element name="Product" ms:relation="Products">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ProductName" type="xsd:string"
ms:field="ProductName"/>
<xsd:element name="Price" type="xsd:decimal" ms:field="UnitPrice"
/>
</xsd:sequence>
<xsd:attribute name="ProductCode" type="xsd:integer"
ms:field="ProductID"/>
</xsd:complexType>
</xsd:element>
</xsd:schema>
<sql:xpath-query xmlns:sql="urn:schemas-microsoft-com:xml-sql"
mapping-schema="#ProductSchema">
Product
</sql:xpath-query>
</Catalog>
VB Script:
set doc = CreateObject("MSXML2.DOMDocument.4.0")
doc.Load "GetProductsInline.xml"
Dim objSvrHTTP
Set objSvrHTTP= CreateObject("MSXML2.XMLHTTP.4.0")
objSvrHTTP.open "POST", "http://localhost/nwind", False
objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
objSvrHTTP.send doc
PostData = objSvrHTTP.responseText
MsgBox PostData
My error is the same except that for the line and position (line 3, position
201).
The VDir is configured to allow everything - sql=, templates, post, XPath,
etc.
It works if I use a template containing a regular SELECT query, like this
one:
<?xml version='1.0' ?>
<Categorylist>
<sql:query xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
SELECT CategoryID, CategoryName
FROM Categories
FOR XML AUTO, ELEMENTS
</sql:query>
</Categorylist>
So to summarize, I haven't a clue what the problem is, but I can confirm
that it's not your XML specifically - I get the same issue with completely
different data and template (I'm also using XMLHTTP instead of
ServerXMLHTTP - just to see if there was any difference, but no such luck!).
If I get time, my next step is to try a template that includes an XPath
expression against an external scheme to find out if it's just the inline
aspect it doesn't like or if there's an issue posting templates that use
XPath.
In the meantime, anyone else got any insights into this?
Cheers,
G
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"AeriesUser" <AeriesUser@.discussions.microsoft.com> wrote in message
news:F087C703-2D85-4985-A5BB-EC5165848E10@.microsoft.com...
Hi Graeme,
Thank you very much for your respone.
Yes, I can call the template from the template virtualDir and get the XML
data that way, no problem.
Another thing I noticed, even though I change the elements/attributes I want
in the output (by changing the inline schema), the error is still showing
the
same line number/position. Perhaps, the xml returned by the sqlxml object is
not a valid one? But I don't know how to debug that.
Here's the template: Thanks again!
--Template Begin--
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:ms="urn:schemas-microsoft-com:mapping-schema"
sql:is-mapping-schema="1"
id="InLineSchema1">
<xsd:annotation>
<xsd:appinfo>
<ms:relationship name="EmployeeDepartment" parent="Employees"
parent-key="EmployeeID" child="EmployeeDepartment"
child-key="EmployeeID" />
<ms:relationship name="EmployeeBU" parent="Employees"
parent-key="BargainingUnit" child="BargainingUnit"
child-key="UnitCode" />
<ms:relationship name="AbsenceRecords" parent="Employees"
parent-key="EmployeeNumber" child="ClassifiedAbsenceRecords"
child-key="EmpNumber" />
<ms:relationship name="DepartmentDesc" parent="EmployeeDepartment"
parent-key="DepartmentCode" child="Departments"
child-key="Code" />
<ms:relationship name="LeaveBalance" parent="Employees"
parent-key="EmployeeID" child="LeaveAmount"
child-key="EmployeeID" />
</xsd:appinfo>
</xsd:annotation>
<xsd:element name="Employees" ms:relation="Employees"
type="Employees_type" />
<xsd:complexType name="Employees_type">
<xsd:sequence>
<xsd:element name="EmployeeDepartment" ms:relation="EmployeeDepartment"
ms:relationship="EmployeeDepartment"
type="EmployeeDepartment_type" />
<xsd:element name="BargainingUnit" ms:relation="BargainingUnit"
ms:relationship="EmployeeBU"
type="BargainingUnit_type" />
<xsd:element name="ClassifiedAbsenceRecords"
ms:relation="ClassifiedAbsenceRecords" ms:relationship="AbsenceRecords"
type="ClassifiedAbsenceRecords_type"></xsd:element>
</xsd:sequence>
<xsd:attribute name="EmployeeID" type="xsd:string" />
<xsd:attribute name="SocialSecurityNumber" type="xsd:string" />
<xsd:attribute name="EmployeeNumber" type="xsd:string" />
<xsd:attribute name="FirstName" type="xsd:string" />
<xsd:attribute name="MiddleName" type="xsd:string" />
<xsd:attribute name="LastName" type="xsd:string" />
<xsd:attribute name="Title" type="xsd:string" />
<xsd:attribute name="EmailName" type="xsd:string" />
<xsd:attribute name="AltEmail" type="xsd:string" />
<xsd:attribute name="Extension" type="xsd:string" />
<xsd:attribute name="Address" type="xsd:string" />
<xsd:attribute name="City" type="xsd:string" />
<xsd:attribute name="StateOrProvince" type="xsd:string" />
<xsd:attribute name="Region" type="xsd:string" />
<xsd:attribute name="PostalCode" type="xsd:string" />
<xsd:attribute name="Country" type="xsd:string" />
<xsd:attribute name="HomePhone" type="xsd:string" />
<xsd:attribute name="WorkPhone" type="xsd:string" />
<xsd:attribute name="Birthdate" type="xsd:dateTime" />
<xsd:attribute name="Salary" type="xsd:decimal" />
<xsd:attribute name="Deductions" type="xsd:short" />
<xsd:attribute name="SpouseName" type="xsd:string" />
<xsd:attribute name="EmrgcyContactName" type="xsd:string" />
<xsd:attribute name="EmrgcyContactPhone" type="xsd:string" />
<xsd:attribute name="PhotoPath" type="xsd:string" />
<xsd:attribute name="BargainingUnit" type="xsd:short" />
<xsd:attribute name="HireDate" type="xsd:dateTime" />
<xsd:attribute name="CreateDate" type="xsd:dateTime" />
<xsd:attribute name="LastUpdateTime" type="xsd:dateTime" />
<xsd:attribute name="LastUpdatedBy" type="xsd:string" />
<xsd:attribute name="Active" type="xsd:boolean" />
</xsd:complexType>
<xsd:complexType name="EmployeeDepartment_type">
<xsd:attribute name="EmployeeID" type="xsd:string" />
<xsd:attribute name="DepartmentCode" type="xsd:short" />
<xsd:attribute name="DeptSequence" type="xsd:unsignedByte" />
<xsd:attribute name="DateStarted" type="xsd:dateTime" />
<xsd:attribute name="WorkdayHours" type="xsd:float" />
<xsd:attribute name="BillingRate" type="xsd:decimal" />
<xsd:attribute name="SupervisorID" type="xsd:string" />
<xsd:attribute name="WorkPhone" type="xsd:string" />
</xsd:complexType>
<xsd:complexType name="BargainingUnit_type">
<xsd:attribute name="UnitCode" type="xsd:short" />
<xsd:attribute name="UnitTitle" type="xsd:string" />
<xsd:attribute name="JobType" type="xsd:string" />
<xsd:attribute name="WorkdayHours" type="xsd:float" />
<xsd:attribute name="SickDays" type="xsd:unsignedByte" />
<xsd:attribute name="VacationDays" type="xsd:unsignedByte" />
<xsd:attribute name="FloatingDays" type="xsd:unsignedByte" />
<xsd:attribute name="VacationCarryoverYears" type="xsd:unsignedByte" />
</xsd:complexType>
<xsd:complexType name="ClassifiedAbsenceRecords_type">
<xsd:attribute name="absentRecordID" type="xsd:long" />
<xsd:attribute name="EmpNumber" type="xsd:string" />
<xsd:attribute name="EmpName" type="xsd:string" />
<xsd:attribute name="Department" type="xsd:string" />
<xsd:attribute name="AbsentFromDt" type="xsd:dateTime" />
<xsd:attribute name="AbsentToDt" type="xsd:dateTime" />
<xsd:attribute name="WorkingHours" type="xsd:float" />
<xsd:attribute name="NameOfSubstitute" type="xsd:string" />
<xsd:attribute name="ReasonID" type="xsd:unsignedByte" />
<xsd:attribute name="ReasonText" type="xsd:string" />
<xsd:attribute name="DeductionMonth" type="xsd:unsignedByte" />
<xsd:attribute name="DeductionYear" type="xsd:short" />
<xsd:attribute name="ESignDate" type="xsd:dateTime" />
<xsd:attribute name="SSignDate" type="xsd:dateTime" />
<xsd:attribute name="SupRecommendation" type="xsd:string" />
<xsd:attribute name="PayrollDeductionHours" type="xsd:float" />
<xsd:attribute name="PayrollDeductionRate" type="xsd:float" />
<xsd:attribute name="SchoolYear" type="xsd:short" />
<xsd:attribute name="TimeRecordCreated" type="xsd:dateTime" />
<xsd:attribute name="RecordCreatedBy" type="xsd:string" />
</xsd:complexType>
<xsd:complexType name="Departments_type">
<xsd:attribute name="Code" type="xsd:short" />
<xsd:attribute name="DPTCode" type="xsd:string" />
<xsd:attribute name="Title" type="xsd:string" />
</xsd:complexType>
<xsd:element name="FamilyRelationships" ms:relation="FamilyRelationships"
type="FamilyRelationships_type" />
<xsd:complexType name="FamilyRelationships_type">
<xsd:attribute name="Code" type="xsd:unsignedByte" />
<xsd:attribute name="Relationship" type="xsd:string" />
</xsd:complexType>
</xsd:schema>
<sql:xpath-query xmlns:sql="urn:schemas-microsoft-com:xml-sql"
mapping-schema="#InLineSchema1">
/Employees[@.EmployeeID='DBC72CCC-370F-4A98-8CDB-6F9F056EE04F']
</sql:xpath-query>
</ROOT>
--Template End--
"Graeme Malcolm" wrote:
> The VB code looks OK, and the error specifically mentions an XML parser
> error, which makes me think the error might be in your template rather
> than
> your client code. Can you execute the same template directly from a
> Template
> virtual name? Could you post the template you're trying to execute?
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "AeriesUser" <AeriesUser@.discussions.microsoft.com> wrote in message
> news:D2297502-8D5D-42FC-8FEE-8B0C8D9F1088@.microsoft.com...
> Folks:
> I need to use an dynamically generated xpath-query Template with inLine
> Schemas (like the one
> [URL=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/ssxsdannotations_1u7n.asp]HERE[/URL])
> I tried to use the function below, but am getting this error:
> ERROR: 500 Internal Server ErrorHResult: 0x80040e14Source: Microsoft XML
> Extensions to SQL ServerDescription: XML Parse Error: Unspecified error
> , Line: 2, Position: 155
> I've been looking for the reason for last 7 hours but without much
> progress.
> Can this be done? is there any other way? Any pointers would be greatly
> appreciated.
> Thanks in advance!!
> ----
> Public Function GetEmployeeData()
> Dim EmpTmplXML As New MSXML2.DOMDocument40
> Dim PostData
> EmpTmplXML.async = False
> 'Load Template from a File for test
> EmpTmplXML.Load aspObjServer.MapPath("\xxx\Template\EmpTemplate.xm l")
> 'In reality it will be something like this
> 'EmpTmplXML.loadXML <dynamicallyGeneratedTemplateAsString>
> Dim objSvrHTTP As New MSXML2.ServerXMLHTTP40
> objSvrHTTP.open "POST", "http://localhost/virtualDir", False
> objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
> objSvrHTTP.send EmpTmplXML
> objSvrHTTP.waitForResponse
> PostData = objSvrHTTP.responseText
> Debug.Print PostData
> 'Do Something with PostData
> Set EmpTmplXML = Nothing
> Set objSvrHTTP = Nothing
> GetEmployeeData = PostData
> End Function
> ----
>
>
|||Hello, Graeme!
You wrote on Thu, 21 Oct 2004 17:16:53 +0100:
[Sorry, skipped]
GM> In the meantime, anyone else got any insights into this?
Sorry, but I cann't reproduce the error. All works fine for me.
I have 3.01.1915.00 version of sqlis3.dll, default version of msxml is 3.0
and soaptoolkit 3.0
[Sorry, skipped]
With best regards, Alex Shirshov.
|||I've got version 3.2.3523.0 of sqlis3.dll (SQLXML 3.0 SP2). Dunno if there
are any known issues with that version relating to posting inline schemas
though.
Cheers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Alex Shirshov" <nomail@.mail.ru> wrote in message
news:OERifUEuEHA.2300@.TK2MSFTNGP09.phx.gbl...
Hello, Graeme!
You wrote on Thu, 21 Oct 2004 17:16:53 +0100:
[Sorry, skipped]
GM> In the meantime, anyone else got any insights into this?
Sorry, but I cann't reproduce the error. All works fine for me.
I have 3.01.1915.00 version of sqlis3.dll, default version of msxml is 3.0
and soaptoolkit 3.0
[Sorry, skipped]
With best regards, Alex Shirshov.
|||Here's a possible (not preferred but gets the job done) solution to this
situation.
This solution makes use of ADO object
(BTW Thanks Graeme and Alex for looking at this and giving me hope)
Private Function GetXMLDataThruADO(dynamicTemplateAsText)
Dim oTestStream As New ADODB.Stream
Dim oTestConnection As New ADODB.Connection
Dim oTestCommand As New ADODB.Command
Dim locXML
oTestConnection.open "provider=sqlxmloledb.3.0;data
provider=sqloledb;data source=(local);initial catalog=dbName;user
id=usr;password=pwd"
oTestCommand.ActiveConnection = oTestConnection
oTestCommand.Properties("ClientSideXML") = "False"
oTestCommand.CommandText = dynamicTemplateAsText
oTestStream.open
' You need the dialect if you are executing a template.
oTestCommand.Dialect = "{5d531cb2-e6ed-11d2-b252-00c04f681b71}"
oTestCommand.Properties("Output Stream").Value = oTestStream
oTestCommand.Properties("Output Encoding") = "utf-8"
oTestCommand.Execute , , adExecuteStream
oTestStream.Position = 0
oTestStream.Charset = "utf-8"
locXML = oTestStream.ReadText(adReadAll)
Set oTestStream = Nothing
Set oTestConnection = Nothing
Set oTestCommand = Nothing
GetXMLDataThruADO = locXML
End Function
"Graeme Malcolm" wrote:
> I've got version 3.2.3523.0 of sqlis3.dll (SQLXML 3.0 SP2). Dunno if there
> are any known issues with that version relating to posting inline schemas
> though.
> Cheers,
> Graeme
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "Alex Shirshov" <nomail@.mail.ru> wrote in message
> news:OERifUEuEHA.2300@.TK2MSFTNGP09.phx.gbl...
> Hello, Graeme!
> You wrote on Thu, 21 Oct 2004 17:16:53 +0100:
>
> [Sorry, skipped]
> GM> In the meantime, anyone else got any insights into this?
> Sorry, but I cann't reproduce the error. All works fine for me.
> I have 3.01.1915.00 version of sqlis3.dll, default version of msxml is 3.0
> and soaptoolkit 3.0
>
> [Sorry, skipped]
>
> With best regards, Alex Shirshov.
>
>
|||A few questions:
What version of SqlXml are you using?
You do have POSTed templates enabled, correct?
What is at Line 2, position 155?
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"AeriesUser" <AeriesUser@.discussions.microsoft.com> wrote in message
news:D2297502-8D5D-42FC-8FEE-8B0C8D9F1088@.microsoft.com...
> Folks:
> I need to use an dynamically generated xpath-query Template with inLine
> Schemas (like the one
> [URL=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/ssxsdannotations_1u7n.asp]HERE[/URL])
> I tried to use the function below, but am getting this error:
> ERROR: 500 Internal Server ErrorHResult: 0x80040e14Source: Microsoft XML
> Extensions to SQL ServerDescription: XML Parse Error: Unspecified error
> , Line: 2, Position: 155
> I've been looking for the reason for last 7 hours but without much
> progress.
> Can this be done? is there any other way? Any pointers would be greatly
> appreciated.
> Thanks in advance!!
> ----
> Public Function GetEmployeeData()
> Dim EmpTmplXML As New MSXML2.DOMDocument40
> Dim PostData
> EmpTmplXML.async = False
> 'Load Template from a File for test
> EmpTmplXML.Load aspObjServer.MapPath("\xxx\Template\EmpTemplate.xm l")
> 'In reality it will be something like this
> 'EmpTmplXML.loadXML <dynamicallyGeneratedTemplateAsString>
> Dim objSvrHTTP As New MSXML2.ServerXMLHTTP40
> objSvrHTTP.open "POST", "http://localhost/virtualDir", False
> objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
> objSvrHTTP.send EmpTmplXML
> objSvrHTTP.waitForResponse
> PostData = objSvrHTTP.responseText
> Debug.Print PostData
> 'Do Something with PostData
> Set EmpTmplXML = Nothing
> Set objSvrHTTP = Nothing
> GetEmployeeData = PostData
> End Function
> ----
|||Hi Irwin, Thanks for responding.
1) I have tried this with SQLXML 3.0 sp2 and also with sp3 that you released
yesterday. Same errors with both versions.
2) Yes, I do have the POSTed templates enabled.
3) The error in Line 2, position 155 is not from my template, but is in the
"XML response from the server". The template itself validates fine and I am
also able to get the xml data if I bring up that template in the browser
http://localhost/sqlvirDir/template/myTemplate.xml
Graeme Malcom, in the post above was also able to replicate this problem.
Mine and his templates are also posted in the above responses.
Please let me know if you need any other information.
Thanks!
"Irwin Dolobowsky [MSFT]" wrote:
> A few questions:
> What version of SqlXml are you using?
> You do have POSTed templates enabled, correct?
> What is at Line 2, position 155?
> --
> Thanks,
> Irwin
> Irwin Dolobowsky
> Program Manager, SqlXml
> http://blogs.msdn.com/irwando
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "AeriesUser" <AeriesUser@.discussions.microsoft.com> wrote in message
> news:D2297502-8D5D-42FC-8FEE-8B0C8D9F1088@.microsoft.com...
>
>
|||Hello, AeriesUser!
You wrote on Wed, 27 Oct 2004 23:49:05 -0700:
[Sorry, skipped]
A> Graeme Malcom, in the post above was also able to replicate this
A> problem. Mine and his templates are also posted in the above responses.
A> Please let me know if you need any other information.
[Sorry, skipped]
I peer into your vb script and have seen, that you post template to the
server. It is not allowed. If it will, than anybody, who knows the address
will be able to execute any TSQL statement. SQLXML allows only to execute
predefined, wellknown templates that are stored in special template folder.
Just replace your script with the following
Dim objSvrHTTP As New MSXML2.ServerXMLHTTP40
objSvrHTTP.open "POST",
"http://localhost/virtualDir/templatepath/actualtemplate.xml", False
objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
objSvrHTTP.send
objSvrHTTP.waitForResponse
PostData = objSvrHTTP.responseText
Debug.Print PostData
With best regards, Alex Shirshov.
Showing posts with label dynamically. Show all posts
Showing posts with label dynamically. Show all posts
Friday, March 23, 2012
How can I open hyperlink in a new window?
I have a number of dynamically configured hyperlinks in my report. Clicking
on them, takes user to a different application. I want for this new app to
open in a different browser window from the report itself, but instead it
opens in the same window and replaces my report data. Any ideas how to force
it to open in a new window?
Thank you!Copied from newsgroup:
You put it in the document map label. This is a standard thing for
hyperlinks. You can also use _self, _top, _parent, etc...
From Books Online,
"Advanced Textbox Properties (Navigation Tab)
Use the Navigation tab of the Advanced Textbox Properties dialog box to
define navigation options for the text box.
Options
Document map label
Type or select a label or an expression that evaluates to a label. Click the
expression (fx) button to edit the expression. The value of the label
appears on the document map."
HTH, Jens Suessmeyer,.
http://www.sqlserver2005.de
--
"Misha_SQL" <Misha_SQL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
>I have a number of dynamically configured hyperlinks in my report.
>Clicking
> on them, takes user to a different application. I want for this new app
> to
> open in a different browser window from the report itself, but instead it
> opens in the same window and replaces my report data. Any ideas how to
> force
> it to open in a new window?
> Thank you!|||Some more links:
#1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
#2: Take a look at _LinkTarget device info setting:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
Jens Suessmeyer.
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> schrieb
im Newsbeitrag news:uv4rf7dRFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Copied from newsgroup:
>
> You put it in the document map label. This is a standard thing for
> hyperlinks. You can also use _self, _top, _parent, etc...
> From Books Online,
> "Advanced Textbox Properties (Navigation Tab)
> Use the Navigation tab of the Advanced Textbox Properties dialog box to
> define navigation options for the text box.
> Options
> Document map label
> Type or select a label or an expression that evaluates to a label. Click
> the expression (fx) button to edit the expression. The value of the label
> appears on the document map."
>
> HTH, Jens Suessmeyer,.
>
>
> --
> http://www.sqlserver2005.de
> --
> "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
>>I have a number of dynamically configured hyperlinks in my report.
>>Clicking
>> on them, takes user to a different application. I want for this new app
>> to
>> open in a different browser window from the report itself, but instead it
>> opens in the same window and replaces my report data. Any ideas how to
>> force
>> it to open in a new window?
>> Thank you!
>|||For the following you need SP1 or greater installed.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> I have a number of dynamically configured hyperlinks in my report.
Clicking
> on them, takes user to a different application. I want for this new app
to
> open in a different browser window from the report itself, but instead it
> opens in the same window and replaces my report data. Any ideas how to
force
> it to open in a new window?
> Thank you!|||Thank you, Jens!
These links contained information that solved my problem.
"Jens Sü�meyer" wrote:
> Some more links:
> #1:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> #2: Take a look at _LinkTarget device info setting:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
>
> Jens Suessmeyer.
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> schrieb
> im Newsbeitrag news:uv4rf7dRFHA.3716@.TK2MSFTNGP14.phx.gbl...
> > Copied from newsgroup:
> >
> >
> > You put it in the document map label. This is a standard thing for
> > hyperlinks. You can also use _self, _top, _parent, etc...
> >
> > From Books Online,
> >
> > "Advanced Textbox Properties (Navigation Tab)
> > Use the Navigation tab of the Advanced Textbox Properties dialog box to
> > define navigation options for the text box.
> >
> > Options
> >
> > Document map label
> > Type or select a label or an expression that evaluates to a label. Click
> > the expression (fx) button to edit the expression. The value of the label
> > appears on the document map."
> >
> >
> >
> > HTH, Jens Suessmeyer,.
> >
> >
> >
> >
> >
> > --
> >
> > http://www.sqlserver2005.de
> >
> > --
> >
> > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> >>I have a number of dynamically configured hyperlinks in my report.
> >>Clicking
> >> on them, takes user to a different application. I want for this new app
> >> to
> >> open in a different browser window from the report itself, but instead it
> >> opens in the same window and replaces my report data. Any ideas how to
> >> force
> >> it to open in a new window?
> >>
> >> Thank you!
> >
> >
>
>|||Hi Bruce/Misha,
I tried the solution given below and it opens in the new window with the URL
given,even when i change it to "_Self".
Please note i am trying to open the url in a particular frame and not the
full window.
And also i see that "javascript:void(window.open
'http://www.google.com','_blank'))" gets pasted in the address bar of the IE
, removing all the frames and also the page is not loaded untill i press the
enter key.
Please help me find a solution to this.
Thanks in advance,
Regads,
Archana Kamath
"Bruce L-C [MVP]" wrote:
> For the following you need SP1 or greater installed.
> = "javascript:void(window.open('http://www.google.com','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > I have a number of dynamically configured hyperlinks in my report.
> Clicking
> > on them, takes user to a different application. I want for this new app
> to
> > open in a different browser window from the report itself, but instead it
> > opens in the same window and replaces my report data. Any ideas how to
> force
> > it to open in a new window?
> >
> > Thank you!
>
>|||Window.open create a new browser window. You want soemthign like:
(javascript)
Window.parent.FRAMENAME.src = 'http://www.google.com'
or
<a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
"Archana" <Archana@.discussions.microsoft.com> wrote in message
news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> Hi Bruce/Misha,
> I tried the solution given below and it opens in the new window with the
URL
> given,even when i change it to "_Self".
> Please note i am trying to open the url in a particular frame and not the
> full window.
> And also i see that "javascript:void(window.open
> 'http://www.google.com','_blank'))" gets pasted in the address bar of the
IE
> , removing all the frames and also the page is not loaded untill i press
the
> enter key.
> Please help me find a solution to this.
> Thanks in advance,
> Regads,
> Archana Kamath
>
> "Bruce L-C [MVP]" wrote:
> > For the following you need SP1 or greater installed.
> >
> > = "javascript:void(window.open('http://www.google.com','_blank'))"
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > I have a number of dynamically configured hyperlinks in my report.
> > Clicking
> > > on them, takes user to a different application. I want for this new
app
> > to
> > > open in a different browser window from the report itself, but instead
it
> > > opens in the same window and replaces my report data. Any ideas how
to
> > force
> > > it to open in a new window?
> > >
> > > Thank you!
> >
> >
> >|||Thanks Jim for a quick response.
But i am still facing the problem.
The problem is Reporting services report expression doesnot accept "<a href>".
And when i try to give the javascript,it doesnot get exceuted.What it simply
does is opens up a new browser and paste the javascript on the adress bar.It
doesnt not get executed untill we press the enter key.
In most of the solutions for such problems they have suggested to use the
javascript.But in my case, it doesnt get executed at all.
Do i need to set any internet settings so that javascript get executed with
out user pressing the enter key.
Please help me out with this issue.
Many Thanks,
Archana
"Jim Underwood" wrote:
> Window.open create a new browser window. You want soemthign like:
> (javascript)
> Window.parent.FRAMENAME.src = 'http://www.google.com'
> or
> <a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
> "Archana" <Archana@.discussions.microsoft.com> wrote in message
> news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > Hi Bruce/Misha,
> >
> > I tried the solution given below and it opens in the new window with the
> URL
> > given,even when i change it to "_Self".
> >
> > Please note i am trying to open the url in a particular frame and not the
> > full window.
> >
> > And also i see that "javascript:void(window.open
> > 'http://www.google.com','_blank'))" gets pasted in the address bar of the
> IE
> > , removing all the frames and also the page is not loaded untill i press
> the
> > enter key.
> >
> > Please help me find a solution to this.
> >
> > Thanks in advance,
> > Regads,
> > Archana Kamath
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > For the following you need SP1 or greater installed.
> > >
> > > = "javascript:void(window.open('http://www.google.com','_blank'))"
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > I have a number of dynamically configured hyperlinks in my report.
> > > Clicking
> > > > on them, takes user to a different application. I want for this new
> app
> > > to
> > > > open in a different browser window from the report itself, but instead
> it
> > > > opens in the same window and replaces my report data. Any ideas how
> to
> > > force
> > > > it to open in a new window?
> > > >
> > > > Thank you!
> > >
> > >
> > >
>
>|||Hi Jim,
Javascript works fine in the report.That is when i try opening the report
using the report manager /reportserver it works fine.When i click the link,
the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Thanks Jim for a quick response.
> But i am still facing the problem.
> The problem is Reporting services report expression doesnot accept "<a href>".
> And when i try to give the javascript,it doesnot get exceuted.What it simply
> does is opens up a new browser and paste the javascript on the adress bar.It
> doesnt not get executed untill we press the enter key.
> In most of the solutions for such problems they have suggested to use the
> javascript.But in my case, it doesnt get executed at all.
> Do i need to set any internet settings so that javascript get executed with
> out user pressing the enter key.
> Please help me out with this issue.
> Many Thanks,
> Archana
> "Jim Underwood" wrote:
> > Window.open create a new browser window. You want soemthign like:
> >
> > (javascript)
> > Window.parent.FRAMENAME.src = 'http://www.google.com'
> >
> > or
> > <a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
> >
> > "Archana" <Archana@.discussions.microsoft.com> wrote in message
> > news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > > Hi Bruce/Misha,
> > >
> > > I tried the solution given below and it opens in the new window with the
> > URL
> > > given,even when i change it to "_Self".
> > >
> > > Please note i am trying to open the url in a particular frame and not the
> > > full window.
> > >
> > > And also i see that "javascript:void(window.open
> > > 'http://www.google.com','_blank'))" gets pasted in the address bar of the
> > IE
> > > , removing all the frames and also the page is not loaded untill i press
> > the
> > > enter key.
> > >
> > > Please help me find a solution to this.
> > >
> > > Thanks in advance,
> > > Regads,
> > > Archana Kamath
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > For the following you need SP1 or greater installed.
> > > >
> > > > = "javascript:void(window.open('http://www.google.com','_blank'))"
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > >
> > > >
> > > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > > I have a number of dynamically configured hyperlinks in my report.
> > > > Clicking
> > > > > on them, takes user to a different application. I want for this new
> > app
> > > > to
> > > > > open in a different browser window from the report itself, but instead
> > it
> > > > > opens in the same window and replaces my report data. Any ideas how
> > to
> > > > force
> > > > > it to open in a new window?
> > > > >
> > > > > Thank you!
> > > >
> > > >
> > > >
> >
> >
> >|||HI Jim,
Thanks for your help.
The javascript works fine.There was some problem with mysharepoint page.
Anyways Many thanks
Regards,
Archana
"Archana" wrote:
> Hi Jim,
> Javascript works fine in the report.That is when i try opening the report
> using the report manager /reportserver it works fine.When i click the link,
> the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> > Thanks Jim for a quick response.
> > But i am still facing the problem.
> > The problem is Reporting services report expression doesnot accept "<a href>".
> > And when i try to give the javascript,it doesnot get exceuted.What it simply
> > does is opens up a new browser and paste the javascript on the adress bar.It
> > doesnt not get executed untill we press the enter key.
> >
> > In most of the solutions for such problems they have suggested to use the
> > javascript.But in my case, it doesnt get executed at all.
> >
> > Do i need to set any internet settings so that javascript get executed with
> > out user pressing the enter key.
> >
> > Please help me out with this issue.
> >
> > Many Thanks,
> > Archana
> >
> > "Jim Underwood" wrote:
> >
> > > Window.open create a new browser window. You want soemthign like:
> > >
> > > (javascript)
> > > Window.parent.FRAMENAME.src = 'http://www.google.com'
> > >
> > > or
> > > <a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
> > >
> > > "Archana" <Archana@.discussions.microsoft.com> wrote in message
> > > news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > > > Hi Bruce/Misha,
> > > >
> > > > I tried the solution given below and it opens in the new window with the
> > > URL
> > > > given,even when i change it to "_Self".
> > > >
> > > > Please note i am trying to open the url in a particular frame and not the
> > > > full window.
> > > >
> > > > And also i see that "javascript:void(window.open
> > > > 'http://www.google.com','_blank'))" gets pasted in the address bar of the
> > > IE
> > > > , removing all the frames and also the page is not loaded untill i press
> > > the
> > > > enter key.
> > > >
> > > > Please help me find a solution to this.
> > > >
> > > > Thanks in advance,
> > > > Regads,
> > > > Archana Kamath
> > > >
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > For the following you need SP1 or greater installed.
> > > > >
> > > > > = "javascript:void(window.open('http://www.google.com','_blank'))"
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > >
> > > > >
> > > > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > > > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > > > I have a number of dynamically configured hyperlinks in my report.
> > > > > Clicking
> > > > > > on them, takes user to a different application. I want for this new
> > > app
> > > > > to
> > > > > > open in a different browser window from the report itself, but instead
> > > it
> > > > > > opens in the same window and replaces my report data. Any ideas how
> > > to
> > > > > force
> > > > > > it to open in a new window?
> > > > > >
> > > > > > Thank you!
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >|||I am glad to hear you got it working.
"Archana" <Archana@.discussions.microsoft.com> wrote in message
news:95947B79-1C8F-4850-A528-231B95C82451@.microsoft.com...
> HI Jim,
> Thanks for your help.
> The javascript works fine.There was some problem with mysharepoint page.
> Anyways Many thanks
> Regards,
> Archana
> "Archana" wrote:
> > Hi Jim,
> >
> > Javascript works fine in the report.That is when i try opening the
report
> > using the report manager /reportserver it works fine.When i click the
link,
> > the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying
"Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> >
> > "Archana" wrote:
> >
> > > Thanks Jim for a quick response.
> > > But i am still facing the problem.
> > > The problem is Reporting services report expression doesnot accept "<a
href>".
> > > And when i try to give the javascript,it doesnot get exceuted.What it
simply
> > > does is opens up a new browser and paste the javascript on the adress
bar.It
> > > doesnt not get executed untill we press the enter key.
> > >
> > > In most of the solutions for such problems they have suggested to use
the
> > > javascript.But in my case, it doesnt get executed at all.
> > >
> > > Do i need to set any internet settings so that javascript get executed
with
> > > out user pressing the enter key.
> > >
> > > Please help me out with this issue.
> > >
> > > Many Thanks,
> > > Archana
> > >
> > > "Jim Underwood" wrote:
> > >
> > > > Window.open create a new browser window. You want soemthign like:
> > > >
> > > > (javascript)
> > > > Window.parent.FRAMENAME.src = 'http://www.google.com'
> > > >
> > > > or
> > > > <a href='http://www.google.com' target='FRAMENAME'>Insert Text
Here</a>
> > > >
> > > > "Archana" <Archana@.discussions.microsoft.com> wrote in message
> > > > news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > > > > Hi Bruce/Misha,
> > > > >
> > > > > I tried the solution given below and it opens in the new window
with the
> > > > URL
> > > > > given,even when i change it to "_Self".
> > > > >
> > > > > Please note i am trying to open the url in a particular frame and
not the
> > > > > full window.
> > > > >
> > > > > And also i see that "javascript:void(window.open
> > > > > 'http://www.google.com','_blank'))" gets pasted in the address bar
of the
> > > > IE
> > > > > , removing all the frames and also the page is not loaded untill i
press
> > > > the
> > > > > enter key.
> > > > >
> > > > > Please help me find a solution to this.
> > > > >
> > > > > Thanks in advance,
> > > > > Regads,
> > > > > Archana Kamath
> > > > >
> > > > >
> > > > > "Bruce L-C [MVP]" wrote:
> > > > >
> > > > > > For the following you need SP1 or greater installed.
> > > > > >
> > > > > > ="javascript:void(window.open('http://www.google.com','_blank'))"
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Bruce Loehle-Conger
> > > > > > MVP SQL Server Reporting Services
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in
message
> > > > > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > > > > I have a number of dynamically configured hyperlinks in my
report.
> > > > > > Clicking
> > > > > > > on them, takes user to a different application. I want for
this new
> > > > app
> > > > > > to
> > > > > > > open in a different browser window from the report itself, but
instead
> > > > it
> > > > > > > opens in the same window and replaces my report data. Any
ideas how
> > > > to
> > > > > > force
> > > > > > > it to open in a new window?
> > > > > > >
> > > > > > > Thank you!
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
on them, takes user to a different application. I want for this new app to
open in a different browser window from the report itself, but instead it
opens in the same window and replaces my report data. Any ideas how to force
it to open in a new window?
Thank you!Copied from newsgroup:
You put it in the document map label. This is a standard thing for
hyperlinks. You can also use _self, _top, _parent, etc...
From Books Online,
"Advanced Textbox Properties (Navigation Tab)
Use the Navigation tab of the Advanced Textbox Properties dialog box to
define navigation options for the text box.
Options
Document map label
Type or select a label or an expression that evaluates to a label. Click the
expression (fx) button to edit the expression. The value of the label
appears on the document map."
HTH, Jens Suessmeyer,.
http://www.sqlserver2005.de
--
"Misha_SQL" <Misha_SQL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
>I have a number of dynamically configured hyperlinks in my report.
>Clicking
> on them, takes user to a different application. I want for this new app
> to
> open in a different browser window from the report itself, but instead it
> opens in the same window and replaces my report data. Any ideas how to
> force
> it to open in a new window?
> Thank you!|||Some more links:
#1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
#2: Take a look at _LinkTarget device info setting:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
Jens Suessmeyer.
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> schrieb
im Newsbeitrag news:uv4rf7dRFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Copied from newsgroup:
>
> You put it in the document map label. This is a standard thing for
> hyperlinks. You can also use _self, _top, _parent, etc...
> From Books Online,
> "Advanced Textbox Properties (Navigation Tab)
> Use the Navigation tab of the Advanced Textbox Properties dialog box to
> define navigation options for the text box.
> Options
> Document map label
> Type or select a label or an expression that evaluates to a label. Click
> the expression (fx) button to edit the expression. The value of the label
> appears on the document map."
>
> HTH, Jens Suessmeyer,.
>
>
> --
> http://www.sqlserver2005.de
> --
> "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
>>I have a number of dynamically configured hyperlinks in my report.
>>Clicking
>> on them, takes user to a different application. I want for this new app
>> to
>> open in a different browser window from the report itself, but instead it
>> opens in the same window and replaces my report data. Any ideas how to
>> force
>> it to open in a new window?
>> Thank you!
>|||For the following you need SP1 or greater installed.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> I have a number of dynamically configured hyperlinks in my report.
Clicking
> on them, takes user to a different application. I want for this new app
to
> open in a different browser window from the report itself, but instead it
> opens in the same window and replaces my report data. Any ideas how to
force
> it to open in a new window?
> Thank you!|||Thank you, Jens!
These links contained information that solved my problem.
"Jens Sü�meyer" wrote:
> Some more links:
> #1:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> #2: Take a look at _LinkTarget device info setting:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
>
> Jens Suessmeyer.
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> schrieb
> im Newsbeitrag news:uv4rf7dRFHA.3716@.TK2MSFTNGP14.phx.gbl...
> > Copied from newsgroup:
> >
> >
> > You put it in the document map label. This is a standard thing for
> > hyperlinks. You can also use _self, _top, _parent, etc...
> >
> > From Books Online,
> >
> > "Advanced Textbox Properties (Navigation Tab)
> > Use the Navigation tab of the Advanced Textbox Properties dialog box to
> > define navigation options for the text box.
> >
> > Options
> >
> > Document map label
> > Type or select a label or an expression that evaluates to a label. Click
> > the expression (fx) button to edit the expression. The value of the label
> > appears on the document map."
> >
> >
> >
> > HTH, Jens Suessmeyer,.
> >
> >
> >
> >
> >
> > --
> >
> > http://www.sqlserver2005.de
> >
> > --
> >
> > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> >>I have a number of dynamically configured hyperlinks in my report.
> >>Clicking
> >> on them, takes user to a different application. I want for this new app
> >> to
> >> open in a different browser window from the report itself, but instead it
> >> opens in the same window and replaces my report data. Any ideas how to
> >> force
> >> it to open in a new window?
> >>
> >> Thank you!
> >
> >
>
>|||Hi Bruce/Misha,
I tried the solution given below and it opens in the new window with the URL
given,even when i change it to "_Self".
Please note i am trying to open the url in a particular frame and not the
full window.
And also i see that "javascript:void(window.open
'http://www.google.com','_blank'))" gets pasted in the address bar of the IE
, removing all the frames and also the page is not loaded untill i press the
enter key.
Please help me find a solution to this.
Thanks in advance,
Regads,
Archana Kamath
"Bruce L-C [MVP]" wrote:
> For the following you need SP1 or greater installed.
> = "javascript:void(window.open('http://www.google.com','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > I have a number of dynamically configured hyperlinks in my report.
> Clicking
> > on them, takes user to a different application. I want for this new app
> to
> > open in a different browser window from the report itself, but instead it
> > opens in the same window and replaces my report data. Any ideas how to
> force
> > it to open in a new window?
> >
> > Thank you!
>
>|||Window.open create a new browser window. You want soemthign like:
(javascript)
Window.parent.FRAMENAME.src = 'http://www.google.com'
or
<a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
"Archana" <Archana@.discussions.microsoft.com> wrote in message
news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> Hi Bruce/Misha,
> I tried the solution given below and it opens in the new window with the
URL
> given,even when i change it to "_Self".
> Please note i am trying to open the url in a particular frame and not the
> full window.
> And also i see that "javascript:void(window.open
> 'http://www.google.com','_blank'))" gets pasted in the address bar of the
IE
> , removing all the frames and also the page is not loaded untill i press
the
> enter key.
> Please help me find a solution to this.
> Thanks in advance,
> Regads,
> Archana Kamath
>
> "Bruce L-C [MVP]" wrote:
> > For the following you need SP1 or greater installed.
> >
> > = "javascript:void(window.open('http://www.google.com','_blank'))"
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > I have a number of dynamically configured hyperlinks in my report.
> > Clicking
> > > on them, takes user to a different application. I want for this new
app
> > to
> > > open in a different browser window from the report itself, but instead
it
> > > opens in the same window and replaces my report data. Any ideas how
to
> > force
> > > it to open in a new window?
> > >
> > > Thank you!
> >
> >
> >|||Thanks Jim for a quick response.
But i am still facing the problem.
The problem is Reporting services report expression doesnot accept "<a href>".
And when i try to give the javascript,it doesnot get exceuted.What it simply
does is opens up a new browser and paste the javascript on the adress bar.It
doesnt not get executed untill we press the enter key.
In most of the solutions for such problems they have suggested to use the
javascript.But in my case, it doesnt get executed at all.
Do i need to set any internet settings so that javascript get executed with
out user pressing the enter key.
Please help me out with this issue.
Many Thanks,
Archana
"Jim Underwood" wrote:
> Window.open create a new browser window. You want soemthign like:
> (javascript)
> Window.parent.FRAMENAME.src = 'http://www.google.com'
> or
> <a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
> "Archana" <Archana@.discussions.microsoft.com> wrote in message
> news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > Hi Bruce/Misha,
> >
> > I tried the solution given below and it opens in the new window with the
> URL
> > given,even when i change it to "_Self".
> >
> > Please note i am trying to open the url in a particular frame and not the
> > full window.
> >
> > And also i see that "javascript:void(window.open
> > 'http://www.google.com','_blank'))" gets pasted in the address bar of the
> IE
> > , removing all the frames and also the page is not loaded untill i press
> the
> > enter key.
> >
> > Please help me find a solution to this.
> >
> > Thanks in advance,
> > Regads,
> > Archana Kamath
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > For the following you need SP1 or greater installed.
> > >
> > > = "javascript:void(window.open('http://www.google.com','_blank'))"
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > I have a number of dynamically configured hyperlinks in my report.
> > > Clicking
> > > > on them, takes user to a different application. I want for this new
> app
> > > to
> > > > open in a different browser window from the report itself, but instead
> it
> > > > opens in the same window and replaces my report data. Any ideas how
> to
> > > force
> > > > it to open in a new window?
> > > >
> > > > Thank you!
> > >
> > >
> > >
>
>|||Hi Jim,
Javascript works fine in the report.That is when i try opening the report
using the report manager /reportserver it works fine.When i click the link,
the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Thanks Jim for a quick response.
> But i am still facing the problem.
> The problem is Reporting services report expression doesnot accept "<a href>".
> And when i try to give the javascript,it doesnot get exceuted.What it simply
> does is opens up a new browser and paste the javascript on the adress bar.It
> doesnt not get executed untill we press the enter key.
> In most of the solutions for such problems they have suggested to use the
> javascript.But in my case, it doesnt get executed at all.
> Do i need to set any internet settings so that javascript get executed with
> out user pressing the enter key.
> Please help me out with this issue.
> Many Thanks,
> Archana
> "Jim Underwood" wrote:
> > Window.open create a new browser window. You want soemthign like:
> >
> > (javascript)
> > Window.parent.FRAMENAME.src = 'http://www.google.com'
> >
> > or
> > <a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
> >
> > "Archana" <Archana@.discussions.microsoft.com> wrote in message
> > news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > > Hi Bruce/Misha,
> > >
> > > I tried the solution given below and it opens in the new window with the
> > URL
> > > given,even when i change it to "_Self".
> > >
> > > Please note i am trying to open the url in a particular frame and not the
> > > full window.
> > >
> > > And also i see that "javascript:void(window.open
> > > 'http://www.google.com','_blank'))" gets pasted in the address bar of the
> > IE
> > > , removing all the frames and also the page is not loaded untill i press
> > the
> > > enter key.
> > >
> > > Please help me find a solution to this.
> > >
> > > Thanks in advance,
> > > Regads,
> > > Archana Kamath
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > For the following you need SP1 or greater installed.
> > > >
> > > > = "javascript:void(window.open('http://www.google.com','_blank'))"
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > >
> > > >
> > > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > > I have a number of dynamically configured hyperlinks in my report.
> > > > Clicking
> > > > > on them, takes user to a different application. I want for this new
> > app
> > > > to
> > > > > open in a different browser window from the report itself, but instead
> > it
> > > > > opens in the same window and replaces my report data. Any ideas how
> > to
> > > > force
> > > > > it to open in a new window?
> > > > >
> > > > > Thank you!
> > > >
> > > >
> > > >
> >
> >
> >|||HI Jim,
Thanks for your help.
The javascript works fine.There was some problem with mysharepoint page.
Anyways Many thanks
Regards,
Archana
"Archana" wrote:
> Hi Jim,
> Javascript works fine in the report.That is when i try opening the report
> using the report manager /reportserver it works fine.When i click the link,
> the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> > Thanks Jim for a quick response.
> > But i am still facing the problem.
> > The problem is Reporting services report expression doesnot accept "<a href>".
> > And when i try to give the javascript,it doesnot get exceuted.What it simply
> > does is opens up a new browser and paste the javascript on the adress bar.It
> > doesnt not get executed untill we press the enter key.
> >
> > In most of the solutions for such problems they have suggested to use the
> > javascript.But in my case, it doesnt get executed at all.
> >
> > Do i need to set any internet settings so that javascript get executed with
> > out user pressing the enter key.
> >
> > Please help me out with this issue.
> >
> > Many Thanks,
> > Archana
> >
> > "Jim Underwood" wrote:
> >
> > > Window.open create a new browser window. You want soemthign like:
> > >
> > > (javascript)
> > > Window.parent.FRAMENAME.src = 'http://www.google.com'
> > >
> > > or
> > > <a href='http://www.google.com' target='FRAMENAME'>Insert Text Here</a>
> > >
> > > "Archana" <Archana@.discussions.microsoft.com> wrote in message
> > > news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > > > Hi Bruce/Misha,
> > > >
> > > > I tried the solution given below and it opens in the new window with the
> > > URL
> > > > given,even when i change it to "_Self".
> > > >
> > > > Please note i am trying to open the url in a particular frame and not the
> > > > full window.
> > > >
> > > > And also i see that "javascript:void(window.open
> > > > 'http://www.google.com','_blank'))" gets pasted in the address bar of the
> > > IE
> > > > , removing all the frames and also the page is not loaded untill i press
> > > the
> > > > enter key.
> > > >
> > > > Please help me find a solution to this.
> > > >
> > > > Thanks in advance,
> > > > Regads,
> > > > Archana Kamath
> > > >
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > For the following you need SP1 or greater installed.
> > > > >
> > > > > = "javascript:void(window.open('http://www.google.com','_blank'))"
> > > > >
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > >
> > > > >
> > > > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in message
> > > > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > > > I have a number of dynamically configured hyperlinks in my report.
> > > > > Clicking
> > > > > > on them, takes user to a different application. I want for this new
> > > app
> > > > > to
> > > > > > open in a different browser window from the report itself, but instead
> > > it
> > > > > > opens in the same window and replaces my report data. Any ideas how
> > > to
> > > > > force
> > > > > > it to open in a new window?
> > > > > >
> > > > > > Thank you!
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >|||I am glad to hear you got it working.
"Archana" <Archana@.discussions.microsoft.com> wrote in message
news:95947B79-1C8F-4850-A528-231B95C82451@.microsoft.com...
> HI Jim,
> Thanks for your help.
> The javascript works fine.There was some problem with mysharepoint page.
> Anyways Many thanks
> Regards,
> Archana
> "Archana" wrote:
> > Hi Jim,
> >
> > Javascript works fine in the report.That is when i try opening the
report
> > using the report manager /reportserver it works fine.When i click the
link,
> > the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying
"Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> >
> > "Archana" wrote:
> >
> > > Thanks Jim for a quick response.
> > > But i am still facing the problem.
> > > The problem is Reporting services report expression doesnot accept "<a
href>".
> > > And when i try to give the javascript,it doesnot get exceuted.What it
simply
> > > does is opens up a new browser and paste the javascript on the adress
bar.It
> > > doesnt not get executed untill we press the enter key.
> > >
> > > In most of the solutions for such problems they have suggested to use
the
> > > javascript.But in my case, it doesnt get executed at all.
> > >
> > > Do i need to set any internet settings so that javascript get executed
with
> > > out user pressing the enter key.
> > >
> > > Please help me out with this issue.
> > >
> > > Many Thanks,
> > > Archana
> > >
> > > "Jim Underwood" wrote:
> > >
> > > > Window.open create a new browser window. You want soemthign like:
> > > >
> > > > (javascript)
> > > > Window.parent.FRAMENAME.src = 'http://www.google.com'
> > > >
> > > > or
> > > > <a href='http://www.google.com' target='FRAMENAME'>Insert Text
Here</a>
> > > >
> > > > "Archana" <Archana@.discussions.microsoft.com> wrote in message
> > > > news:992668D3-C45F-4950-ACE0-E7D04FB034DF@.microsoft.com...
> > > > > Hi Bruce/Misha,
> > > > >
> > > > > I tried the solution given below and it opens in the new window
with the
> > > > URL
> > > > > given,even when i change it to "_Self".
> > > > >
> > > > > Please note i am trying to open the url in a particular frame and
not the
> > > > > full window.
> > > > >
> > > > > And also i see that "javascript:void(window.open
> > > > > 'http://www.google.com','_blank'))" gets pasted in the address bar
of the
> > > > IE
> > > > > , removing all the frames and also the page is not loaded untill i
press
> > > > the
> > > > > enter key.
> > > > >
> > > > > Please help me find a solution to this.
> > > > >
> > > > > Thanks in advance,
> > > > > Regads,
> > > > > Archana Kamath
> > > > >
> > > > >
> > > > > "Bruce L-C [MVP]" wrote:
> > > > >
> > > > > > For the following you need SP1 or greater installed.
> > > > > >
> > > > > > ="javascript:void(window.open('http://www.google.com','_blank'))"
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Bruce Loehle-Conger
> > > > > > MVP SQL Server Reporting Services
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Misha_SQL" <Misha_SQL@.discussions.microsoft.com> wrote in
message
> > > > > > news:AB7CB9AF-6CAA-4A13-9A75-8FF174E9E5D3@.microsoft.com...
> > > > > > > I have a number of dynamically configured hyperlinks in my
report.
> > > > > > Clicking
> > > > > > > on them, takes user to a different application. I want for
this new
> > > > app
> > > > > > to
> > > > > > > open in a different browser window from the report itself, but
instead
> > > > it
> > > > > > > opens in the same window and replaces my report data. Any
ideas how
> > > > to
> > > > > > force
> > > > > > > it to open in a new window?
> > > > > > >
> > > > > > > Thank you!
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
Subscribe to:
Posts (Atom)