I ma trying to create a report based on a virtual list as explained in FM 13 Advanced training course, paragraph Virtual Lists for Crosstab Reporting. I am having issues, and this drives me nuts .
I have the right values in my virtual table, but they don't show up properly on the report.
This is the content of the virtual table
Everything is as expected. But in the report layout, it's wrong.
Issue 1, I get only one Projet (project) instead of 3.
Issue no 2, some numbers are either multiplied by 100 (3 125.00) or by 10 (395.00). See what happens if I click into one of those fields
Issue no 3: see what I get when I click preview
This time I get all of the Projets, but the Client name is repeated.
I seriously think about quitting drinking water .
But wait, there is more. I move my mouse over the only displayed Projet and roll the mouse wheel, I can get to other Projet. Since some may ask about the script, here it is
Thanks in advance to all of you who can throw some light in my nightmare.