If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

reg dynamic conditionall formatting for list reports

Started by murthyvasan, 12 Dec 2006 07:23:05 PM

Previous topic - Next topic

murthyvasan

Hi all,

Iam working on a report where I need to show data differences
between two databases A and A'. There are 2 tables on each
database that need's to be reported on their differences. Let's
call the tables on DB A as T1 and T2, and tables on A' as T1'
and T2'. Iam comparing T1 and T1' and creating a report and
doing the same for T2 and T2'.

Let's say Iam comparing T1 and T1' and creating a report out of
it. A_id is the common column between the two tables.

I have to create a UNION between these two tables and then do a
order by on A_id, so that my first row is from T1, second row is
from T1' for the same A_id, third row is from T1 with the next
A_id, 4th row is from T1' with the same A_id as 3rd row, and so
on....  The report will be like the one shown below.

DB    A_id     M_id     A_type
A      1          999       Pr
A'     1          987       Pr
A      2          223       Ke
A'     2          223       Ka

As you can see , the rows from the different databases are one
below another.

My issue is , how can I conditional format(apply a color) the
column whose value differs in A and A' , for same A_id. For
Example, in the first 2 rows M_id column has different values,
so both these values needs to be colored. In the 3rd and 4th
rows A_type differs, so A_type values for 3rd and 4th row needs
to be colored.Thus for each pair of rows with same A_id, there
may be different columns which will have different values, which
needs to be colored. On occasions , for a pair of rows , both
the columns may have different values. How to acheive this? Or
is there a workaround, given the business scenario? There are
lot of columns , but for the sake of this discussion, they are
not shown. Thanks

BIsrik

I feel instead of using union if we use a two child tabular models inside one parent model might help..My approach is like this..

Tabular model 1 - contains data from database A
Tabular model 2 - contains data from database A'

Tabular model 0 - contains both the data of tabular model 1&2 with a join on field A_id. In this model i create a calc which compares the columns of both the tabular model columns.


Plz let me know if this helps or is there any problem in the approach..

Srik