• Registered: 2015-12-25
  • Posts: 211

Topic: BUG? Using Report (SQL)

Hey guys, i have a strange bug, i got 3 combo boxes, two have a child, they are:

TIPO , MARCA, MODELO (Type, Brand, Model)

And i am using SQL Report because i want to report a table grid with a few values, and the only way i was able to do this is via Report (SQL)

So... about these 3 combo boxes

here's part of the script that fetches this info:

tipo.tpo
marca.marca
modelo.model

LEFT OUTER JOIN tipo on assistencia.id_tipo = tipo.id
LEFT OUTER JOIN marca on assistencia.id_marca = tipo.id
LEFT OUTER JOIN modelo on assistencia.id_modelo = tipo.id

Note: the tipo marca and modelo are all in their own table.

When i preview the report only the Tipo shows up, the Marca and Modelo are not present...
If i do the same but using the automatic Report (without the sql) i can see all the info correctly.

Is this a bug or am i doing something wrong?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: BUG? Using Report (SQL)

Hello,


Please attach your project (zip file without exe and dll)
and describe steps how to reproduce this bug.

Dmitry.
  • Registered: 2015-02-24
  • Posts: 446

Re: BUG? Using Report (SQL)

Just a wild guess (because without the database, hard to tell) by looking at the query :

try to change 

LEFT OUTER JOIN tipo on assistencia.id_tipo = tipo.id
LEFT OUTER JOIN marca on assistencia.id_marca = tipo.id
LEFT OUTER JOIN modelo on assistencia.id_modelo = tipo.id

with

LEFT OUTER JOIN tipo on assistencia.id_tipo = tipo.id
LEFT OUTER JOIN marca on assistencia.id_marca = marca.id
LEFT OUTER JOIN modelo on assistencia.id_modelo = modelo.id
I'm a very good housekeeper !
Each time I get a divorce, I keep the house
Zaza Gabor