darkoGj
15th September 2023, 10:54
Hi all,

I am new to working with Baan and Infor. I have a task to create calculated fields and insert them into report designer.
The report was already done by someone else, I have just to insert new fields and redesign the layout.

I created several calculated fields that I need to fetch the value from tdsls401 and assign it to my fields. I do have fields for: 'desc', 'item', 'number', but only the last value is getting printed in report designer when I Press 'preview'.
Checked with debugger and it seems to be working good since I can see that it is starting from the first line and assigning the value to my field, but as a result I am getting only the last line.
There should be 2 lines printed in the report, but only line 2 is printed.

I tried to do with dataset but when tested with debugger it seems like it is not entering the dataset and the values are empty. Maybe you could also guide me through that as well.

Just started with this few months ago, apologize if the question does not seem understandable.

Thanks in advance

Eddie Monster
15th September 2023, 16:18
Can you provide a screenshot of the calculated field as you defined it in extensiblity along with the code you are using?

darkoGj
15th September 2023, 16:49
Hi,

Thanks for the reply.
I managed to fix. When I printed the original report and disabled report personalizations for user level, found out that the standard layout is getting printed only once, hence only the last data was printed.

So I made a new layout which will print the dataset and inserted all the fields I want to be printed and it worked.

There are some things that I still do not understand how they work, and Infor LN itself.

Eddie Monster
15th September 2023, 16:52
Very good. Glad you were able to figure it out. I'm just getting back into this myself. Baanboard is a good resource!