Results 1 to 7 of 7

Thread: Zucker Reports - Account_ID SQL query

  1. #1
    ngoha is offline Junior Member
    Join Date
    May 2007
    Posts
    1

    Default Zucker Reports - Account_ID SQL query

    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

  2. #2
    poseidonfrax is offline Member
    Join Date
    May 2008
    Posts
    6

    Default Re: Zucker Reports - Account_ID SQL query

    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!!

  3. #3
    nvdp2002 is offline Sugar Community Member
    Join Date
    Mar 2008
    Posts
    134

    Default Re: Zucker Reports - Account_ID SQL query

    Hi

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

  4. #4
    poseidonfrax is offline Member
    Join Date
    May 2008
    Posts
    6

    Default Re: Zucker Reports - Account_ID SQL query

    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!

  5. #5
    nvdp2002 is offline Sugar Community Member
    Join Date
    Mar 2008
    Posts
    134

    Default Re: Zucker Reports - Account_ID SQL query

    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

  6. #6
    gunni is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    Cologne, Germany
    Posts
    364

    Default Re: Zucker Reports - Account_ID SQL query

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

  7. #7
    poseidonfrax is offline Member
    Join Date
    May 2008
    Posts
    6

    Default Re: Zucker Reports - Account_ID SQL query

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 2008-02-22, 04:25 PM
  2. Zucker Reports UTF 8 Character Encoding
    By richardp in forum Japanese
    Replies: 0
    Last Post: 2007-07-27, 07:18 AM
  3. Replies: 0
    Last Post: 2007-02-26, 03:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •