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.
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.
Jai ho song free download. Both solutions are welcome. Chrome extension downloader. 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.
Browse other questions tagged c#sql-serverlogincrystal-reportswindows-10 or ask your own question.
Crystal version: 10.0.5.FieldA FieldB
Sometimes FeildA has more text and sometime it has less so if i move fieldB to right than its looking ODD and way to far from FieldA.
It should be just like this.
EmployerName(FieldA) Salary(FieldB) (It shouldn't overlap or shouldn't be too far from each other)
Note: I used the can grow property but that divides fieldA into 2 parts
For instance FieldA FieldB
FieldA='ABCDABCD'
It appears like ABCD $1000.00
ABCD
but this is how i want to see this ABCDABCD $1000.00
Hope you understand what i'm talking about now.
Thanks,
Cindy
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 Crystal Reports for Visual Studio is now known as Crystal Reports Developer Edition for Visual Studio. It is also known as CR for VS (CrforVs). Crystal Reports currently supports Visual Studio 2017, Visual Studio 2015, Visual Studio 2013, Visual Studio 2012, Visual Studio 2010. Prior to Visual Studio 2010, the Crystal Reports were Installed along with Visual Studio.
Starting from Visual Studio 2010, the Crystal Reports are no longer installed with Visual Studio. Crystal Reports for Visual Studio must be downloaded and installed separately from the SAP Crystal Reports website. The Sap Crystal Reports is free to use and download.
Crystal Reports For Visual Studio
To Create and develop Dot Net application with crystal reports, you need to install Crystal Reports Developer Edition for Visual Studio. To distribute the application to the client or as a web server, you need to install the Crystal Reports runtime.
Crystal Reports Developer Edition for Visual Studio Download
Crystal Reports For Visual Studio can be downloaded from the following link
Crystal Reports Version | Supported IDE | Developer Edition Download | Runtime Download |
---|---|---|---|
Service Pack 24 | Visual Studio 2017, 2015,2013,2012,2010 | SP 24 | 32 Bit 64 Bit |
Service Pack 23 | Visual Studio 2017, 2015,2013,2012,2010 | SP 23 | 32 Bit 64 Bit |
Service Pack 22 | Visual Studio 2017, 2015,2013,2012,2010 | SP 22 | 32 Bit 64 Bit |
Service Pack 21 **Contains Breaking Changes | Visual Studio 2017, 2015,2013,2012,2010 | SP 21 | 32 Bit 64 Bit |
Service Pack 20 | Visual Studio 2015, 2013,2012,2010 | SP 20 | 32 Bit 64 Bit |
Service Pack 19 | Visual Studio 2015, 2013,2012,2010 | SP 19 | 32 Bit 64 Bit |
Service Pack 18 | Visual Studio 2015, 2013,2012,2010 | SP 18 | 32 Bit 64 Bit |
Service Pack 17 | Visual Studio 2015, 2013,2012,2010 | SP 17 | 32 Bit 64 Bit |
Service Pack 16 | Visual Studio 2015, 2013,2012,2010 | SP 16 | 32 Bit 64 Bit |
Service Pack 15 | Visual Studio 2013 2013,2012,2010 | SP 15 | 32 Bit 64 Bit |
Installation Notes
Crystal Reports for Visual Studio 2017
Crystal Reports Crystal Reports For Visual Studio 2017 is released by SAP on 01.09.2017. The Service Pack Version that supports Visual Studio 2017 is 21. The Crystal Reports supports all editions of Visual Studio including the Visual Studio Community Edition.
- Install Windows Update KB2999226 before proceeding with the install
- Use “Run as Administrator” to install the setup
- CR has changed the Version No of Assemblies. The Old Version is 13.0.2000.0. The New Version is 13.0.3500.0. You need to open all your projects, Remove the old reference and add the new references. Then build the application
- If you do not want to remove the reference, then you need to add the following to app.config/web.config.
- Crystal Reports now uses the Net Framework 4.0. The old versions used Net Framework 2.0/3.5. Now you can get rid of <startup useLegacyV2RuntimeActivationPolicy=”true”> from the app.config
- Disclaimer: I have not tested any of the above points. If you have any issues, feel free to comment below.
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 | <?xml version='1.0'encoding='utf-8'?><configuration> <startup><supportedRuntime version='v4.0'sku='.NETFramework,Version=v4.0'/></startup> <runtime> <assemblyBinding xmlns='urn:schemas-microsoft-com:asm.v1'> <dependentAssembly> <assemblyIdentity name='CrystalDecisions.CrystalReports.Engine'publicKeyToken='692fbea5521e1304'culture='neutral'/> <bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <dependentAssembly><assemblyIdentity name='CrystalDecisions.ReportSource'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.Shared'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> assemblyIdentity name='CrystalDecisions.Web'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <dependentAssembly><assemblyIdentity name='CrystalDecisions.Windows.Forms'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <dependentAssembly><assemblyIdentity name='CrystalDecisions.ReportAppServer.ClientDoc'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.CommonControls'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.CommonObjectModel'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.Controllers'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.CubeDefModel'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.DataDefModel'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.DataSetConversion'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/> <assemblyIdentity name='CrystalDecisions.ReportAppServer.ObjectFactory'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/></dependentAssembly> <dependentAssembly> <assemblyIdentity name='CrystalDecisions.ReportAppServer.Prompting'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/></dependentAssembly> <dependentAssembly> <assemblyIdentity name='CrystalDecisions.ReportAppServer.ReportDefModel'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/></dependentAssembly> <dependentAssembly> <assemblyIdentity name='CrystalDecisions.ReportAppServer.XmlSerialize'publicKeyToken='692fbea5521e1304'culture='neutral'/><bindingRedirect oldVersion='13.0.2000.0'newVersion='13.0.3500.0'/></dependentAssembly> </assemblyBinding> /configuration> |
Crystal Reports for Visual Studio 2015
SAP Crystal Reports supports Visual Studio 2015 since the version developer version for Microsoft Visual Studio – Service Pack 16. Service Pack 16 was released on 1st February 2016. It Contains several bug fixes and enhancements.
- You need to install Framework 3.5. The Windows 10 OS does not install the 3.5 frameworks. You can do it by selecting “Turn Windows feature on or off” and choose both options
- Add <startup useLegacyV2RuntimeActivationPolicy=”true”> in app.config/web.config file
Crystal Reports for Visual Studio 2013
Crystal Report Version 10.2.36
Support for Visual Studio 2013 was added in the Service Pack 9
- You need to install Framework 3.5. The Windows 10 OS does not install the 3.5 frameworks. You can do it by selecting “Turn Windows feature on or off” and choose both options
- Add <startup useLegacyV2RuntimeActivationPolicy=”true”> in app.config/web.config file
Crystal Report Official Download page
The SAP Crystal Reports keep changing their download page. Now it is available at. Only the latest version is available here.
How to Install Crystal Reports for Visual Studio
Installing is a very simple process. Download the installer and execute it. You will are taken through the step by step process. You can also refer to the Tutorial below if you find any issues while installing it.
- Click on How to install Crystal Reports for Visual Studio
- Click on How to install Crystal Reports runtime for Visual Studio
List of Changes Crystal Reports For Visual Studio
Crystal Reports Version 10.2.3600.0
List of Changes in Service Pack 21
- This Update requires Microsoft Windows Update KB2999226 is a prerequisite.
- For VS2017 integration, user needs use “run as Administrator” by right-clicking setup.exe, even if you are already logged on by using Administrator account
- CR Assemblies are re versioned from 13.0.2000.0 to 13.0.3500.0. The user MUST remove all old CR assemblies from Reference list and add the new version of CR assemblies, then rebuild the application.
- If you do not want to rebuild the application, then there’s workaround to use <dependentAssembly> in app.config/web.config
- Crystal Reports now uses the Net Framework 4.0. The old versions used Net Framework 2.0/3.5. Now you can get rid of <startup useLegacyV2RuntimeActivationPolicy=”true”> in app.config is required
List of Changes in Service Pack 20
- HANA 2.0 SPS01
- Crystal for visual studio web preview no prompt text
- Textfield Formatting problem
- PDF output format differs between Crystal designer and Crystal runtime
- Crystal for visual studio web preview missing box object
- Wrong Top Margin * vertical and horizontal lines are not at the same position
List of Changes in Service Pack 19
- Windows Server 2016
- IIS 10 on Windows Server 2016
- Error when cancelling a print job using PrintOutputController() to the local file system: Unable to start the print job.
- Charts now have pixilated edges when using CR for VS Windows form viewer SP 18
- Enhancement Request: PrintOutputController does not allow Current Page in Winform Viewer
- Inline RAS printing does not respect Suppress Printing If No Records option selected
- Set Location to a secure MDB up one folder fails using .Access.mdb fails for subreports
- Crosstab report with rotated text does not show values
- Error Printing barcodes from WPF-Viewer
- Add the Xbase native DB driver back into distribution packages ( 32 bit only )
- Print from WPF viewer will not print landscape on Windows 2012 R2
- Linking Dataset Tables together does not work based on date/time fields
- The character in RTF string overlaps with the punctuation mark.
- Enhancement Request – Getting field values for each section
- CHM search with 3 5 framework hangs in search on the second attempt
Crystal Reports Version 10
List of Change in Service Pack 18
- Support for Visual Studio 2015 Update3
- Support for SQL Server 2014
- Support for SAP Sybase SQL Anywhere 17
- Addressed several customer Incidents.
List of Changes in Service Pack 17
- Support for Firefox ESR 45.
- Support for Office 2016.
- Addressed 10 customer Incidents.
- SAP HANA SP12.
- ER – Add a property in Windows.Forms.CrystalReportViewer to control the display quality of OLE object images
- Paging through report with linked OLE is missing images
- Reporting off of Outlook/Exchange error – Fixed in CR Designer, no fix required for CR for VS
- Print from WPF viewer will not print landscape
- DateTime field is rounding up now in CR.NET
- ‘DefaultAnimation.gif’ cannot be found exception will be thrown when instantiating instance inherits from CrystalDecisions.Windows.Forms.CrystalReportViewer
- Formula text is too long, which will lead the stack overflow when CR Designer attempts to compile the formula
- Exporting to CSV in .NET app wrong, different than CR Designer
- ER – OpenReportByDefault should use the “Same as Report” database option for PC data sources
- After upgrading to Cortez SP 16 from SP 15 Object on top of the object next to it in a WEB app.
- Right justified text on left side in WEB viewer – VS 2015
- Hyperlink does not show underline under the whole link – not an issue in CR for VS
- ER – Setting screen size higher than 1080 does not render the page centred when using Whole Page – Zoom Level 2 in .NET SDK
Changes in Service Pack 16
- Support for Edge browser on Win 10.
- Support for Safari 9 on Mac OS 10.11.
- Addressed several Incidents.
- Support for HANA SP11
- Error from crpe32.dll on ExportToDisk
- Framework 4.6 causes CR for VS to create a unique folder path to the Crystalreportsviewer13 folder in IIS and IISExpress
- Enhancement Request: Crystal viewers OLE Object Copy does not work – use CTRL-C to copy
- Missing CR Viewer button Icons in VS 2015 when editing a report within Visual Studio
- Enhancement Request – print and export viewer control tab
- “Visual Studio not installed” message when executing the CRVS setup.exe on a 32 (x86) bit Operating System
- Pervasive Database can use a 24-byte encryption key for the Btrieve driver – password value length has been extended and in Crystal Reports Designer
- NET Runtime DisplayString Expression Parsing error
Changes in the Service Pack 15
- Added support for Visual Studio 2015 RC.
- Added an easy way to use Print Output Control in WinForm Viewer.
- Addressed several Incidents.
- Support for FireFox ESR 38.
Crystal Report How to Guides
- How to Create Crystal Report using Visual Studio
Learn how to create Crystal Reports using windows forms - How to Create Crystal Reports in ASP.NET Webforms
This step by step tutorial takes you through the process of creating Crystal reports using ASP.NET Webforms - How to Create Crystal Report using ASP.NET MVC
This Tutorial explains how to Create Crystal Reports Using ASP.NET MVC and ADO.NET Entity Model - Crystal Reports Developer Guide & Tutorials
Symptom
Parameter prompt fails with one of the following errors:
- '_pe' is undefined
- The value of property 'newUnits' is null or undefined, not a Function object
- 'CR_units' is undefined
- 'promptengine_calendar' is undefined
- The value of property 'CR_cancel' is null or undefined, not a Function object
Environment
- Crystal Reports 2008 V1
- SAP Crystal Reports 2011
- SAP Crystal reports 2013
- Internet Explorer 10
Reproducing the Issue
Cause
User does not have proper rights to IE temp folder location. As opposed to all previous versions of Internet Explorer that used the same file structure to store the history/cache/cookies information, IE10 uses a completely new file structure and at a different location. It is located under C:Users[User Profile]AppDataLocalMicrosoftWindowsWebCache folder.
Resolution
Work with IT department to make sure company security policy does not restrict access to IE10 temp folder.
Keywords
IE 10, LOV prompt, JS, javascript , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem