
Announcements
I am trying to build a report using report wizard. My report goal is to show in a screen a user all transactions withingthe selected date with status loading and a common this todays loaded Components and Projects overview. I Explain
There are here 3 entities. Components - that hold all let's say manufactured equiplment and entitie transactions - that hold all operations done with those Components and Projects that is like a Project number where Project has multiple components related to it. WHat i want to do is to be able user to select a date in transactions entity report and he can see what is loaded overall grouped by projects name(Component table has a lookup to project name).
It has to list all project components with their quantities and aside in a column list what is loaded for the selected date. But there is alsp and issue if loading occured on some other date and i select let's say tocay it will not be presented.
I am trying to build report on transactions table and on components table but i fail with my desired output.
How you you guys proceed and maybe can help me with that?