 |
Further
Reading ...
|
|
Writing Helpful Help – A Minimalism Checklist
User documentation is all too often written by programmers for programmers. It tends to focus on the product’s features, rather than the user’s tasks. Generally, programmers aren’t in the ideal position to be writing user documentation. They’re...
Finding The Right Log Analyzer
A log analyzer is an essential part of many websites. It basically tells you what is happening on your website. Do you want to know where your website's visitors go and what they do? If you are an ecommerce merchant it can be quite important to know...
HOW TO TURN YOUR OLD ARTICLES INTO A PROFITABLE E-MAIL WORKSHOP!
If you've written numerous articles, you can use them to further promote yourself and your business, e-zine or web site. You can re-use your old articles by transforming them into another form of promotional tool. And one way to re-use them is...
Password Policy
Modern corporate life means due dilegence, adhering to legislation, and many other distractions from the core business of an organisation. Where computers are concerned, there is potential for abuse of corporate systems, infection of corporate...
|
|
|
Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve – tips for developer
|
 |
Written By:
Andrew Karasev
|
|
|
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 - continued below ...
|
|
|
continued ...
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 1-866-528-0577! help@albaspectrum.com
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.
akarasev@albaspectrum.com
|
|
|
|
 |
|
|
| _Additional Resources ... |
|
IKANO Communications Secures $16.5 Million in Funding
SALT LAKE CITY, UT – IKANO Communications, the nation’s largest provider of private-label Internet services, announced that it has secured a $16.5 million credit facility from Hercules Technology Growth Capital Inc. IKANO has entered into the...
Speeds Explained
So how fast is your internet connection anyway? Yeah, I know that many companies now (especially DSL - for more information see http://www.internet-tips.net/System/DSL.htm, and cable) are advertising speeds of upwards of a megabit or more. Well,...
Microsoft CRM Integration & Customization: SharePoint Document Gateway
MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. In this small article we describe the solution...
|
|
|
|
|
|
|
|
|
|
