[CLOSED] Unable to place reports into different excel tabs based on an across field

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, 2010

Tony A

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: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Tony A

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: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Danny-SRL

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: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

info4pals

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, 2010

Ignored post by info4pals posted

Show Post

Alex

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, 2003

Ignored post by Alex posted

Show Post

info4pals

Member

posted

Hide Post

[CLOSED]

webfocus 769,windows 7,html

Posts: 24 | Registered: July 16, 2010

Ignored post by info4pals posted