Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using BYTOC for EXCEL 2000

Status
Not open for further replies.
LeonelSanchezJr

LeonelSanchezJr

Programmer
Jan 26, 2001
522
US
I realize that BYTOC can be used to create separate workbooks within 1 excel sheet, but here's the trick I have to do.

I have a Report Caster Job that needs to BURST by ORIGIN.
I also need to do a BYTOC by SHIPMENTTYPE.

When I do this, the BYTOC creates separate tabs in Excel by ORIGIN instead of by SHIPMENTTYPE.

How can I do a BYTOC on my 2nd BY field?

Thanks,

Leo ;-)
 
Sort by date Sort by votes
Hi Leo,

BYTOC will only work on the first BY field, same as Caster...

Anyone know a work-around in this situation?

oceannative
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ekl0908
  • Locked
  • Question
Is there a maximum length for an index field?
Replies
0
Views
300
ekl0908
ekl0908
LeonelSanchezJr
  • Locked
  • Question
Resize IFrame Using JavaScript in WebFOCUS 7.6.7
Replies
0
Views
238
LeonelSanchezJr
LeonelSanchezJr
jackiev
  • Locked
  • Question
WebFocus SQL Report: Excel97 - ok, Excel2000- No query Info
Replies
0
Views
292
jackiev
jackiev
LeonelSanchezJr
  • Locked
  • Question
Row Formulas for Excel
Replies
2
Views
220
LeonelSanchezJr
LeonelSanchezJr
peechy23
  • Locked
  • Question
Wrap a field in a free form report
Replies
0
Views
168
peechy23
peechy23

Part and Inventory Search

Sponsor

Back
Top