MVSFORUMS.com

[jmateo]

Hi,

I am writing a report with 2 different input files where the relationship is many-to-one (transaction vs. master). I wanted to make a report from both files where the fields from the master will be printed once only while the transaction fields always should be printed.

My fields from the master file are quantitative with 2 decimal places which cannot be used in CONTROL statement.

Hoping for an Easytrieve solution.

Regards,
Joseph

[kolusu]

jmateo,

A sample input and desired output will be helpful.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[jmateo]

As requested.

[jmateo]

Hi Kolusu,

Just wondering if you got a solution to the 'suppress quantitative fields' problem.

Thanks in advance,
Joseph

[kolusu]

[kolusu]

I am lost here. I am not sure as to what you want here. If you don't want the decimals in your amount fields you can just move the input fields to a working storage variable defined without decimal places and use that in your report

for ex:

[nsoudi]

Kolsu,

As per my understanding, Joseph wants to see the decimal points on the report, but problem is EasyTrieve does not allow him to use that field (with decimal point) in CONTROL statement.

[jmateo]

Hi Kolusu,

Yes, NSOUDI is right, I cannot use the quatitative fields in CONTROL statement. I tried using the WS field without the decimal point in the CONTROL statement and at the same time use the real fields in my PRINT statement but does not work. For the meantime, I created an extracted file out of both transaction and master files using Eastrieve then generate the report using both PRINT statement for Master file fields and DISPLAY for transaction fields.

I am just wondering if there is a quick Easytrieve solution that I dont know yet.

Thanks a lot Kolusu for spending time on this.