<?xml version="1.0" encoding="utf-8" ?> <root xmlns="http://enesyssoftware.com/schemas">
<multiList title="Financial Event Calendar" relativeSiteUrl="@site!" type="RollUpList" tableName="Financial Event Calendar" useDisplayName="false">
<fields>Title, District_x0020_Name, Property_x002f_Project_x0020_Nam, Event_x002f_Obligation_x0020_Typ, Payment_x0020_Status, Supplier, Account, Due_x0020_Date,Ap_x0020_Status,Requested_x0020_By,
Amount_x0020_Due,Check_x0020_Number, Check_x0020_Cut_x0020_Date
</fields>
<query>
</query>
</multiList>
<sqlOp op="select">
<dstTableName>FilteredCalendar</dstTableName>
<sourceTableName>Financial Event Calendar</sourceTableName>
<selectExpression>('@district!' = '(ALL)' OR District_x0020_Name = '@district!'or ( '@district!'='707 PHELPS DODGE MIAMI, INC - CHRISTMAS' and District_x0020_Name='707 PHELPS DODGE MIAMI, INC') ) and ('@property!' = '(ALL)' OR Property_x002f_Project_x0020_Nam= '@property!') and ('@event!'='(ALL)' or Event_x002f_Obligation_x0020_Typ= '@event!') and ('@event!'='(ALL)' or Event_x002f_Obligation_x0020_Typ= '@event!') and ('@month!' ='(ALL)' or (Due_x0020_Date>= '@month!/1/@year!' and Due_x0020_Date>='@month!/15/@year!'))</selectExpression>
</sqlOp>
<resultSet>FilteredCalendar</resultSet>
</root>
This one works, but as soon as i change it to what it needs to be:
<?xml version="1.0" encoding="utf-8" ?> <root xmlns="http://enesyssoftware.com/schemas">
<multiList title="Financial Event Calendar" relativeSiteUrl="@site!" type="RollUpList" tableName="Financial Event Calendar" useDisplayName="false">
<fields>Title, District_x0020_Name, Property_x002f_Project_x0020_Nam, Event_x002f_Obligation_x0020_Typ, Payment_x0020_Status, Supplier, Account, Due_x0020_Date,Ap_x0020_Status,Requested_x0020_By,
Amount_x0020_Due,Check_x0020_Number, Check_x0020_Cut_x0020_Date
</fields>
<query>
</query>
</multiList>
<sqlOp op="select">
<dstTableName>FilteredCalendar</dstTableName>
<sourceTableName>Financial Event Calendar</sourceTableName>
<selectExpression>('@district!' = '(ALL)' OR District_x0020_Name = '@district!'or ( '@district!'='707 PHELPS DODGE MIAMI, INC - CHRISTMAS' and District_x0020_Name='707 PHELPS DODGE MIAMI, INC') ) and ('@property!' = '(ALL)' OR Property_x002f_Project_x0020_Nam= '@property!') and ('@event!'='(ALL)' or Event_x002f_Obligation_x0020_Typ= '@event!') and ('@event!'='(ALL)' or Event_x002f_Obligation_x0020_Typ= '@event!') and ('@month!' ='(ALL)' or (Due_x0020_Date>= '@month!/1/@year!' and Due_x0020_Date<='@month!/15/@year!'))</selectExpression>
</sqlOp>
<resultSet>FilteredCalendar</resultSet>
</root>
I get an error:
TITLE: Microsoft Report Designer
------------------------------
An error occurred while executing the query.
Name cannot begin with the '=' character, hexadecimal value 0x3D. Line 14, position 508.
------------------------------
ADDITIONAL INFORMATION:
Name cannot begin with the '=' character, hexadecimal value 0x3D. Line 14, position 508. (System.Xml)
------------------------------
BUTTONS:
OK
------------------------------