Forced List

[CPK6104]

I'm using CR 2008 and I have a (probably rookie) question. Here's my set-up…

Table3 < Table2 < Table1
All links are Left Outer Join.

Table1 contains incident records. Each incident record contains generic information about each incident such as Start Date, End Date and Severity.

Table2 contains the impact records (one to many). There can be one or more impact records per incident joined by a unique ID.

Table3 stores application names. Each impact record in Table2 contains an application name, but the actual names are stored in Table3. Let’s say there are 10 unique application names.

Scenario:
In January, there are incidents impacting 5 of the 10 applications. In February, all 10 applications are impacted.

If I report on February Year-to-Date incidents, I can list all 10 application names. But if I just report on January incidents, I can only list the 5 applications impacted. You can’t display all 10 application names if the records don’t exist, right?

Well, I’m wondering if there’s a way to force the entire list of 10 app names. I’d like to list all 10 applications in January even if the impact records aren’t there, like this:

January
App Data

App1 213
App2
App3 25
App4 242
App5
App6
App7 556
App8 449
App9
App10

Is this possible? Sorry for the long explanation. Thanks for your help.

 

[lbass]

You could use left outer joins with tables set up like this:

table3->table2->table1

Then don't make any selections on fields from table2 or table3. Instead write conditional formulas like this:


//{@January}:
if year({table.date}) = {?Year} and
month({table.date})=1 then
{table.data}

//{@February}:
if year({table.date}) = {?Year} and
month({table.date})=2 then
{table.data}

etc.

If you insert a group on Application Name, you can then place these formulas in the detail section and insert summaries on them at the group level and then suppress the details.

-LB