Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Unable to Output Report in PDF/EXL2K

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Unable to Output Report in PDF/EXL2K
 Login/Join
 
Silver Member
posted
Hi Guys,

I am facing a problem when I selected output the report to PDF/EXL2K.

Anyone can enlighten me on this issue?

1. HTML - No Issue.

2. EXL2K - Generated Output still in HTML format.


2. PDF - Generated Output seems like binary to me as below :

  
%PDF-1.4 6 0 obj << /Length 7 0 R >> stream BT /F1 1 Tf ET 0 g /GS1 gs 0 Tc 0 Tw 0 G 0 J 0 j 1 w 10 M []0 d 1 i BT /F2 1 Tf 8 0 0 8 13 770 Tm (PAGE )Tj 8 0 0 8 41 770 Tm ( 1)Tj ET q 121.00 0 0 29.00 17 730 cm /Im1 Do Q BT /F3 1 Tf 12 0 0 12 19 703 Tm (DAILY CARD STATISTICS FOR THE MONTH OF )Tj /F2 1 Tf 12 0 0 12 299 703 Tm (APRIL )Tj 12 0 0 12 342 703 Tm (2006 )Tj /F3 1 Tf 12 0 0 12 109 673 Tm (APPLICATION COUNT \(AA No.\))Tj ET 0.00 0.00 0.00 RG 109 671 m 296 671 l S 0.60 0.80 1.00 rg 13 634 32 11 re f 0.10 w 13 645 m 45 645 l S 13 645 m 13 634 l S 45 634 133 11 re f 45 645 m 178 645 l S 45 645 m 45 634 l S 178 634 114 11 re f 178 645 m 292 645 l S 178 645 m 178 634 l S 292 634 99 11 re f 292 645 m 391 645 l S 292 645 m 292 634 l S 391 645 m 391 634 l S BT /F3 1 Tf 0.00 0.00 0.00 rg 8 0 0 8 22 636 Tm (Day)Tj 8 0 0 8 54 636 Tm (Total No. of Application)Tj 8 0 0 8 187 636 Tm (Last Application No.)Tj 8 0 0 8 301 636 Tm (Total Application)Tj ET 1.00 1.00 1.00 rg 13 623 32 11 re f 13 634 m 45 634 l S 13 634 m 13 623 l S 45 623 133 11 re f 45 634 m 178 634 l S 45 634 m 45 623 l S 178 623 114 11 re f 178 634 m 292 634 l S 178 634 m 178 623 l S 292 623 99 11 re f 292 634 m 391 634 l S 292 634 m 292 623 l S 391 634 m 391 623 l S BT /F2 1 Tf 0.00 0.00 0.00 rg 8 0 0 8 25 625 Tm (01)Tj 8 0 0 8 110 625 Tm (0)Tj 8 0 0 8 233 625 Tm (.)Tj 8 0 0 8 340 625 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 612 32 11 re f 13 623 m 45 623 l S 13 623 m 13 612 l S 45 612 133 11 re f 45 623 m 178 623 l S 45 623 m 45 612 l S 178 612 114 11 re f 178 623 m 292 623 l S 178 623 m 178 612 l S 292 612 99 11 re f 292 623 m 391 623 l S 292 623 m 292 612 l S 391 623 m 391 612 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 614 Tm (02)Tj 8 0 0 8 110 614 Tm (0)Tj 8 0 0 8 233 614 Tm (.)Tj 8 0 0 8 340 614 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 601 32 11 re f 13 612 m 45 612 l S 13 612 m 13 601 l S 45 601 133 11 re f 45 612 m 178 612 l S 45 612 m 45 601 l S 178 601 114 11 re f 178 612 m 292 612 l S 178 612 m 178 601 l S 292 601 99 11 re f 292 612 m 391 612 l S 292 612 m 292 601 l S 391 612 m 391 601 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 603 Tm (03)Tj 8 0 0 8 110 603 Tm (0)Tj 8 0 0 8 233 603 Tm (.)Tj 8 0 0 8 340 603 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 590 32 11 re f 13 601 m 45 601 l S 13 601 m 13 590 l S 45 590 133 11 re f 45 601 m 178 601 l S 45 601 m 45 590 l S 178 590 114 11 re f 178 601 m 292 601 l S 178 601 m 178 590 l S 292 590 99 11 re f 292 601 m 391 601 l S 292 601 m 292 590 l S 391 601 m 391 590 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 592 Tm (04)Tj 8 0 0 8 110 592 Tm (0)Tj 8 0 0 8 233 592 Tm (.)Tj 8 0 0 8 340 592 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 579 32 11 re f 13 590 m 45 590 l S 13 590 m 13 579 l S 45 579 133 11 re f 45 590 m 178 590 l S 45 590 m 45 579 l S 178 579 114 11 re f 178 590 m 292 590 l S 178 590 m 178 579 l S 292 579 99 11 re f 292 590 m 391 590 l S 292 590 m 292 579 l S 391 590 m 391 579 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 581 Tm (05)Tj 8 0 0 8 110 581 Tm (0)Tj 8 0 0 8 233 581 Tm (.)Tj 8 0 0 8 340 581 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 568 32 11 re f 13 579 m 45 579 l S 13 579 m 13 568 l S 45 568 133 11 re f 45 579 m 178 579 l S 45 579 m 45 568 l S 178 568 114 11 re f 178 579 m 292 579 l S 178 579 m 178 568 l S 292 568 99 11 re f 292 579 m 391 579 l S 292 579 m 292 568 l S 391 579 m 391 568 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 570 Tm (06)Tj 8 0 0 8 110 570 Tm (0)Tj 8 0 0 8 233 570 Tm (.)Tj 8 0 0 8 340 570 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 557 32 11 re f 13 568 m 45 568 l S 13 568 m 13 557 l S 45 557 133 11 re f 45 568 m 178 568 l S 45 568 m 45 557 l S 178 557 114 11 re f 178 568 m 292 568 l S 178 568 m 178 557 l S 292 557 99 11 re f 292 568 m 391 568 l S 292 568 m 292 557 l S 391 568 m 391 557 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 559 Tm (07)Tj 8 0 0 8 110 559 Tm (0)Tj 8 0 0 8 233 559 Tm (.)Tj 8 0 0 8 340 559 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 546 32 11 re f 13 557 m 45 557 l S 13 557 m 13 546 l S 45 546 133 11 re f 45 557 m 178 557 l S 45 557 m 45 546 l S 178 546 114 11 re f 178 557 m 292 557 l S 178 557 m 178 546 l S 292 546 99 11 re f 292 557 m 391 557 l S 292 557 m 292 546 l S 391 557 m 391 546 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 548 Tm (08)Tj 8 0 0 8 110 548 Tm (0)Tj 8 0 0 8 233 548 Tm (.)Tj 8 0 0 8 340 548 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 535 32 11 re f 13 546 m 45 546 l S 13 546 m 13 535 l S 45 535 133 11 re f 45 546 m 178 546 l S 45 546 m 45 535 l S 178 535 114 11 re f 178 546 m 292 546 l S 178 546 m 178 535 l S 292 535 99 11 re f 292 546 m 391 546 l S 292 546 m 292 535 l S 391 546 m 391 535 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 537 Tm (09)Tj 8 0 0 8 110 537 Tm (0)Tj 8 0 0 8 233 537 Tm (.)Tj 8 0 0 8 340 537 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 524 32 11 re f 13 535 m 45 535 l S 13 535 m 13 524 l S 45 524 133 11 re f 45 535 m 178 535 l S 45 535 m 45 524 l S 178 524 114 11 re f 178 535 m 292 535 l S 178 535 m 178 524 l S 292 524 99 11 re f 292 535 m 391 535 l S 292 535 m 292 524 l S 391 535 m 391 524 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 526 Tm (10)Tj 8 0 0 8 110 526 Tm (0)Tj 8 0 0 8 233 526 Tm (.)Tj 8 0 0 8 340 526 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 513 32 11 re f 13 524 m 45 524 l S 13 524 m 13 513 l S 45 513 133 11 re f 45 524 m 178 524 l S 45 524 m 45 513 l S 178 513 114 11 re f 178 524 m 292 524 l S 178 524 m 178 513 l S 292 513 99 11 re f 292 524 m 391 524 l S 292 524 m 292 513 l S 391 524 m 391 513 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 515 Tm (11)Tj 8 0 0 8 110 515 Tm (0)Tj 8 0 0 8 233 515 Tm (.)Tj 8 0 0 8 340 515 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 502 32 11 re f 13 513 m 45 513 l S 13 513 m 13 502 l S 45 502 133 11 re f 45 513 m 178 513 l S 45 513 m 45 502 l S 178 502 114 11 re f 178 513 m 292 513 l S 178 513 m 178 502 l S 292 502 99 11 re f 292 513 m 391 513 l S 292 513 m 292 502 l S 391 513 m 391 502 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 504 Tm (12)Tj 8 0 0 8 110 504 Tm (0)Tj 8 0 0 8 233 504 Tm (.)Tj 8 0 0 8 340 504 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 491 32 11 re f 13 502 m 45 502 l S 13 502 m 13 491 l S 45 491 133 11 re f 45 502 m 178 502 l S 45 502 m 45 491 l S 178 491 114 11 re f 178 502 m 292 502 l S 178 502 m 178 491 l S 292 491 99 11 re f 292 502 m 391 502 l S 292 502 m 292 491 l S 391 502 m 391 491 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 493 Tm (13)Tj 8 0 0 8 110 493 Tm (0)Tj 8 0 0 8 233 493 Tm (.)Tj 8 0 0 8 340 493 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 480 32 11 re f 13 491 m 45 491 l S 13 491 m 13 480 l S 45 480 133 11 re f 45 491 m 178 491 l S 45 491 m 45 480 l S 178 480 114 11 re f 178 491 m 292 491 l S 178 491 m 178 480 l S 292 480 99 11 re f 292 491 m 391 491 l S 292 491 m 292 480 l S 391 491 m 391 480 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 482 Tm (14)Tj 8 0 0 8 110 482 Tm (0)Tj 8 0 0 8 233 482 Tm (.)Tj 8 0 0 8 340 482 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 469 32 11 re f 13 480 m 45 480 l S 13 480 m 13 469 l S 45 469 133 11 re f 45 480 m 178 480 l S 45 480 m 45 469 l S 178 469 114 11 re f 178 480 m 292 480 l S 178 480 m 178 469 l S 292 469 99 11 re f 292 480 m 391 480 l S 292 480 m 292 469 l S 391 480 m 391 469 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 471 Tm (15)Tj 8 0 0 8 110 471 Tm (0)Tj 8 0 0 8 233 471 Tm (.)Tj 8 0 0 8 340 471 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 458 32 11 re f 13 469 m 45 469 l S 13 469 m 13 458 l S 45 458 133 11 re f 45 469 m 178 469 l S 45 469 m 45 458 l S 178 458 114 11 re f 178 469 m 292 469 l S 178 469 m 178 458 l S 292 458 99 11 re f 292 469 m 391 469 l S 292 469 m 292 458 l S 391 469 m 391 458 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 460 Tm (16)Tj 8 0 0 8 110 460 Tm (0)Tj 8 0 0 8 233 460 Tm (.)Tj 8 0 0 8 340 460 Tm (0)Tj ET 1.00 1.00 1.00 rg 13 447 32 11 re f 13 458 m 45 458 l S 13 458 m 13 447 l S 45 447 133 11 re f 45 458 m 178 458 l S 45 458 m 45 447 l S 178 447 114 11 re f 178 458 m 292 458 l S 178 458 m 178 447 l S 292 447 99 11 re f 292 458 m 391 458 l S 292 458 m 292 447 l S 391 458 m 391 447 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 449 Tm (17)Tj 8 0 0 8 107 449 Tm (35)Tj 8 0 0 8 231 449 Tm (42)Tj 8 0 0 8 340 449 Tm (7)Tj ET 0.95 0.93 0.94 rg 13 436 32 11 re f 13 447 m 45 447 l S 13 447 m 13 436 l S 45 436 133 11 re f 45 447 m 178 447 l S 45 447 m 45 436 l S 178 436 114 11 re f 178 447 m 292 447 l S 178 447 m 178 436 l S 292 436 99 11 re f 292 447 m 391 447 l S 292 447 m 292 436 l S 391 447 m 391 436 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 438 Tm (18)Tj 8 0 0 8 110 438 Tm (2)Tj 8 0 0 8 231 438 Tm (44)Tj 8 0 0 8 337 438 Tm (42)Tj ET 1.00 1.00 1.00 rg 13 425 32 11 re f 13 436 m 45 436 l S 13 436 m 13 425 l S 45 425 133 11 re f 45 436 m 178 436 l S 45 436 m 45 425 l S 178 425 114 11 re f 178 436 m 292 436 l S 178 436 m 178 425 l S 292 425 99 11 re f 292 436 m 391 436 l S 292 436 m 292 425 l S 391 436 m 391 425 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 427 Tm (19)Tj 8 0 0 8 110 427 Tm (0)Tj 8 0 0 8 233 427 Tm (.)Tj 8 0 0 8 340 427 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 414 32 11 re f 13 425 m 45 425 l S 13 425 m 13 414 l S 45 414 133 11 re f 45 425 m 178 425 l S 45 425 m 45 414 l S 178 414 114 11 re f 178 425 m 292 425 l S 178 425 m 178 414 l S 292 414 99 11 re f 292 425 m 391 425 l S 292 425 m 292 414 l S 391 425 m 391 414 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 416 Tm (20)Tj 8 0 0 8 107 416 Tm (26)Tj 8 0 0 8 231 416 Tm (71)Tj 8 0 0 8 337 416 Tm (45)Tj ET 1.00 1.00 1.00 rg 13 403 32 11 re f 13 414 m 45 414 l S 13 414 m 13 403 l S 45 403 133 11 re f 45 414 m 178 414 l S 45 414 m 45 403 l S 178 403 114 11 re f 178 414 m 292 414 l S 178 414 m 178 403 l S 292 403 99 11 re f 292 414 m 391 414 l S 292 414 m 292 403 l S 391 414 m 391 403 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 405 Tm (21)Tj 8 0 0 8 110 405 Tm (1)Tj 8 0 0 8 231 405 Tm (72)Tj 8 0 0 8 337 405 Tm (71)Tj ET 0.95 0.93 0.94 rg 13 392 32 11 re f 13 403 m 45 403 l S 13 403 m 13 392 l S 45 392 133 11 re f 45 403 m 178 403 l S 45 403 m 45 392 l S 178 392 114 11 re f 178 403 m 292 403 l S 178 403 m 178 392 l S 292 392 99 11 re f 292 403 m 391 403 l S 292 403 m 292 392 l S 391 403 m 391 392 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 394 Tm (22)Tj 8 0 0 8 107 394 Tm (16)Tj 8 0 0 8 231 394 Tm (88)Tj 8 0 0 8 337 394 Tm (72)Tj ET 1.00 1.00 1.00 rg 13 381 32 11 re f 13 392 m 45 392 l S 13 392 m 13 381 l S 45 381 133 11 re f 45 392 m 178 392 l S 45 392 m 45 381 l S 178 381 114 11 re f 178 392 m 292 392 l S 178 392 m 178 381 l S 292 381 99 11 re f 292 392 m 391 392 l S 292 392 m 292 381 l S 391 392 m 391 381 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 383 Tm (23)Tj 8 0 0 8 105 383 Tm (301)Tj 8 0 0 8 228 383 Tm (392)Tj 8 0 0 8 337 383 Tm (91)Tj ET 0.95 0.93 0.94 rg 13 370 32 11 re f 13 381 m 45 381 l S 13 381 m 13 370 l S 45 370 133 11 re f 45 381 m 178 381 l S 45 381 m 45 370 l S 178 370 114 11 re f 178 381 m 292 381 l S 178 381 m 178 370 l S 292 370 99 11 re f 292 381 m 391 381 l S 292 381 m 292 370 l S 391 381 m 391 370 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 372 Tm (24)Tj 8 0 0 8 107 372 Tm (29)Tj 8 0 0 8 228 372 Tm (421)Tj 8 0 0 8 335 372 Tm (392)Tj ET 1.00 1.00 1.00 rg 13 359 32 11 re f 13 370 m 45 370 l S 13 370 m 13 359 l S 45 359 133 11 re f 45 370 m 178 370 l S 45 370 m 45 359 l S 178 359 114 11 re f 178 370 m 292 370 l S 178 370 m 178 359 l S 292 359 99 11 re f 292 370 m 391 370 l S 292 370 m 292 359 l S 391 370 m 391 359 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 361 Tm (25)Tj 8 0 0 8 110 361 Tm (7)Tj 8 0 0 8 228 361 Tm (428)Tj 8 0 0 8 335 361 Tm (421)Tj ET 0.95 0.93 0.94 rg 13 348 32 11 re f 13 359 m 45 359 l S 13 359 m 13 348 l S 45 348 133 11 re f 45 359 m 178 359 l S 45 359 m 45 348 l S 178 348 114 11 re f 178 359 m 292 359 l S 178 359 m 178 348 l S 292 348 99 11 re f 292 359 m 391 359 l S 292 359 m 292 348 l S 391 359 m 391 348 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 350 Tm (26)Tj 8 0 0 8 107 350 Tm (18)Tj 8 0 0 8 228 350 Tm (446)Tj 8 0 0 8 335 350 Tm (428)Tj ET 1.00 1.00 1.00 rg 13 337 32 11 re f 13 348 m 45 348 l S 13 348 m 13 337 l S 45 337 133 11 re f 45 348 m 178 348 l S 45 348 m 45 337 l S 178 337 114 11 re f 178 348 m 292 348 l S 178 348 m 178 337 l S 292 337 99 11 re f 292 348 m 391 348 l S 292 348 m 292 337 l S 391 348 m 391 337 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 339 Tm (27)Tj 8 0 0 8 107 339 Tm (14)Tj 8 0 0 8 228 339 Tm (460)Tj 8 0 0 8 335 339 Tm (446)Tj ET 0.95 0.93 0.94 rg 13 326 32 11 re f 13 337 m 45 337 l S 13 337 m 13 326 l S 45 326 133 11 re f 45 337 m 178 337 l S 45 337 m 45 326 l S 178 326 114 11 re f 178 337 m 292 337 l S 178 337 m 178 326 l S 292 326 99 11 re f 292 337 m 391 337 l S 292 337 m 292 326 l S 391 337 m 391 326 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 328 Tm (28)Tj 8 0 0 8 110 328 Tm (4)Tj 8 0 0 8 228 328 Tm (465)Tj 8 0 0 8 335 328 Tm (461)Tj ET 1.00 1.00 1.00 rg 13 315 32 11 re f 13 326 m 45 326 l S 13 326 m 13 315 l S 45 315 133 11 re f 45 326 m 178 326 l S 45 326 m 45 315 l S 178 315 114 11 re f 178 326 m 292 326 l S 178 326 m 178 315 l S 292 315 99 11 re f 292 326 m 391 326 l S 292 326 m 292 315 l S 391 326 m 391 315 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 317 Tm (29)Tj 8 0 0 8 110 317 Tm (0)Tj 8 0 0 8 233 317 Tm (.)Tj 8 0 0 8 340 317 Tm (0)Tj ET 0.95 0.93 0.94 rg 13 304 32 11 re f 13 315 m 45 315 l S 13 315 m 13 304 l S 45 304 133 11 re f 45 315 m 178 315 l S 45 315 m 45 304 l S 178 304 114 11 re f 178 315 m 292 315 l S 178 315 m 178 304 l S 292 304 99 11 re f 292 315 m 391 315 l S 292 315 m 292 304 l S 391 315 m 391 304 l S BT 0.00 0.00 0.00 rg 8 0 0 8 25 306 Tm (30)Tj 8 0 0 8 110 306 Tm (0)Tj 8 0 0 8 233 306 Tm (.)Tj 8 0 0 8 340 306 Tm (0)Tj ET 13 304 m 45 304 l S 45 304 m 178 304 l S 178 304 m 292 304 l S 292 304 m 391 304 l S BT 8 0 0 8 13 239 Tm (Private & Confidential)Tj /F2 1 Tf 7 0 0 7 13 226 Tm (Report Generated On )Tj 7 0 0 7 97 226 Tm (19 August, 2010 )Tj ET endstream endobj 7 0 obj 13984 endobj 8 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents 6 0 R >> endobj 9 0 obj << /Type /XObject /Subtype /Image /Name /Im1 /Width 245 /Height 55 /BitsPerComponent 8 /ColorSpace /DeviceRGB /Filter [/ASCII85Decode /FlateDecode] /Length 6470 >> stream Gb"/l?\iXP,;#n(/U6"eC#i_B.mDHHBWVE6#,=?r">?%+dWF1n0b%t$ (LfpKllT]e9$r=+2,l,YQj7!J#8-f/#`PBs5/6!!f%oM5cMV;:pUbKfH[[LUB?o1Wm?-\jM3X^LIOPF7@6^M.DGJRm[Bi>/+ KC)2.lFZ43cV--3Q9_kISh9>tDE\-PZg+.H-75tqcJSZVc1:e;G=XM\\^d0NG&G2\qKEt$g9,/J@>n3/_oa&G!C6%1Tl4dc_&J**%Y096]`kqstA7)(-ahQ[#mVHh7CNUQY4X@PgLQ#0,*VFao_ [?@H4PQYUW3rL3K7[OM#%QOs4]h0eTSlN4H[:rML.l4%dP;aBNWo6d\&"-5BkqqAq,_)IKTp?kYWk-4` 39r]7ZrG4QhYsLnr:JDnG$slfO0o&Qg> U;+JN$+Y4^p($#2[%T.$rSQS"5J;gkl$r,R:KE.l)7CZL\&m_@Cn':`Zq8(+A"W\-8F$uYh?!1H5(<9\ LL6tmneRs3W#pm$_d)*'Hhj5Iog7O3q>1\.Ke8bk=$HHir_0$4T7$W"<"AJ@eP7bOWKn"kjtW!*g(=puq+'j*Yf.LOQg4Scf(?fMkts7q^N$8.J\?&=NuBa B)aT^bmts6(<,.Hqu>S)b*F+k%fUtC(S7?o2Qun>kJBnu6&2Q[;(TjZf<>>BO2UO`6>/cfC],/B\_A6H Md8'7\p;S*bRu$Ti@rb:3J@ILQ#2tIlGi7`\>L?q9@^#[P*ZMgkbOM\>VL-LG7^$r\5g6>9(ccUG)5Md ,J(Bt"S!4`i='"L[/PRb))F@,"!)-4+...!QdTVJ %oE\0W@j!r#%j[Dlf.NK;?MRC#+rQ9_Wds-[QCpGD=D[BM92nYBY)s'5<]F_gG?U\,]tuH\nUeNeK)EI .1gAid=n\]?q_$aSM_Ii=R-FW!&2ro)8R%qjqTq@HdPA>`qR7f-CBU`Nb4!7=l?9](jMNuTt:-sPcEAr i/#\onAC6/LBE^gXJ1`a)+T8fd)&.891hg[#j7e^6*A2VGjg/naj/Y0\9:>V#4W8"-;\N73ij>)lqqZP htITrEo)(%'j`2+4K<]&9_?G9[^^O3$oL[0U@YDX3eYpQ7Yt:t(!N+BF_GZ/a=XCZ1!o1oRsXG3haj8A;jMSSdG^7l;(D:[;F&27";tFudJ0gJ;,:j-tcISKM=*X>Tf&SjHKN$KXPkfG[pcqV@neg=nj:@'AFE]SI9F#"WlQi6SN@CKeV+D%m\Vc=8q9_mQhJAA?,Ufa1nVuFh/i3\^:\6(b8VZHI$i! _-Oqnc4haiaN2S&&<^.MBmS3([,>1k6,b3moH==D$n%5--Ojfqo]ietAof\ZTrPd$6Bal:1Y%n:4rthXI4;4"G"rP@+n%)M\VFY+33`'D!][DQAHn]_AZ6`]@5qm_(qV T%C9L3X`7RN4n%,YaJaHj<5E62s(<9A0UYnDe84P3e#RYuERbYra=^!/s9TL1nBV(A]T9Y!U98l[uQ).BM@(FKO"U;X'/Ugeli N?s$1IT0J2U@]9_I(6"+D#<'Ge,ZgR(k*+Tk?7eX%d81"pht01>J7qborLdN<5RDQ"JTnS.&3 Zs`)(d;m<%gtuS`]Y![A2/`Z#oi'i:A>*upAs#OVI^?Q5aMtXX\iZI<*,TItI72gD]\PG7>>1Ct@i?3] ,S8KPP3%$;Sd\(%CRsbj$-OT80pgs7CI#rM.TGRq5g=oUmQFY2imrR/K4AT9Z/-hVYm+"eO8>doCRMmM mA/Xl/uCY&'4)DZ&YX3HM]b>CO*\O>pR0#3V,t]lW0?G'c//h;3CA#M[:"^icAL75j>I*mo.bjqi=7)S+ >HHZL/cluTG7dTS*Qt6.n7*9cVeljJdqu.s(AniZL0'g#@lg,7RLp"*@2Kr9/E7WuQ`/qY9qFEtGrEtikVuR6-Lpt3`7JhtC:7esY]dJ0u >o&*$1,M'=;B5@.o>Y!:5742t.'tN-o.7a2a^>]EO>91&TW@A?jjd2(OGrf=OKVCkoeV`K_.$'i5!o$a ;6LXs6tg8L$[t9_bj84,O"'Q:p@#;*]t'uXaX?12CUd+YX_51=j@\ce*BI-M==6]L7TR):@P=]p9eEV! ](6h)9RrAs^T_jGWod<"2]]-]+4mu&*4c40)$H3R:VN.uMfA<(Ml9o75mXlS`7$WPd7CbnE`RE_G`-!h nD@NGW!TDK[ mZe-,rT24jXs^2_SK@(UE'=0PBFr3b/\N)@j8dUSaRs9$J-#\oQ\T1p=n_=.ZmAoBS(PE5*n/Su*a<:B VhWg8ZFrNS1D8Dgr!4/@XIj@.k[ph(t9]Hf>l5COqQSds5?b$b@:RA r_B;A.o,qH@./jN#i739#faGjR3AtPaPQ[=*( J2>>a%BFio)L%okAGZmCm?Zo3S)uNoXkDsOZWo[RG%fM4D*rjnB9MjmB%e]d!"Tl1r`+K"@0!;j&&b`e DOmi=>g7I;Yb<]V9f*:&4`ST,Y-]sq]5GqLpXSGRQKMja:"G.0U?J?>Q^]pX8uG#t6Wmdurh\ATJDL<;Gpnf\2O"+uXM /,SpBg_Gu+&s*"57)1Jk%m%dd$_Fk"G3?I6&cj/m"3=EfR.``:BdYhuAJPSa`3p47n0ucFfk+QuV/`ME k*eish4q:`A')O,1SYj/rhfYp0a#DNXCj4e]ucn$G\&D(Tg="G6+Hc`";p)Q\(nRl,J/*R("`pgf8$a/ 4j\G%](Ne(`cc#65]uKs]$Vp\.'9!k6>j:,hAoo_ro,>RI?4qS+3>;igFfDDsb&L3H#<\:Ge(-8WBJ 4!9i2*9-*664C[>@Nm?/e>u&T,J51kA]iBaDFa@iq_CPGg>eaYhC[DpZpPt39kdk G7V2+!F6q>Us*9Jr#uFEg0+%?Uh3-43jc4U6)&@gbU3'VEgQ<8kO/V)h-Qo6,fgJZ*$kWohff$44U&26 HnB@nZRV5h_@]]2UB@!"o^X_Q9`[Q=/3PI'= :.SjuGliq;>3`Bn>'g*)8G!pTmYnbnhYPBAXeTrUJs0(H\-KFdn=H;GFDME*#o\[;D2^(*-CX;$)"rZg <>a&Wa@9$Cl(`=d2b2.A;9QbBDVK"A?9WH-MqK?D@>P2(Gr3?,DZHc&A.u/Hs ou7!6iPPEqafVGC8><%K3.GOs#H.`OO%hfb=^_+I%tEWpRqAP(;o1Ff)GmPJp2"SA'\Vd&h7^gc%">+GBl)8@/KH_E/nE(&Z9[V4l&#IC>J-\!h\`>,?;4f%paY[guXr< VG.YIDAHkLrTs:IGjss=(Mot:c9bnU,`bA:4SluH(]W\@c<\MZAi_AtgBQ"(&!&254TGH^~> endstream endobj 4 0 obj << /ProcSet [/PDF /Text /ImageC] /Font << /F1 10 0 R /F2 11 0 R /F3 12 0 R >> /XObject << /Im1 9 0 R >> /ExtGState << /GS1 2 0 R >> >> endobj 5 0 obj << /Types /Pages /Kids [8 0 R ] /Count 1 /MediaBox [0 0 612 792] >> endobj 10 0 obj << /Type /Font /Subtype /Type1 /Encoding /WinAnsiEncoding /Name /F1 /BaseFont /Courier >> endobj 11 0 obj << /Type /Font /Subtype /Type1 /Encoding /WinAnsiEncoding /Name /F2 /BaseFont /Courier >> endobj 12 0 obj << /Type /Font /Subtype /Type1 /Encoding /WinAnsiEncoding /Name /F3 /BaseFont /Courier-Bold >> endobj 3 0 obj << /Type /Halftone /HalftoneType 1 /HalftoneName (Default) /Frequency 60 /Angle 45 /SpotFunction /Round >> endobj 2 0 obj << /Type /ExtGState /SA false /OP false /HT /Default >> endobj 1 0 obj << /Type /Catalog /Pages 5 0 R >> endobj xref 0 13 0000000000 65535 f 0000021666 00000 n 0000021587 00000 n 0000021455 00000 n 0000020845 00000 n 0000021011 00000 n 0000000010 00000 n 0000014053 00000 n 0000014077 00000 n 0000014158 00000 n 0000021105 00000 n 0000021220 00000 n 0000021335 00000 n trailer << /Size 13 /Root 1 0 R >> startxref 21721 %%EOF 



