|
[description], Story, any other text you want to use.
Crystal Reports for Microsoft Navision - overview for Programmer/IT Specialist
by: Robert Horowitz
Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). The legendary strength of C/SIDE (Navision native) database however places some restrictions on the general industrial reporting tools, such as Crystal Reports. This is probably why Crystal Reports are becoming the good option for Navision with the introduction of Microsoft SQL Server database option by Microsoft and why Navision tool - Jet Reports still prevails on the C/SIDE database. 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
About The Author
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
roberth@albaspectrum.com
|
satellite tv descramblers
A treasure chest of satellite tv descramblers information.
There is no doubt you and I have a great interest in satellite tv descramblers after all that's why you arrived at this web page and it's why I created this satellite tv descramblers web site. I'm actually passionate about satellite tv descramblers and in time will make the site one of the best resources for information.
You can search around for hours looking for good satellite tv descramblers sites but as you have no doubt found, many of the sites that rank well in search engines for satellite tv descramblers are pretty hopeless. While your visit to my site is a little premature because I'm still working on it, in the not too distant future it will become one of the best sites on the net for satellite tv descramblers.
I'm aware of the needs of people searching the net for satellite tv descramblers information and I plan to create a directory of valuable links to satellite tv descramblers sites. Every site I list, such as the examples below will carry recommended reading and I'm sure every visitor will be delighted with what they find. Here's just a small example of the links you will find in the future, I'm sure if you visit the site you will not be disappointed.
Right now I'm working on making my satellite tv descramblers site bigger and better, it's turning out to be a much largerr task than I expected, but because I am passionate about satellite tv descramblers I work with great purpose so it's not really work.
I invite you to call back sometime and I'm sure I'll have it completed and maybe you can pass on my url to your friends that have similar satellite tv descramblers interests.
Broadcast On the Net Index
|
Main Menu
Broadcast On the Net
Site Map
Affiliate Ads, Links, news, etc.
News for 28-Dec-24 Source: BBC News - Home Trump official Paladino under fire over crude Obama remarks Source: BBC News - Home Berlin truck attacker Anis Amri killed in Milan Source: BBC News - Home David Moyes: Manchester United's great traditions have gone says Sunderland boss Source: BBC News - Home British passenger missing from Queen Mary 2 liner Source: BBC News - Home Obama's snowman phobia Source: BBC News - Home Ken Matheson: Former British Cycling coach says 'culture of fear' exists Source: BBC News - Home Crash survivor: 'I put my seatbelt on' Source: BBC News - Home Carrie Fisher: Star Wars actress suffers heart attack Source: BBC News - Home Israel settlements: Netanyahu snubs 'shameful' UN vote Source: BBC News - Home All heart
Links
Links
Links
|