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

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

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

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.

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!

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.

[CLOSED]