My code snippet as below :

  
-INCLUDE gen_def_env_vars
-SET &IMGURL = IF &WFFMT EQ 'HTML' THEN &HTMLIMGURL ELSE &PDFIMGURL
SET EMPTYREPORT = ON

FILEDEF DATEMAS DISK DATERNG.MAS
-RUN
-WRITE DATEMAS FILE=DATERNG,SUFFIX=XFOC
-WRITE DATEMAS SEGNAME=SEG1
-WRITE DATEMAS FIELD=DATE_KEY, ,YYMD ,YYMD , $
-RUN
-* Now create it
CREATE FILE DATERNG
-* and add all possible dates within a month
MODIFY FILE DATERNG
FREEFORM DATE_KEY.A8.
LOG FORMAT MSG OFF
LOG TRANS MSG OFF
LOG INVALID MSG OFF
DATA
-* This repeat loop will ensure at least a whole year is input,
-* Any invalid dates will be rejected.
-SET &Year  = &year;
-SET &Month = &month;
-SET &MTHDESC = DECODE &Month(01 'JANUARY' 02 'FEBRUARY' 03 'MARCH' 04 'APRIL' 05 'MAY' 06 'JUNE' 07 'JULY' 08 'AUGUST' 09 'SEPTEMBER' 10 'OCTOBER' 11 'NOVEMBER' 12 'DECEMBER');
-SET &Day   = 1;
-REPEAT :Loop1 31 TIMES;
-SET &Date = IF &Day LT 10 THEN '0' || &Day ELSE &Day;
&Year&Month&Date
-SET &Day = &Day + 1;
-:Loop1
END
-RUN

