1 Reply Latest reply on Jan 22, 2010 4:48 AM by gramsay

    Blank Notes Report

    gramsay Specialist

      Running the notes report from the notes window (via print button on toolbar) gives a blank report.

      Running the same report from crystal and entering a valid GUID when prompted gives a correct report.

      If I hard code a GUID into the report I get the same details via crystal & console, so I know it's loading the correct report.

       

      SQL (with GUID entered via prompt) is below.


      SELECT "usr_notescategory"."usr_notescategory", "im_incident_note"."im_guid", "im_incident"."im_id", "tps_user"."tps_title", "tps_group"."tps_title", "im_incident_note"."im_creation_date", "im_incident_note"."im_text"
      FROM   ((("ITBM"."dbo"."im_incident_note" "im_incident_note" LEFT OUTER JOIN "ITBM"."dbo"."im_incident" "im_incident" ON "im_incident_note"."im_incident_guid"="im_incident"."pm_guid") LEFT OUTER JOIN "ITBM"."dbo"."tps_group" "tps_group" ON "im_incident_note"."im_create_group_guid"="tps_group"."tps_guid") LEFT OUTER JOIN "ITBM"."dbo"."usr_notescategory" "usr_notescategory" ON "im_incident_note"."usr_notescategory"="usr_notescategory"."usr_guid") LEFT OUTER JOIN "ITBM"."dbo"."tps_user" "tps_user" ON "im_incident_note"."im_creation_user_guid"="tps_user"."tps_guid"
      WHERE  "im_incident_note"."im_guid"='29C46FA2-3D83-4A1E-959D-2CE3956178F6'

       

      Anybody any ideas?