Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Previous VS Current Reports (Report Assistant)
Go
New
Search
Notify
Tools
Reply
  
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, 2012Reply With QuoteReport 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, 2012Reply With QuoteReport 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: 332 | Location: Orlando, FL | Registered: October 17, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.