TABLE FILE DATERNG
PRINT DATE_KEY
ON TABLE HOLD AS DATERANGE
END
-RUN

TABLE FILE DATERANGE
PRINT
* NOPRINT
END
-RUN

-*Card Application File
DEFINE FILE APPL
UPDTCENTURY/I7 = IF ARGLEN(7,EDIT(ANUPDT),UPDTCENTURY) = 6 THEN 0 ELSE IF SUBSTR(7, EDIT(ANUPDT), 0, 1, 1, 'A1') = '1' THEN 1 ELSE 0;
UPDT8/I8 =  IF UPDTCENTURY = 0 THEN 19000000 + ANUPDT ELSE IF UPDTCENTURY = 1 THEN 20000000 + ANUPDT;
UPDT/YYMD = DATECVT(UPDT8, 'I8YYMD', 'I8YYMD');
DATE3/A8YYMD = UPDT;
DD3/A2 = EDIT(DATE3,'$$$$$$99');
MM3/A2 = EDIT(DATE3,'$$$$99$$');
YY3/A4 = EDIT(DATE3,'9999$$$$');
END

TABLE FILE APPL
PRINT
*
UPDT
BY UPDT
BY ANLOPN
ON TABLE HOLD AS HOLD1
END

-*Join Date Range with Card Application File
JOIN LEFT_OUTER DATE_KEY IN DATERANGE
  TO MULTIPLE UPDT IN HOLD1 AS J0
