Enquiry report

  • TheTitan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 5 months ago #18221 by TheTitan
Enquiry report was created by TheTitan
Hi Guys

I have a requirement to create enquiry reports and then copy them to a folder. The reports copied from &HOLD& should be in the .csv/.xls format.

1. How to generate the file in .csv format? - I provided value 5 in the field OUTPUT.FILE.TYPE in the REPORT.CONTROL record, but still it is not generating in comma format.

XXX XXXX XX-XXX - BNK REPORT CONTROL FILE MAINTENANCE SEE

REPORT.NAME....... XXXXX.DM.REP.CNTR
1. 1. 1 GB DESC..... REPORT.CONTROL FOR ENQUIRY REPORT (MIG)
2. 1 GB SHORT.DESC.. MIGRATION ENQUIRY REPORT.CONTROL
3 FORM.NAME......... M.D.FM
8 MICROFICHE.OUTPUT. N
23 CRYSTAL.REPORT.... NO
27 OUTPUT.FILE.TYPE.. 5 Comma separated values (.txt)
44 CURR.NO........... 5
45. 1 INPUTTER....... 40761_RAM1__OFS_BUILD.CONTROL
46. 1 DATE.TIME...... 01 OCT 15 09:31
47 AUTHORISER........ 40761_RAM1_OFS_BUILD.CONTROL
48 CO.CODE........... NL-001-0001 ABN AMRO BE-DJC - BNK
49 DEPT.CODE......... 1 Implementation


2. How to generate the file in .xls format?
3. While copying the file to the local folder, I need to rename the file. (for ex,. CUSTOMER_POST.csv).

XXX XXXX XX-XXX - BNK PRINTER FILE MAINTENANCE SEE

PRINTER.NAME...... XXXXX.DM.PRINT
1 PRIME.PRINTER.ID.. ENQ REP
2 DESCRIPTION....... Printer for Enquiry Extract
4. 1. 1 COMMAND..... COPY FROM &HOLD& TO /mbted06/bnk/bnk.run/ENQREPORT
4. 1. 2 COMMAND..... .BP &HOLD.CONTROL>@ID&
12 CURR.NO........... 3
13. 1 INPUTTER....... 40761_RAM1__OFS_BUILD.CONTROL
14. 1 DATE.TIME...... 01 OCT 15 09:31
15 AUTHORISER........ 40761_RAM1_OFS_BUILD.CONTROL
16 CO.CODE........... NL-001-0001 ABN AMRO BE-DJC - BNK
17 DEPT.CODE......... 1 Implementation

4. In the report, the headers are getting repeated. What is the attribute to be used to avoid header repetition?

00017
00018 Customer Details
00019
00020 Customer ID, Mnemonic, Short Name,
00021
00022 2001 ,MM1CLIENT ,MM1CLIENT ,
00023 3001 ,RMS1CLIENT,RMS1CLIENT ,
.
.
.
00129
00130
00131 Customer Details
00132
00133 Customer ID, Mnemonic, Short Name,
00134
00135 10000239 ,C10000239 ,Short.name 10000239 ,
00136 10000240 ,C10000240 ,Short.name 10000240 ,
00137 10000241 ,C10000241 ,Short.name 10000241 ,
.
.
.

XXX XXXX XX-XXX - BNK ENQUIRY.REPORT SEE

KEY............... XXXXX.DM.CUST.POST
1. 1 GB DESCRIPTION. Migration Enquiry Report
2. 1 ENQUIRY........ XXXXX.DM.CUSTOMER CUSTOMER
7 REPORT.CONTROL.... XXXXX.DM.REP.CNTR MIGRATION ENQUIRY REPORT.CONTROL
11 OUTPUT.FORMAT..... FILE
28. 1 DATE.TIME...... 30 SEP 15 10:26
29 AUTHORISER........ 30287_N75906.SUP
30 CO.CODE........... NL-001-0001 ABN AMRO BE-DJC - BNK



XXX XXXX XX-XXX - BNK ENQUIRY SEE

ENQUIRY........... XXXXX.DM.CUSTOMER
22.66. 1 GB FIELD.LBL Date Time
23.66 FIELD.DISP.TYPE DATE
35.66 SINGLE.MULTI... M
14.67 FIELD.NAME..... ZERONORECORDS
15.67. 1 OPERATION... "No Customer Details Available"
16.67 COLUMN......... 1
21.67 DISPLAY.BREAK.. NONE
23.67 FIELD.DISP.TYPE CLASS-ENQ.NORECS
24.67 SECTION........ HEADER
36. 1 ENQU QUIT SEE @ID
38. 1 LABEL.FIELD.... @ID 1
39. 1. 1 GB NXT.DESC. View Record

Please Log in or Create an account to join the conversation.

  • TheTitan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 5 months ago #18229 by TheTitan
Replied by TheTitan on topic Enquiry report
Hi

How can the page breakers be removed from the enquiry report?

Please Log in or Create an account to join the conversation.

Time to create page: 0.091 seconds