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,

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.

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.

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

Oh Gosh!...How could I overlooked that. Thanks a million Tony...owed you one.

Luckily I found the DATENRG sample.

Thanks guys, problem solved.