Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Previous VS Current Reports (Report Assistant)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Previous VS Current Reports (Report Assistant)
 Login/Join
 
Member
posted
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
 
Posts: 12 | Registered: March 08, 2012Report This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: March 08, 2012Report This Post
Guru
posted Hide Post
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
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Previous VS Current Reports (Report Assistant)

Copyright © 1996-2020 Information Builders