Results 1 to 10 of 10

Thread: zucker reports - put report in left hand menu for a module

  1. #1
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default zucker reports - put report in left hand menu for a module

    Is it possible to put a zucker report in the left hand menu panel of a module?

    I have written several reports that are related to specific modules and I'd like to put them in the modules menu

    Also is it possible to pass a parameter to a zucker report

    Ideally I would like to put a button on detailview that will call a report and pass it the id of the record
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  2. #2
    DragonflyMaster is offline Sugar Community Member
    Join Date
    Dec 2007
    Location
    Rimini, Italy
    Posts
    1,421

    Default Re: zucker reports - put report in left hand menu for a module

    Quote Originally Posted by mikesolomon
    Is it possible to put a zucker report in the left hand menu panel of a module?

    I have written several reports that are related to specific modules and I'd like to put them in the modules menu

    Also is it possible to pass a parameter to a zucker report

    Ideally I would like to put a button on detailview that will call a report and pass it the id of the record
    Would it be the same with a ZuckerReports subpanel in that module?
    What do you think the cookie monster eats ?

  3. #3
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: zucker reports - put report in left hand menu for a module

    Quote Originally Posted by DragonflyMaster
    Would it be the same with a ZuckerReports subpanel in that module?
    can you have a zucker report subpanel?
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  4. #4
    DragonflyMaster is offline Sugar Community Member
    Join Date
    Dec 2007
    Location
    Rimini, Italy
    Posts
    1,421

    Default Re: zucker reports - put report in left hand menu for a module

    Quote Originally Posted by mikesolomon
    can you have a zucker report subpanel?
    Ok, your question makes me think you hade already tried that...
    I dunno, I'm not very skilled on ZR but I thought a relationship could be set between Zucker and Sugar. Am I wrong?
    What do you think the cookie monster eats ?

  5. #5
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: zucker reports - put report in left hand menu for a module

    I have got part way there

    If I put $module_menu[]=Array("index.php?module=ZuckerReports&action=Repo rtOnDemand&record=d5bb5a7e-6ae3-119f-9bb8-482034d6076b&return_module=zz_jobh&return_action=L istView", 'Job Sheet');

    in Menu.php

    I get the report in the menu

    Now I would like it to open in a new window so i need to have the target=_blank in there somewhere

    I need this because it does not return to the starting point after running a report

    or even better work out how to run a report & pass parameter at the same time
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  6. #6
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: zucker reports - put report in left hand menu for a module

    Quote Originally Posted by DragonflyMaster
    Ok, your question makes me think you hade already tried that...
    I dunno, I'm not very skilled on ZR but I thought a relationship could be set between Zucker and Sugar. Am I wrong?
    nope - i never thought of it - definitely worth me investigating
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  7. #7
    DragonflyMaster is offline Sugar Community Member
    Join Date
    Dec 2007
    Location
    Rimini, Italy
    Posts
    1,421

    Default Re: zucker reports - put report in left hand menu for a module

    Quote Originally Posted by mikesolomon
    nope - i never thought of it - definitely worth me investigating
    Good then, please let me know if you find out something about it.
    What do you think the cookie monster eats ?

  8. #8
    tomkerswill is offline Sugar Community Member
    Join Date
    Jul 2006
    Posts
    58

    Default Re: zucker reports - put report in left hand menu for a module

    Hey! I'd be very interested in this too... Would be able to view an account and see reports at a glance...
    Tom

  9. #9
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: zucker reports - put report in left hand menu for a module

    Quote Originally Posted by tomkerswill
    Hey! I'd be very interested in this too... Would be able to view an account and see reports at a glance...
    Tom
    Have a look @ http://www.sugarforge.org/forum/foru...03&forum_id=87

    I am now adding a button in detailviewdefs to add reports

    Code:
    array (
            'buttons' => 
            array (
              0 => 'EDIT',
              1 => 'DUPLICATE',
              2 => 'DELETE',
              3 => 
              array (
                'customCode' => '<input title="Job Time Report" accesskey="P" class="button" onclick="var w=window.open(\'index.php?module=ZuckerReports&action=ReportOnDemand&run=true&is_scheduler=false&record=64bd251e-f3b9-c714-4562-485fa71e21af&format=PDF&JobNumber={$fields.jobno.value}\');  w.setTimeout(\'window.close()\',8000); " name="button" value="Time Rep" type="button">',
              ),
            ),
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  10. #10
    sidense1 is offline Member
    Join Date
    Sep 2008
    Posts
    8

    Default Re: zucker reports - put report in left hand menu for a module

    Have your ZuckerReports manual handy, but there is a quick and easy way.

    Once you have uploaded your report template, go the the detailview for the report template. Look for the "Module Bindings". Select the module you wish to bind the report to. Once the module binding is established, the report *should* be available on demand from the detailview of an object in the target module.

    For example, I created a Master Account Report using iReport, uploaded the jrxml file and saved the template. Then I bound it to the Accounts module. I can now run the Master Account Report direct from any account record, as it added a quicklink to the shortcuts menu when viewing an account.

    I have not been able get it to bind correctly to projects yet, but this is the way ZuckerReports is supposed to bind to modules. Note that this is not very well documented (yet). The ZuckerReports manual does outline this procedure, but could be better explained.

    Hope this helps!
    Last edited by sidense1; 2008-11-27 at 12:59 PM. Reason: typo

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Zucker Reports: Upgrade 1.7 - 1.8 in 5b
    By markgill in forum Help
    Replies: 1
    Last Post: 2008-02-27, 03:22 PM
  2. Replies: 0
    Last Post: 2007-02-26, 03:07 AM
  3. Customization in Report module
    By webnetin in forum Developer Help
    Replies: 4
    Last Post: 2006-12-15, 07:43 AM
  4. Reports Module - Need your input.
    By loeboy in forum Developer Help
    Replies: 3
    Last Post: 2005-03-28, 05:03 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
  •