the problem when extracting a report

[zmau_razvan]

hello i have a problem how to make a report of invoices per year and at reports invoices i will not select my company name as it is in the database there are also companies, I am attaching some pictures to be more explicit thank you

[zmau_razvan]

I have a suggestion in the invoices.php file to insert "tblclients.companyname"
meaning
"concat(tblclients.firstname, ' ', tblclients.lastname) "
instead of
"concat(tblclients.firstname, ' ', tblclients.lastname, ' ',tblclients.companyname) "
and
$query->addSelect(Capsule::raw("concat(tblclients.firstname, ' ', tblclients.lastname)"));
instead of
$query->addSelect(Capsule::raw("concat(tblclients.firstname, ' ', tblclients.lastname, ' ',tblclients.companyname)"));

and in the report of invoices to appear my company name but also the clients' names
because we also have a company name on the page