Displaying amount field in query 400.

185 pts.
Tags:
AS/400
Microsoft Excel
Query/400
In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values.

How to display amount fields with decimal fields using query400?

 



Software/Hardware used:
as400
ASKED: February 17, 2012  12:22 PM
UPDATED: February 27, 2012  8:20 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have you checked the cell formats of the excel sheet to make sure it is set to show decimals?

Discuss This Question: 13  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • deepu9321
    Hi JayaShree, I guess, there is no possibility of missing decimal fields while downloading to Excel. Verify the fields you have defined using QRY400. And, You can view the Layout of the report by taking 'F13' in Define Result Fields screen. Pradeep.
    3,605 pointsBadges:
    report
  • philpl1jb
    Execl drops insignificant digits. That is because it imports numeric fields as general number format. No simple export to Excel will do any better. It will also drop leading zeros from dates. ssn and part numbers. You might preceed numbers that must retine the leading zero in a '. Phil
    48,575 pointsBadges:
    report
  • TomLiotta
    If i download report... Are you downloading a report created by Query/400? Or are you downloading an output file generated out of a Query/400 query? If you are downloading a file, how are you running the download? What is the definition of the field in the Query/400 output file? Tom
    125,585 pointsBadges:
    report
  • VJayashree
    Hi, I am downloading a report created by query400. In tables, amount columns are numeric fields having length 15 with 0 decimal positions. In query 400, result fields, if i give decimal position as 4, it is showing report output as 15+4. decimal position is not getting included in total length 15. if i give length 11 and decimal 4, it is showing some replacement character '+' in report. Please clarify how to display amount columns with decimal positios?
    185 pointsBadges:
    report
  • philpl1jb
    So do you want the result column to be width 19 digits 4
    48,575 pointsBadges:
    report
  • VJayashree
    The result should contain only 15 digits including decimal positions
    185 pointsBadges:
    report
  • philpl1jb
    So the report, using 15-4 is ok.? The download isn't. Are the missing digits zero? How do you download your file to excel?
    48,575 pointsBadges:
    report
  • philpl1jb
    Now that I read your statement I'm confused. Are you chaning the width/decimals in Query/400 to 15 4, do you expect this to move the decimal point .. like dividing by 10000?
    48,575 pointsBadges:
    report
  • TomLiotta
    I am downloading a report created by query400. How are you doing the download? If you tell us how, some of our confusion should clear up and we can help better. There are many ways to get output from Query/400 into Excel. Which way are you doing it? Tom
    125,585 pointsBadges:
    report
  • VJayashree
    Am downloading the report using IBM Iseries..
    185 pointsBadges:
    report
  • philpl1jb
    Am downloading the report using IBM Iseries.. Yes, well we kind of suspected that, but what do you do to get the report spool file to Excel? What do you do on the 400? What programs do you use on your pc and how does a report spool file end up in Excel columns.
    48,575 pointsBadges:
    report
  • TomLiotta
    Am downloading the report using IBM Iseries.. How do you do that? What programs do you use? Or what buttons do you click? Or what menu options do you select? Or do you drag and drop the report? Or do you do something else? Tom
    125,585 pointsBadges:
    report
  • VJayashree
    [...] Need help displaying amount fields using query 400? Philpl1jb and TomLiotta provide the [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following