Good morning/afternoon/evening and night,

Is there a way to show fields from the database wich don't have data in it.

For example iam trying to show the last 4 weeks with data. Some of these last 4 weeks don't contain data.

Those weeks wich don't contain any data aren't being shown in the output. The complete row is being removed from the output.'

Greetings !

There is a very large section in the Developers Studio on-line help dealing with missing data.

It might be a good idea to read it.

SET ALL=PASS

for most adapters however there are lots of rules.

P.S. ask Santa for a basic training course for Christmas.

SET ALL = PASS...isn't working.. also left outer joins aren't working??

More options?

OK you have a joined structure.

What dbms/file type are the tables you are joining?

If you extract data from each table individually do you see all the rows
required when SET ALL=PASS is used.

quote:

P.S. ask Santa for a basic training course for Christmas.

SMSL

T

quote:

For example iam trying to show the last 4 weeks with data. Some of these last 4 weeks don't contain data.

Does your database have any entry at all if no data exists?

I suppose your want something like a week report and even if a specific week has no data you want it in the report.

Something like

           01      02       03     04         05
Country
ENGLAND     5       2        1                 7
SPAIN       3       4        2                 5
ITALY       2       1        3                  
          ---     ---      ---               ---
TOTAL      10       7        6                12
          ===     ===      ===               ===

If this is it, you can do a forced column by the command

TABLE FILE xxx
SUM SALES
BY COUNTRY
ACROSS WEEK COLUMNS '01' AND '02' AND '03' AND '04' AND '05'
END

So even if week '04' has no data you will get it in your report

Happy Holidays