| Home | Links |
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
Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012 Reuters SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ... Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ... Advent Software's CEO Discusses Q4 2011 Results - Earnings Call Transcript Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick Facts |
Scorpion Software Announces AuthAnvil Single Sign On Support for Level ... San Francisco Chronicle (press release) Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ... Scorpion Software Offers Support for Level Platforms Managed Workplace |
Caduceus Software Plans to Integrate a Cloud Platform with its Software ... SmallCap Network By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems. Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ... QualityStocks News - Caduceus Software Systems Provides Update on Current ... |
Proposal Software Continues Strong SaaS Revenue Growth in 2011 MarketWatch (press release) WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ... |
Manhattan Software Announces Strategic Partnership With Indiabulls for ... MarketWatch (press release) 6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ... |
Mezeo Software Announces National Master Distributor for Japan MarketWatch (press release) HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ... |
The Cloud Software Companies You Need to Know About Motley Fool But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ... |
Is BMC Software Growing or Slowing? DailyFinance By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ... |
Oakland police get free forensic software to analyze Occupy videos San Francisco Chronicle (blog) A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ... |
Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc MarketWatch (press release) MAYNARD, Mass., Feb 06, 2012 (BUSINESS WIRE) -- Longwood Software, Inc., the developers and marketers of the RevBase(R) software-as-a-service (SaaS) marketing asset management system ( www.revbase.com ), announced today a strategic reseller agreement ... |
Google News
Related Articles
Removing Incoming Email in MS Exchange, C# Example
The purpose of one of our projects was MS Exchange handler for processing incoming email.
Microsoft Great Plains Inventory Control ? Overview For Consultant
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features.
Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant
Microsoft Great Plains ? ERM from Microsoft Business Solutions and formerly Great Plains Software is pretty generic with its standard set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization history ? Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Dexterity written application has been and still is attractive core platform for third party software development companies to write vertical and horizontal modules, written as well in Great Plains Dexterity. If you have Microsoft Great Plains implemented or under the implementation should have your options in making in-house or outsourced customizations to fit your vertical industry needs. Let's consider consignment, barcoding and distribution/warehouse management
Reloading Windows XP
If you have been running Windows XP for a couple of years or more you may find that it is not running quite as quickly and smoothly as it was when you did your first install. I am constantly 'evaluating' software and uninstalling and reinstalling beta software on my computer and have always gradually become more and more disappointed after nine months to a year with the performance of my PC. So I regularly do a backup and reinstall all my software, including Windows.
Imagine if Everyone Working In Your Office Was In Synch?
Microsoft-Outlook is a pretty amazing program. So much more than simply an e-mail client, it provides a task list, a powerful calendar with recurring scheduling capabilities, wonderful electronic sticky notes, mail-merge capability with MS-Word support and so much more.
Vlans
In order to implement VLANs in a network environment, you'll need a Layer 2 switch that supports them. Almost all switches sold today that are described as "managed" switches provide the ability to make ports members of different VLANs. However, switches that don't provide any configuration function (such as many basic, lower-end switches) don't provide the ability to configure VLANs. Almost any Cisco Catalyst switch that you'll come across today provides the ability to make ports part of different VLANs.
Collaboration Software: Index of Collaboration Software Technologies
Collaboration Software
Falling in Love With More Than One Screensaver: The Fun Part
Having from five to ten and more favorite screensavers is cool. But how do you enjoy them all in a straightforward and convenient way? Draw the power you need from the little yet useful tools discussed in this article!
Lowering The Risks In Developing Do-It-Yourself Software Projects
Mike Dunville* had a decision to make. As the new operations manager for Alpha Staffing, he wanted to make a difference at the dynamic staffing firm. The principals of the firm had charged him with making the day-to-day operations run smoothly and efficiently while they concentrated on growing the business in today's challenging economy.
10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now
Is Photoshop CS2 worth the upgrade? You bet it is! Here are just 10 things you can do with this fantastic new version of Photoshop that were impossible (or difficult) to do with previous versions:
Computer Based Language Development and Spell-checking
Language development computer: Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.
Crystal Reports for Microsoft Great Plains ? Overview for Developer
Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market. It serves the whole of vertical and horizontal market: most of the industries and company sizes. Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc. If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated ? read this and you will have the clues on where to look further. Great Plains Tables Structure ? first of all you need to know the tables to link. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc. Create ODBC connection to GP Company database. Use the same technique as when you create standard ODBC connection for GP workstation ? but change default database to targeted company database. Consider SQL Views ? if you don't want complex links in Crystal Report itself or if you need unionization from several companies ? SQL view is the answer. Consider SQL Stored Procedures. Sometimes you can not pull the data in one view ? you need temporary tables to be created and the final query should be based on these temp tables ? this is when you need stored procedure. Call Crystal Report from GP Screens via VBA/Modifier ? if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window ? you can use Modifier and VBA to call Crystal Reports engine. Create SQL Query to probe the data ? we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query. Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
Ukraine IT Myths Dispersed
While Ukraine is becoming a new popular IT outsourcing destination, there are still many myths about it and no clear understanding of the opportunities outsourcing to Ukraine can present. Let us look closely at some of those myths and find out whether there is any truth behind them.
Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist
There are certain pluses and minuses in both cases and you should make your decision, based on your company needs. We'll give you some hints in this subject and you should know then where to look further.
Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM require existing customer to be on active service contract: enhancement program. Minimal maintenance plan gives you free new software version (however upgrade itself, if it is done by your MBS partner is not free). If you are outside of USA/Canada: Mexico, South America, UK, South Africa, France, Australia, New Zealand ? you may have different promotion campaigns and might be not required to be on the service contract. In this article we assume that you are US/Canadian client.
Microsoft Great Plains Integrations ? Retail Management Sample
Microsoft Business Solutions is emerging as very attractive vendor for mid-size companies. The strength of its products is in their cross integration potential. This integration strategy will be the software development direction for this Microsoft subdivision. Meanwhile, as of right now ? we have to recommend just to stake on it and deal with custom or in-house developed integration.
eCommerce development for Microsoft Great Plains: tools and highlights for programmer
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on Mac and PC ? Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure:
A Time-Saving Programming Tactic that Doesn?t Work
Let's say that you have a software project that's under severe time pressure. Let's say that this deadline is so tight that you already know it will involve many late nights of black coffee and frenetic programming. What can you do to make this process go faster?
Story Development Software: Good or Evil?
In the early days of the personal computer, we're talking the mid-'80s here, there was speculation that someday books would all be writen by computers. It sounded a little too science-fictiony for most writers. After all, words on a page---no matter how well they appear to work together---are meaningless without the insights and experiences of the writer behind them.
Microsoft Small Business Manager eCommerce ? Overview
Microsoft Business Solutions Small Business Manager is scaled down Great Plains Dexterity based version of Microsoft Great Plains or former Great Plains Dynamics/eEnterprise. Small Business Manager first release 7.0 and all the following version was available on MSDE (MS SQL Server 2000 with limited usage and database size ? 2GB maximum). It is nice situation on the market in eCommerce niche ? we see huge number of customers, who have purchased and implemented SBM for their small and mid-size businesses and then realized that customization options for Small Business Manager are very limited: in comparison to Great Plains SBM doesn't have VBA/Modifier, it has very restricted version of Integration Manager. These restrictions lead you, eCommerce developer to direct SQL programming. Again ? being scaled down version of Microsoft Great Plains ? Small Business Manager has a legacy of relatively complex tables structure. tom stored procedures way here:
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.