Hi,

I am a little bit confused about the use of Rolluplists and parameters. Perhaps you can help me to find my mistake.

First I created a Query with the following content: Everything worked fine. As desired I could filter the report by my report parameters.

<?xml version="1.0" encoding="utf-8" ?>
<root>
  <list title="Savings" relativeSiteUrl="/savings/goldland" tableName="Savings" useDisplayName="true">
    <fields></fields>
       <query>
           <Where>
<And>
             <Eq>
                <FieldRef Name="Customer"/>
                <Value Type="Text">@DS_Par_Customer!</Value>
              </Eq>
 <And>
<Gt>
                <FieldRef Name="Saving Date"/>
                <Value Type="DateTime">@DS_Par_Date_From!</Value>
</Gt>
<Lt>
                <FieldRef Name="Saving Date"/>
                <Value Type="DateTime">@DS_Par_Date_Until!</Value>
</Lt>
</And>
</And>
            </Where>
    </query>
  </list>
</root>

Now I made some changes, including a Rolluplist. My intention was to create a query in which I can use data from all lists named "Savings" in my site collection and I want to filter by my report parameters as before (see above). I created the following query:

<?xml version="1.0" encoding="utf-8" ?>
<root>
    <multiList title="Savings" relativeSiteUrl="/savings/" type="RollUpList" tableName="Savings" useDisplayName="true">
  
<fields>Title, Customer, Operating Company, Location, Duration, Saving Author, Responsible Employee, Project ID, Saving Date, Saving Status, Sum, Saving Category</fields>

           <query>
           <where>

<And>
             <Eq>
                <FieldRef Name="Customer"/>
                <Value Type="Text">@DS_Par_Customer!</Value>
              </Eq>

 <And>
<Gt>
                <FieldRef Name="Saving Date"/>
                <Value Type="DateTime">@DS_Par_Date_From!</Value>
</Gt>
<Lt>
                <FieldRef Name="Saving Date"/>
                <Value Type="DateTime">@DS_Par_Date_Until!</Value>
</Lt>
</And>
</And>

 </where>
    </query>
    </multiList>
    <resultset>Savings</resultset>
</root>

But now by results will not filtered as desired.

Hi,

thanks for your reply. I deleted these mistakes in my query and used your xml schema file as has been described in your documentation.From xml-point-of-view there should be no syntax problems as nothing is highlighted in the xml-document.

But I have the following error: When having created the dataset Iam used to click on the "!"-button to get my data. But now I get the message "Microsoft.SharePoint.SoapServer.SoapServerException". And this happens since I am using the correct syntax with "Where" instead of the previous "where".

Here my code:

<?xml version="1.0" encoding="utf-8" ?>
<root xmlns="http://enesyssoftware.com/schemas">
    <multiList title="Savings" relativeSiteUrl="/savings/" type="RollUpList" tableName="Savings" useDisplayName="true">
  
<fields>Title, Customer, Operating Company, Location, Duration, Category</fields>
           <query>
           <Where>
<And>
             <Eq>
                <FieldRef Name="Operating Company"/>
                <Value Type="Text">@DS_Par_OpCo!</Value>
              </Eq>
<And>
             <Eq>
                <FieldRef Name="Customer"/>
                <Value Type="Text">@DS_Par_Customer!</Value>
              </Eq>
 <And>
<Gt>
                <FieldRef Name="Saving Date"/>
                <Value Type="DateTime">@DS_Par_Date_From!</Value>
</Gt>
<Lt>
                <FieldRef Name="Saving Date"/>
                <Value Type="DateTime">@DS_Par_Date_Until!</Value>
</Lt>
</And>
</And>
</And>
     </Where>
    </query>
    </multiList>
    <resultSet>Savings</resultSet>
</root>

Hi,

yes I can confirm that it is working fine when using "list". You can see the code at the top of this thread...

Hi,

I can confirm this is a bug. This should work if you remove the namespace from the root element.

Can you confirm?

Regards,

Hi,

My posts might have been confusing.

Remove the namespace but keep useDisplayName="true".

Alternatively, you could remove useDisplayName attribute but you will need to use SharePoint internal field names rather than display names in your query.

Let me know.

Regards,

Hi,

Do all lists share common metadata?

Some tests you could do for the sake of narrowing down the problem:

1. Specify just one column in the fields element (eg: Customer or ID)

2. Start from "/savings/goldland" even if there is one list to roll up.

Regards,

Hi,

That's good news.

Since then we have released an official 2.0.2 release. You may want to download it if you haven't done already so. There are still some limitations regarding Rolling up data for the current user as explained in the release history page.

Do not hesitate to contact us if you have further questions.

Regards,

Hi,

I have double cheked and it works as expected here.

I will post more thorough information on this subject later on this afternoon.

Also, it could help to get more detailed information about the error you are getting. You can find it in the reporting services log files. Alternatively, you can run the report within the report designer using the credentials which cause the error.

My first guess is that you have a user that do not have access to the list (specified in your query) in any of the descendant sites nor the root site specified.

Regards,

Are you sure you have installed the 2.0.2 version on the server from which you run the report? You can confirm this by running the "Version" sample report from the server.

If so and so that I can try to reproduce this exact error here could you tell me what are the permission of this user regarding your site hierarchy and the list you are retrieving items from:

Let's say you are rolling up the list "list X" starting from site "Starting Site".

Starting Site (user permissions)
     |---list X (user permissions)
     |
     |----Child Site 1 (user permissions)
     |         |----list X (user permissions)
     |
     |----Child Site 2 (user permissions)
     |         |----list X (user permissions)

Regards,

Hi,

This is very confusing. Is the DS_ParentCorporation based on a multiList statement? Did you try to run the DS_ParentCorporation dataset in its very own report?

From your answer, your users seem to have contribute permissions both at the site and list level which is fine for rolling-up lists. I'm assuming that you have standard contribute permissions (or at least the browse directories permission has not been removed).

Regards,