END


DEFINE FILE DATERANGE
-*MONTH/A2='&month';
-*YEAR/A4 = '&year';
-*MTHDESC/A15=DECODE MONTH(01 'JANUARY' 02 'FEBRUARY' 03 'MARCH' 04 'APRIL' 05 'MAY' 06 'JUNE' 07 'JULY' 08 'AUGUST' 09 'SEPTEMBER' 10 'OCTOBER' 11 'NOVEMBER' 12 'DECEMBER');
END

-* Generate Report
TABLE FILE DATERANGE
SUM
     COMPUTE DAYS/A2 = EDIT(DATECVT(DATE_KEY, 'YYMD', 'A8YYMD'), '$$$$$$99');
 AS 'Day'
     'CNT.HOLD1.HOLD1.ANLOPN' AS 'Total No. of Application'
     'LST.HOLD1.HOLD1.ANLOPN' AS 'Last Application No.'
     COMPUTE TOT/I11 = ( LST.ANLOPN - CNT.ANLOPN ); AS 'Total Application'
BY 'DATERANGE.DATERANG.DATE_KEY' NOPRINT
ON TABLE SUBHEAD
" "
" "
HEADING
"DAILY CARD STATISTICS FOR THE MONTH OF <+0>&MTHDESC <+0>&year  "
" "
"APPLICATION COUNT (AA No.)"
" "
FOOTING
" "
" "
" "
"Private & Confidential"
"Report Generated On <+0>&DATEtrDMYY<+0> <+0>   "
ON TABLE SET PAGE-NUM ON
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET HTMLCSS ON



