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

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.

akarasev@albaspectrum.com

MORE RESOURCES:

Elliott Terminates Tender Offer to Acquire Epicor Software Corporation - MarketWatch

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/0i-0fd=Rurl=http://www.earthtimes.org/articles/show/epicor-comments-on-the-termination-of-elliott-associatesrsquo-tender-offer,632860.shtmlcid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNFo70IEW923J9_qW2lRztAw_kjEYwimg src=http://news.google.com/news?imgefp=-zwqhIcofgUJimgurl=www.earthtimes.org/newsimage/Bus_20081121191102_35.jpg width=80 height=80 alt= border=1brfont size=-2Earthtimes (press release)/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/0-0fd=Rurl=http://www.marketwatch.com/news/story/Elliott-Terminates-Tender-Offer-Acquire/story.aspx%3Fguid%3D%257B715050E5-AD0A-4808-A8D6-38ED8DF5BC63%257Dcid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNHiK_pTxMOOAa_OkpCtHYA_C_MMPgElliott Terminates Tender Offer to Acquire Epicor bSoftware/b Corporation/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr16 hours ago/nobr/fontbrfont size=-1b.../b LP and Elliott International, LP (collectively, quot;Elliottquot; or quot;wequot;), a major shareholder of Epicor bSoftware/b Corporation (the quot;Companyquot; or quot;Epicorquot;), b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-1fd=Rurl=http://www.forbes.com/feeds/ap/2008/11/21/ap5729568.htmlcid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNF8wiwEeE22YcvGVKIutuT4w7qFTAEpicor drops after hedge fund ends hostile bid/a font size=-1 color=#6f6f6fnobrForbes/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-2fd=Rurl=http://www.ocbj.com/industry_article.asp%3FaID%3D75658381.8793711.1711307.8237208.5233255.264%26aID2%3D131630cid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNFFNmIKiRk8HUThPE6zMNXI3wlmGwHedge Fund Elliott Associates Withdraws Offer for Epicor bSoftware/b/a font size=-1 color=#6f6f6fnobrOrange County Business Journal/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-3fd=Rurl=http://www.reuters.com/article/mergersNews/idUSBNG18344320081121cid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNFRFaSSEVQhgvXmNlGnqOSoric2-QUPDATE 1-Hedge Fund ends offer for Epicor/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/0-4fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782142%26SMap%3D1cid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNF0J6pvoCnhsNlNqxYjV4GHkSeopAnobrRTT News/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/0-5fd=Rurl=http://blogs.barrons.com/techtraderdaily/2008/11/21/epicor-elliott-associates-drops-bid-stock-tumbles/cid=1272902427ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNH2MNLhW5HYDa2BkHAGuoMA_bxJxgnobrBarron's Blogs/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272902427hl=ennobrall 44 news articles/nobr/a/font/div/font/td/tr/table

The best thing about the 2.2 iPhone software update - CNET News

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/1i-0fd=Rurl=http://gadgetwise.blogs.nytimes.com/2008/11/21/picture-google-street-view-on-the-iphone/cid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNEq_0VmblazQuMUJq1qzMyDyYOKLwimg src=http://news.google.com/news?imgefp=DbM9qO9EamEJimgurl=graphics8.nytimes.com/images/2008/11/21/technology/personaltech/iphonemap2.480.jpg width=80 height=32 alt= border=1brfont size=-2New York Times/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/1-0fd=Rurl=http://news.cnet.com/8301-17938_105-10105305-1.htmlcid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNHvzIzsO8d0pIgc7pch0YYFYOx_yAThe best thing about the 2.2 iPhone bsoftware/b update/abrfont size=-1font color=#6f6f6fCNET News,nbsp;CAnbsp;-/font nobr9 hours ago/nobr/fontbrfont size=-1When it some to iPhone bsoftware/b updates, I#39;m all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-1fd=Rurl=http://www.crn.com/networking/212101415cid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNEhHCNUj-P9ergx9-0-E9UfXkd4wwFirst Look: Apple#39;s iPhone 2.2 bSoftware/b Hits The Street (And b.../b/a font size=-1 color=#6f6f6fnobrCRN/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-2fd=Rurl=http://arstechnica.com/news.ars/post/20081121-lots-to-like-about-new-iphone-2-2-software-update.htmlcid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNHQoisc53tQDIblhvM7j_owAbN9zwLots to like about new iPhone 2.2 bsoftware/b update/a font size=-1 color=#6f6f6fnobrArs Technica/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-3fd=Rurl=http://www.appleinsider.com/articles/08/11/21/apple_releases_iphone_software_v2_2.htmlcid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNGX4ntyZPqBt5Scvi315LQMUubJvgApple releases iPhone bSoftware/b v2.2/a font size=-1 color=#6f6f6fnobrApple Insider/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/1-4fd=Rurl=http://www.g4tv.com/thefeed/blog/post/691179/iPhone_Software_Update_22_Out_NOW.htmlcid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNES6v35qO8zf4HbO2ydHWuojJxOegnobrG4 TV/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/1-5fd=Rurl=http://www.infosyncworld.com/news/n/9932.htmlcid=1272850889ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNGJLDsIQ4xEcEuN8piPN8mDqN6CUQnobrinfoSync World/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272850889hl=ennobrall 119 news articles/nobr/a/font/div/font/td/tr/table

