I build my reports in MS Visual Studio 2005.  I have an existing report with two parameter fields designed to allow users to run a report in a more targeted fashion (i.e. for specific customers and products vs. the default of getting everybody).  I need to add a 3rd parameter, but when I do - I get the following error:

Exception of type 'Microsoft.SharePoint.SoapServerException' was thrown. (Enesys.ReportingServices.Ersde2008)

If I remove one of the previously existing parameter fields, the report runs fine with the new parameter - the problem seems to be that I am defining more than 2.  I am selftaught at all of this - so possibly I have to change to a different approach if I have 3 or more parameter fields?

The query looks like this, with StatusType being the 3rd parameter:

<?xml version="1.0" encoding="utf-8" ?>
<root xmlns="http://enesyssoftware.com/schemas">
<list title="MasterList" relativeSiteUrl="/sites/field-partner/61EAP/" stripHtml="true" tableName="MasterList">
<fields>*</fields>
<query>
                                                <Where>
                                                        <And>
                                                                <In>
                                                                                                <FieldRef Name="Customer_x0020_Name_x0020_N" />
                                                                                                <Value Type="Text">@CustomerName!</Value>
                                                                                </In>
                                                                <In>
                                                                                                <FieldRef Name="Product_x0020_N" />
                                                                                                <Value Type="Text">@Product!</Value>
                                                                                </In>
                                                                <In>
                                                                                                <FieldRef Name="Status_x0020_Type" />
                                                                                                <Value Type="Text">@StatusType!</Value>
                                                                                </In>
                                                        </And>
                                                       
                                               </Where>
                                </query>
</list>
                                <sqlQuery tableName="SortList">
               SELECT *
               FROM MasterList
                                            WHERE Category LIKE 'Current'
              ORDER BY Customer_x0020_Name_x0020_N, Title
                                </sqlQuery>
</root>

Thanks for your help!

Frederic,

Thank you for your help.  I do appreciate the high level of support that I always recieve from you and the rest of the team at Enesys.  Your suggestion worked.  I had a feeling that the solution lay in how the nesting of the multiple parameters was done - but I couldn't get the proper configuration on my own.  As I say - I am self taught at all of this, which is why I haven't yet moved on to using your query builder.  But take heart - I am moving in that direction!  I am in the process of getting access to BIDS and hope to be able to then learn your tool and take advantage of the integration features.

Thanks again for your help!

Sincerely,

Bill