Does SQL Server support XML Functions

Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
sNot sure about Oracle counterparts, but have you checked out the FOR XML
clause in SQL Server 2000 Books Online?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s|||See BOL for OPENXML and FOR XML
--
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s|||In addition, SQL 2005 will make XML a first-class citizen in the server, XML
data types, XQUERY, the full ride!
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s|||Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>|||FOR XML is SQL Server's T-SQL specific.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408022328.464b6cae@.posting.google.com...
Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>|||These functions are part of the ANSI/ISO SQL-2003 standard and are not
supported in SQLServer 2005 for a variety of reasons (ISO spec was released
too late for us to add them, they are less performing and more verbose than
a rowset mapping approach such as FOR XML).
We may consider them in the next release, if enough users request them. So
please let me know if I should count you :-).
Best regards
Michael
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s

Does SQL Server support XML Functions

Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s
Not sure about Oracle counterparts, but have you checked out the FOR XML
clause in SQL Server 2000 Books Online?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s
|||See BOL for OPENXML and FOR XML
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s
|||In addition, SQL 2005 will make XML a first-class citizen in the server, XML
data types, XQUERY, the full ride!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s
|||Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
|||FOR XML is SQL Server's T-SQL specific.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408022328.464b6cae@.posting.google.c om...
Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
|||These functions are part of the ANSI/ISO SQL-2003 standard and are not
supported in SQLServer 2005 for a variety of reasons (ISO spec was released
too late for us to add them, they are less performing and more verbose than
a rowset mapping approach such as FOR XML).
We may consider them in the next release, if enough users request them. So
please let me know if I should count you :-).
Best regards
Michael
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s

Does SQL Server support XML Functions

Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s
Not sure about Oracle counterparts, but have you checked out the FOR XML
clause in SQL Server 2000 Books Online?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s
|||See BOL for OPENXML and FOR XML
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s
|||In addition, SQL 2005 will make XML a first-class citizen in the server, XML
data types, XQUERY, the full ride!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s
|||Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
|||FOR XML is SQL Server's T-SQL specific.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408022328.464b6cae@.posting.google.c om...
Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
|||These functions are part of the ANSI/ISO SQL-2003 standard and are not
supported in SQLServer 2005 for a variety of reasons (ISO spec was released
too late for us to add them, they are less performing and more verbose than
a rowset mapping approach such as FOR XML).
We may consider them in the next release, if enough users request them. So
please let me know if I should count you :-).
Best regards
Michael
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.c om...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s

Does SQL Server support XML Functions

Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
sNot sure about Oracle counterparts, but have you checked out the FOR XML
clause in SQL Server 2000 Books Online?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
s|||See BOL for OPENXML and FOR XML
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s|||In addition, SQL 2005 will make XML a first-class citizen in the server, XML
data types, XQUERY, the full ride!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> s|||Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:<uldgTsGeEHA.1764@.TK
2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>|||FOR XML is SQL Server's T-SQL specific.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408022328.464b6cae@.posting.google.com...
Hi,
Yep the SQL Server supports the FOR XML clause which returns the
Records/Rows as XML. However Oracle does not support FOR XML clause.
(oracle 9i). To get the output in XML format the functions that i have
mentioned have to be used.
Now before I end up using the above mentioned functions, i wanted
to know whether these functions are supported by other Databases also
or not.
Bye
Amardeep Verma
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:<uldgTsGeEHA.1764@.TK2MSFTNGP10.phx.gbl>...
> Not sure about Oracle counterparts, but have you checked out the FOR XML
> clause in SQL Server 2000 Books Online?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>|||These functions are part of the ANSI/ISO SQL-2003 standard and are not
supported in SQLServer 2005 for a variety of reasons (ISO spec was released
too late for us to add them, they are less performing and more verbose than
a rowset mapping approach such as FOR XML).
We may consider them in the next release, if enough users request them. So
please let me know if I should count you :-).
Best regards
Michael
"Amardeep Verma" <addverma@.netscape.net> wrote in message
news:45d3f402.0408012353.49b1ab71@.posting.google.com...
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
> ssql

Does SQL Server support XML Functions

Hi,
Do any versions of SQL Server support the following functions, as
they appear in the Oracle Database:-

1) XMLElement
2) XMLAttributes
3) XMLForest

Thanks in Advance for your reply
Bye
Amardeep VermaAmardeep Verma (addverma@.netscape.net) writes:
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply

Since I don't know Oracle, I don't know what these functions do. It is
not likely that SQL Server supports these functions directly, but it
may support the same functionality. You would need to explain what these
functions do to get answer.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi,
Thanks Erland for your Response. These Functions take simple
SELECT statement and return the result in a XML format. With each
Column name as a tag and the value in that column as the data.
For Example the Employee Table of NorthWind Database has 3
columns:-
1) EmpNo
2) EmpLastName
3) EmpFirstName
Then using the below mentioned functions we can get the output
<EMP>
<EMPNo>1</EMPNo>
<EMPFirstName>ABC</EMPFirstName>
<EMPLastName>XYZ</EMPLastName>
</EMP
Hope this helps
Amardeep Verma

Erland Sommarskog <esquel@.sommarskog.se> wrote in message news:<Xns9536EC50E4C4FYazorman@.127.0.0.1>...
> Since I don't know Oracle, I don't know what these functions do. It is
> not likely that SQL Server supports these functions directly, but it
> may support the same functionality. You would need to explain what these
> functions do to get answer.|||Amardeep Verma (addverma@.netscape.net) writes:
> Thanks Erland for your Response. These Functions take simple
> SELECT statement and return the result in a XML format. With each
> Column name as a tag and the value in that column as the data.
> For Example the Employee Table of NorthWind Database has 3
> columns:-
> 1) EmpNo
> 2) EmpLastName
> 3) EmpFirstName
> Then using the below mentioned functions we can get the output
><EMP>
> <EMPNo>1</EMPNo>
> <EMPFirstName>ABC</EMPFirstName>
> <EMPLastName>XYZ</EMPLastName>
></EMP
It looks like you should study the FOR XML clause in the SELECT statement.
It gives you several possibilities. Rather than typing examples here,
I refer you to Books Online myself, since I am no XML wizard myself.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||SQL sever has a few ways to generate xml. An example below that
conforms to your spec(ie columns as elements) can be viewed in QA

