Zucker Reports - Account_ID SQL query

[ngoha]

Hi,

Have installed Zucker Rports and is working beautifully. Is it possible to limit the Account selection to show only the users's assigned accounts and not all the accounts in the database? How about for team assignment?

Any help is appreciated.

Thanks,

Harvey

[poseidonfrax]

I also need this..!!
I would like to make a report where you chose from the drop down list a user, than the "account" dropdown list changes and shows only the assigned accounts to the user chosen.
Hope you can help me.
Thanks.
Bye!!

[nvdp2002]

Hi

You need to setup a paramater to bind to your report.

[poseidonfrax]

Hi

I want to make a report where you can see all the tasks that a user has. to do that, i bind the user id and the account id, and that works really fine, it shows me all the tasks for that user and that account id.

the problem is that the accounts list is too long and i would like to show ONLY the accounts that the user has assigned, and when i change the user id from the list, the account list would change too.

hope someone can help me

bye!

[nvdp2002]

all you need to do is use the accounts list template and link the paramater for users to that. that you can sellect the user and show only accounts for each user

[gunni]

When i understand your answer correct something like "accounts.assigned_user_id = '{USER_ID}' " in your query should work.

[poseidonfrax]

Thank you for your responses...
What I understand from your answers is to create a report and show all the assigned accounts, right?
Well, I don't need to show the assigned accounts as a report, but to generate any report, using a user and an account, and when I choose the account from the drop down list, that list must be ONLY the assigned users that choose.
If I change the user parameter, the account parameter drop down list must change.

the ""accounts.assigned_user_id = '{USER_ID}' " is what i need to insert in the query that generates the drop down list.

Thank you.