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:

Sydney Morning Herald

New Apple software for iPhone 'bug fixes'
Newsday, NY - 15 hours ago
BY EMI ENDO | emi.endo@newsday.com Apple Inc. has released a software update for its iPhone aimed at improving its connection with faster wireless Internet ...
Apple's iPhone 2.0.2 software update didn't fix much Computerworld
Apple updates iPhone software to fix glitches Reuters
Jobs promises September iPhone software patch InfoWorld
ZDNet - NEWS.com.au
all 567 news articles


BuilderFusion(R) Inc. Named the 11th Fastest-Growing Software ...
MarketWatch - 1 hour ago
"Since its inception eight years ago, the BuilderFusion software has had a dramatic impact on professional associations across the United States, ...


Carnegie Learning(TM) Developmental Math Software Aligns with ...
MarketWatch - 4 hours ago
PITTSBURGH, Aug 21, 2008 (BUSINESS WIRE) -- Carnegie Learning, Inc. announced today that the company's developmental math software for higher education ...


BakBone Software Appoints New Chief Financial Officer
MarketWatch - 1 hour ago
The common shares of BakBone Software are currently subject to cease trade orders in the Canadian jurisdictions of Alberta, British Columbia and Ontario due ...


RTT News

Wall Street Beat: Salesforce, HP, M&A in the Spotlight
PC World - 1 hour ago
Salesforce is often seen as a bellwether for the SaaS (software-as-a-service) market, since it was one of the first companies to jump into hosted software, ...
Salesforce.com shares drop on outlook CNET News
Acquisition Costs Sink Salesforce (Update) TheStreet.com
Salesforce 2Q profit nearly triples, stock plunges Forbes
Register - Wall Street Journal Blogs
all 101 news articles


The Software, Called iClink, Allows Two-Way Wireless ...
MarketWatch - 7 hours ago
The software, called iClink, wirelessly synchronizes contacts, calendar events, and to-do items between the iPhone and Lotus Notes. The iClink software runs ...


American Software, Inc. Invites You to Join Its First Quarter ...
MarketWatch - 6 hours ago
What: American Software, Inc.'s First Quarter Fiscal Year 2009 Earnings Release When: September 4, 2008 5:00 pm ET Where: http://www.amsoftware.com How: ...


Tamale Software Launches Latest Version of Investment-Research ...
MarketWatch - 7 hours ago
The expanded scalability boosts the effectiveness of search and other functions -- making the software an ideal choice for an increasingly wide client base ...


Inc. Magazine Recognizes Nimsoft as the 36th Fastest Growing ...
MarketWatch - 8 hours ago
Last year, Nimsoft was ranked as the 49th Fastest Growing Software Company. This list is part of the Inc. 5000, the magazine's annual list of the fastest ...


Environmental Risk Services (ERS) Selects Locus' Environmental ...
MarketWatch - 11 hours ago
EIM's Software as a Service delivery model is also ideal for single site applications as the customer eliminates hardware/software purchases and maintenance ...

Software - Google News

home | site map
© 2006