Microsoft to offer free security software to attract beginners - eTaiwan News

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/2i-0fd=Rurl=http://www.canada.com/topics/technology/news/gizmos/story.html%3Fid%3Dacb3b045-9d46-4f3b-aa25-5447dd34d5b6cid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNGBaarZ6dZsyn6jQQoM7Zyss3PAkgimg src=http://news.google.com/news?imgefp=2UkyZbz6Tp0Jimgurl=a123.g.akamai.net/f/123/12465/1d/media.canada.com/reuters/olustech_iptc/2008-10-28t011803z_01_btre49r03ot00_rtroptp_2_tech-us-china-microsoft.jpg%3Fsize%3Dl width=80 height=80 alt= border=1brfont size=-2Canada.com/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/2-0fd=Rurl=http://www.etaiwannews.com/etn/news_content.php%3Fid%3D794127%26lang%3Deng_newscid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNEZDQOOBJFSqn3C6YYpnm9QSRMyJQMicrosoft to offer free security bsoftware/b to attract beginners/abrfont size=-1font color=#6f6f6feTaiwan News,nbsp;Taiwannbsp;-/font nobr18 hours ago/nobr/fontbrfont size=-119 to stop selling personal computer security bsoftware/b and to use free personal anti-virus bsoftware/b instead. The new bsoftware/b called Morro can support seven b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-1fd=Rurl=http://voices.washingtonpost.com/securityfix/2008/11/spamhaus_microsoft_now_5th_mos.html%3Fnav%3Drss_blogcid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNEC-eb3mrvHpON-SGZSx-uBI14RzwSpamhaus: Microsoft Now 5th Most Spam Friendly ISP/a font size=-1 color=#6f6f6fnobrWashington Post/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-2fd=Rurl=http://www.reuters.com/article/technologyNews/idUSTRE4AI7T420081119cid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNGuOP6utI4cQUfRyNRbloS-OqQa2AMicrosoft: New bsoftware/b not Symantec, McAfee rival/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-3fd=Rurl=http://www.networkworld.com/news/2008/111808-microsoft-drops-onecare-antivirus.html%3Ft51hbcid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNFmZh99rbOoq_qPmsVM0fiw14OXHQMicrosoft to offer free security bsoftware/b/a font size=-1 color=#6f6f6fnobrNetworkWorld.com/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/2-4fd=Rurl=http://www.allheadlinenews.com/articles/7013120895cid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNEJFznYtIo8Ih625HIpamusoJzBCQnobrAHN/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/2-5fd=Rurl=http://online.wsj.com/article/SB122706587967940197.html%3Fmod%3Dgooglenews_wsjcid=1272030386ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNFOHQ0NZUxn7siuBMJ0YiqEYWN0XgnobrWall Street Journal/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272030386hl=ennobrall 304 news articles/nobr/a/font/div/font/td/tr/table

Traction Software Introduces Live Blog Micro-Messaging and End-of ... - MarketWatch

Hann’s On Software bouht by Mediware - Bizjournals.com

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/4-0fd=Rurl=http://www.bizjournals.com/sanfrancisco/stories/2008/11/17/daily94.htmlcid=1272927325ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNHYDDnr04S9XkjuDqkIt5yiItnyiwHann’s On bSoftware/b bouht by Mediware/abrfont size=-1font color=#6f6f6fBizjournals.com,nbsp;NCnbsp;-/font nobr11 hours ago/nobr/fontbrfont size=-1Mediware Information Systems Inc. has bought the assets of Hann’s On bSoftware/b, a pharmacy-management bsoftware/b provider based in Santa Rosa, for $3.5 million b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-1fd=Rurl=http://www.marketwatch.com/news/story/Mediware-Acquisition-Adds-320-Pharmacy/story.aspx%3Fguid%3D%257BD97D6EA2-0A06-49FD-BE33-0A9811CA460D%257Dcid=1272927325ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNHqZ6owNGFPGd9X9aiW5Gi3ndlhGgMediware Acquisition Adds 320 Pharmacy Facilities/a font size=-1 color=#6f6f6fnobrMarketWatch/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-2fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782712%26SMap%3D1cid=1272927325ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNHkSczWaMvcrA_iVZBpGXbNWP-wUAMediware Information buys assets of Hann#39;s On bSoftware/b - Quick Facts/a font size=-1 color=#6f6f6fnobrRTT News/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-3fd=Rurl=http://www.ibtimes.com/prnews/20081121/pharmacy-software.htmcid=1272927325ei=VI4nSbSXB4u-9gSkwFAusg=AFQjCNFO73OizUHwutexY2lxjtcEXyhvPQMediware Acquisition Adds 320 Pharmacy Facilities/a font size=-1 color=#6f6f6fnobrInternational Business Times/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272927325hl=ennobrall 19 news articles/nobr/a/font/div/font/td/tr/table

