Jump to content

Services Report to include Product Name, Product Group & Currency


Recommended Posts

Hi all,

I've been trying to figure this out myself but I have failed 😞

Currently, the Sevices report page has a field called 'Product ID' but I need an option to display/filter:

  • Product Name (tblproducts.name field in this case)
  • Product Group it falls under (tblproducts.gid field in this case)
  • Currency based on the client's profile (tblclients.currency field in this case)

I've made a copy of the Services report and tried different things so now I am here. Any help would be appreciated!

Link to comment
Share on other sites

11 hours ago, baymax said:

Any idea?

some. ☺️

it's been on the pending list since you posted... but sadly I only have one pair of hands and 24 hours in the day! 🙁


currency is relatively simple because you can get the currency ID value from tblclients and then it's just a case of looking up the value in tblcurrencies and getting the code (e.g USD, GBP etc).


then for product group, you'll have to decide if you just want the gid value, or if you need to convert it to a product group name.

if you're not used to laravel queries, then using sentq's report from the other thread might be a good starting point for you... and let me know if you get it working as it will save me wasting time looking at it if it's already done. 🙂

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated