Author Archives: greysagecrm

OSQL error at the time of installing CRM

You must have come across the above mentioned issue when installing CRM on multiserver architecture where Application server and Database server are two different machines on the network. This error occurs at the time of installing CRM on Application server. This issue seems to be related to the database connectivity across the server, but what… Read More »

Cannot open database requested by the login. The login failed.

Have you ever encountered this error message “Cannot open database [XXXX] requested by the login. The login failed. “ While installing CRM patches with SQL Server and MSSQL services both available on the same SQL server??? As the error says there might be many reasons for it to not to connect to database like network dis-connectivity,… Read More »

Remove hyperlink from summary caption tags

In standard CRM you can see summary screen for all entities like Company, Person, Cases, and Communication. To change basic details for the company or Person entity you can choose two ways 1. Click on the Change button from Summary screen (Refer screenshot below.) 2. Click on the Summary Block hyperlink of Summary screen. (Refer… Read More »

Document upload link from other entity lists

Sage CRM provides document upload functionality against almost all the entities in CRM. We can use the same to upload Draft and Finalized versions of relevant documents. Recently we came across the requirement where we were supposed to show the upload link as the separate hyperlink column in custom entity list screen. The requirement was… Read More »

Remove Action Buttons using client side script

We had posted much detailed content earlier for removing buttons from standard screens using client side scripts. This is in continuation with the same. When you are customize any List or Summary screen you can find there are lots of action buttons available on right hand side; for example communication search screen. On this screen you can see Find,Clear… Read More »

Executing Stored Procedures using COM API methods

This is developer specific technical tip which can be used in CRM customizations. In customizations we usually execute sql statements using CreateQueryObj function. For Eg. SqlQuery = “Select comp_name from company (nolock) where comp_compname=”+sCompId; SqlObj = eWare.CreateQueryObj(SqlQuery); SqlObj.SelectSQL(); Here to retrieve the value of comp_name we can use SqlObj(“comp_name”). The above example is for the… Read More »

Error while writing scripts on OnChange script section

Recently I came across a problem with OnChangeScript in sage CRM version 7.1. Somehow OnChangeScript for search select advanced fields doesn’t like the script to be on multiple lines! i.e. Below written script doesn’t work: id = document.EntryForm.comp_type.value; alert (‘comp_type:’+id); and Below written script works: id = document.EntryForm.proj_companyid.value;alert (companyid :’+id); First script gives the following… Read More »