reporting services - Issue accessing SharePoint list data using SSRS 2008 -


I am trying to access catalog data using SSRS 2008.

I have created an XML data source with the following connection string: "".

Then I created a dataset with the following query:

& lt; Query & gt; & Lt; SoapAction & gt; Http: //schemas.microsoft.com/sharepoint/soap/GetListItems< / SoapAction & gt; & Lt; Method namespace = "http://schemas.microsoft.com/sharepoint/soap/" name = "GetListItems" & gt; & Lt; Parameter & gt; & Lt; Parameter name = "list name" & gt; & Lt; DefaultValue & gt; Your_List_Name & lt; / DefaultValue & gt; & Lt; / Parameters & gt; & Lt; / Parameters & gt; & Lt; / Method & gt; & Lt; Elementpath IgnoreNamespaces = "True" & gt; * & Lt; / ElementPath & gt; & Lt; / Query & gt;

Problems now:

I am having trouble reading column values, including html markup tags (especially the "light lines of text" field) type ). Reporting service creates a field called "row" in the dataset, when it encounters such a column.

I tried to delete this "row" field and created the actual field manually. I then set up the HTML value in the placeholder properties (SSRS 2008 did not work on a new feature where HTML markup is considered as styles).

For example, in the "points tracking list" the comments column is stored as "div"

The CAMLBuilder works perfectly with executing the same query Is showing all the columns.

How do I get this problem? Any help?

Thank you in advance

PS: I posted the same question on the MSDN SQL Server Reporting Services Forum. Here it is.

I posted the same query on the MSDN SQL Server Reporting Services Forum. Here it is. MSFT moderator has solved this problem.


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -