Crystal Reports Microsoft Navision Overview Programmer/IT Specialist Software

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

XML error: not well-formed (invalid token) at line 14

Common misspellings for words used in this page include abilty accross addtional adecuate adn ahev ahve allready alreayd alsot alwasy alwyas amke amking anbd aplication applicaiton aready artical artice articel aslo asume availaible availble availiable availible avalable avaliable avilable baout becomeing becomming bedore befoer beng buisness busineses busness bussiness campains caperbility ceratin certian chalenging claer clera cmoputer comany comapany comparision concider conection consdider consentrated constanly controll conveinent convienient coputer coudl creaeted dael decison decribed delevopment descibed descision desgined dessigned developement developped develpment devolopement dicussed diferent diferrent differnt diffrent discribed dissappointed doccuments ealier eearly effeciently efficently enchancement ened ethose exemple exmaple eyar eyars eyasr fidn follwoing folowing fomr formelly frome fucntion funtion haev hstory hten htere htey htis hvae hvaing hvea hwihc hwile hwole imagin impliment implimented includng incuding inlcuding intergration inudstry iwll iwth jstu jsut knwo konw kwno laguage liek littel liuke maintainance maintainence maintance maintenence mkae mkaing mkea monts moreso mroe nkow nkwo nmae nowe nto omre orginally origanaly originall originaly originially originnally orignally orignially otehr owrk owudl pary performence peronal pomotion populare poverful poweful powerfull previvous probablly probaly proccess proccessing proces propper pwoer qtuie quicklyu qutie reaccurring realitvely reccomend reccommend reccuring recomend recquired recuring reguarly regularily relativly relitavely requred resticted runing runnung rwite severeal sevice shoudl shoudln smae smoe soem sofware sohw sophicated sould startegy statment stradegy stregth strenght suphisticated tahn taht targetted tath teh tehy temprary tghe thast theese ther theri thgat thge thier thigns thigsn thn thna thne thnigs thrid thsi thsoe thta thyat tiem tihs timne tiome tje tjhe tkae tlaking todya tyhat tyhe uise useage usefull vell verison veyr vrey vyer vyre waht wass watn weas wehn whant whants whcih whic whihc whith whlch whn whta whther wich wiew wih wiht wille witht witn wiull wnat wnated wnats wohle wokr wonderfull workststion woudl wriet writen wrok ws wtih yearm yeasr yera yeras yersa youself ytou yuo.