Vertical Releases Feature-Rich Software Update for Wave - MarketWatch

PAR Technology Corporation Releases Next Version of SpaSoft(R) Spa ... - MarketWatch

Progress Software and QAD Propose A Formula for The Perfect Lean ... - MarketWatch

DR Systems to Feature Software-Only, Enterprise Web-PACS for ... - MarketWatch

Check Point Software Announces Participation in Fourth Quarter ... - MarketWatch

Software - Google News

RELATED ARTICLES

Cisco Certification: Five Things To Do DURING Your CCNA Exam
There are plenty of articles out there about how to prepare for the CCNA exam.� However, there are also things you can do to increase your chances of success on exam day during the most important part of the entire process -- the time that you're actually taking the test.

HelpDesk & Asset Management Software - Choosing The Right One
If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole).

The Death of Windows
I have always regretted how Microsoft price gouges and rips off computer users. I really regret Windows XP activation.

Helping Newbies Understand Professional Software
The Windows registry is a huge database that ensures normal computer operation. Installing and uninstalling software can make your registry a mess, leading to decreased PC performance and causing computer crashes.

Microsoft Business Solutions Customization Options - Overview for Programmer
Several years ago Microsoft purchased Great Plains Software, then Navision (Denmark based software development company). At this time Great Plains Software already was active ERP applications consolidation player - it already acquired Solomon Software couple of years prior.

Microsoft Great Plains eCommerce - Stored Procedures Approach
Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB).

Microsoft CRM Customization - Processing In/Out-Going Email Messages
We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator.

Three Steps To Windows Safety Heaven
Now there are Three Steps To HeavenJust listen and you will plainly seeHow virus and hackers attack and destroyYour precious internet-connected computer toyJust follow steps one, two and threeStep one - Run windows update automatically each dayStep Two - Always keep your antivirus running and updatedStep Three - Install and configure a firewallFaster VirusToday can many viruses find and infect a computer connecting to internet in less then 5 minutes, even if the computer connects to internet using a modem. And how much time will the 24/7 connected computer not give the bad guys?So leaving a computer without proper protection is not advisable.

Collaboration Software: Index of Collaboration Software Technologies
Collaboration SoftwareCollaboration Software, also known as group collaboration software or groupware, is software which allows cooperation on a business document between multiple parties on multiple computers. Collaboration software also allows the integration and merging of document changes and versions on a business document.

OEComplete - A Personal Information Manager
OEComplete is a utility for managing the personal information of the user. It is designed to be flexible and affordable even for the home user.

Linux - Keyboard Or Mouse
Just stress testing one of the latest Linux distributions. Been testing it for about two months.

Microsoft Great Plains: Dexterity vs. eConnect - FAQ
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise was originally written in IDE and programming language - Great Plains Dexterity. Currently Microsoft is on the way of transforming its ERP applications: Great Plains, Navision, Solomon, Axapta and MS CRM to be better integrated and fit into the future of its .

Anti-Virus Software
Anti-virus software is used to find, remove or fix files that are infected with computer viruses. Most anti-virus companies release weekly updates of their databases to help keep you safe.

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?
Many reasons made GBM a unanimous choice for experts, one of them is the fact that with the set of features it offers, it's definitely the easiest to use."Genie Backup Manager Professional has a clear, simple interface which lets you manage the application without problems and in just a few minutes," the UK's Personal Computer World (PCW) stated in its Feb 2005 review of GBM, in which it selected the application for its Highly Recommended award.

Cross-Platform Custom Software Development & Integration - IT Strategy for Large Corporation
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta, MS RMS integration with UNIX/Java based platforms & non-Microsoft applications: Oracle, Lotus Notes/Domino, DBII, PeopleSoft, SAPThe history of software application development indicates that global trends to unification might be reversed in the future. If you take a look at C programming language, intended as cross platform solution (which resolves graphical interface cross platform migration).

Selecting Corporate ERP: Microsoft Business Solutions Great Plains - Estimation Parameters
As we could imagine, if you are reading this article - you are in the decision making mode, probably replacing legacy system with the new one or abandoning either Unix/Mainframe or Apple direction for your corporation. In any case, nobody should make an outside influence on your decision - you should be maximally objective.

Lotus Notes Domino and Microsoft CRM Integration
Well, even if the combination might look very unusual, we see the coexistence of these two systems, especially in large corporations, non-profit organizations. Technically Lotus Notes Domino has parallel structure, including Domino email server.

Benefits of Shareware
Shareware has been fighting the stigma of being misunderstood for decades. While corporate software giants can no longer ignore the marketing potential of a trial version, small software startups are struggling with new listings and bandwidth costs.

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL
Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Now Microsoft Business Solutions offers following ERP applications: Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta.

Demand More From Your Lead Tracking Software
An integral part of any quality CRM system is lead tracking software. This is the part of the system that helps you gather customer data from your sales force.