I have three tables I am trying to create a report from.
Two of them use "profile_key" matched with a "user_id" to get the value in "profile_value"

"profile_value" is the data I want to show based on the user_id and the profile_key.

How do I put that in the fields?

Hi @mfisher99,

Please could you further explain your tables?

Do you mean that one of them is the core joomla users table when you refer to:

Two of them use "profile_key" matched with a "user_id"

AND
What is

profile_value

and which table is it from?

Thanks,

Gez

Welcome to the community.

Did you understood how Cook deals with Foreign Tables ?

If you want to create a chart, or a report, the simpliest thing to do is to create a grid list containing (preparing) all the foreign values that you will want to use to compose your report or chart or anything else... (map, pdf, ...)

If you deal with an item, do the same with a 'Fly' brick (read only item page)

OK, on reading this having come across it again when looking for another post, I think I understand better what you are trying to do...

You are referring to getting info from a profile plugin, right?

Please see www.j-cook.pro/forum/12-new-functionalit...er-profile-data#6217

G