How to modify the joins in Report Studio

[willie]

Hi,

I have a report were I have to list the 'Products' along with the 'week' were there is no corresponding 'status' entry made for a given period. I want the report to display the week with blank cells for the status which I can replace with a string "Missing".

I tried using the 'is Null' operator but unable to bring up the records with no status entries.

Can anyone suggest how I can achieve this...

Thanks,
Willie

[COGNOiSe administrator]

Crosstab or list?

[almeids]

When you say there is no corresponding status entry, do you mean there is no record for that product/week, or that a column is not populated with a status value in an existing record for that product/week?
If there is no record, you'll need an additional table or tables to select product/week combinations from.  If there is a record, you need to find out what the status value is - if it's not null, then perhaps blank or some default value like zero.