select * from employees
where employeeid=1 for xml auto, elements

NOTE: it is best run when the query is set to 'Results in text' and
also
'DBCC TRACEON(257)' has been run first

Does SQL 2005 take XML query time into acount?

if there's an [untyped] XField.Query() in a select, does SQL 2005 do
anything (internally) like an automatic sub-select if there's standard
fields to compare, saving the XML analysis for later, (to avoid uneccessary
calculations)?Hello Jerry,
XML queries do cache their query plans, of course, like any other T-SQL quer
y.
However, unindexed XML has to reconstruct the node table each time. That's
an expensive unit of work (usually), so the best thing you can (usually)
do is create an primary XML index over those instances. That "kind of" does
that you're looking for here.
Cheers,
Kent|||> XML queries do cache their query plans, of course, like any other T-SQL
> query. However, unindexed XML has to reconstruct the node table each time.
> That's an expensive unit of work (usually), so the best thing you can
> (usually) do is create an primary XML index over those instances. That
> "kind of" does that you're looking for here.
Thanks for all, Kent ;)

Does SQL 2005 take XML query time into acount?

if there's an [untyped] XField.Query() in a select, does SQL 2005 do
anything (internally) like an automatic sub-select if there's standard
fields to compare, saving the XML analysis for later, (to avoid uneccessary
calculations)?
Hello Jerry,
XML queries do cache their query plans, of course, like any other T-SQL query.
However, unindexed XML has to reconstruct the node table each time. That's
an expensive unit of work (usually), so the best thing you can (usually)
do is create an primary XML index over those instances. That "kind of" does
that you're looking for here.
Cheers,
Kent
|||> XML queries do cache their query plans, of course, like any other T-SQL
> query. However, unindexed XML has to reconstruct the node table each time.
> That's an expensive unit of work (usually), so the best thing you can
> (usually) do is create an primary XML index over those instances. That
> "kind of" does that you're looking for here.
Thanks for all, Kent ;)
sql

Does anyone know of an easy way (read without going into the XML) of deleting a dataset?

Please see above

In report designer, go to the data tab and in its toolbar click the icon with the red X (deletes the currently selected dataset).

-- Robert

Does an embedded XML DataSet have to be hardcoded?

I have an XML DataSource in my report which does not specify a connection
string, because I want to use an embedded XML DataSet. However I would like
the XML DataSet text to be defined using an expression (actually a function
call in my custom assembly). Even though you can define an expression for the
XML DataSet, doing so generates a design time error like this:
"The XmlDP query is invalid. Syntax error at line 1, character 3 of the
ElementPath. (Microsoft.ReportingServices.DataExtensions)"
If I define the DataSet text like this it works fine:
============================================= <Query>
<ElementPath>Root /Parameter {@.ParamName, @.ParamValue} </ElementPath>
<XmlData>
<Root>
<Parameter ParamName="Param1" ParamValue="Value1"></Parameter>
<Parameter ParamName="Param2" ParamValue="Value2"></Parameter>
<Parameter ParamName="Param3" ParamValue="Value3"></Parameter>
<Parameter ParamName="Param4" ParamValue="Value4"></Parameter>
<Parameter ParamName="Param5" ParamValue="Value5"></Parameter>
</Root>
</XmlData>
</Query>
=============================================
If I define the DataSet text like this I get the error message:
============================================= = "<Query>"
+ "<ElementPath>Root /Parameter {@.ParamName, @.ParamValue} </ElementPath>"
+ "<XmlData>"
+ "<Root>"
+ "<Parameter ParamName=""Param1"" ParamValue=""Value1""></Parameter>"
+ "<Parameter ParamName=""Param2"" ParamValue=""Value2""></Parameter>"
+ "<Parameter ParamName=""Param3"" ParamValue=""Value3""></Parameter>"
+ "<Parameter ParamName=""Param4"" ParamValue=""Value4""></Parameter>"
+ "<Parameter ParamName=""Param5"" ParamValue=""Value5""></Parameter>"
+ "</Root>"
+ "</XmlData>"
+ "</Query>"
=============================================
The above is just an expression that shows the error message. Ideally my
DataSet text will look like this:
=Code.RptLib.ReportParametersXML()
It looks like I am up against a limitation in the product. Can you confirm
that this is a limitation in trhe product (embedded XML DataSets MUST be
hardcoded), or is there a workaround or technique that I am missing?
Thanks!
-- Chris
--
Chris, SSSIHello Chirs,
I have reproduced this issue on my side.
I will do some research on this. I appreciate your patience.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hi Wei Lu,
I found an interesting thing.
By accident I tried =Code.RptLib.ReportParametersXML instead of
=Code.RptLib.ReportParametersXML() and that worked.
Because my method does not take any parameters, I guess VB.NET does not like
the empty parenthesis and for some reason the Report Designer gives a
misleading error message about this problem.
So I solved my problem and I do not have to hard code the XML. It is coming
from my custom assembly.
However, I have no idea why the expression syntax ="..." does not work. But
since I do not need that approach it is not a problem for me right now.
Still, you might want to pass this "bug" on to the developers of SSRS.
-- Chris
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chirs,
> I have reproduced this issue on my side.
> I will do some research on this. I appreciate your patience.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>