Thank you in advance.

This message has been edited. Last edited by: Kevin Tong,


WebFOCUS 7.6.9
Windows 2003, all output
 
Posts: 32 | Location: Malaysia | Registered: December 29, 2009Report This Post
Expert
posted Hide Post
I think that this is a MIME issue.

The file type returned is not flagged as a PDF or Excel document.


All PDF documents begin with %PDF

The Excel document produced with FORMAT EXL2K are effectively a web page, HTML, with some other stuff wrapped around it.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Silver Member
posted Hide Post
But my other reports able to prompt up to open the PDF/Excel Files but not this one.

Any idea what went wrong or any setting that I need to set in order to make it work?

Thanks.


WebFOCUS 7.6.9
Windows 2003, all output
 
Posts: 32 | Location: Malaysia | Registered: December 29, 2009Report This Post
Expert
posted Hide Post
quote:
TABLE FILE DATERANGE
PRINT
* NOPRINT
END
-RUN
Debug processing left in?

T

p.s. Nice to see that my DATERNG sample code is being put to good use Smiler



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, 2004Report This Post
Silver Member
posted Hide Post
Oh Gosh!...How could I overlooked that. Thanks a million Tony...owed you one.

Luckily I found the DATENRG sample.

Thanks guys, problem solved.


WebFOCUS 7.6.9
Windows 2003, all output
 
Posts: 32 | Location: Malaysia | Registered: December 29, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Unable to Output Report in PDF/EXL2K

Copyright © 1996-2020 Information Builders