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] Unable to place reports into different excel tabs based on an across field
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Unable to place reports into different excel tabs based on an across field
 Login/Join
 
Member
posted
Hi,
I have a requirement such that if the end user selects say 2 ID's from the listbox in the launchpage,then the report should have 1 excel tab having the 1st ID report and 2nd excel tab having the selected 2nd ID report details.

Below is the code :
-DEFAULT &SELECTEDID='1,2';
TABLE FILE HOLD1
PRINT *
WHERE PID IN (&SELECTEDID)
ON TABLE HOLD AS HOLD2
END

TABLE FILE HOLD2
SUM
XYZ
BY SID
BY SNM
ACROSS PID
ACROSS PNM
WHERE PID NE ' '
END
-RUN
-EXIT

Can anyone please tell me how to do this.I know that we can place the reports in different excel tabs using BYTOC but I want to place the reports based on an across field - PID in this case.

This is really really urgent.Any help is greatly appreciated.
Thanks a lot!

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


webfocus 769,windows 7,html
 
Posts: 24 | Registered: July 16, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
If you want multiple Excel tabs in your output then use ON TABLE PCHOLD FORMAT EXL2K BYTOC.

However, this works on the FIRST BY field and not an ACROSS, so either add BY PID NOPRINT as the first BY phrase or change the ACROSS PID to the first BY phrase.

This sort of thing is covered in basic training, is this an option for you?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5682 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Please also take the time to read responses to identical earlier questions.

The post you raised at 12:34 BST yesterday was answered by Jimbo less than an hour later at 13:16 BST.

You could find that your pleas for help go unanswered if you do not at least look at the replies your have had before asking the same question again.

Remember, posters on this forum are very happy to help out and they do so willingly and for free. If individuals do not show appreciation by apparently ignoring answers ask yourself if you would continue to help such an individual?

T
 
Posts: 5682 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
To add to what Tony said, it is not logical to want to have different TABs based on an ACROSS field.
When you want to have different TABs what you are implying is that your report is separated into blocks and the only way to do this is with a BY. WebFOCUS gives you this possibility on the FIRST BY field of your TABLE request only.

As I said in a previous thread, for your own satisfaction, your employer should provide you with some training.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1954 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Thanks everyone for the response.Sure going forward I will ensure that multiple posts aren't posted.
Yes I had undergone a training and as webfocus is very vast,I thought there could be some other way to achieve what Iam trying to do.

Can we do it using looping?Any thoughts/suggestions would be appreciated.

Thanks a lot in advance!


webfocus 769,windows 7,html
 
Posts: 24 | Registered: July 16, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
By making your ACROSS field the first BY field you automatically are creating the output block you want. Using the Table of Contents feature (BYTOC) you will automatically get you separate worksheets.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Reply With QuoteReport This Post
Member
posted Hide Post
[CLOSED]


webfocus 769,windows 7,html
 
Posts: 24 | Registered: July 16, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Unable to place reports into different excel tabs based on an across field

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