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  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Display the date range as a text value for a field
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Display the date range as a text value for a field
 Login/Join
 
Member
posted
The output of the table is
Product Volume Value %Volume %Value Period
abc 12 1,354 45% %60 12 Jan2012 to 19 Jan2012
xyz 4 354 15% %10 12 Jan2012 to 19 Jan2012

How do i display this Value?

This is a weekly report that runs between date1 and date2 already predefined.

This message has been edited. Last edited by: <Kathryn Henning>,


release 7.6.4
OS: windows 7 professional
EXL2K, HTML
 
Posts: 4 | Registered: January 16, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What's your source data? What fields are available in the masterfile?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
The source data is picked up from a SQL Database.

The fields availabe are Product_Code, Count(Row_Num) as Volume, Count(Price) as Value.

Since this is a weekly report, we usually display the heading as " From 01/12/2014 to 01/19/2012"

We would like to insert a seperate column after Product, Volume and Value called Period to display the date range " From 01/12/2014 to 01/19/2012"


release 7.6.4
OS: windows 7 professional
EXL2K, HTML
 
Posts: 4 | Registered: January 16, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
date1 and date2 can be used in a Dialog Manager command to form the text value you seek.
-SET &MY_TEXT = 'From ' | date1 | ' To ' date2;
You may have to manipulate date1 and date2 into Dialog Manager variables.
Your print statement can be
Print
Product_Code
.
.
.
&My_Text

HTH


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Display the date range as a text value for a field

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