How do i show my XQuery field in my reports?

• shivani sharma-428076

  SSC-Addicted

  Points: 429

  More actions

  June 12, 2007 at 11:29 am

  #174559

  In my query there is one column of XML datatype.How do i take this column in my reports.When i take this query below it just displays RequestXMl column as text.

  SELECT     RequestXML ,CreateDate, VendorName, ErrorMessage, ResponseDate

  FROM         tblBPINTIEEUploadRequestLog

  WHERE  (CreateDate  BETWEEN @startdate AND @enddate) and VendorName=@vendorname

  I want that when user view reports RequestXML should show a link and user should be able to click on that link to open the xml.How do i do that?

   

   

   

• sumit-417494

  Say Hey Kid

  Points: 686

  More actions

  June 12, 2007 at 12:04 pm

  #712362

  have you tried using "action" properties of textbox?