Sage Accpac Community
Accpac Support Community
Search in

Excel Report

Last post Sat, Apr 11 2009 4:54 PM by Jay Converse. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • Sat, Apr 11 2009 1:30 PM

    • pabloisl
    • Top 75 Contributor
    • Joined on Sat, Apr 11 2009
    • Posts 9

    Excel Report

     I currently have a customised Income statement report, I need to adjust the report to display all the departments in columns across the page. How do I in the relevant instructions.

    I also need to adjust the the report to create another report displaying the relevent figures by period from period 1 to a specific period.  I need the field names for periods and possible solution for setup. 

  • Sat, Apr 11 2009 2:07 PM In reply to

    Re: Excel Report

    From the statement designer in Excel, select FR/Help, and look at the instructions for FRAMT.

  • Sat, Apr 11 2009 2:29 PM In reply to

    • pabloisl
    • Top 75 Contributor
    • Joined on Sat, Apr 11 2009
    • Posts 9

    Re: Excel Report

     thnx much, will try and let you know the out come.

  • Sat, Apr 11 2009 4:17 PM In reply to

    • pabloisl
    • Top 75 Contributor
    • Joined on Sat, Apr 11 2009
    • Posts 9

    Re: Excel Report

    How do I access excel stmt designer is this a seperate software?

     

  • Sat, Apr 11 2009 4:19 PM In reply to

    • pabloisl
    • Top 75 Contributor
    • Joined on Sat, Apr 11 2009
    • Posts 9

    Re: Excel Report

     found it now trying solution

     

  • Sat, Apr 11 2009 4:28 PM In reply to

    • pabloisl
    • Top 75 Contributor
    • Joined on Sat, Apr 11 2009
    • Posts 9

    Re: Excel Report

     I am in reprot designer help but the help details are not displayed when i select a keyword or code, the details window displays " the address is not valid.  how do i resolve this issue.

     

  • Sat, Apr 11 2009 4:54 PM In reply to

    Re: Excel Report

    Old problem, you need to do a little regedit:


    REGEDIT4
    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp]
    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\HHRestrictions]
    "MaxAllowedZone"=dword:00000001

    For more info, go here and look at Example 2.
Page 1 of 1 (7 items)