DBXtra ... problem with SUBREPORT ... no row result

• roberto 7952

  SSC Enthusiast

  Points: 159

  More actions

  September 4, 2015 at 9:43 am

  #302887

  I have a problem with SUBREPORT in DBXtra.

  The problem it's that a subreport should always return at least one row of data, so if it doesn't return anything, then the whole report fails with a login exception.

  How I can CREATE a report where, if there are no data, I have a ROW with data 0 ?

  My SQL report is this :

  Select xOperatori.Descrizione As desc_operatore, xriltempi.Attivita As Attivita1, xriltempi.DataInizio, xriltempi.DataFine

  From xriltempi Inner Join

  xOperatori On xriltempi.Cd_xOperatori = xOperatori.Cd_xOperatori

  Group By xOperatori.Descrizione, xriltempi.Attivita, xriltempi.DataInizio, xriltempi.DataFine, xriltempi.Cd_xOperatori

  Having xriltempi.Attivita = 'Z' And xriltempi.DataInizio = '<|Last month|>'

  Order By xriltempi.Cd_xOperatori

  If there are no data I need that can result at last one row with 0 value in every field, but no without row and value.

  Thanks in advance ... rgds

  Roberto Giussani