How to make comparison characteristics equal for both years (2004 vs.2005)?

I was trying to create a simple report to compare two years' sales by
region (2004 vs. 2005). We used to have 13 regions before 2005. Now we
only have 12 (DOM013 was removed starting 2005). How can I make DOM013
to appear in the comparison table even if we have no data for it in
2005?

Any help is appreciated.

Keith

Mahesh
Mon Jul 18 17:44:22 CDT 2005

Keith,
Please, let me know which data region u r using?
If u r using chart the its quite straight forward to add region as data
fields and year as series fields.

If u r using dataset fields then probably u can use IsMissing property
of field.

Hope this helps.

Thanks,
Mahesh

Keith
Mon Jul 18 17:58:09 CDT 2005

Mahesh,

Thanks for your reply! I am using TABLE. Basically, there are 3
columns: Region, 2004 Sales, and 2005 Sales. How to use this IsMissing
property? Can you give me an example?

Thanks,
Keith

Mahesh
Wed Jul 20 15:38:19 CDT 2005

Keith,
Sorry for late reply. Was busy with other stuff.

Well, normally we use
= Fields!CaseStatus.Value
to assign value to text box

instead if you think there is possibilty that you will not get any data
for this field the you can check for value before using it

e.g

= iif(Fields!CaseStatus.IsMissing, "N/A", Fields!CaseStatus.Value)

now here your column will display the value if its returned by dataset,
else it will display "N/A"

hope this helps.

Cheers,
Mahesh