Home
>
Software
>
Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

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 (help@albaspectrum.com).

You can contact Robert: help@albaspectrum.com

Ford Excursion rentals Bolingbrook ..

In The News:

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Artificial intelligence has made social engineering scams more sophisticated. They are scams by which criminals exploit trust for money or information.

Quadroin AUV is an underwater research robot that mimics penguins' graceful and swift swimming, descending to depths of 492 feet at speeds up to 11.5 mph.

Will fake movie trailers made with AI become real enough to take over Hollywood? Kurt “CyberGuy" Knutsson discusses more about spotting AI movie trailers and how they work.

Kurt “CyberGuy" Knutsson discusses how Triton Submarines redefines the underwater experience with the Triton 660/9 AVA, which offers panoramic views and unparalleled ocean access.

If your Facebook account has been hacked and you're having trouble logging back in, Kurt “CyberGuy" Knutsson shows you some steps to recover your account.

Kurt “CyberGuy" Knutsson reveals how the Aloha Unleashed project showcases a dual-arm robot system that autonomously performs tasks, demonstrating remarkable precision in robotics.

Air Force Secretary Frank Kendall boarded the cockpit of an F-16 controlled by artificial intelligence on Friday, before the plane entered a dogfight with a human-controlled plane.

Using a virtual private network to seach the internet has its pros and cons. It can provide more security and privacy. But users can be blocked from websites.

Dragon 12 is an underwater kite manufactured by Swedish company Minesto that promises to generate clean electricity deep under the sea.

The Federal Communications Commission slapped the nation's four biggest mobile carriers with fines totaling $200 million for unauthorized sharing of customer location information.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

The fully electric Atlas 2.0 robot was designed for real-world applications, and it is capable of lifting and maneuvering heavy, irregular objects.

Rather than spending time searching for the right buttons, here are a variety of keyboard shortcuts to make your workflow easier, faster and with less clutter.

High tech video cameras seem to find their way into the hands of Peeping Toms in hotels, dressing rooms and rental properties. Here's how to keep yourself safe.

If you consider Facebook's "People You May Know" section distracting, there's a way to temporarily remove it. There is no permanent way to eliminated it.

ChatGPT is an industry game-changer — here are a few simple prompts that can easily come in handy as personal and professional life hacks.

IPhones have several voice assist options available — like Siri and VoiceOver — that can help users search the web and read articles by voice.

The X1 exoskeleton is a motorized artificial intelligence-powered all-terrain device that straps to your waist and thighs for hiking climbing and running.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Hackers and scammers portray themselves as legitimate businesses or people with urgent propositions to entice victims to open compromising documents.

A decommissioned Boeing 737 that operated in Indonesia is now a luxurious private villa about 492 feet above the sea in Bali.

If you can't log in to your email account, you might want to try one of these methods to get yourself back in. Kurt “CyberGuy" Knutsson shows you how.

Kurt “CyberGuy" Knutsson introduces you to HERO-BLUE, a biomimetic, multimodal locomotion robot poised to transform underwater exploration and maintenance.

Kurt “CyberGuy" Knutsson reveals how the "Yahoo Boys" scam utilizes deepfake and face-swapping technology to trick people who believe they are in a romantic relationship.

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

Software