Focal Point
Previous VS Current Reports (Report Assistant)

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/3567049916

May 09, 2012, 09:19 AM
DavidGarcia
Previous VS Current Reports (Report Assistant)
Hello

I want to make a report in which I can compare the information of 2 different columns (both columns belong to the same field).

Example

01/12 02/12 "COMPARISON COLUMN"
(Datefield1) (Datefield1)

10 12 12/10
11 14 14/11
12 16 16/12
. . ./.
. . ./.
n n n/n

I have 2 issues

1.- I am using the report assistant cause I am not a developer so essentially I need to fix this with R.A.
2.- 01/12 and 02/12 come from a single date field converted to an MY format.

Is there a way to do this???


Regards


Webfocus 7.7.03
May 09, 2012, 09:42 AM
DavidGarcia
Columns didnĀ“t display properly.

01/12 02/12 Target Column

1 2 2/1
2 3 3/2
3 4 4/3
4 5 5/4


Webfocus 7.7.03
May 10, 2012, 07:26 AM
Anatess
Hi David,

I'm not sure I understand your issue. Let me see if I got this straight:

1.) You have 2 tables that contain the field DATEFIELD1.
2.) You want to display DATEFIELD1 from one table and DATEFIELD1 from the other table on the same line in the report.

Is that right?

If so, then JOIN both tables together and create the report against the joined resulting set.


WF 8.1.05 Windows