Software Information

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist


Let us give you - developer some hints in the report creation.

  • C/SIDE database - use C/ODBC to create the connection for your Crystal Report. You have to make all the links inside the report. The drawback of this approach - report becomes inflexible if you would like to change database mapping (re-link from work to historical tables for example) - it is probably easier to redo report from scratch. You can use something like Crystal Query - which is still very restricted in its functionality.
  • Microsoft SQL Server - you are better positioned to create Crystal Reports. You can deploy MS SQL Server views. View will allow you to unionize work and historical info, pull the data from several databases to name a few nice features. Also the option to use stored procedures (or stored procs) enables you to create temp tables for data manipulation before sending the final result set. You can also have parameters (name of the company/database, dates restrictions) - this gives you additional advantage versus SQL View
  • Reports on geterogeneus databases - imagine creation of Linked Server in your Microsoft SQL Server Enterprise Manager. If Navision sits in MS SQL - you create linked server to the third party database (Oracle, DB2, Unidata, Ingress, Sybase, Pervasive, Ctree, MS Access). If you are on C/SIDE DB - you create linked server to it via C/ODBC, then you create additional linked servers to your legacy DBs. Now you are ready to create geterogeneus SQL View to link all your databases and have the data shown in one Crystal Report. You should probably familiarize yourself with OPENROWSET statement in Transaction SQL

Good luck in reports design and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com).

You can contact Robert: welcome@albaspectrum.com


MORE RESOURCES:

Callidus Software Slips To Wider Q4 Loss
NASDAQ
(RTTNews.com) - Callidus Software Inc. (CALD) reported a fourth-quarter net loss of $3.6 million or $0.11 per share, wider than last year's loss of $1.5 million or $0.04 per share. Last year, results included $1.4 million of stock-based compensation ...
Callidus Software Announces Fourth Quarter and Full Year 2011 ResultsMarketWatch (press release)
Callidus Software, Inc. (CALD) Reports In-Line Q4 EPS; Guides Q1 RevsStreetInsider.com (subscription)

all 12 news articles »


Moxie Software Sponsors Free, Live Webinar on Canon's Best Practices for Field ...
MarketWatch (press release)
Moxie Software, Inc., the Enterprise Social Software Company, today announced it is sponsoring a free, live webinar discussing Canon's Best Practices for Field Service: The New Face of Customer Satisfaction. John Ragsdale, TSIA's vice president of ...

and more »


Guidance Software stock jumps after strong 4Q
CBS News
(AP) NEW YORK — Shares of Guidance Software Inc. rose to their highest level in more than three years Wednesday on strong fourth-quarter results and an upbeat outlook. THE SPARK: After the market closed on Tuesday, Guidance reported net income of $2.3 ...
Guidance Software to Acquire CaseCentralBusiness Wire (press release)
Guidance Software buys CaseCentral for eDiscovery one-two punchFierceContentManagement
Guidance Software Acquires CaseCentralsocalTech.com
Los Angeles Business Journal
all 9 news articles »


Marin Software Promotes Brian Marin and Ed Stevenson to Global Positions
MarketWatch (press release)
SAN FRANCISCO, CA, Feb 08, 2012 (MARKETWIRE via COMTEX) -- Marin Software, provider of the leading online advertising management platform for advertisers and agencies, today announced the promotions of Brian Marin to Vice President, Global Services and ...

and more »


Latitude Software and PaymentVision Offer Integrated Debt Collection and ...
MarketWatch (press release)
GAITHERSBURG, Md., Feb 08, 2012 (BUSINESS WIRE) -- Latitude Software, an Interactive Intelligence Group Inc. company /quotes/zigman/5694010/quotes/nls/inin ININ +0.25% , and PaymentVision have partnered to offer an integrated debt collection and ...

and more »


BMC Software Sells $500 Mln 10-Yr Bonds at 4.316%
Wall Street Journal
By Patrick McGee Of DOW JONES NEWSWIRES NEW YORK (Dow Jones)--BMC Software Inc. (BMC) completed a $500 million sale of 10-year bonds in the US credit markets Wednesday, according to a person familiar with the deal. The 4.25% coupon bonds were priced to ...

and more »


Jive Software Q4 Loss Widens Despite Higher Revenues - Update
NASDAQ
(RTTNews.com) - Enterprise social networking company Jive Software Inc. (JIVE) on Tuesday reported a loss for the fourth quarter that widened from last year as higher costs and expenses offset strong revenue growth. The latest quarterly results are the ...
Jive Software to Present at the Goldman Sachs Technology & Internet Conference ...MarketWatch (press release)
Jive Software reports fourth-quarter lossSan Francisco Chronicle
Jive Financials Show Social Software MomentumInformationWeek
Forbes -TalkinCloud (blog) -RTT News
all 52 news articles »


iWay Software and UBM Global Trade Partner to Automate Legacy Processes for ...
MarketWatch (press release)
NEW YORK, NY, Feb 08, 2012 (MARKETWIRE via COMTEX) -- iWay Software from Information Builders, an innovator of enterprise integration solutions, today announced that UBM Global Trade, a worldwide provider of proprietary data, news, and other content ...

and more »


CNET

Google Offers Mobile Chrome Browser for New Android Software
BusinessWeek
7 (Bloomberg) -- Google Inc., seeking to get more of its desktop-computer software onto mobile devices, introduced a test version of its Chrome Web browser for the latest Android operating system. The browser, first unveiled in 2008, will be available ...
Google launches Chrome for Android BetaInquirer
Adobe confirms no Flash for Chrome on AndroidComputerworld
Google releases Chrome beta for AndroidTechnology Spectator

all 510 news articles »


GigaOm

Akamai Acquires Website Performance Company Blaze Software
TechCrunch
After scooping up rival Cotendo for $268 million recently, content delivery and web services giant Akamai is making another acquisition today—Blaze Software. Blaze's technology helps accelerate speed of Websites, and optimizes load times while cutting ...
Akamai scoops up Canadian software outfitBoston Herald
Akamai Technologies Buys Blaze Software - Quick FactsNASDAQ
Akamai Acquires Venture-Backed Blaze SoftwareTechFinance
Xconomy -Sacramento Bee
all 87 news articles »

Google News

Home | Site Map

Powered By: Free Work At Home Business Opportunity!

© 2006