Hi All:
I am importing a file into my Cognos report using the Manage External Data option. The file is a fixed width delimited, so it all appears on 1 column (probably not the best use case for Cognos, but I am hoping this option works for ease of use for my user).
Anyway, I got all the data importing into the proper fields using substring and trim, but I am running into 2 problems:
- Is there a way to import every line of a text file into the report, or will the top line always be a "header" that doesn't import? So, I have 81 lines; it is importing 80 lines but I want all 81. I cannot change system settings if it would relate to that.
- This is the main problem I am having; there a couple numbers in the report that I extract and cast to integers and divide by 100 (to get them to the proper decimal format). I can add and multiply with them, but anytime I try rounding them, I get the below error. If I do "round(integer)" then it works, but if I do "round(integer, 1)" then it breaks. Any help as to why? None of the fields are blank or anything, so I cannot figure it out.
Thank you