Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. 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 1-866-528-0577! [email protected]

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.

[email protected]

In The News:


The Register

Green software blacked out Australian State
The Register
Something good is going to come out of last year's “Black System” in the Australian State of South Australia: the global wind power industry has learned how to do better modelling for systems under attack from repeated failures. South Australia last ...

and more »

TNW

3 software development trends you don't want to miss
TNW
This has led to more and more companies adopting team chat applications to assist in conducting key business operations, including the building and shipping software applications. Interacting with your team members using a chat application is only ...


New York Times

Software Engineer Starts Unlikely Business: A Weekly Newspaper
New York Times
The investment — by a software engineer who studied artificial intelligence, no less — seems like a quixotic one when so many newspapers are struggling and many readers prefer to catch up on town news on Facebook. But the engineer, Heeten Choxi, ...

and more »

Siemens' software donation to benefit Connecticut community college students
New Haven Register
The intial befeficiaries of Siemens' product lifecycle management software will be students in the Advanced Manufacturing Technology Centers at Three Rivers, Manchester, Asnuntuck and Gateway community colleges. Use of the software Siemens is making ...
Siemens Gives Community Colleges $315 Million Worth of Advanced Manufacturing SoftwareHartford Courant

all 4 news articles »

Brownwood Bulletin

Commissioners OK use of forfeiture funds for prosecutors' software
Brownwood Bulletin
Brown County Commissioners Court members on Monday authorized District Attorney Micheal Murray's office to spend just over $94,000 in forfeiture funds to buy software and equipment that will streamline the process of providing discovery to defense ...
Brown County DA getting new software to increase transparencyKTXS

all 2 news articles »

PCWorld

Switching from Mac to PC, Part 3: The software challenge | PCWorld
PCWorld
When you switch from Mac to PC, you'll be leaving some software behind. We've found some solid replacements.

and more »

GeekWire

How this legal software startup used its funding round to support legal aid under Trump budget cuts
GeekWire
But MetaJure, a Seattle startup that provides software to help lawyers manage their documents and email, is starting early. As early as the company's Series A funding round, in fact. MetaJure used its $2.6 million round as an opportunity for what its ...

and more »

Market Realist

How BBM Enterprise Could Impact BlackBerry's Software Business
Market Realist
By opening BBM Enterprise SDK (software development kit) to third-party developers, BlackBerry has also unlocked a new revenue stream in its Software and Services segment. The company could take a cut from the sales of third-party apps integrated with ...

and more »

Daily Mail

The 'magic carpet' software that helps fighter jet pilots make a perfect landing on a warship in ANY conditions
Daily Mail
The US Navy has revealed a radical new system allowing fighter pilots to land on deck safely. Called 'Magic Carpet' the software is being tested by F/A-18E/F Super Hornet and EA-18G Growler pilots across the Navy's fleet. It effectively acts as an ...

and more »

9 to 5 Mac

Apple rolling out macOS 10.12.4 software update with Night Shift for Mac
9 to 5 Mac
funny, that you mention case sensitivity. That is actually the biggest reason why I want APFS as soon as possible, because I'd really like a case sensitive filesystem for web development. I tried using HFS+ in it's case sensitive mode but a lot of ...

and more »
Google News

5 Mac Security Tips You Can?t Live Without

So, you've bought a new Macintosh, and now you may... Read More

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

The Hidden Power of Online Manual

Writing software manuals is boring, isn't it? We often think:... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Microsoft CRM: Implementation, Customization, Support ? Consultant Overview

Microsoft Business Solutions CRM is present several years on the... Read More

Great Plains Dexterity History and Programming Overview

As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

I've been active in the Cisco Certification track for four... Read More

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

Free Software - Powerful Alternatives to Budget-Busting Software

When you buy a computer, it most likely comes with... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More