I have this XML file. When I try to click on it, I received an error message.
This is my XML Query
<?xml version='1.0' encoding='utf-16'?> <Scheduler daysAfter='60' step='30' lockHistory='false' heightspec='Fixed' height='550'> <heading><div style='padding:5px; font-weight: bold; font-size:12px; text-align:center'>Drag/Drop Planner</div></heading> <resources source='VEHICLES_FW' name='VEHICLE_ID_FW' onService='IN_SERVICE_DATE_FW' offService='SOLD_DATE_FW' width='150'> <sql> SELECT VEHICLES_FW.LOCATION_CODE_FW, VEHICLE_ID_FW, CAR_NO_FW, CAMPUS_FW, BUSINESS_CRITERIA_FW, PRIVATE_CRITERIA_FW, IN_SERVICE_DATE_FW, SOLD_DATE_FW, MAKE_CODE_FW, ( SELECT TOP 1 DESCRIPTION_FW FROM MANUFACTURERS_FW WHERE CODE_FW = MAKE_CODE_FW AND ARCHIVE_STATUS_FW = 'N' ) AS Make, MODEL_CODE_FW, BODY_TYPE_FW, TRANSMISSION_TYPE_fW, DERIVATIVE_FW, VEHICLE_PHONE_NUMBER_FW, VEHICLE_DESCRIPTION_FW, DOORS_FW, EXTERIOR_COLOUR_FW, VEHICLE_ID2_FW, VEHICLES_FW.RECORD_NUMBER_FW FROM VEHICLES_FW WHERE IN_POOL_FW = 1 AND VEHICLES_FW.ARCHIVE_STATUS_FW='N' AND (IN_SERVICE_DATE_FW IS NULL OR IN_SERVICE_DATE_FW < %enddate%) AND (SOLD_DATE_FW IS NULL OR SOLD_DATE_FW >= %startdate%) ORDER BY VEHICLES_FW.CAR_NO_FW ASC </sql> <columns> <column name='CAR_NO_FW' width='110'/> <column name='BUSINESS_CRITERIA_FW' width='120'/> <column name='MODEL_CODE_FW' width='110'/> <!-- <column name='Make' width='100'/> <column name='DERIVATIVE_FW' width='150'/> <column name='BODY_TYPE_FW' width='100'/> --> </columns> <bubble header='<table style="border:none; background-colour:#ffffee;font-size: 8pt; font-family: verdana;">' format='<tr><th align="left">{0}</th><td>:</td><td>{1}</td></tr>' footer='</table>'> <sql> SELECT VEHICLES_FW.VEHICLE_ID_FW,VEHICLES_FW.PRIVATE_CRITERIA_FW, VEHICLES_FW.ODOMETER_FW FROM VEHICLES_FW WHERE VEHICLES_FW.ARCHIVE_STATUS_FW ='N' AND VEHICLES_FW.RECORD_NUMBER_FW = %id% </sql> <field name='VEHICLE_ID_FW' /> <field name='PRIVATE_CRITERIA_FW' /> <field name='ODOMETER_FW' /> </bubble> <colours default='#e9e9e9'> <sql>SELECT DATEDIFF(d, GetDate(), ON_FLEET_DATE_FW) FROM VEHICLES_FW WHERE RECORD_NUMBER_FW = %id%</sql> <band limit='30' code='#ff0000' /> <band limit='60' code='#ffff00' /> <band limit='90' code='#00ff00' /> </colours> </resources> <events source='RENTALS_FW' display='DRIVER_NAME_FW' resource='VEHICLE_RECORD_NUMBER_FW' height='50' handle='15' status='RENTAL_STATUS_FW' click='SINGLE'> <start date='FROM_DATE_FW' time='FROM_TIME_FW' combined='FROM_FW' /> <end date='TO_DATE_FW' time='TO_TIME_FW' combined='TO_FW' /> <sql> SELECT RENTALS_FW.RECORD_NUMBER_FW, RENTALS_FW.DRIVER_RECORD_NUMBER_FW, RENTALS_FW.DRIVER_NAME_FW,RENTALS_FW.DEPARTMENT_FW,RENTALS_FW.COSTCENTRE_FW,CONCAT(RENTALS_FW.DEPARTMENT_FW,' ',RENTALS_FW.COSTCENTRE_FW) as VALUE_FW,RENTALS_FW.RENTAL_STATUS_FW, RENTALS_FW.FROM_DATE_FW, RENTALS_FW.FROM_DATE_FW + CAST (ISNULL(RENTALS_FW.FROM_TIME_FW, '00:00:00') AS datetime) as FROM_FW, RENTALS_FW.TO_DATE_FW, RENTALS_FW.TO_DATE_FW + CAST (ISNULL(RENTALS_FW.TO_TIME_FW, '00:00:00') as datetime) as TO_FW, RENTALS_FW.VEHICLE_ID_FW, RENTALS_FW.VEHICLE_RECORD_NUMBER_FW, RENTALS_FW.TRAVELLED_DISTANCE_FW ,driver.DRIVER_STATUS_FW FROM RENTALS_FW LEFT OUTER JOIN VEHICLES_FW resource ON RENTALS_FW.VEHICLE_RECORD_NUMBER_FW = resource.RECORD_NUMBER_FW LEFT OUTER JOIN DRIVERS_FW driver ON RENTALS_FW.DRIVER_RECORD_NUMBER_FW=driver.RECORD_NUMBER_FW WHERE (RENTALS_FW.FROM_DATE_FW < %enddate% OR (RENTALS_FW.FROM_DATE_FW = %enddate% AND RENTALS_FW.FROM_TIME_FW <= %endtime%)) AND (RENTALS_FW.TO_DATE_FW > %startdate% OR (RENTALS_FW.TO_DATE_FW = %startdate% AND RENTALS_FW.TO_TIME_FW >= %starttime%)) AND RENTALS_FW.ARCHIVE_STATUS_FW='N' </sql> <colours key='STATUS_CODE_FW' value='BACKGROUND_COLOUR_FW'> <sql>SELECT BACKGROUND_COLOUR_FW, STATUS_CODE_FW FROM STATUS_CODES_FW WHERE ARCHIVE_STATUS_FW='N'</sql> </colours> <dragbar key='STATUS_CODE_FW' value='BACKGROUND_COLOUR_FW' colour='#008800' status='RENTAL_STATUS_FW'> <sql>SELECT STATUS_CODE_FW, BACKGROUND_COLOUR_FW FROM STATUS_CODES_FW WHERE RENTALS_FW = 1 AND ARCHIVE_STATUS_FW='N'</sql> <fixed colour='#000088'> <status>ISSUED</status> </fixed> <locked colour='#880000'> <status>COMPLETE</status> </locked> </dragbar> <bubble> <sql>SELECT CASE WHEN LONG_MULTIPLE_DRIVERS_FW IS NOT NULL AND LONG_MULTIPLE_DRIVERS_FW != '' THEN DRIVER_NAME_FW + '-Pool' ELSE DRIVER_NAME_FW END DRIVER_NAME_FW, TRAVELLED_DISTANCE_FW, FROM_DATE_FW, FROM_TIME_FW, TO_DATE_FW, TO_TIME_FW FROM RENTALS_FW WHERE RECORD_NUMBER_FW = %id%</sql> <field name='DRIVER_NAME_FW' /> <field name='TRAVELLED_DISTANCE_FW' /> <field name='FROM_DATE_FW' /> <field name='FROM_TIME_FW' /> <field name='TO_DATE_FW' /> <field name='TO_TIME_FW' /> </bubble> </events> <colours unavailable='#ffdddd' available='#ddffdd' weekend='#ddddff' resource='#888888' /> <legend visible='true' source='RENTALS_FW' caption='MSGLEGEND' /> </Scheduler> Can you please tell me whats wrong, why I am receiving the Object reference not set an instance of an object?
Thank you!
No comments:
Post a Comment