Software Information

Crystal Reports for Microsoft Great Plains - Overview for Developer

Norton AntiVirus 2009 - Blokér for vira og spyware med avanceret beskyttelse JumpLaunch Web Hosting Laplink Software CyberLink Power2Go 6 Easy Keyword Research with KeyCompete Email Marketing made easy -No skill required FotoSlate Print Manager Net Nanny Protects Your Family Get up to $900 in Free Software with 1&1 Hosting! Zap Spyware and Keep it Gone! Elephant Drive- Backup Storage and Anywhere Access

myspace profile views counter

Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market.  It serves the whole of vertical and horizontal market: most of the industries and company sizes.  Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.

If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated - read this and you will have the clues on where to look further.

  • Great Plains Tables Structure - first of all you need to know the tables to link.  Launch Great Plains and go to Tools->Resource Description->Tables.  Find the table in the proper series.  If you are looking for the customers - it should be RM00101 - customer master file.  If you need historical Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc.
  • Create ODBC connection to GP Company database.  Use the same technique as when you create standard ODBC connection for GP workstation - but change default database to targeted company database.
  • Consider SQL Views - if you don't want complex links in Crystal Report itself or if you need unionization from several companies - SQL view is the answer.
  • Consider SQL Stored Procedures.  Sometimes you can not pull the data in one view - you need temporary tables to be created and the final query should be based on these temp tables - this is when you need stored procedure.
  • Call Crystal Report from GP Screens via VBA/Modifier - if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window - you can use Modifier and VBA to call Crystal Reports engine.
  • Create SQL Query to probe the data - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query.
  • Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.


    MORE RESOURCES:

    Moneycontrol.com

    Adobe To Pay $240M For Day Software
    Emii.com
    Adobe Systems will acquire Switzerland's Day Software Holding for about $240 million, The Wall Street Journal reports. The San Jose-based computer software ...
    Adobe acquires Web software maker for US$240 millionBusinessWeek
    Adobe to Launch $240 Million Tender Offer for Day SoftwareWall Street Journal
    Adobe to buy Day Software for $240 million, adding Web marketing toolsSan Jose Mercury News
    Boston Globe -Barron's (blog) -Reuters
    all 224 news articles »


    RTT News

    BMC Software Q1 2011 Earnings Call Transcript
    TheStreet.com
    Welcome to today's BMC Software First Quarter Fiscal Year 2011 Earnings Results Conference Call. [Operator Instructions] At this time, for opening remarks ...
    BMC Software posts 13 percent jump in 1Q profitBusinessWeek
    BMC Software Q1 profit trails Street, keeps 2011 viewReuters
    BMC Software Inc. first-quarter profit up 13%MarketWatch
    Wall Street Journal -Barron's (blog) -RTT News
    all 38 news articles »


    CNET (blog)

    Adobe signs up for Microsoft protection
    Inquirer
    MAKER OF SOFTWARE that ticks off Apple's Steve Jobs, Adobe has signed up to be part of the Microsoft Active Protections Program (MAPP). ...
    Software rivals turning to allies to battle cyber crimeAFP
    Microsoft Program Will Report Adobe Software FlawsMicrosoft Certified Professional
    Microsoft argues for "neighborhood watch" approach to securityArs Technica
    ZDNet (blog) -Register -ITProPortal
    all 93 news articles »


    CDC Software Exceeds Second Quarter 2010 Estimates for Application Sales with ...
    MarketWatch (press release)
    Non-GAAP earnings per share was impacted by several factors, including the company's transition to its hybrid software model that included increased upfront ...
    Small and Midsized Businesses Unconcerned Whether Software-as-a-Service ...PR-USA.net (press release)

    all 7 news articles »


    2 held in $2.6 million theft from software firm
    San Francisco Chronicle
    Dionisio was a payroll clerk at Autonomy Inc., a business software company whose customers include Coca-Cola, FedEx and Lockheed Martin. ...
    Former Software Company Workers Accused Of Embezzling $2.6 MillionKTVU San Francisco
    2 arrested for embezzling millions from software firmabc7news.com

    all 4 news articles »


    Administaff Acquires Galaxy Technologies, a Leading Time and Attendance ...
    MarketWatch (press release)
    Galaxy Technologies' offering, along with our recently acquired expense management software, solidifies our growing line of SaaS products," said Paul J. ...

    and more »


    Software AG Net Rises 29%; Sees FY at Upper End of Forecast
    BusinessWeek
    July 29 (Bloomberg) -- Software AG, Germany's second- largest software maker, said second-quarter profit climbed 29 percent driven by ...

    and more »


    Pervasive Software among Information Management's "40 Vendors We're Watching ...
    MarketWatch (press release)
    The "40 Vendors We're Watching in 2010" list recognizes Pervasive for its data integration and analytics solution and notes, "[Pervasive has] software or ...
    Pervasive Software Reports Results for its Fourth Quarter of Fiscal Year 2010MarketWatch (press release)
    Pervasive Software buying back $10M sharesAustin Business Journal

    all 45 news articles »


    Post Online

    FalconStor Software Reports Second Quarter Results
    MarketWatch (press release)
    FalconStor Software, Inc. (NASDAQ:FALC) is the market leader in disk-based data protection. FalconStor delivers proven, comprehensive data protection ...
    Ness Technologies Announces Second Quarter 2010 Financial ResultsPR Newswire (press release)
    Entropic Communications Reports Second Quarter ResultsMarketWatch (press release)
    Akamai Reports Second Quarter 2010 Financial ResultsAmerican Chronicle
    MarketWatch (press release)
    all 1,063 news articles »


    CBC.ca

    I4i gets patent confirmed in the US
    Inquirer
    THE SOFTWARE outfit that humbled the finest legal minds that Microsoft could chuck at it has had a key patent confirmed in the US. ...
    I4i Says US Agency Upholds Patent Disputed By MicrosoftWall Street Journal
    Patent confirmed in Microsoft XML fightThe Guardian (blog)
    Microsoft loses 3rd round to Canadian firmCBC.ca
    PC World (blog) -PC Magazine -Seattle Post Intelligencer (blog)
    all 53 news articles »

    Google News

    home | site map
    © 2006