https://crystalmanager.crmtogether.com/api.php?action=feedcontributions&user=Crmtogether&feedformat=atomCrystal Manager for Sage CRM - User contributions [en]2024-03-29T08:44:29ZUser contributionsMediaWiki 1.40.0https://crystalmanager.crmtogether.com/index.php?title=File:Crystal_bobj_aspnet.png&diff=411File:Crystal bobj aspnet.png2022-12-22T16:08:09Z<p>Crmtogether: </p>
<hr />
<div></div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=File:Blank_report_crystal.png&diff=410File:Blank report crystal.png2022-12-22T16:07:57Z<p>Crmtogether: </p>
<hr />
<div></div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=409Troubleshoot2022-12-22T15:27:59Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
The issue here is that an external url <br />
EG<br />
http://crm.server.com/crm/eware.dll <br />
<br />
does not work/resolve on the CRM Server. To test this open a browser on the server and use the external url. This will fail is this is the issue. <br />
<br />
But the local url <br />
EG<br />
http://localhost/crm/eware.dll <br />
<br />
does work so you must add in the local url to the "CRMCodedPath" setting<br />
<br />
**Do not add in the eware.dll part. Only put it in in the following format<br />
<br />
http://localhost/crm/<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. <br />
<br />
On 2021 versions of windows you must use Server Manager to install the latest ASP.Net.<br />
<br />
Older windows systems can do the following:<br />
<br />
To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).<br />
<br />
----<br />
January 2019<br />
Due to to changes in .net you may need to add in<br />
<br />
<httpCookies requireSSL="false" /><br />
<br />
to the web.config file<br />
<br />
EG<br />
<br />
<system.web><br />
<httpCookies requireSSL="false" /><br />
<customErrors mode="RemoteOnly" /><br />
<br />
----<br />
<br />
ERROR when you view page:<br />
<br />
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_*****.dll' or one of its dependencies.<br />
<br />
Check the "Identity" that the CRM app pool is running under. If its not "LocalSystem" and is some other user you should uninstall the SAP runtime and then open a command prompt as the user that is being used and then navigate to the folder that contains the SAP runtime installer and run this. It will run as that user and should install with correct permissions.<br />
<br />
----<br />
<br />
BLANK report<br />
<br />
Windows updates can cause the Crystal runtime to look for the wrong folder name resulting in a 404 (you need to inspect this in chrome/edge to see this)<br />
<br />
Image A<br />
[[File:blank report crystal.png]]<br />
<br />
To resolve this copy the existing folder (it may differ from our screen shot)<br />
<br />
Image B<br />
[[File:crystal bobj aspnet.png]]<br />
<br />
info the folder name from the Image A above.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=408Releases2022-11-02T10:02:48Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.7.0.0 2nd Nov 2022 <br />
* Sage CRM 2022 R2 support<br />
* Options to customise a quote and/or report name when created as PDF or WORD document<br />
<br />
<add key="pdfRenameQuote" value="N" /><br />
<add key="pdfRenameQuoteFieldToUse" value="quot_reference" /><br />
<add key="pdfRenameQuoteFilename" value="Quote #quot_reference#" /><br />
<add key="pdfRenameOrder" value="N" /><br />
<add key="pdfRenameOrderFieldToUse" value="orde_reference" /><br />
<add key="pdfRenameOrderFilename" value="Order #orde_reference#" /><br />
<br />
set pdfRenameQuote=Y to turn on<br />
set pdfRenameQuoteFieldToUse to be a field to use (only one field is allowed)<br />
set pdfRenameQuoteFilename to be the name and position the value in pdfRenameQuoteFieldToUse within it<br />
<br />
Any characters not acceptable to windows for a filename will be removed. <br />
<br />
4.6.0.0 2021<br />
* Updated Runtime (v30) and 2021 support<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=407Releases2022-10-27T13:05:05Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.7.0.0 Nov 2022 (soon)<br />
* Sage CRM 2022 R2 support<br />
* Options to customise a quote and/or report name when created as PDF or WORD document<br />
<br />
<add key="pdfRenameQuote" value="N" /><br />
<add key="pdfRenameQuoteFieldToUse" value="quot_reference" /><br />
<add key="pdfRenameQuoteFilename" value="Quote #quot_reference#" /><br />
<add key="pdfRenameOrder" value="N" /><br />
<add key="pdfRenameOrderFieldToUse" value="orde_reference" /><br />
<add key="pdfRenameOrderFilename" value="Order #orde_reference#" /><br />
<br />
set pdfRenameQuote=Y to turn on<br />
set pdfRenameQuoteFieldToUse to be a field to use (only one field is allowed)<br />
set pdfRenameQuoteFilename to be the name and position the value in pdfRenameQuoteFieldToUse within it<br />
<br />
Any characters not acceptable to windows for a filename will be removed. <br />
<br />
4.6.0.0 2021<br />
* Updated Runtime (v30) and 2021 support<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=406Releases2022-10-27T12:44:25Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.7.0.0 Nov 2022 (soon)<br />
* Sage CRM 2022 R2 support<br />
* Options to customise a quote and/or report name when created as PDF or WORD document<br />
<br />
<add key="pdfRenameQuote" value="N" /><br />
<add key="pdfRenameQuoteFieldToUse" value="quot_reference" /><br />
<add key="pdfRenameQuoteFilename" value="Quote #quot_reference#" /><br />
<add key="pdfRenameOrder" value="N" /><br />
<add key="pdfRenameOrderFieldToUse" value="orde_reference" /><br />
<add key="pdfRenameOrderFilename" value="Order #orde_reference#" /><br />
<br />
set pdfRenameQuote=Y to turn on<br />
set pdfRenameQuoteFieldToUse to be a field to use (only one field is allowed)<br />
set pdfRenameQuoteFilename to be the name and position the value in pdfRenameQuoteFieldToUse within it<br />
<br />
Any characters not acceptable to widows for a filename will be removed. <br />
<br />
4.6.0.0 2021<br />
* Updated Runtime (v30) and 2021 support<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=405Releases2022-10-27T12:43:07Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.7.0.0 Nov 2022 (soon)<br />
* Sage CRM 2022 R2 support<br />
* Options to customise a quote and/or report name when created as PDF or WORD document<br />
<br />
<add key="pdfRenameQuote" value="N" /><br />
<add key="pdfRenameQuoteFieldToUse" value="quot_reference" /><br />
<add key="pdfRenameQuoteFilename" value="Quote #quot_reference#" /><br />
<add key="pdfRenameOrder" value="N" /><br />
<add key="pdfRenameOrderFieldToUse" value="orde_reference" /><br />
<add key="pdfRenameOrderFilename" value="Order #orde_reference#" /><br />
<br />
set pdfRenameQuote=Y to turn on<br />
<br />
The rest of the options should be self explanitory<br />
<br />
4.6.0.0 2021<br />
* Updated Runtime (v30) and 2021 support<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Install&diff=404Install2022-08-08T10:11:30Z<p>Crmtogether: </p>
<hr />
<div>* '''As of March 2017 (Version 4.4.3) the license key can be added in the Install Component section of SageCRM'''<br />
<br />
<br />
***************************************************************************************************<br />
New licensing - The release out in Oct 2015 (currently RC4) will require a new license<br />
Installation of this license is now via the web.config file (located in folder "CustomPages/CRViewer/"<br />
Open this file in notepad (or some text editor)<br />
Find the text<br />
<add key="CrystalManagerLicense" value="PasteLicenseHere" /><br />
and replace the text "PasteLicenseHere" with your license<br />
***************************************************************************************************<br />
<br />
<br />
The notes are useful though if ANY of the install process wizard fails. <br />
'''If not, they are not needed.''' <br />
----<br />
<br />
Upgrading CRM: When you upgrade CRM it typically wipes out the application setting in IIS on the CRViewer folder. So you have to get the latest install (from the portal) and run that. Typically you will not need to reinstall the CRM component file. <br />
----<br />
<br />
<br />
Installation steps:<br />
<br />
1. Run the wizard and also Install the Crystal Runtime files on the server (Crystal Reports is not required on the server) <br />
<br />
2. Install the component<br />
<br />
Log on to CRM and navigate to the “Administration”->”Customisation”->”Component Manager”<br />
<br />
Add the CRViewer.zip component to CRM. Browse and click “upload new component”<br />
<br />
[[File:ComponentUpload2.png]]<br />
<br />
The component should be displayed in the “Available Components” list<br />
<br />
[[File:ComponentAvailable2.png]]<br />
<br />
Select the component and click “Install Component”<br />
<br />
[[File:ComponentInstall2.png]]<br />
<br />
On the following screen enter the license key<br />
<br />
[[File:ComponentLicense2.png]]<br />
<br />
And click “Install Component”<br />
<br />
[[File:ComponentInstall2.png]]<br />
<br />
When done your screen should say that the install has been completed<br />
<br />
Click “Continue”<br />
<br />
You will see then that the component is listed as installed<br />
<br />
[[File:ComponentList2.png]]<br />
<br />
3. (Note As of March 2017, Version 4.4.3, This part should be automatically completed by the installer) <br />
Open IIS. Navigate to the ‘CRViewer’ folder in your CRM install<br />
<br />
[[File:iis1.png]]<br />
<br />
And select the “CRViewer” folder<br />
<br />
[[File:iis2.png]]<br />
<br />
Right click and select “Convert to application” (for older versions of IIS you may be required to complete this step via the properties window)<br />
<br />
IIS Properties window - click "Create" to create the application<br />
<br />
[[File:crystaliis6.png]]<br />
<br />
[[File:iis3.png]]<br />
<br />
Ensure that the Application pool is the same as the CRM application pool and that the .Net Version is 4.0<br />
<br />
[[File:apppool.png]]<br />
<br />
4. The ‘CRViewer” is located in the Administration->Email and Documents -> CRViewer<br />
<br />
You first off need to configure the settings and database connections. This is done from the ‘Config’ menu. <br />
<br />
[[File:config.png]]<br />
<br />
5. Update the desktop heap - this is required on newer servers<br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. Please double the second and third numeric values, so the SharedSection numbers look like this: sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=403Troubleshoot2022-06-15T08:44:44Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
The issue here is that an external url <br />
EG<br />
http://crm.server.com/crm/eware.dll <br />
<br />
does not work/resolve on the CRM Server. To test this open a browser on the server and use the external url. This will fail is this is the issue. <br />
<br />
But the local url <br />
EG<br />
http://localhost/crm/eware.dll <br />
<br />
does work so you must add in the local url to the "CRMCodedPath" setting<br />
<br />
**Do not add in the eware.dll part. Only put it in in the following format<br />
<br />
http://localhost/crm/<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. <br />
<br />
On 2021 versions of windows you must use Server Manager to install the latest ASP.Net.<br />
<br />
Older windows systems can do the following:<br />
<br />
To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).<br />
<br />
----<br />
January 2019<br />
Due to to changes in .net you may need to add in<br />
<br />
<httpCookies requireSSL="false" /><br />
<br />
to the web.config file<br />
<br />
EG<br />
<br />
<system.web><br />
<httpCookies requireSSL="false" /><br />
<customErrors mode="RemoteOnly" /><br />
<br />
----<br />
<br />
ERROR when you view page:<br />
<br />
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_*****.dll' or one of its dependencies.<br />
<br />
Check the "Identity" that the CRM app pool is running under. If its not "LocalSystem" and is some other user you should uninstall the SAP runtime and then open a command prompt as the user that is being used and then navigate to the folder that contains the SAP runtime installer and run this. It will run as that user and should install with correct permissions.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=License_File&diff=402License File2022-03-14T09:47:18Z<p>Crmtogether: </p>
<hr />
<div>'''Updating of Your License'''<br />
<br />
The license is stored in the "../CustomPages/CRViewer/web.config" file.<br />
<br />
This file can be edited via any text editor.<br />
<br />
The Key value is shown as follows:<br />
<br />
<add key="CrystalManagerLicense" value="YourCurrentLicenseIsHere"/><br />
<br />
To update your license replace the value setting with the license provided<br />
<br />
<add key="CrystalManagerLicense" value="YourNewLicenseIsHere"/><br />
<br />
Save the file.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=401Requirements2022-02-28T11:24:09Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 2018,2019, 2020 and 2021, 2022<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_30.msi (shipped with the product) <br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=400Releases2021-07-19T11:52:39Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.6.0.0 2021<br />
* Updated Runtime (v30) and 2021 support<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=399Troubleshoot2021-04-19T12:23:11Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
The issue here is that an external url <br />
EG<br />
http://crm.server.com/crm/eware.dll <br />
<br />
does not work/resolve on the CRM Server. To test this open a browser on the server and use the external url. This will fail is this is the issue. <br />
<br />
But the local url <br />
EG<br />
http://localhost/crm/eware.dll <br />
<br />
does work so you must add in the local url to the "CRMCodedPath" setting<br />
<br />
**Do not add in the eware.dll part. Only put it in in the following format<br />
<br />
http://localhost/crm/<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).<br />
<br />
----<br />
January 2019<br />
Due to to changes in .net you may need to add in<br />
<br />
<httpCookies requireSSL="false" /><br />
<br />
to the web.config file<br />
<br />
EG<br />
<br />
<system.web><br />
<httpCookies requireSSL="false" /><br />
<customErrors mode="RemoteOnly" /><br />
<br />
----<br />
<br />
ERROR when you view page:<br />
<br />
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_*****.dll' or one of its dependencies.<br />
<br />
Check the "Identity" that the CRM app pool is running under. If its not "LocalSystem" and is some other user you should uninstall the SAP runtime and then open a command prompt as the user that is being used and then navigate to the folder that contains the SAP runtime installer and run this. It will run as that user and should install with correct permissions.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Install&diff=398Install2021-04-15T13:48:52Z<p>Crmtogether: </p>
<hr />
<div>* '''As of March 2017 (Version 4.4.3) the license key can be added in the Install Component section of SageCRM'''<br />
<br />
<br />
***************************************************************************************************<br />
New licensing - The release out in Oct 2015 (currently RC4) will require a new license<br />
Installation of this license is now via the web.config file (located in folder "CustomPages/CRViewer/"<br />
Open this file in notepad (or some text editor)<br />
Find the text<br />
<add key="CrystalManagerLicense" value="PasteLicenseHere" /><br />
and replace the text "PasteLicenseHere" with your license<br />
***************************************************************************************************<br />
<br />
<br />
The notes are useful though if ANY of the install process wizard fails. <br />
'''If not, they are not needed.''' <br />
----<br />
<br />
Run the following to ensure that .Net 4.0 is installed fully<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
The CRM app pool also needs to be set to use the .Net 4.0 framework<br />
<br />
----<br />
<br />
Upgrading CRM: When you upgrade CRM it typically wipes out the application setting in IIS on the CRViewer folder. So you have to get the latest install (from the portal) and run that. Typically you will not need to reinstall the CRM component file. <br />
----<br />
<br />
<br />
Installation steps:<br />
<br />
1. Run the wizard and also Install the Crystal Runtime files on the server (Crystal Reports is not required on the server) <br />
<br />
2. Install the component<br />
<br />
Log on to CRM and navigate to the “Administration”->”Customisation”->”Component Manager”<br />
<br />
Add the CRViewer.zip component to CRM. Browse and click “upload new component”<br />
<br />
[[File:ComponentUpload2.png]]<br />
<br />
The component should be displayed in the “Available Components” list<br />
<br />
[[File:ComponentAvailable2.png]]<br />
<br />
Select the component and click “Install Component”<br />
<br />
[[File:ComponentInstall2.png]]<br />
<br />
On the following screen enter the license key<br />
<br />
[[File:ComponentLicense2.png]]<br />
<br />
And click “Install Component”<br />
<br />
[[File:ComponentInstall2.png]]<br />
<br />
When done your screen should say that the install has been completed<br />
<br />
Click “Continue”<br />
<br />
You will see then that the component is listed as installed<br />
<br />
[[File:ComponentList2.png]]<br />
<br />
3. (Note As of March 2017, Version 4.4.3, This part should be automatically completed by the installer) <br />
Open IIS. Navigate to the ‘CRViewer’ folder in your CRM install<br />
<br />
[[File:iis1.png]]<br />
<br />
And select the “CRViewer” folder<br />
<br />
[[File:iis2.png]]<br />
<br />
Right click and select “Convert to application” (for older versions of IIS you may be required to complete this step via the properties window)<br />
<br />
IIS Properties window - click "Create" to create the application<br />
<br />
[[File:crystaliis6.png]]<br />
<br />
[[File:iis3.png]]<br />
<br />
Ensure that the Application pool is the same as the CRM application pool and that the .Net Version is 4.0<br />
<br />
[[File:apppool.png]]<br />
<br />
4. The ‘CRViewer” is located in the Administration->Email and Documents -> CRViewer<br />
<br />
You first off need to configure the settings and database connections. This is done from the ‘Config’ menu. <br />
<br />
[[File:config.png]]<br />
<br />
5. Update the desktop heap - this is required on newer servers<br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. Please double the second and third numeric values, so the SharedSection numbers look like this: sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=397Requirements2021-04-15T13:47:28Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 2018R1/R2 ,2019, 2020 and 2021<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_30.msi (shipped with the product) <br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=396Requirements2021-04-15T13:46:23Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 2018R1/R2 ,2019, 2020 and 2021<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_23.msi (shipped with the product) *(Pre 2019)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=395Requirements2021-04-15T13:43:42Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 2018R1/R2 ,2019, 2020 and 2021<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_23.msi (shipped with the product) *(Pre 2019)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
<br />
----<br />
4 April 2019<br />
<br />
There doesn’t seem to be a way to get around print to pdf. <br />
We think the reason is that the full report is not in fact downloaded on the screen (you can navigate next page etc) and if you just print what you see then you miss any other pages. <br />
This is not an explanation from SAP but our guess as to why this happens.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Report_Troubleshoot&diff=394Report Troubleshoot2021-01-21T22:41:10Z<p>Crmtogether: </p>
<hr />
<div>This area will outline how to resolve issues with reports being run in the system.<br />
<br />
1. If reports use ODBC connections you must configure the "DB Server Name" to point to the 32 bit - ODBC connection name rather than the servers name.<br />
<br />
(The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.)<br />
<br />
The ODBC connection must also be created at the "System" level and not the "User level". This is because CRM runs withing IIS and not at a user level so it would not have access to that ODBC connection.<br />
<br />
The error you will see in this case is "Failed to open connection".<br />
<br />
[[File:failedtoopenconnection.png]]<br />
<br />
If the report connection was made using ODBC, for this to work via Crystal Manager (and IIS) the server needs to have the same connection setup on the "system" level (as opposed to "User") in the ODBC settings<br />
<br />
[[File:odbccrystal.png]]<br />
<br />
Within Crystal Manager the "server name" value should be the name of the ODBC connection name(in my sample it is TSNTST)<br />
<br />
[[File:odbcsettings.png]]<br />
<br />
'''On windows server 2008 if you are using 32bit ODBC you need to open ODBC from "%systemdrive%\Windows\SysWoW64" (Odbcad32.exe)'''<br />
<br />
<br />
2. Failed to retrieve data from the database.<br />
<br />
Details: [Database Vendor Code: 8114 ] Failed to retrieve data from the database. Error in File jc3crystal {E59A15F9-280F-4422-A3BC-7E1411788899}.rpt:<br />
<br />
Failed to retrieve data from the database.<br />
<br />
Details: [Database Vendor Code: 8114 ]<br />
<br />
If you see this error this can be caused by bad data in the Crystal Query<br />
<br />
3. No prompts appearing<br />
<br />
Check that the data has not been saved with the report. This option is under the File menu<br />
<br />
[[File:crsaveddata.png]]<br />
<br />
Make sure this option is '''unchecked'''<br />
<br />
4. Missing parameter values<br />
<br />
This can occur when the report is called from a custom button and the parameter value setting in the report config is not set to be a query string value<br />
<br />
In later versions this will display as<br />
<br />
Message: Report paramfield is empty or null. ReportId: n<br />
<br />
To resolve this enter a value into the "Use Query String Value" setting of the report configuration.<br />
<br />
5. White spaces inserted in web viewed report<br />
<br />
How to Delete Line Spacing in Crystal Reports<br />
<br />
Ref: http://www.ehow.com/how_8621249_delete-line-spacing-crystal-reports.html<br />
<br />
Open the report you would like to correct.<br />
Highlight the section or area that contains the line spacing you would like to correct. Or highlight everything if you want to correct entire report.<br />
Click on the Properties menu located at the top of your toolbar. Go to the "Text Format" properties.<br />
Set the "Line Spacing" category to either multiple or exact. If you choose the multiple option, the number you'll enter in Step 5 will be multiplied by the font size to change the line spacing. If you choose the exact option, the line spacing will change to the exact number you enter.<br />
Enter a number in the "Line Spacing" value, based on whether you selected multiple or exact in Step 4.<br />
Close the Properties window and double-check the result of your line spacing change. If it's still not to your liking, go back into the Properties menu and change the line spacing value as many times as needed.<br />
<br />
<br />
----<br />
6.<br />
Report is slow to open print dialog<br />
<br />
Ref: http://scn.sap.com/thread/1850299<br />
<br />
Could be related to local default printer settings.<br />
<br />
----<br />
7. "Database Connector Error"<br />
This can happen we you use newer drivers (for SQL Server for example) with an older version of Crystal (EG 2011). You should then switch the ODBC connection from using the SQL Server Native Client 11.0 to "SQL Server".</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=393Releases2020-11-19T10:07:15Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=392Requirements2020-11-19T09:57:37Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.3, 2017R1/R2/R3 ,2018R1/R2 ,2019 and 2020<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_23.msi (shipped with the product) *(Pre 2019)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
<br />
----<br />
4 April 2019<br />
<br />
There doesn’t seem to be a way to get around print to pdf. <br />
We think the reason is that the full report is not in fact downloaded on the screen (you can navigate next page etc) and if you just print what you see then you miss any other pages. <br />
This is not an explanation from SAP but our guess as to why this happens.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=391Requirements2020-08-18T09:05:57Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.3, 2017R1/R2/R3 ,2018R1/R2 ,2019 and 2020<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_23.msi (shipped with the product) *(Pre 2019)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
4.5.0.0 (2019 release) Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_23.zip<br />
<br />
Pre 4.5.0.0 Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
<br />
----<br />
4 April 2019<br />
<br />
There doesn’t seem to be a way to get around print to pdf. <br />
We think the reason is that the full report is not in fact downloaded on the screen (you can navigate next page etc) and if you just print what you see then you miss any other pages. <br />
This is not an explanation from SAP but our guess as to why this happens.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=390Releases2020-07-08T11:28:40Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
* 7.2 support removed<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=389Releases2020-07-08T11:10:00Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.2.0 09 July 2020<br />
* Removed button image path as images not used for buttons anymore<br />
* (fix) for add user screen where there is massive amounts of users and custom fields<br />
* Added version no and link to this page in admin config page<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Install&diff=388Install2019-06-28T13:42:06Z<p>Crmtogether: </p>
<hr />
<div>* '''As of March 2017 (Version 4.4.3) the license key can be added in the Install Component section of SageCRM'''<br />
<br />
<br />
***************************************************************************************************<br />
New licensing - The release out in Oct 2015 (currently RC4) will require a new license<br />
Installation of this license is now via the web.config file (located in folder "CustomPages/CRViewer/"<br />
Open this file in notepad (or some text editor)<br />
Find the text<br />
<add key="CrystalManagerLicense" value="PasteLicenseHere" /><br />
and replace the text "PasteLicenseHere" with your license<br />
***************************************************************************************************<br />
<br />
<br />
The notes are useful though if ANY of the install process wizard fails. <br />
'''If not, they are not needed.''' <br />
----<br />
<br />
Run the following to ensure that .Net 4.0 is installed fully<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
The CRM app pool also needs to be set to use the .Net 4.0 framework<br />
<br />
----<br />
<br />
Upgrading CRM: When you upgrade CRM it typically wipes out the application setting in IIS on the CRViewer folder. So you have to get the latest install (from the portal) and run that. Typically you will not need to reinstall the CRM component file. <br />
----<br />
<br />
<br />
Installation steps:<br />
<br />
1. Install the Crystal Runtime files from 'CRRuntime_32bit_13_0_1.msi' on the server (Crystal Reports is not required on the server) <br />
<br />
2. Install the component<br />
<br />
Log on to CRM and navigate to the “Administration”->”Customisation”->”Component Manager”<br />
<br />
Add the CRViewer.zip component to CRM. Browse and click “upload new component”<br />
<br />
[[File:ComponentUpload2.png]]<br />
<br />
The component should be displayed in the “Available Components” list<br />
<br />
[[File:ComponentAvailable2.png]]<br />
<br />
Select the component and click “Install Component”<br />
<br />
[[File:ComponentInstall2.png]]<br />
<br />
On the following screen enter the license key<br />
<br />
[[File:ComponentLicense2.png]]<br />
<br />
And click “Install Component”<br />
<br />
[[File:ComponentInstall2.png]]<br />
<br />
When done your screen should say that the install has been completed<br />
<br />
Click “Continue”<br />
<br />
You will see then that the component is listed as installed<br />
<br />
[[File:ComponentList2.png]]<br />
<br />
3. (Note As of March 2017, Version 4.4.3, This part should be automatically completed by the installer) <br />
Open IIS. Navigate to the ‘CRViewer’ folder in your CRM install<br />
<br />
[[File:iis1.png]]<br />
<br />
And select the “CRViewer” folder<br />
<br />
[[File:iis2.png]]<br />
<br />
Right click and select “Convert to application” (for older versions of IIS you may be required to complete this step via the properties window)<br />
<br />
IIS Properties window - click "Create" to create the application<br />
<br />
[[File:crystaliis6.png]]<br />
<br />
[[File:iis3.png]]<br />
<br />
Ensure that the Application pool is the same as the CRM application pool and that the .Net Version is 4.0<br />
<br />
[[File:apppool.png]]<br />
<br />
4. The ‘CRViewer” is located in the Administration->Email and Documents -> CRViewer<br />
<br />
You first off need to configure the settings and database connections. This is done from the ‘Config’ menu. <br />
<br />
[[File:config.png]]</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=387Releases2019-06-26T12:24:02Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
* (fix) - cope better when a report has no company context<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=386Releases2019-06-26T12:23:15Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.1.0 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=385Releases2019-06-26T09:53:06Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.1.0 coming 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
* (fix) - SSA fields not working in some scenarios<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=384Releases2019-06-26T09:19:31Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
4.5.1.0 coming 27 June 2019<br />
* (fix) - One-click reports id values were being cached (only affects one click reports)<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Permissions&diff=383Permissions2019-06-24T10:12:03Z<p>Crmtogether: </p>
<hr />
<div>Access to reports can be controlled at the User and Team level.<br />
<br />
All permissions can be ignored by setting the "Ignore Security" option in the "Report Details".<br />
<br />
To set up user access you click on the button "User Access"<br />
<br />
[[File:useraccessbutton.png]]<br />
<br />
Select the user and click "Save"<br />
<br />
[[File:useraccess.png]]<br />
<br />
The user appears in the User List where you can also delete users from.<br />
<br />
[[File:userlist.png]]<br />
<br />
To set up user access you click on the button "Team Access"<br />
<br />
[[File:teamaccessbutton.png]]<br />
<br />
[[File:teamaccess.png]]<br />
<br />
The team appears in the Team List where you can also delete Teams from.<br />
<br />
[[File:teamlist.png]]<br />
<br />
<br />
----<br />
<br />
If the user dropdown does not display you may need to update the dropdowntheshold setting<br />
<br />
From SQL run the following:<br />
<br />
update <br />
Custom_SysParams<br />
set Parm_Value='100'<br />
where Parm_Name='dropdownthreshold'<br />
<br />
where 12 is the number of users...you may need to increase to the current user count<br />
<br />
Refresh the metadata then<br />
<br />
----<br />
<br />
Filtering the data based on the user/team<br />
<br />
Within CRM itself the data can be filtered by territories and users security profiles. <br />
Crystal Reports however connects natively to the database and so you would need to replicate this in a report. <br />
<br />
Built with the report viewer the system will look for 2 parameters by the names<br />
<br />
1. CurrentUser<br />
2. CurrentUserTeam<br />
<br />
and if found set to be the current user id (user_userid) and the current users team id (user_primarychannelid) when mapping is not set up. <br />
<br />
These values can be used to link to the user data and therefore filter out data.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=382Requirements2019-04-04T15:25:55Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017R1/R2/R3 ,2018R1/R2 and 2019<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_23.msi (shipped with the product) *(Pre 2019)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
4.5.0.0 (2019 release) Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_23.zip<br />
<br />
Pre 4.5.0.0 Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
<br />
----<br />
4 April 2019<br />
<br />
There doesn’t seem to be a way to get around print to pdf. <br />
We think the reason is that the full report is not in fact downloaded on the screen (you can navigate next page etc) and if you just print what you see then you miss any other pages. <br />
This is not an explanation from SAP but our guess as to why this happens.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Custom_Entity_One_Click&diff=381Custom Entity One Click2019-04-04T12:49:04Z<p>Crmtogether: </p>
<hr />
<div>*Functionality available as of 3rd May 2012<br />
<br />
There is some manual work to create a one click button into a custom entity in CRM. <br />
<br />
We provide the details here as well as sample code.<br />
<br />
----<br />
<br />
The button in this example is created in an ASP page (Sample entity is Project and summary page is created using CRM Entity Wizard)<br />
<br />
In the report we have created a parameter called "projid". When we upload this report to CRM we set the "Use Query String Value" to be "ProjectID"<br />
<br />
[[File:projectparam.png]]<br />
<br />
Within the Project summary page we add the following:<br />
<br />
var rpturl=CRM.Url("CRViewer/Default.aspx")+ "&rptname=project.rpt&ProjectID="+UseId;<br />
Container.AddButton(CRM.Button("Project Crystal Report","edit.gif",rpturl, "Project", "EDIT","BLANK"));<br />
<br />
The line<br />
var rpturl=CRM.Url("CRViewer/Default.aspx")+ "&rptname=project.rpt&ProjectID="+UseId;<br />
builds the url. You can see that we specify the reports name '''rptname=project.rpt''' and set the '''ProjectID''' value.<br />
<br />
You can see that the url that the button has will look something like the following<br />
<br />
http://localhost/crm/CustomPages/CRViewer/Default.aspx?SID=152674372762009&Key0=58&Key1=49&Key2=63&Key5=5&Key37=6000&Key50=988&Key58=6000&F=Project/ProjectSummary.asp&J=CRViewer/Default.aspx&rptname=project.rpt&ProjectID=6000<br />
<br />
As we have mapped the parameter to the query string value "ProjectID" you can see that this value goes in as "ProjectID=6000"<br />
<br />
You can also have the report open as a pdf by appending "&pdfformat=Y" to the querystring (url)<br />
<br />
var rpturl2=CRM.Url("CRViewer/Default.aspx")+ "&rptname=project.rpt&ProjectID="+UseId+"&pdfformat=Y";<br />
Container.AddButton(CRM.Button("Project Crystal Report as PDF","edit.gif",rpturl2, "Project", "EDIT","BLANK"));<br />
<br />
* for a WORD document use the querystring name value "wordformat"<br />
<br />
E.G. wordformat=Y<br />
<br />
*Jan 2013<br />
<br />
Option added to turn off library saving of PDF or Word versions<br />
<br />
E.G. nolibrary=Y<br />
----<br />
<br />
The button in this example below is created by adding in some code to the custom content which creates a button when the page is loaded. You may need this where an add on was written using the .net sdk<br />
<br />
----<br />
<br />
Create a folder within the CRM "CustomPages" folder. In our example we will call this folder "CRMTogether".<br />
<br />
Create a file there called "CRViewer.js".<br />
<br />
Select a CRM screen that exists on the page you wish to create the button.<br />
<br />
Within the "custom content" of that screen enter a path to the script<br />
<br />
<script src="../../custompages/CRMTogether/CRViewer.js" type="text/javascript" language="JavaScript"></script><br />
<br />
Enter the following script code into the page<br />
----<br />
var ButtonGroup;<br />
//set the name of your CRM<br />
var CRMName="CRM";<br />
<br />
function addButton(name, caption, imgname, reportname, pdfformat, createcomm, CE, CE_ID, LE, backupKey)<br />
{<br />
<br />
getButtonGroup();<br />
<br />
var rowCount = ButtonGroup.rows.length;<br />
var row = ButtonGroup.insertRow(rowCount);<br />
<br />
var cell1 = row.insertCell(0);<br />
cell1.innerHTML='<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0><TR><TD><A id="'+name+'1" <br />
<br />
CLASS=ButtonItem HREF="" ><IMG SRC="/'+CRMName+'/Themes/img/color/Buttons/'+imgname+'" BORDER=0 ALIGN=MIDDLE></A></TD><TD>&nbsp;</TD><TD><A id="'+ name+'2" CLASS=ButtonItem HREF="" >'+caption+'</A></TD></TR></TABLE>';<br />
<br />
var item1=document.getElementById(name+"1");<br />
<br />
var item2=document.getElementById(name+"2");<br />
<br />
item1.href=buildURL("CRViewer/NewWindow.aspx")+"rptname="+reportname;<br />
<br />
if (item1.href.toLowerCase().indexOf(CE_ID)<1) //use the backup key<br />
{ <br />
item1.href+="&"+CE_ID+"="+qsParm["backupKey"]; <br />
}<br />
<br />
if (CE!="")<br />
item1.href+="&CE="+CE;<br />
if (CE_ID!="")<br />
item1.href+="&CE_ID="+CE_ID;<br />
if (LE!="")<br />
item1.href+="&LE="+LE;<br />
if (pdfformat==true)<br />
{<br />
item1.href+="&pdfformat=Y";<br />
}<br />
if (createcomm==true)<br />
{<br />
item1.href+="&createcomm=Y";<br />
}<br />
<br />
<br />
item2.href=item1.href;<br />
<br />
}<br />
<br />
//get the params sent in to the page<br />
var qsParm = new Array();<br />
function qs() <br />
{<br />
var query = window.location.search.substring(1);<br />
var parms = query.split('&');<br />
for (var i=0; i<parms.length; i++) <br />
{<br />
var pos = parms[i].indexOf('=');<br />
if (pos > 0) <br />
{<br />
var key = parms[i].substring(0,pos);<br />
var val = parms[i].substring(pos+1);<br />
qsParm[key] = val;<br />
}<br />
}<br />
} <br />
qs();<br />
<br />
function getButtonGroup()<br />
{<br />
var ButtonGroup_col=document.getElementsByTagName("TABLE");<br />
for(var i=0;i<ButtonGroup_col.length;i++)<br />
{<br />
ButtonGroup=ButtonGroup_col[i];<br />
if (ButtonGroup.className=="ButtonGroup")<br />
{ <br />
break;<br />
}<br />
}<br />
}<br />
function buildURL(PagePath)<br />
{ <br />
var strFileName = PagePath;<br />
var strPath = document.URL;<br />
if (strPath.indexOf("eware.dll")!=-1)<br />
{<br />
var arrayApp = strPath.split("eware.dll"); <br />
PagePath="CustomPages/"+PagePath;<br />
}else{<br />
var arrayApp = strPath.split("CustomPages");<br />
arrayApp[0]+="CustomPages/";<br />
}<br />
var arrayContext = strPath.split("?");<br />
var strAppPath = arrayApp[0];<br />
var strContextInfo = arrayContext[1];<br />
strAddr= strAppPath + PagePath+"?"+strContextInfo+"&";<br />
return strAddr; <br />
}<br />
function CRMTogether_Onload()<br />
{<br />
//here we add in the button<br />
addButton("Report", "Report", "edit.gif","testerrpt.rpt", true, true,"comm_testerid", "test_testerid","libr_testerid");<br />
}<br />
window.onload=CRMTogether_Onload;<br />
----<br />
<br />
The "addButton" function adds in the button<br />
<br />
addButton parameters<br />
<br />
#name - name of the button<br />
#caption - Caption of the button<br />
#imgname - name of the image to display<br />
#reportname - name of the report to use<br />
#pdfformat - flag to show the report as a PDF <br />
#createcomm - flag to create a communication<br />
#CE - name of the communication id field<br />
#CE_ID - - query string name value of the field that holds the main entity value<br />
#LE - name of the library id field<br />
#backupkey - second value (typically Key37) to look up as in CRM it varies how it uses/creates urls<br />
<br />
Note: CE_ID is used as the querystring value picked up by the system as a parameter.</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=380Requirements2019-03-25T09:51:00Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017R1/R2/R3 ,2018R1/R2 and 2019<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_23.msi (shipped with the product) *(Pre 2019)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
4.5.0.0 (2019 release) Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_23.zip<br />
<br />
Pre 4.5.0.0 Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 4.6.x versions of the framework installed on server (CRM app pool must have 4.0 run-time)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=379Requirements2019-03-25T09:49:59Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017R1/R2/R3 ,2018R1/R2 and 2019<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
<br />
4.5.0.0 (2019 release) Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_23.zip<br />
<br />
Pre 4.5.0.0 Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=378Releases2019-03-25T09:48:35Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
THIS NOTE IS PRE: 4.5.0.0 - <br />
<br />
This is a link to the SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=377Releases2019-03-25T09:47:44Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
<br />
4.5.0.0 25 March 2019<br />
* Support for Sage CRM 2019<br />
* Support for Sage 100 2019 - CRRuntime_32bit_13_0_23.msi is the updated run-time shipped with the product.<br />
CRRuntime_32bit_13_0_23 is a major update to the SAP Crystal run-time and must be run when installing or updating the product. <br />
<br />
*******************<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
This is a link to the latest SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=376Requirements2019-03-14T12:55:11Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017R1/R2/R3 ,2018R1/R2 and 2019<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=375Troubleshoot2019-01-17T12:58:55Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
The issue here is that an external url <br />
EG<br />
http://crm.server.com/crm/eware.dll <br />
<br />
does not work/resolve on the CRM Server. To test this open a browser on the server and use the external url. This will fail is this is the issue. <br />
<br />
But the local url <br />
EG<br />
http://localhost/crm/eware.dll <br />
<br />
does work so you must add in the local url to the "CRMCodedPath" setting<br />
<br />
**Do not add in the eware.dll part. Only put it in in the following format<br />
<br />
http://localhost/crm/<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).<br />
<br />
----<br />
January 2019<br />
Due to to changes in .net you may need to add in<br />
<br />
<httpCookies requireSSL="false" /><br />
<br />
to the web.config file<br />
<br />
EG<br />
<br />
<system.web><br />
<httpCookies requireSSL="false" /><br />
<customErrors mode="RemoteOnly" /></div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=374Troubleshoot2019-01-17T12:58:45Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
The issue here is that an external url <br />
EG<br />
http://crm.server.com/crm/eware.dll <br />
<br />
does not work/resolve on the CRM Server. To test this open a browser on the server and use the external url. This will fail is this is the issue. <br />
<br />
But the local url <br />
EG<br />
http://localhost/crm/eware.dll <br />
<br />
does work so you must add in the local url to the "CRMCodedPath" setting<br />
<br />
**Do not add in the eware.dll part. Only put it in in the following format<br />
<br />
http://localhost/crm/<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).<br />
<br />
----<br />
January 2018<br />
Due to to changes in .net you may need to add in<br />
<br />
<httpCookies requireSSL="false" /><br />
<br />
to the web.config file<br />
<br />
EG<br />
<br />
<system.web><br />
<httpCookies requireSSL="false" /><br />
<customErrors mode="RemoteOnly" /></div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=373Requirements2018-04-10T10:26:35Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017R1/R2/R3 and 2018R1/R2<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=372Requirements2018-02-20T14:44:54Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017 and 2018<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=One_Click&diff=371One Click2018-02-14T09:49:26Z<p>Crmtogether: </p>
<hr />
<div><br />
*One click reports should only have one parameter and that parameter should be an ID field (EG oppo_opportunityid)<br />
<br />
Click on the "One Click" button.<br />
<br />
[[File:oneclickbutton.png]]<br />
<br />
A popup window appears.<br />
<br />
[[File:oneclick.png]]<br />
<br />
Set the button group you wish to publish your button to.<br />
**'''Be sure to select the correct button group as this control which screen the button appears on!'''<br />
<br />
Set the options that control how the report is opened.<br />
<br />
Click "Save" and the button appears on the "One Click" list.<br />
<br />
[[File:oneclicklist.png]]<br />
<br />
**'''Remember to refresh the CRM metadata to see the button<br />
'''</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=One_Click&diff=370One Click2018-02-14T09:49:08Z<p>Crmtogether: </p>
<hr />
<div><br />
*One click reports should only have one parameter and that parameter should be an ID field (EG oppo_opportunityid)<br />
<br />
Click on the "One Click" button.<br />
<br />
[[File:oneclickbutton.png]]<br />
<br />
A popup window appears.<br />
<br />
[[File:oneclick.png]]<br />
<br />
Set the button group you wish to publish your button to.<br />
**Be sure to select the correct button group as this control which screen the button appears on!<br />
<br />
Set the options that control how the report is opened.<br />
<br />
Click "Save" and the button appears on the "One Click" list.<br />
<br />
[[File:oneclicklist.png]]<br />
<br />
**Remember to refresh the CRM metadata to see the button</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=369Troubleshoot2018-02-09T09:40:43Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
The issue here is that an external url <br />
EG<br />
http://crm.server.com/crm/eware.dll <br />
<br />
does not work/resolve on the CRM Server. To test this open a browser on the server and use the external url. This will fail is this is the issue. <br />
<br />
But the local url <br />
EG<br />
http://localhost/crm/eware.dll <br />
<br />
does work so you must add in the local url to the "CRMCodedPath" setting<br />
<br />
**Do not add in the eware.dll part. Only put it in in the following format<br />
<br />
http://localhost/crm/<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Releases&diff=368Releases2018-01-08T11:44:32Z<p>Crmtogether: </p>
<hr />
<div>Details of releases<br />
<br />
<br />
Support for Sage CRM 2018 will be available the week of the 15th January 2018<br />
<br />
<br />
4.4.5 27 July 2017<br />
* Full Official CRM version 2017 support<br />
* (fix)-updated SAP runtime which fixes .net update issue<br />
<br />
<br />
*******************<br />
This is a link to the latest SAP Crystal reports runtime. This is needed now to prevent .Net updates from breaking the system paths and this is only needed until the next release out and we ship the updated runtime with it.<br />
<br />
Download the link below, unblock the zip file and extract the contents and run on your CRM server.<br />
<br />
[http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip]<br />
<br />
*******************<br />
<br />
4.4.4 - March 2017<br />
* (change)- License Key can be added in the Install Component section of SageCRM<br />
* (change)- Changes made to IIS should now be automatically completed by the Installer<br />
<br />
<br />
4.4.1 - Released 21 Nov 2016<br />
* (change)- Upload a new version of a report from within the report view<br />
<br />
4.4.0 - Jun 2016<br />
* (change) Any number of connections can be set - previous limit was 4. Please note that you must reset all connection link data when upgrading so please note all current connections before doing so.<br />
<br />
4.3.0 - Jun 2015<br />
<br />
Changes/Fixes <br />
* Full Official CRM version 7.3 support<br />
* Fix for custom entities generating word files - bug introduced in 4.2<br />
* Any parameters called "CurrentUser" and "CurrentUserTeam" are now set based on the current user when mapping is not set up fully<br />
* Prompt page will auto run reports when no parameters are needed from the user.<br />
* For 7.3 using ASP pages to cope with layout issues<br />
* New licensing !!!!! - FOR UPGRADES PLEASE REQUEST A NEW LICENSE WITH YOUR SERVER NAME<br />
<br />
<br />
4.2.0 - Jan 2015<br />
<br />
Changes/Fixes <br />
* New report caching options added in (turned off by default)<br />
* Removed old PDF install document from installation<br />
* Parameter persistence added in<br />
* CRM Parameters support for Date/DateTime added in<br />
* CRM and Crystal parameters cannot be mixed (one or the other)</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=367Requirements2017-11-15T10:23:44Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017<br />
*CRM DB: MSSQL <br />
*Reports should be set up using ODBC<br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=366Troubleshoot2017-10-06T10:44:08Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
***PLEASE note that you should only install up to version 20 (the default version is higher)<br />
EG<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip?_ga=2.105168387.1072756685.1507286576-103813667.1498225595<br />
<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Troubleshoot&diff=365Troubleshoot2017-09-22T19:50:33Z<p>Crmtogether: </p>
<hr />
<div>1. External IP addresses cannot run reports<br />
<br />
Check the Server error log. If you see 500 errors there is a chance that the server request (which is made within the iis process) is not allowed and so is returning 500 errors.<br />
<br />
To resolve this open the "custompages/crviewer/web.config" file and set the CRMCodedPath (CRM Coded Path) setting to be something like "http://servername/CRM/". (Note: you may need to add this setting)<br />
<br />
For example<br />
<br />
<add key="CRMCodedPath" value="http://localhost/crm/"/><br />
<br />
One message you might see that shows this is when you use https<br />
<br />
Message: Exception Msg: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.<br />
<br />
<br />
2. NT Authenication Error<br />
<br />
Depending on the IIS setup you may need to add in a windows users details to the web.config file. This usually occurs when IIS requires authentication.<br />
<br />
Set the following values to be a relevenat user. It is best to ensure that the users password does not expire.<br />
<br />
<add key="CRMNetworkUser" value=""/><br />
<add key="CRMNetworkUserPassword" value=""/><br />
<add key="CRMNetworkDomain" value=""/><br />
//CRMNetworkUserAuthType value options are "Basic" or "Digest"<br />
<add key="CRMNetworkUserAuthType" value="" /><br />
<br />
(Note: you may need to add these settings)<br />
<br />
3.'''Images/Graphs Not appearing in Reports'''<br />
<br />
On the server the image is created in a temp folder<br />
E.G.<br />
C:\Windows\Temp\cr_tmp_image__CRM71_CustomPages_CRViewer_server_serverport<br />
<br />
But deleted immediately once it has been downloaded. <br />
<br />
You need to check permissions on this folder<br />
<br />
[[File:imageperm.png]]<br />
<br />
<br />
If you continue to have issues check the IIS log file.<br />
The location of the IIS log files can be located in IIS.<br />
<br />
[[File:iisloglocation.png]]<br />
<br />
Next in IIS<br />
<br />
*Click on 'Handler Mappings'<br />
*On the right side under 'Actions' I selected 'Add Managed Handler'<br />
*Request Path: 'CrystalImageHandler.aspx'<br />
*Type: 'CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<br />
*Enter Name as 'Crystal Reports Image Handler'<br />
*Press OK<br />
<br />
[[File:maphandler.png]]<br />
<br />
<br />
----<br />
4. Button Groups<br />
<br />
Crystal Manager creates button groups in the system. <br />
<br />
If you are running Sage 300 (Accpac) integration then this new button group may override existing groups. <br />
<br />
To resolve delete the empty button group.<br />
<br />
<br />
----<br />
5. Windows Authentication<br />
<br />
Within the Crystal Manager folder (CustomPages/CRViewer) in IIS click on the "Authentication" button.<br />
<br />
If you see "Windows Authentication" enabled, disable this.<br />
<br />
<br />
----<br />
6. Wrong web.config file being used<br />
<br />
Depending on the IIS configuration sometimes it can use the parent web.config file.<br />
<br />
If you can delete or rename the parent web.config file.<br />
<br />
Otherwise an unverified fix is as follows:<br />
<br />
The attribute '''inheritInChildApplications''' must be placed in the '''<configuration>''' section of the web.config. <br />
<br />
It looks like this:<br />
<br />
<configuration><br />
<location inheritInChildApplications="false"><br />
...<br />
</location><br />
....<br />
<br />
----<br />
7. System.Web.Compilation<br />
<br />
You get a compilation error after some time. This is a Trust Level issue.<br />
Check the user that the w3svc process is running under.<br />
<br />
For IIS 6 look at<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1f7959af-2eac-4418-91a3-56006ea6eb07.mspx?mfr=true<br />
and<br />
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/a55fb31b-5b42-476d-9cae-050ab3fae307.mspx?mfr=true<br />
<br />
For IIS 7 look at<br />
http://technet.microsoft.com/en-us/library/cc753658%28v=ws.10%29.aspx<br />
<br />
----<br />
8. Invalid field name<br />
<br />
Error when adding new report<br />
<br />
Source: Analysis Server<br />
<br />
Message: Invalid field name. sample report {F91D3E21-5DDB-45D0-8826-8E7CFA07C233}.rpt<br />
<br />
Stack trace: at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()<br />
<br />
The issue is that there is a static parameter that needs to have the "Show on viewer" option changed from "Editable" to "Do not show"<br />
<br />
[[File:showonviewer.png]]<br />
<br />
----<br />
9. Move CR Viewer into its own application pool<br />
<br />
In some instances this can make sense to do. There is a change in the "CRReportsListUser" list though that needs to be applied.<br />
<br />
In this list the field "Description" links to the "CRViewer/Prompt.asp" (Custom File setting) page. The ASP page cannot live outside of CRM however. <br />
You need to move the prompt.asp page to the CustomPages folder and change the Custom File value to be just "Prompt.asp".<br />
<br />
If you do not do this you will see an error on the screen<br />
<br />
'''Not licensed or not registered correctly<br />
In IIS check the application pool that your custom site is running in and make sure it is the same application pool as CRM.'''<br />
<br />
Within the prompt.asp page also you would have to change line 62 from<br />
<br />
document.EntryForm.action="Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
to be <br />
<br />
document.EntryForm.action="'''CRViewer/'''Default.aspx?crre_crreportsid=<%=Request.QueryString('crre_crreportsid')%>&SID=<%=Request.QueryString('SID')%>";<br />
<br />
----<br />
10. Report load slow<br />
<br />
If the report is slow to load you may need to edit the report (.rpt) file itself and turn of the default printer.<br />
<br />
To do this open the report and select "File" -> "Page Setup".<br />
<br />
[[File:pagesetup.png]]<br />
<br />
From the dialog that opens check the "No Printer" otion.<br />
<br />
[[File:noprinter.png]]<br />
<br />
Click the "Ok" buttons and save the report.<br />
<br />
----<br />
11. Bobj is undefined <br />
<br />
Issue: Missing (or inaccessible) “crystalreportviewers13″ folder in the C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727.<br />
<br />
Fix : Copy the entire ‘crystalreportviewers13′ from crystal report installed path. “D:\Program Files\Common\4.0″ to C:\inetpub\..<br />
<br />
Enable access to the aspnet_client folder in IIS ****ENSURE THAT THE FOLDER IS ENABLED AS AN ASP.NET APPLICATION AND THAT THE APPLICATION POOL IS THE SAME AS CRM'S<br />
<br />
[[File:crystalreportviewer.png]]<br />
<br />
This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.<br />
<br />
Quick check list for this issue:<br />
<br />
1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)<br />
<br />
2. Install complete version of CR’s.<br />
<br />
3. Check whether CR web site is created under IIS.<br />
<br />
4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727<br />
<br />
5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)<br />
<br />
Ref: [http://gisprog.wordpress.com/2012/03/19/report/ http://gisprog.wordpress.com/2012/03/19/report/ ]<br />
<br />
If this is still unresolved we recommend using a http sniffer tool like fiddler to help diagnose the issue (you will see 404 or 500 errors usually which highlight where the problem is)<br />
<br />
*HTTP Error 500.23 - Internal Server Error<br />
<br />
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.<br />
<br />
Ref: https://social.technet.microsoft.com/Forums/sqlserver/en-US/aa2f52ba-dd8b-4f8f-8f15-0f9f765c3eee/http-error-50023-internal-server-error-an-aspnet-setting-has-been-detected-that-does-not-apply?forum=sqlreportingservices<br />
<br />
You may need to put the follow entry in your Web.config<br />
<br />
<system.webServer><br />
<validation validateIntegratedModeConfiguration="false" /><br />
</system.webServer><br />
<br />
<br />
----<br />
12. Could not load file or Assembly...<br />
<br />
When first trying to use the system you see this error<br />
<br />
[[File:couldnotload.png]]<br />
<br />
This is caused by the IIS application pool not having "Enable 32-Bit Applications" enabled.<br />
Set this to be True (you may need to restart the application pool and/or IIS)<br />
<br />
[[File:enable32bit.png]]<br />
<br />
----<br />
13. The table .... could not be found. Error in File ....<br />
<br />
If you see this issue check the SQL SA user is not locked out. <br />
<br />
This can happen if the "Enforce password policy" checkbox is checked.<br />
<br />
Un-check this and unlock the user in SQL Enterprise Manager to resolve.<br />
<br />
----<br />
14. Reports not opening (hanging) - <br />
<br />
Check is Crystal itself is installed and whether it is registered. If not a register dialog may appear and this seems to affect the running of the reports.<br />
<br />
If you cannot register you need to uninstall Crystal from the server.<br />
<br />
<br />
----<br />
15. 404 pages appearing<br />
<br />
This can be caused by upgrading Sage CRM (a patch even). In some instances IIS is reset to now allow ASP.Net by the patch. To resolve follow these steps:<br />
<br />
If you go to "Internet Information Services Manager" on your server you should see your "Web Sites" folder as well as a "Web Service Extensions" folder. <br />
In that folder there are some services listed there (depending on what you have installed) and you should have "ASP.NET v4.x" listed. <br />
Make sure the service is set to "Allow".<br />
<br />
Ref: http://forums.asp.net/t/894724.aspx/1<br />
<br />
<br />
----<br />
16. Random hanging when running reports<br />
<br />
In the registry key (on the server) edit<br />
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.2\Report Application Server\Server\PrintJobLimit <br />
<br />
and change it (from 75) to -1<br />
<br />
HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument<br />
<br />
Change the value of the field MaxNumOfRecords to -1(For Unlimited No. of records)<br />
<br />
*Note that the location of the key in the registry may vary depending on how SAP change things.<br />
<br />
Notes from our partners Kastech Consulting Inc [http://www.kastechco.com/ http://www.kastechco.com/] <br />
<br />
Kastech saw sporadic complus errors in the event log which lead to this solution. <br />
<br />
The following registry key can be tweaked to increase the amount of desktop heap. <br />
Please double the second and third numeric values, so the SharedSection numbers look like this:<br />
sharedSection =1024,6144,1024 as a test.<br />
<br />
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows\ SharedSection=1024,3072,512<br />
<br />
The first SharedSection value (1024) is the shared heap size common to all desktops. This includes the global handle table, which holds handles to windows, menus, icons, cursors, and so forth, and shared system settings. It is unlikely that you would ever need to change this value.<br />
<br />
The second SharedSection value (3072) is the size of the desktop heap for each desktop that is associated with the "interactive" window station <WinSta0>. User objects like hooks, menus, strings, and windows consume memory in this desktop heap. It is unlikely that you would ever need to change this second SharedSection value. Each desktop that is created in the interactive window station uses the default 3072-KB desktop heap.<br />
<br />
The third SharedSection value (512) is the size of the desktop heap for each desktop that is associated with a "noninteractive" window station. If this value is not present, the size of the desktop heap for noninteractive window stations will be same as the size specified for interactive window stations (the second SharedSection value).<br />
<br />
----<br />
17. Retrieving the COM class factory...<br />
<br />
[[File:crystalcom.png]]<br />
<br />
To resolve you need to restart IIS as this instance does not seem to be picking up the newly installed run time.<br />
<br />
<br />
----<br />
18. Invalid TLV record<br />
<br />
This happens if you try run the sage crystal reports integration after installing the SAP runtime (that ships with Crystal Manager)<br />
<br />
This is because the runtime updates crqe.dll - So both the classic and crystal manager cannot be supported on the one server.<br />
<br />
Ref: http://stackoverflow.com/questions/11149413/invalid-tlv-record-when-executing-crystal-reports-in-c-sharp<br />
<br />
----<br />
19. The server committed a protocol violation<br />
<br />
Add the following to your web.config file (just under the configuration element)<br />
<br />
<system.net><br />
<settings><br />
<httpWebRequest useUnsafeHeaderParsing="true" /><br />
</settings><br />
</system.net><br />
<br />
----<br />
20. Request Timeout<br />
<br />
On slower servers you could see a server timeout. To increase this set the 'executionTimeout="300"' atrribute in the web.config httpRuntime node<br />
<br />
<httpRuntime maxRequestLength="1048576" requestValidationMode="2.0" executionTimeout="300" /><br />
<br />
----<br />
21. 404 on ASP.Net pages<br />
<br />
ASP.net is not installed or not installed correctly. To install run the following from the command line (run as admin)<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
In windows server 2012 you may need to do the following<br />
<br />
[[File:win2012.png]]<br />
<br />
<br />
<br />
----<br />
<br />
22. Maximum request length exceeded<br />
<br />
Ref: http://stackoverflow.com/questions/3853767/maximum-request-length-exceeded<br />
<br />
If you are using IIS for hosting your application, then the default upload file size if 4MB. To increase it, please use this below section in your web.config -<br />
<br />
<configuration><br />
<system.web><br />
<httpRuntime maxRequestLength="1048576" /><br />
</system.web><br />
</configuration><br />
<br />
For IIS7 and above, you also need to add the lines below:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxAllowedContentLength="1073741824" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
Note: maxAllowedContentLength is measured in bytes while maxRequestLength is measured in kilobytes, which is why the values differ in this config example. (Both are equivalent to 1 GB.)<br />
<br />
23. Setup IIS error reporting<br />
<br />
By default IIS will only report a generic 500 error. In terms of troubleshooting this is next to useless. We must configure IIS to report out the problem. We do this as follows:<br />
<br />
Open IIS<br />
<br />
Navigate to the folder/application you are using (in our example we use the CRViewer)<br />
<br />
[[File:asp1.png]]<br />
<br />
Click on ASP to open this option<br />
<br />
Expand the options and set the "Send Errors to Browser to be true"<br />
<br />
[[File:asp2.png]]<br />
<br />
Next select the folder/application again in IIS<br />
<br />
Select the Error Pages option<br />
<br />
[[File:error1.png]]<br />
<br />
On the right hand side of the screen we have "Edit Feature Settings" - select this<br />
<br />
[[File:error2.png]]<br />
<br />
On the dialog select the "Detailed Errors" option<br />
<br />
[[File:error3.png]]<br />
<br />
Now in the browser you should start seeing any errors.<br />
<br />
24. 500 error: Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.<br />
<br />
This is because ASP.Net was not completely installed with IIS even though I checked that box in the "Add Feature" dialog. To fix this simply run the following command at the command prompt<br />
<br />
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
If I had been on a 32 bit system, it would have looked like the following:<br />
<br />
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i<br />
<br />
Fix found via ref: http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip<br />
<br />
<br />
----<br />
<br />
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads<br />
<br />
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads<br />
<br />
http://www.crystalreports.com/crvs/confirm/<br />
<br />
----<br />
<br />
Parser Error<br />
<br />
[[File:serrorparse.png]]<br />
<br />
Within IIS convert the CRViewer folder to an application<br />
<br />
[[File:crviewerconvert.png]]<br />
<br />
<br />
----<br />
<br />
Low level debugging<br />
<br />
Get the url of the report (from the browser when you open the report). <br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005<br />
<br />
Change the url by adding on "&tmpdbg=Y" to the url<br />
<br />
EG<br />
http://crm.servername.com/CRMDemo/CustomPages/CRViewer/Default.aspx?SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&F=CRViewer/NewWindow.aspx&J=CRViewer/Default.aspxrptid=6005&btnid=6000&SID=123455666645&Key0=71&Key1=28&Key2=30&Key4=1&Key7=6&Key71=2&J=CRViewer%2fNewWindow.aspx&rptid=6005&tmpdbg=Y<br />
<br />
This will out put data (something like below)<br />
<br />
start Page Load<br />
Tab Group set up<br />
Reading Request.QueryString[rptid]<br />
Report Id (from rptid):6005<br />
getting report record<br />
<br />
EVENT Logging<br />
<br />
Within the web.config file set to "ApplicationEventLog" to True to turn on <br />
<br />
<add key="ApplicationEventLog" value="True"/><br />
<br />
*Permissions are required to create the logs so assuming the IIS user does not have permission we...<br />
<br />
Go to registry editor (regedit), locate key <br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application<br />
<br />
and create a new key with the source name "CRMTogetherCRViewer2"<br />
You may need to add a string type to the key (change the .Net version number as required)<br />
<br />
EventMessageFile=C:\Windows\Microsoft.NET\Framework\v4.0.30319\EventLogMessages.dll<br />
<br />
<br />
----<br />
<br />
Not registered or not licensed correctly<br />
<br />
In IIS check the application pool that your custom site is running in and make sure it is in the same application pool as CRM<br />
<br />
* this is a CRM error (and not a license error in Crystal Manager<br />
<br />
[[File:apppoolissue.png]]<br />
<br />
To resolve this open IIS and check the application pool for CustomPage/CRViewer is the same as CRM<br />
<br />
[[File:crapppool.png]]<br />
<br />
If not click select to change<br />
<br />
----[[File:Example.jpg]]<br />
Useful links: <br />
<br />
Configure Crystal Reports 2008 for ASP.NET on IIS<br />
Ref: http://blog.aaziz.org/configure-crystal-reports-2008-for-aspnet-on-iis<br />
<br />
Crystal report images in toolbar not displaying and export/print functionality not working in asp.net<br />
Ref: http://www.aspdotnet-suresh.com/2012/01/crystal-report-images-in-toolbar-not.html<br />
----<br />
Update to .Net4.5 (and later) on server breaks system<br />
<br />
****to fix this install the latest SAP runtime (as the bug is in that) from <br />
[http://www.crystalreports.com/crvs/confirm/ http://www.crystalreports.com/crvs/confirm/]<br />
<br />
To fix this open IIS 'aspnet_client\system_web' folder and create a folder with the .net version you now have (you may need to check the version)<br />
<br />
To find .NET Framework versions by viewing the registry (.NET Framework 1-4)<br />
On the Start menu, choose Run.<br />
In the Open box, enter regedit.exe. You must have administrative credentials to run regedit.exe.<br />
In the Registry Editor, open the following subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP.<br />
<br />
[[File:crys_net_update.png]]<br />
<br />
Then copy the crystalreportsviewers13 folder into this new folder<br />
<br />
*To find out what versions of .Net that you have open windows explorer and the folder<br />
<br />
C:\Windows\Microsoft.NET\Framework<br />
<br />
[[File:netversions.png]]<br />
<br />
<br />
----<br />
<br />
ProvideX drivers - Sage 100 <br />
<br />
When using providex ODBC and Crystal Manager you have to use a new setting in the system for his to work.<br />
<br />
Firstly your driver setting must have the Logon details setup correctly <br />
<br />
EG<br />
[[File:providex.png]]<br />
<br />
Then in the web.config file you need to add in the settings. In our example below SOTAMAS90 is the name of the ODBC connection name. You must replace this with your connection name (though usually its the same). You also create the settings in the Crystal Manager config area.<br />
<br />
<add key="SOTAMAS90_OdbcConnection_Name" value="DSN=SOTAMAS90; UID=REE; PWD=somepassword; Company=ABC;" /<br />
<add key="SOTAMAS90_OdbcConnection_DLL" value="crdb_odbc.dll" /><br />
<add key="SOTAMAS90_UseDSNProperties" value="false" /><br />
<add key="SOTAMAS90__disableconnectiontest" value="True" /> <br />
<br />
The following settings should also be set<br />
<br />
<add key="doodbctest" value="N" /><br />
<add key="useExistingConnections" value="N"/><br />
<br />
<br />
----<br />
Font issue when printing - strange characters being inserted (i in front of t for example)<br />
<br />
This is an issue with your font (seen in calibri). Only solution is to change the font to something else or repair your fonts (outside the scope of support).</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=364Requirements2017-09-20T21:34:44Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017<br />
*CRM DB: MSSQL <br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime (DO NOT INSTALL VERSION 21 OR LATER)<br />
Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=363Requirements2017-09-20T21:19:45Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017<br />
*CRM DB: MSSQL <br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime <br />
Download from here<br />
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip<br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogetherhttps://crystalmanager.crmtogether.com/index.php?title=Requirements&diff=362Requirements2017-09-20T21:19:13Z<p>Crmtogether: </p>
<hr />
<div>*Sage CRM 7.2, 7.3, 2017<br />
*CRM DB: MSSQL <br />
*Crystal Run-time - CRRuntime_32bit_13_0_20.msi (shipped with the product) *(2017)you need to install the version 20 runtime <br />
<br />
*Crystal Reports - To create the reports (not required on the server)<br />
*.Net 3.5 and .Net 4.0 and .Net 4.5.2 versions of the framework installed on server (CRM app pool must have 4.0 runtime)<br />
*Compatible with all variants of Sage CRM (inc Sage 200/300 etc)<br />
<br />
[[File:iisapppool.png]]<br />
<br />
Run the following to ensure that .Net 4.0 is installed (* Newer versions of windows will need to use Server Manager to install this)<br />
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i<br />
<br />
*Note: If you are running pre 7.2 - Sage's native Crystal Reports Integration (pre 7.2 as support ended then) and Crystal Manager cannot run on the one server at the same time!<br />
<br />
*Note: IE 11 and some other new browsers only allow print to pdf (if they are locked down - this is environmental and does not happen in most instances). <br />
<br />
----<br />
<br />
Note: The Crystal Report Engine that is shipped with our software allows 3 reports to be executed at any one time. Reports are queued then. This is sufficient for most businesses and no locking up occurs.<br />
<br />
----<br />
<br />
<br />
SAP runtime service pack location (latest updates)<br />
<br />
http://scn.sap.com/docs/DOC-7824<br />
<br />
New Link (June 2017)<br />
http://www.crystalreports.com/crvs/confirm/</div>Crmtogether