Developer(s) | SAP SE |
---|---|
Operating system | Windows |
Available in | English, French, German, Japanese, Spanish, Simplified Chinese, Italian ,Dutch ,Russian, Korean, Traditional Chinese, Portuguese, Swedish, Polish, Danish, Norwegian, Finnish, Thai, Czech, Hungarian, Slovakian, Turkish, Romanian, Slovenian, Arabic, Hebrew, Ukrainian, Kazakh |
Type | Reporting software |
License | Trialware |
Website | www.crystalreports.com |
Crystal Reports is a business intelligence application, currently marketed to small businesses[1] by SAP SE.
- 3Features
History[edit]
Terry Cunningham and the Cunningham Group originated the software in 1991.[2] Crystal Services Inc. marketed the product[3] (originally called 'Quik Reports') when they couldn't find a suitable commercial report writer for their accounting software.[citation needed] After producing versions 1.0 through 3.0, Crystal Services was acquired by Seagate Technology in 1994.[4] Crystal Services was combined with Holistic Systems to form the Information Management Group of Seagate Software, which later rebranded as Crystal Decisions and produced versions 4.0 through 9.0. Crystal Decisions was acquired in December 2003 by BusinessObjects, which produced versions 10, 11 (XI) and version 12 (2008). SAP acquired BusinessObjects on October 8, 2007 and released Crystal Reports 2011 (version 14) on May 3, 2011.
Several other applications, including Microsoft Visual Studio versions 2003 through 2008, and Borland Delphi, at one time bundled an OEM version of Crystal Reports as a general purpose reporting tool.[5] Microsoft discontinued this practice and later released their own competing reporting tool, SQL Server Reporting Services (SSRS).[6][verification needed]
Versions and editions[edit]
Version | Release Date[7] | Ownership | Edition |
---|---|---|---|
1 | Crystal Services | ||
2 | 1992 | Crystal Services | |
3 | 1994 | Crystal Services | |
4 | 1995 | Crystal Decisions | |
5 | 1996 | Crystal Decisions | |
6 | 1997 | Crystal Decisions | |
7 | 1998 | Crystal Decisions | |
8 | 2000 | Crystal Decisions | D,P,S |
8.5 | 2001 | Crystal Decisions | A,D,P,S |
9 | 2002 | Crystal Decisions | A,D,P,S |
10 | 2003 | BusinessObjects | A,D,P,S |
XI (11) | 2004 | Business Objects | D,P,S |
XI R2 (11.5) | Nov 24, 2005 | Business Objects | D,P,S |
2008 (12) | Mar 31, 2008 | Business Objects | D |
2011 (14.0.x) | Aug 31, 2011 | SAP SE | D |
2013 (14.1.x) | Aug 29, 2013 | SAP SE | D |
2016 (14.2.x) | Mar 08, 2016 | SAP SE | D |
- A=Advanced Developer, D=Developer, P=Professional, S=Standard[8]
Features[edit]
Report designer[edit]
Crystal Reports allows users to graphically design data connection(s) and report layout. In the Database Expert, users can select and link tables from a wide variety of data sources, including Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server databases, Microsoft Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Formulas can be evaluated at several phases during report generation as specified by the developer.
Both fields and formulas have a wide array of formatting options available, which designers can apply absolutely or conditionally. The data can be grouped into bands, each of which can be split further and conditionally suppressed as needed. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
Central Management Server[edit]
The Central Management Server (CMS, formerly 'Crystal Management Server') operates as the main server for BusinessObjects XI.[9]
Supported data sources[edit]
- Databases such as PostgreSQL, Sybase, IBM DB2, Ingres, Microsoft Access, Microsoft SQL Server, MySQL, Interbase, Btrieve, Informix, Oracle and Salesforce.[10]
- Spreadsheets such as Microsoft Excel
- XML Files
- Groupware applications as Lotus Notes, Microsoft Exchange and Novell GroupWise
- APIs such as ODBC and OLE DB[11]
- SAP: BW, Info Sets, Tables, and BusinessObjects Universes
Target audience[edit]
Crystal Report Version 10.5 Free Download
Crystal Reports came integrated with Visual Studio versions prior to 2010. Crystal Reports competes with several products in the Microsoft market, such as SQL Server Reporting Services, XtraReports, ActiveReports and List & Label. Users can also access Crystal Reports from outside of Microsoft environments; this allows (for instance) Java developers to build applications with Crystal Reports components.
See also[edit]
References[edit]
Crystal Reports Version 10 Iso
- ^Crystal Reports small business marketing website
- ^'Meet the Team'. Indicee. Retrieved 2012-10-11.
That's what initially motivated his family business, The Cunningham Group, and his brother Terry to begin building… Crystal Reports in 1991.
- ^'Crystal Reports links dBASE and Paradox data'. Data Based Advisor. Access my library. September 1, 1992. Retrieved 2009-07-09.
Crystal Services says that they will address both the installation problem and the documentation omission in the new version. …Crystal Reports is being marketed by them and Borland International…
- ^'Seagate to acquire Crystal Services'. San Jose Mercury News. News bank. 1994-05-11. Retrieved 2009-04-14.
- ^Peck, George (2008). Crystal Reports 2008: The Complete Reference. McGraw-Hill Professional. p. 566. ISBN978-0-07-159098-3. Retrieved 2009-07-09.
Not only was Crystal Reports bundled with earlier versions of Visual Basic…, but every Professional or higher version of VS.NET, up to and including Visual Studio 2008, includes an option to install Crystal Reports as well…
- ^'Support for Crystal Reports for Visual Studio'. Support (knowledge base). Microsoft.
- ^Short history and resources for Crystal Reports Software Developer Kits (SDK)
- ^'Crystal Reports family of offerings. Features by edition comparison chart'(PDF). SAP. 2009.
- ^Ganz, Carl (2006). Pro Crystal Enterprise / BusinessObjects XI Programming. Expert's voice in .NET. Apress. p. 22. ISBN9781430202776. Retrieved 2014-09-25.
The aptly named Central Management Server (CMS) is the main server in the BO XI collection. Before the rebranding effort, it was known as the Crystal Management Server, and before that as the Automated Process Scheduler (APS).
- ^Compare for example: 'Crystal Reports Server 2008 V1 Service Pack 4 for Windows: Supported Platforms'. SAP Community Network. SAP. 2012-02-15. pp. 8ff. Retrieved 2015-07-28.
Supported Data Sources for Crystal Reports
- ^Fitzgerald, Neil (2008). Crystal Reports 2008 Official Guide. Business Objects Press. Pearson Education. ISBN9780768685701. Retrieved 2015-07-27.
The two major indirect access drivers provided are ODBC and OLE DB. [..] The Crystal Reports ODBC database driver communicates with an ODBC driver, which in turn communicates with the actual database. The database vendors generally develop the ODBC drivers, which often come bundled with the database software.
Bibliography[edit]
- G. Taylor, Allen (June 3, 2008). Crystal Reports 2008 For Dummies (1st ed.). For Dummies. p. 396. ISBN0-470-29077-3.
- Peck, George (June 19, 2008). Crystal Reports 2008: The Complete Reference (1st ed.). McGraw-Hill Osborne Media. p. 968. ISBN0-07-159098-6.
- McCoy, Cate; Maric, Gord (2002). Mastering Crystal Reports 9 (1st ed.). Sybex. p. 639. ISBN0-7821-4173-0.
External links[edit]
Hello all!
The Crystal Reports product team is happy to announce the production release of SAP Crystal Reports for Visual Studio 2010.
You can download the release packages from the following locations:
- Complete Package (EXE) – Standard EXE installation package which installs SAP Crystal Reports for Visual Studio into the Visual Studio 2010 IDE
- Click Once – Click-Once installation package used to create self-updatin Windows-based applications which can be installed and run with minimal user interaction. For more details see here.
- Merge Modules – Merge Modules installation package used to install components which are shared by multiple applications. For more details see here.
After downloading the appropriate package(s), you can also review the What’s New guide, details about Crystal Reports for Visual Studio 2010 Licensing, and the Supported Platforms guide.
In addition, we have made a few videos available. You can access those via the following links:
Crystal Reports in Visual Studio 2010 explains what has changed in this release of SAP Crystal Reports for Visual Studio.
We look forward to hearing about your experience with SAP Crystal Reports for Visual Studio 2010. For support, please visit the SAP Crystal Reports, version for Visual Studio.
The Problem:
We have a software-project coded in C#/.Net with report functions builded on Crystal Reports. This project worked for years with this functions until someday it came to a strange error. If the project was installed on a 64-Bit Windows System Crystal Reports won't log in into the Report-Viewer. This means, before the report was shown to the user, there will be a window, in which you have to insert your credentials of your Database. Sadly after giving the credentials, no login will be performed, instead there will be a message telling the user that the login failed. And after that the login box returns. It doesn't matter, what you insert into the password or user field, there won't be a login.
Well, this error could be solved by installing the 32-Bit version of the sql-native Client from 2005 or 2008 instead of the 64-Bit version. But now Windows 10 64 Bit doesn't allow to install a 32-Bit version of this native sql clients. Therefore the old fix doesn't work anymore and the problem returned.
This question is discussing the same problem (like many other threads), without a solution.
We have two computers with windows 10 64 bit on which the problem occurs. On one of them, the login window has no database selected (visible in the database-field). On the other computer, this field is correctly filled with the database. We found no difference in the behavior of both issues, except from the empty field. We tested, if the database wasn't correctly given to Crystal Report. It was, but the field still remained empty on one of the computers. This issue is also discussed on the internet without a solution (at least I couldn't find some). As an example, in the following link the problem with the empty Database-field is discussed. Full list of snes games.
The 'best' solution in the thread above is 'There is no solution to this problem. Regards [..]', wich is not a good solution.
There is another oberservation. The problem doesn't occure, if the windows 10 System is an upgrade from a lower system, on which the 32-bit version of the Sql-Native-Clients was installed. Therefore, Crystal Report can run indeed on windows 10 64 bit, if the correct environment could be installed. But we can't install the needed clients on the freshly installed 64-bit systems.
What was done until this question:
Cause the Code does work on every other system, except from a freshly installed Windows 10 64-bit one, we haven't looked into the Code deeply for the fixing. Instead we concentrated firstly on internet research and secondly on trying to get the sql native clients 32-bit on the new systems (or at least the needed dlls). Therefore we tested:
Registry SolutionCause a research-founding, we tried to add the registry entries under 'SAP BusinessObjects' into the 'WOW6432Node', if it wasn't there. This didn't fix anything at all.
DLL CopiesWe tried to determine the dll-files installed by the sql-native Clients 32-bit and manually copy them into the folders. But all the systems already had them.
We unziped the msi for the native clients and tested for the dlls in the msi directly. Also we searched for the files, that will be copied into the System32 folder directly and found them.
'Die SQL Server Native Client-Dateien (sqlncli11.dll, sqlnclir11.rll und s11ch_sqlncli.chm) werden in folgendem Verzeichnis installiert:
%SYSTEMROOT%system32'
Meaning: The SQL Server Native Client-files (sqlncli11.dll, sqlnclir11.rll and s11ch_sqlncli.chm) will be installed in the following folder:
%SYSTEMROOT%system32
So we checked for this files and also for the sqlncli..dll files with lower version (10). They were in the system folders.
Cause the dlls may not be compiled in the GAC folder, this may not be the solution at all (cause we can't write them into the folder without installing the 32-bit versions).
Installing all the avaiable sql-native clients for 64 bitHoping, that one of the versions had the needed files in them, we installed all the version for the 64-bit version, but without success.
Clearing the Connection for Crystal Report in CodeFollowing a solution from the internet, we tried to clear the DataSourceConnections before setting the new one. Just for testing purpose, if this may help (which it didn't).
Debugging and ResearchAs said in the text above, we tested the Information in Code and found no problem with the connections. We could connect with the same information in the database from every other tool of the programm. The issue only occurs with Crystal Report. Also researching the issue showed only 'open' questions withouth answers, or without answers that worked for us.
The Question
What to do, to get into the CrystalReport-Viewer without the login-window failing to login?
As solutions there may be two ways to fix this. One within the code, and one with the needed files from the sql native clients, or other environmental changes.
Both solutions are welcome. Of course we will further search for solutions ourself, but in the moment, we are a little clueless (which explains this question).
So any help is welcome.
And at last a little Code:
In this code example, we set the filepath towards the report and the connection towards the database. Everything is correctly filled on the systems with issues. But if there are some configurations to be done, feel free to comment them.
If you are interested to look into the issues, but need some further information, that we can provide, I will happily provide them.