Posts

How to migrate Closed (Won or Lost) Opportunities?

Image
  Introduction In this blog I have explained how to migrate historical Closed (Won or Lost) Opportunities. Solution We will use comma separated (CSV) file as import file. Here are some important things you need to consider: Get your import file ready:  Make sure your data is as complete and accurate when you create the import file. Make sure that the import file has “Status” & “Status Reason” fields information. Format of your date and crm environment should be same:  make sure that “Source” and “Target” date formats are same. Because if “Source” system format is different than “Target” then system will throw an error. To check it, go to  Settings > Data Management > Imports. Click on Setting icon at top right side of the import page. Select  Options. Check your date format and crm environment date format are same or not, if it is not change it select your date format. Step by Step Go to  Settings > Data Management > Imports. On the command ...

How to convert SSRS report in word format using JavaScript?

Introduction In this blog, I am going to explain how we can export SSRS reports as Word Document.  Solution To get SSRS report in word format, first we need to execute SSRS report, you can refer above link to execute report. Then we will get the response in which we will get  ReportSession  and  ControlID.  We will need these report session and control id to generate word document version of SSRS report. Now, create a query string to get word version of SSRS report as follows: let queryString = [Organization URI] + "/Reserved.ReportViewerWebControl.axd?ReportSession=" + ReportSession + "&Culture=1033&CultureOverrides=True&UICulture=1033&UICultureOverrides=True&ReportStack=1&ControlID=" + ControlID + "&OpType=Export&FileName=public&ContentDisposition=OnlyHtmlInline&Format=WORDOPENXML"; Now, create request object that will be called to convert the response in DOCX base 64 string: function fnConvertReportToWord( quer...