i have several reports that im pulling form my database.
these reports i would like to customise to add more detail
stored in the database is information that i would like to have at the head of the report.
For example
Customer name
customer address
project
project owner
date report ran
product | description | quantity | price | discount | net price |Total price | Supplier price |
I would only like this information displayed on the report and i would only like this information displayed on one page per unique_id that relates to the project. so to group by the project unique id.
I have tried to group the report by
Customer name
customer address
project
project owner
but it doesnt run correctly with more than project unique id and project owner.