none
Representar NULL en un reporte RRS feed

  • Pregunta

  • Hola
    Necesito representar un NULL en un reporte de crystal que me de el siguiente query:
    SELECT MovPed.*
    FROM
        { oj ((((((("SC276T" MovPed
         INNER JOIN "SC1Q4T" DetPed ON
            MovPed."SC165A" = DetPed."SC165A" AND
            MovPed."SC1prA" = DetPed."SC1prA" AND
            MovPed."SC1q8A" = DetPed."SC1q8A")
         INNER JOIN "SC2PT" DirxCli ON
            MovPed."SC1puA" = DirxCli."SC7gA" AND
            MovPed."SC1pvA" = DirxCli."SC7hA" AND
            MovPed."SC1pwA" = DirxCli."SCbdA" AND
            MovPed."SC254A" = DirxCli."SC9jA")
         INNER JOIN "SCCMT" Periodo ON
            DetPed."SCacA" = Periodo."SCacA")
         INNER JOIN "SCET" SCET ON
            DirxCli."SC8iA" = SCET."SC8iA" AND
            DirxCli."SC8lA" = SCET."SC8lA" AND
            DirxCli."SC8nA" = SCET."SC8nA")
         INNER JOIN "SC1PNT" HedPed ON
            DetPed."SC165A" = HedPed."SC165A" AND
            DetPed."SC1prA" = HedPed."SC1prA")
         LEFT OUTER JOIN "SC1dzT" SC1dzT ON
            DetPed."SC87A" = SC1dzT."SC87A" AND
            DetPed."SC1dlA" = SC1dzT."SC1dlA")
         INNER JOIN "SCMT" SCMT ON
            HedPed."SC1puA" = SCMT."SC7gA" AND
            HedPed."SC1pvA" = SCMT."SC7hA")
         LEFT OUTER JOIN "SC24T" SC24T ON
            SCMT."SC7gA" = SC24T."SC7gA" AND
            SCMT."SC7hA" = SC24T."SC7hA"}
    WHERE
        MovPed."SC87A" = 'E001' AND
        MovPed."SC488A" = 'DI' AND
        MovPed."SC220A" >= {ts '2009-09-15 00:00:00.00'} AND
        MovPed."SC220A" < {ts '2009-09-23 00:00:00.00'} AND
        (DetPed."SC1dlA" = 'P001' OR SC1dzT."SC1e1A" = 'P001' OR SC1dzT."SC1e1A"  <> NULL)

    Agradesco su colaboración

    • Cambiado Fran DiazModerator martes, 23 de agosto de 2011 10:50 Es de CR (De:SQL Server Reporting Services)
    martes, 22 de septiembre de 2009 15:56