|
|
| Software Information |
|
|
|
|
Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer
Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Sometimes developers try to use Crystal directly to pull data from multiple database platforms - we understand the need to give you additional tips to increase Crystal report flexibility. Also common case when Crystal report should pull data from multiple database platforms. Assuming that you are creating Crystal Reports on Windows platform - we recommend you to use Microsoft SQL Server as a database access tool. 1. Use Crystal when you have your query tuned ? regardless how good Crystal Reports is - it is reporting tool - not querying environment. Tune your query first and be sure that you are pulling the right data. 2. Use SQL Server Linked Servers. Use professional tool, such as Microsoft SQL Server, where you can create linked servers to Oracle, Ctree, Btrieve, MS Access, Unidata, DB2 and other platforms. 3. Use Distributed Queries ? in the case of SQL Server - research the possibilities with OPENQUERY, OPENROWSET clauses to connect to non-SQL Server linked servers. 4. Create Stored Procedures - when you need parameters to be transferred to the SQL statement - you need stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query. 5. Report Flexibility ? when you have report based on the SQL view or stored proc - if you need to modify the data query - you don't have to change the report - you change your SQL view/ stored procedure. 6. Create SQL Query to probe the data ? again - 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. About The Author Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Great Plains Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. 1-866-528-0577! [email protected]
|
|
|
|
RELATED ARTICLES
Explore the Internet in a Whole New Way For a long time now Microsoft's Internet Explorer has ruled as 'King of Internet browsers'. Like many of Microsoft's products an initially brutal marketing campaign pushed Internet Explorer into the mainstream's consciousness and from then on it was the logical, default choice. It's free with the operating system, works well, loads any page and is easy to use. Other web browsers soon faded into obscurity and sometimes even died in the shadow of the new king of the pack. Netscape Navigator, the former 'King of the browsers', has now ceased commercial operations and has been taken over by the fan base. Opera is fading into obscurity and Mozilla was facing a similar fate, until recently. Know Linux Linux essentials: Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product ? Great Plains provides such horizontal solutions as Collection department automation. The most common question we hear in collection department is how we assign problem clients to specific collection manager and how she/he works with them one by one, simply by hitting next arrow button. This is not possible in Great Plains Accounts Payable module and this is where Collection Management module comes to the scenes. Spyware, Adware, etc. -- Terms and Common Sense When reading an article where some term is used often, it is useful to make sure the author of the article and you mean the same. Not surprisingly for those who still remember English lessons at school, every noun ending with "ware" is a mixture of objects having something in common--usually used for similar purposes. So it tends to be when "ware" is short for "software"; sometimes it's pretty tricky to define exactly what kind of software it includes and what these programs do. The End of Spyware? The US House of Representatives has recently passed the "Spy Act" - or to give it its full title - the Securely Protect Yourself Against Cyber Trespass Act. This aims to prevent software companies from installing spyware on users PCs without their knowledge, and anyone found guilty of breaching the act faces a fine of up to $3 million. Start Developing Your Own Software Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. If it were, the majority of nerds wouldn't be doing it because the defining factor of our kind is an inherent laziness. Why do you think we like computers? The heaviest thing we have to lift is a monitor and that's done fairly irregularly and for a very short period of time. Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free? Heard about the Quark "killer"? Monitoring Software Can be Used for Spying as Well We all already got used to computer monitoring both at work and at home. We got used to advertising monitoring software products as tools for parental control and workplace surveillance. Outlook... Not Just for Email! Using Your Outlook Calendar Microsoft Outlook is one of the most widely used software programs for email, but if you're only using it for email, you're missing out on a great productivity tool! This month's column looks at a few ways you can use the Outlook calendar to make scheduling easier. Should I Use Windows Update? Should one use Windows Update? 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 Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0 Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th ? the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6.5, 7.0 and 2000 ? we see more historical custom projects done in SQL stored procedures and front ends coded in VB in Visual Studio 6.0. This was probably wise and natural choice in that time (around 1997-2001), but if you consider Microsoft move to .Net platform and reshaping its own programming environments (ADO, OLE, VB, etc) ? you would nowadays rather be nervous relying on VB 6.0 custom front end, calling stored procs via ADO. Let's consider your options: Microsoft Great Plains Integration Manager ? Working With Text File Microsoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. You certainly can deploy such SDK tools as eConnect. However here we would like to show you how to program the simplest user friendly tool: Microsoft Great Plains Integration Manager. Multiple times in our consulting practice we saw the need to integrate General Ledger transactions from one text file and here we give you this and even more complex case, when credit and debit amounts are present on the same line with their own account numbers. Let's assume that we have tab delimited text file, GLSOURCE.txt. Here is how the line looks: Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes Microsoft Great Plains fits to majority of industries, in the case of Chemicals & Paint you should consider implementation with balanced approach of utilizing existing Great Plains standard module and light customization and reporting with Great Plains Dexterity, MS SQL Server stored procedures, Modifier/VBA and direct .Net publishing from Great Plains Company database. Let's consider industry requirements and their implementation in Microsoft Great Plains: 5 Mac Security Tips You Can?t Live Without So, you've bought a new Macintosh, and now you may be wondering how to make it safer. There are several things that you can do which will protect your Mac from viruses and hackers. Macs are already very difficult to hack, but don't let that fact allow you to become lenient with your security. EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr Microsoft Great Plains - Microsoft Business Solutions accounting and ERP system, originally targeted to mid-size - now, with advancements and increasing reliability of its database - Microsoft SQL Server, Great Plains is attractive solution for large corporation. Big companies usually have purchasing and order processing automation via so-called Electronic Document Interchange or EDI. EDI was introduced long time ago for UNIX systems and in most of the cases appears in the form of Header, Lines and Trailer of predefined fixed position fields. How Do I Get Rid Of That Darn Spyware? Ad-Aware and Spybot are probably the two most well known antispyware solutions. However, they frequently fail to catch the more crafty spyware. Here is a list of five solutions known to get rid of the problem when all others fail. Dont Choose Adobe When Working With PDF While Adobe is the most known maker of PDF tools, your business will be much better off, if you select third party tools to work with PDF documents. Make or Break Factors - When Considering Estimating Software Make-or-Break Factors in Success and Profitability What Stands Behind The Software Description? With thousands of web pages added to the Net every day, it's getting more and more frustrating both to submit the information to the attention of those, who are interested in it and to find the information one needs.
|
| home | site map |
| © 2005 |