Software Information

Crystal Reports for Microsoft Great Plains - Overview for Developer


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:
    Enterprise software is hot — who would have thought?  TechCrunch

    Once considered the most boring of topics, enterprise software is now getting infused with such energy that it is arguably the hottest space in tech.


    VMware shopping spree lands $5 billion in public cloud-software companies  MarketWatch

    VMware Inc. has been snapping up cloud-focused startups while making deals with former enemies like Amazon.com Inc. and Alphabet Inc. for months, but ...


    Winning Over Your Organization On Software Adoption  Forbes

    Implementing new software programs can be difficult regardless of company size. How do you make sure that selection, implementation and adoption of new ...


    FAA Seeking 737 Airline Pilots to Test Software on Grounded Max  Bloomberg

    U.S. regulators are turning to a variety of Boeing Co. 737 Max pilots, including some with relatively little experience, to help test revamped flight-control software ...


    'Stick with software over semis' as tech recovers, says investor  CNBC

    Software stocks are the place to be in tech as the sector mounts a recovery from its recent pullback, some analysts say.


    Magecart hackers target popular poker software  TechRadar

    Magecart credit card skimmers typically target users through their web browser when shopping online but new research from Malwarebytes has discovered that ...


    Exclusive: KKR explores $5 billion sale of Epicor Software - sources  Reuters

    Buyout firm KKR & Co Inc is exploring a sale of Epicor Software Corp that could value the U.S. enterprise resource planning software provider at close to $5 ...


    Share Your Salary: Kate - Tier III Software Support Rep  RADIO.COM

    Share your Salary: Because we all want to know what everybody else makes for a living, but its never ok to ask until now!This week we talked to Kate a Tier III ...


    Synopsys Gains After Earnings Beat by Chip-Design-Software Maker  TheStreet.com

    Shares of Synopsys (SNPS - Get Report) surged Thursday after the maker of chip-design software handily beat analyst earnings estimates for profit and revenue ...


    State temporarily halts implementation on new K-3 reading software  Greenville Daily Reflector

    Thursday, August 22, 2019. The N.C. Department of Information Technology on Monday granted a motion to temporarily halt implementation of the Istation ...


    Tesla can tune your Model S or X's suspension via software update  CNET

    The catch is that it only works on the newest S and X models, due to changes in air suspension design.


    Software for diagnostics and fail-safe operation of robots developed at FEFU  EurekAlert

    A team of scientists from School of Engineering at Far Eastern Federal University (FEFU), Institute of Automation and Control Processes, and Institute of Marine ...


    Best Practices for Software Change Assessment  DevOps.com

    There are many ways to approach and implement software change assessment. These best practices can ensure a glitch-free software change rollout.


    New software tools help better manage growing complexity in the datacenter  CIO

    Although it's exciting to be part of a growing business, rapid growth can be challenging. That's because as a business grows, it encounters different problems ...


    Splunk to Buy Cloud-Monitoring Software Maker SignalFx for $1.05 Billion  Wall Street Journal

    Splunk reached a $1.05 billion deal to buy cloud-monitoring startup SignalFx, a deal that would strengthen the cybersecurity and data-analytics firm's offerings.


    Software Development with IT Outstaffing Services  The Libertarian Republic

    The IT field is usually one of the most important sectors in the economy of leading countries. We use modern technology on a daily basis and the more advanced ...


    Tesla’s head of Autopilot software leaves in restructuring  Electrek

    Tesla's head of Autopilot software, Stuart Bowers, has left the automaker to work for the venture capital firm Greylock after a restructuring of the Autopilot team.


    Guidewire's Predictive Analytics Software Helps Insurers Control Risk  Forbes

    Guidewire is helping to modernize the $2 trillion global property and casualty insurance industry.


    Options traders see big moves on the horizon for a software giant  CNBC

    A software giant on a shopping spree is set to report earnings on Thursday, and the options market is eyeing a pretty substantial move for the stock. Salesforce is ...


    Cisco: 6 critical security alarms for UCS software, small-biz routers  Network World

    Cisco finds critical bugs in its Unified communications Director and Director Express software for Big Data packages as well as its Small Business 220 Series ...


    How this ex-Microsoft director launched a spa and salon software startup that has raised $91M  GeekWire

    Sudheer Koneru thought he was pretty much done working. After stints at Microsoft and SumTotal Systems, Koneru considered himself semi-retired, or at least ...


    The Rally in Paycom Software Could Be Slowing So Here's How I'd Play It  TheStreet.com

    For his "Executive Decision" segment of Mad Money Wednesday night, Jim Cramer spoke with Chad Richison, founder and CEO of Paycom Software (PAYC) ...


    Movers & Shakers: Hegg, Ultimate Software, Claims Associates Inc., The Jones Financial Cos.  Sioux Falls Argus Leader

    Claims Associates, Inc., locally owned independent adjusting and third party administrator, has hired Craig Matson as a casualty general adjuster in the Sioux ...


    National Grid says new-style stability software will avoid blackouts  The Guardian

    National Grid plans to stabilise the energy grid by plugging into new technology after raising concerns a year ago that it may be “walking blind” into the risk of ...


    Growing software company opens Houston office  Houston Chronicle

    A software company that says it's valued at $7 billion is opening an office in Houston Thursday as it aims to win customers in the health care and energy sectors ...


    Should Income Investors Look At Magic Software Enterprises Ltd. (NASDAQ:MGIC) Before Its Ex-Dividend?  Yahoo Finance

    It looks like Magic Software Enterprises Ltd. (NASDAQ:MGIC) is about to go ex-dividend in the next 3 days. You can purchase shares before the 26th of August ...


    Helmerich & Payne Adds More E&P Engineering Software with DrillScan  Natural Gas Intelligence

    To give it another leg up with exploration customers wanting to drill deeper laterals more efficiently, Helmerich & Payne Inc. (H&P) has acquired DrillScan, ...


    Six Ways To Make An Enterprise Software Release Plan Less Inaccurate  Forbes

    Don't load up the release with features that take you to the last minute.


    3 software that coordinate computer resources and activities  Windows Report

    If you want to optimize your PC to make it faster and remove all the junk files, use Iolo System Mechanics, Wise Care 365, or IObit Advanced SystemCare .


    Volkswagen calls for applications to software training program, 'Faculty 73'  AutomotiveIT International

    As part of an ongoing effort to increase software development and programing expertise, Volkswagen Group is now looking for applicants to the second round of ...


    CORRECTING and REPLACING Upland Software Announces Acquisition, Raises Guidance  Yahoo Finance

    Acquisition of Cimpl creates first IT Financial Management Cloud with enterprise-class Telecom Expense Management capabilities.


    Raytheon IIS Wins $30M for Navy V-22 Systems and Software Engineering  ClearanceJobs

    ClearanceJobs is your best resource for news and information on security-cleared jobs and professionals. Learn more with our article, "Raytheon IIS Wins $30M ...


    Collaboration to Test Blockchain-Based Electricity Market Software  Transmission & Distribution World

    Local energy market project to examine how blockchain technology can help integrate more EVs and solar on the grid.


    Global Software-as-a-Service (SaaS) CRM Market 2019-2023 | Increasing Adoption of Cloud-based Offerings is Expected to be a Key Growth Driver | Technavio  Yahoo Finance

    The global SaaS customer relationship management market size is poised to grow by USD 33.15 billion during 2019-2023, according to a new report by ...


    SpotQA picks up $3.25M seed funding for its automated software testing  TechCrunch

    SpotQA, a new automated software testing platform that claims to be significantly faster than either manual testing or existing automated QA solutions, has raised ...


    American Software's Board Approves the Quarterly Cash Dividend  Valdosta Daily Times

    ATLANTA--(BUSINESS WIRE)--Aug 22, 2019--. American Software, Inc. (NASDAQ: AMSWA) today announced that its Board of Directors declared a quarterly ...


    One of Indiana's largest software firms gets new majority owner  Indianapolis Business Journal

    Editor's note: IBJ is now using a new comment system. Your Disqus account will no longer work on the IBJ site. Instead, you can leave a comment on stories by ...


    Facial recognition software could help predict hail storms  The Denver Channel

    Scientists at the National Center for Atmospheric Research in Boulder are working on new technology to better predict hail storms. It uses the same algorithm as ...


    IBM updates cloud-native software with Red Hat OpenShift  TechGenix

    IBM's purchase of Red Hat is paying dividends for users optimizing their technology for the cloud era. Here's more on IBM and Red Hat OpenShift.


    Best email marketing software of 2019  TechRadar

    Get your message out there in the most powerful way possible with some excellent email marketing software.


    The End Of Overpromise-Underdeliver Software  Forbes

    SaaS companies have revolutionized how software is delivered. Now we need to revolutionize how we measure its business value.


    Serent Capital Invests in Davisware, a Leading Field Services ERP Software Company  Valdosta Daily Times

    AUSTIN, Texas & SAN FRANCISCO--(BUSINESS WIRE)--Aug 22, 2019--. Davisware, a leading provider of ERP software for field services businesses, has ...


    Veracode Releases Advanced Software Composition ...  Dark Reading

    Cloud-based solution helps developers prioritize and remediate open source vulnerabilities quickly within DevSecOps environments.


    Software Engineer II (Mid-Level) - G2  Built In Chicago

    G2 is hiring for a Software Engineer II (Mid-Level) in Chicago. Find more details about the job and how to apply at Built In Chicago.


    Harvest Profit Adds a Balance Sheet to its Farm Management Software  Business Wire

    Harvest Profit, Inc. announced today that the company has added a farm balance sheet feature to its farm management software platform. Its customers w.


    Software-Defined Security Governance: The Market Shift  Infosecurity Magazine

    Digital transformation drives organizations to software-define every aspect of what they deliver to customers, from infrastructure to networking and more.


    Sesame Software Releases Relational Junction 6.1 with Instant Data Warehousing for Over 100 Cloud and On-Premise Applications  MarTech Series

    Sesame Software, the innovative leader in Enterprise Data Management, announced the rollout of Relational Junction 6.1, the latest version of its suite of data ...


    Gambling software maker Playtech cuts Asia outlook  Yahoo Finance

    (Reuters) - Gambling software maker Playtech Plc on Thursday cut its full-year revenue forecast for Asia, blaming rising competition in China and a regulatory ...


    Game Development Software To Help Bring Your Ideas To Life  TheGamer

    Here are a few great software programs that are designed to help bring your game to life.


    Tesla releases new software update with adaptive suspension damping improvements and more  Electrek

    Tesla started releasing a new software update this week with improvements to Model S and Model X's new adaptive suspension damping and more. In April ...


    Asure Software Welcomes Charlie Lathrop to Board of Directors  GlobeNewswire

    AUSTIN, Texas, Aug. 22, 2019 (GLOBE NEWSWIRE) -- Asure Software (NASDAQ: ASUR), the leading provider of workforce and workspace software solutions, ...


    Luxe Pricing's HouseCount Revenue Management Software (RMS) Achieves Oracle Validated Integration with Oracle Hospitality OPERA Property Management System  Hospitality Net

    Luxe Pricing, a Gold level member of Oracle PartnerNetwork (OPN), today announced it has achieved Oracle Validated Integration of HouseCount RMS with ...


    2019 State of DevOps Report Released; Research Links Fast, Reliable Software Delivery to Business Transformation  GlobeNewswire

    Armory Sponsors Study from DevOps Research and Assessment (DORA) and Google Cloud; Announces Upcoming Webinar to Discuss Report Findings.


    Nearmap launches 3-D software  Lawn & Landscape

    Along with the new software, the company also announced its AI program.


    Best CRM software of 2019: Customer relationship management solutions for any business  TechRadar

    Here's our top CRM systems to improve your customer interactions.


    New Tesla Model S & X Software Updates: Suspension Improvements & More  InsideEVs

    To some, it might seem crazy to think that Tesla can make notable improvements to its cars' suspension system with over-the-air software updates. Sure, update ...


    Low- and No-Code Software Help Manufacturers, Supply Chain Managers Create Apps  ThomasNet News

    Low-code software provides the building blocks for specifically tailored supply chain and manufacturing apps.


    Software update bricked my car  Tesla Motors Club

    I am new here so apologies if I break any rules... On Monday I got a notification that there would be a software update overnight. I accepted that,...


    Decatur school district leaders working to resolve scheduling software issues  Herald & Review

    DECATUR — School district officials say they are working out issues with a new information system to get student class schedules at Stephen Decatur Middle ...


    Mopar Website Adds Software to Traditional Hardware  Ward's Auto

    While Mopar has sold performance parts and other accessories for decades, its role as FCA's digital conduit to customers is expanding quickly.


    8BitDo SN30 Pro+ review: Vintage style meets modern hardware & software  PCWorld

    The SN30 Pro+ is 8BitDo's first full sized controller. It keeps up with the competition in the hardware department, but the software is where it truly shines.


    Data Breach Discovery Software, Canopy, Adds New 'Smart Tools' to Accelerate the Identification of Affected Individuals  MarTech Series

    CanopyCo LLC, the data mining and breach review software developer, released several new "smart tools" to all subscribers of its flagship application, Canopy.


    Europe's regulators grope for value of software  Risk.net

    In the US, the cost of software is not taken out of capital. Europe is fumbling for something similar.


    Jamaica seeks cannabis seed-to-sale software; 54 licenses 'granted'  Marijuana Business Daily

    Jamaica's cannabis regulator has launched an international bidding process to identify an organization to provide seed-to-sale tracking software.


    A look at the backup software Acronis True Image 2020  Ghacks Technology News

    Acronis True Image 2020 is the latest installment in Acronis' long-standing backup product series. It is a commercial backup program, a trial version is provided ...


    EMUI10 - Huawei's latest smartphone software  Egypttoday

    CAIRO – 22 August 2019: Huawei, a brand known and loved for its smartphones that cater to every kind of user, has always seen great appreciation for its EMUI ...


    Software Vulnerability Disclosure Is a Real Mess | News & Opinion  PCMag

    In July, several reputable websites reported a critical security flaw in VLC, a popular open-source, multiplatform media-player application. Readers were urged ...


    Bernie Sanders wants to stop police from using facial recognition software  CNN

    New York (CNN Business) A criminal justice plan from presidential candidate Bernie Sanders would ban police from using facial recognition software.


    Cequence Security Wins Gold as Network Product Guide's 2019 Security Software Startup of the Year  Business Wire

    SUNNYVALE, Calif.--(BUSINESS WIRE)--Cequence Security, a provider of innovative application security solutions for today's hyper-connected enterprises, ...


    ENTREVESTOR: Data crunching software company could have moved anywhere in North America. Here's why they chose Halifax  TheChronicleHerald.ca

    Having caught the attention of some of the world's largest corporations, two Vietnamese entrepreneurs have now chosen Nova Scotia as their company's new ...


    Global logistics software company WiseTech reports huge rise in revenues and profits  FreightWaves

    WiseTech (ASX:WTC), a global provider of advanced logistics software, has reported a whopping 57 percent growth in revenues and a massive 37 percent net ...


    LabVantage Solutions’ Security Safeguards for its Leading LIMS Software Recognized with Award of ISO/IEC 27001 Certification  Technology Networks

    LabVantage Solutions, Inc., the leading provider of laboratory informatics solutions and services including purpose-built LIMS solutions that allow labs to go live ...


    Simulation software: protecting organisations during the cyber war  Information Age

    Organisations and consumers are in real threat of falling victim to the ongoing cyber war. Is simulated software a reasonable response?


    India’s software industry to top $80 billion by 2025: CII  Livemint

    The global software industry is currently valued at $511 billion, of which India's share is $8.1 billion but the objective is to take India to $80-90 billion by 2025.


    Logistics software vet launches process automation venture  JOC.com

    The founder of widely-used freight rate management software provider Catapult International has started a new venture that aims to equip logistics companies ...


    Teen Hacker Finds Bugs in School Software That Exposed Millions of Records  WIRED

    Some kids play in a band after school. Bill Demirkapi hacked two education software giants.


    Helmerich & Payne Expands Portfolio of Drilling Optimization Software and Capabilities with the Acquisition of DrillScan  Business Wire

    TULSA, Okla.--(BUSINESS WIRE)--Helmerich & Payne, Inc. (H&P) (NYSE: HP) announced today its wholly owned subsidiary, Helmerich & Payne Technologies, ...


    Apple sues startup for creating a software copy of the iPhone  The Verge

    For more than a year, a company called Corellium has been offering hackers a virtual iPhone — but now, Apple is pushing back in court.


    Marketing Project Management Software Market to Witness Robust Expansion by 2025: Workzone, Smartsheet, Clarizen  Daily Watch Reports

    Global Marketing Project Management Software Market Research Report comprises holistic business information and changing trends in the market that ...


    H-1B Visa Most Used for ‘Software Engineer,’ ‘Software Developer’ Roles  Dice Insights

    A recent H-1B visa data-dump from the U.S. Department of Labor shows job titles such as “software developer” and “software engineer” are the most widely used ...


    Pivotal Software surges after VMware says it's in talks to acquire the company  CNBC

    Pivotal shares rose as much as 72% premarket Thursday after VMware said Wednesday it's proceeding with an agreement to acquire all outstanding shares of ...


    Media software Plex launches a new desktop app for Mac and Windows  TechCrunch

    Plex today is launching a new desktop application for Mac and Windows, with the goal of eventually replacing Plex Media Player as the company's only desktop ...


    5 ancient software programs we refuse to give up  PCWorld

    We know you're out there: Users who cling to an ancient software program because it just works. We name six programs that many people just won't give up, ...


    Software Engineering Firm EPAM Joins Blockchain in Transport Alliance  Cointelegraph

    Software engineering and IT consulting services firm EPAM Systems Inc. has joined the Blockchain in Transport Alliance (BiTA) that develops blockchain ...


    Are the arts at the center of software's evolution?  UC Santa Cruz

    August 14, 2019. By Scott Rappaport. Share this story:TwitterFacebookGoogle+LinkedInReddit. sack-book-cover-400.jpg The Software Arts is an invitation to ...


    Volkswagen’s Dieselgate software fix has another cheat device: German court  Teslarati

    It appears that Volkswagen's high-profile Dieselgate scandal won't let go of the veteran German automaker just yet. In a recent decision, a district court in ...


    Exclusive: Kaspersky Software Lingers On Sensitive Government Systems 2 Years After U.S. Ban  Forbes

    New research shows that Kaspersky Lab's antivirus software remains active on sensitive U.S. government networks two years after it was banned as a potential ...


    Google’s new ‘Assignments’ software for teachers helps catch plagiarism  TechCrunch

    Just in time for the new school year, Google's educational arm, Google for Education, today announced the launch of new tools aimed at helping teachers fight ...


    ProGrade Digital's New Software Tells You When Your Card is About to Die  PetaPixel

    Memory Card maker ProGrade Digital has unveiled an interesting new piece of software called “Refresh Pro.” When used with compatible ProGrade memory ...


    Making OKRs OK: Ally raises $8M for software to help companies meet objectives and key results  GeekWire

    A Seattle startup has raised $8 million to fuel its quest to help companies stay on track and hit their goals in an era of rapid change for businesses, markets and ...


    The State of the Art and the Future of GDPR Compliance Software  Techopedia

    The GDPR has many facets that organizations must comply with, and software tools are available to help ensure compliance with multiple aspects of the law.


    Amazon's Rekognition software can now spot fear  CNET

    The facial recognition tech is also getting better at estimating a person's age, the company says.


    US software company ActiveCampaign to create 200 jobs in Dublin  The Irish Times

    Company says initial hires will be in support, sales, customer *service* and marketing.


    Why chipmaker Broadcom is spending big bucks for aging enterprise software companies  TechCrunch

    Last year Broadcom, a chipmaker, raised eyebrows when it acquired CA Technologies, an enterprise software company with a broad portfolio of products, ...


    Texas Ransomware Attacks: MSP Software Involved?  MSSP Alert

    Twenty-two Texas local governments are striving to recover from coordinated ransomware attacks, and some of those government agencies are already back ...


    Private Equity Firm Accel-KKR’s Latest Fix: Hotel Enterprise Software  Skift

    Buyout firm Accel-KKR is rolling up hotel technology vendors. It needs to find bargains, given the high valuations for the bigger businesses it more ...


    Polarity raises $8.1M for its AI software that constantly analyzes employee screens and highlights key info  TechCrunch

    Reference docs and spreadsheets seemingly make the world go 'round, but what if employees could just close those tabs for good without losing that ...


    IK Multimedia tease Brian May AmpliTube software release  MusicRadar

    IK Multimedia have released a 22-second video on YouTube teasing the release of a new amp and effects modelling software package with "Tones that will rock ...


    Twitch has released its own broadcasting software  The Verge

    Though Twitch is the biggest player around in the live-streaming space, its broadcasters — from the most prominent creators to the smallest streamers — all rely ...


    Software developers remain in high demand across NC, report shows  WRAL Tech Wire

    RALEIGH - Demand for software developers, especially with certifications in Java, remains strong across North Carolina even as overall open high tech job.


    home | site map
    © 2006