locked
SSRS report preview with xml input RRS feed

  • Question

  • User955080112 posted

    Hello -

    I am trying to preview an SSRS report that uses a stored procedure that takes an XML input as one of the parameters.  It uses openxml on that XML input as part of the query retrieval process

    Problem is, I take in the xml as a text input parameter when previewing, but am unsure of how to format it on the input.  Double quotes, single quotes?  Nothing seems to work.  its' maddening.

    Below is sample input.  Anyone have any idea?

    "<PM><PG prov_no = \"360037\" /><PG prov_no = \"360059\" /><PG prov_no = \"360077\" /><PG prov_no = \"360087\" /><PG prov_no = \"360101\" /><CG code = \"001\" type = \"MSDRG\" /></PM>"

    Monday, May 22, 2017 5:55 PM

All replies

  • User-2057865890 posted

    Hi mndotnetdev,

    Problem is, I take in the xml as a text input parameter when previewing, but am unsure of how to format it on the input.  Double quotes, single quotes?  Nothing seems to work.

    It is better if you could share what you have tried or any error message that you are facing.

    Try

    <PM>
    <PG prov_no = "360037" />
    <PG prov_no = "360059" />
    <PG prov_no = "360077" />
    <PG prov_no = "360087" />
    <PG prov_no = "360101" />
    <CG code = "001" type = "MSDRG" />
    </PM>

    Best Regards,

    Chris

    Tuesday, May 23, 2017 3:03 AM