Results 1 to 2 of 2

Thread: Parameter in ZuckerReport

  1. #1
    fbrites is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Lisbon, Portugal
    Posts
    79

    Default Parameter in ZuckerReport

    Hello

    I am doubt with ZuckerReports 1.8.

    I created one query template called 'Report1' and bind parameter 'Account' (ACCOUNT_ID).

    Report1 Query:
    Code:
    select name 
    from accounts
    Parameter 'Account' Query:
    Code:
    select id, name 
    from accounts 
    where deleted = 0 order by name
    My question is when I run the report. In the selection field of 'Account' parameter, I choose an account (view image http://www.dibconsulting.com/sites/images/reports1.jpg ) but when I run report appears all accounts (view image http://www.dibconsulting.com/sites/images/reports2.jpg)
    The report should not have just the account that I selected in the 'Account' parameter?

    What am I doing wrong?

    Someone can help me?

    Thanks
    Fábio Brites
    <Sugar 6.>
    <Windows XP>

  2. #2
    fbrites is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Lisbon, Portugal
    Posts
    79

    Default Re: Parameter in ZuckerReport

    Ok, I made a mistake.

    I forgot to put the 'where' clause in query template.

    Code:
    select name 
    from accounts
    where id = '$ACCOUNT_ID'
    Thanks
    Fábio Brites
    <Sugar 6.>
    <Windows XP>

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Parameter problems with ZuckerReports 1.8
    By srazvigorov in forum Help
    Replies: 4
    Last Post: 2013-01-01, 03:16 PM
  2. Zuckerreport and Ireport blank Output
    By SVydelingum in forum Help
    Replies: 2
    Last Post: 2007-04-03, 07:26 PM
  3. Sugar Suite "sugarEntry" Parameter Security Bypass
    By mikeshinn in forum General Discussion
    Replies: 4
    Last Post: 2006-05-29, 11:31 PM
  4. Multiple errors
    By amoslmeditabcom693427 in forum Help
    Replies: 0
    Last Post: 2004-11-11, 05:02 PM
  5. Errors when importing
    By amoslmeditabcom693427 in forum Help
    Replies: 0
    Last Post: 2004-11-09, 05:14 PM

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
  •