The following work in the Enesys SharePoint Query Builder but not in Visual Studio 2005, I receive this error:

[rsInvalidReportParameterDependency] The report parameter ReportTrack has a DefaultValue or a ValidValue that depends on the report parameter ReportTrack. Forward dependencies are not valid.

<?xml version="1.0" encoding="utf-8"?>
<root xmlns="http://enesyssoftware.com/schemas">
  <queryName></queryName>
  <description></description>
  <list title="Review Comments" relativeSiteUrl="/ipoms/pakistan/" tableName="Review Comments">
    <fields>Track,Lesson,Document_x0020_Type,Page_x0020_or_x0020_Slide_x0020_,Origin,Comment,Customer_x0020_Priority,Contractor_x0020_Comment,Commnet_x0020_Action,ReportTrack,Comment_x0020_Category,Status</fields>
    <query></query>
  </list>
  <sqlQuery tableName="TrackReport">
    SELECT *
    FROM [Review Comments]
    WHERE ReportTrack  = (@ReportTrack!)
  </sqlQuery>
  <resultSet>TrackReport</resultSet>
</root>

 *****The ReportTrack column is a calculated column (string)

 Thanks......

Hi Bill,

If you want to have only distinct items, you have to add a sqlQuery statement to your first dataset from which you get the values to put in the drop down list:

<sqlQuery tableName="sqlQuery1">
  SELECT DISTINCT [ReportTrack]
  FROM [Pakistan Review Comments]
</sqlQuery>

I used the data from what you gave in the other thread, you have to change "ReportTrack" by your column name and "Pakistant Review Comments" by your list's tableName if they are different.

If you use a resultSet statement, don't forget to change its value to the sqlQuery's tableName.

Hope this help,

Regards,
Marien MONNIER
Enesys