My BrainPreview
Open in TheBrain

FW: SAP Crystal Reports: Deprecated Functionality

<p><b>FW: SAP Crystal Reports: Deprecated Functionality</b></p>

<p>Jul 31, 2015 2:54 PM</p><p>Ranjan, Amit - CRM(Cognizant)</p>

<p>/O=COGNIZANT/OU=CZTINCHE/CN=RECIPIENTS/CN=RA3631</p>

<div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Other than Sanofi , are we doing any project on SalesLogix at any other account ?&nbsp; Our team at Sanofi are facing some critical issue and needs some guidance /help ..<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>----------------------------------------------------------------------------------------<o:p></o:p></span></p><p class=MsoNormal><i><span style='font-size:10.0pt;color:#1F497D'>Amit Ranjan | Director- CRM | Cognizant | Cell: 201-759-2015 </span></i><i><span style='color:#1F497D'><o:p></o:p></span></i></p><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Naveenkanth.Kottala@sanofi.com [mailto:Naveenkanth.Kottala@sanofi.com]
<b>Sent:</b> Friday, July 31, 2015 2:33 PM
<b>To:</b> Ranjan, Amit - CRM(Cognizant)
<b>Cc:</b> Alexis, Aloysius (Cognizant); Mukherjee, Anirban (Cognizant)-CSP
<b>Subject:</b> FW: SAP Crystal Reports: Deprecated Functionality<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal><span style='color:#1F497D'>Amit-<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>We are facing issues with Crystal reports (this is OEM version from SalesLogix) during upgrade project.&nbsp; Please check if we have anyone faced similar issues in any project and how they overcame. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thanks and Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Naveen<o:p></o:p></span></p><p class=MsoNormal><span lang=DE-CH style='font-size:10.0pt;color:#1F497D'>NAAMS TEAM<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><img width=250 height=41 id="_x0000_i1025" src="cid:image001.png@01D0CBB0.D427B8C0" alt="cid:image001.png@01CFD27C.B4E0E910"><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>+1 647-667-2132<o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Samp, Robert PH/US/EXT
<b>Sent:</b> Friday, July 31, 2015 4:57 PM
<b>To:</b> Kottala, Naveenkanth PH/US/EXT
<b>Subject:</b> SAP Crystal Reports: Deprecated Functionality<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><b><span style='color:#1F497D'>Recent releases of the Crystal Reports, have ‘featured’ a reduction in functionality. This has left us all searching for workarounds.<o:p></o:p></span></b></p><p class=MsoListParagraph style='margin-bottom:12.0pt;text-indent:-.25in;mso-list:l0 level1 lfo2;background:white'><![if !supportLists]><b><span style='color:#1F497D'><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span></b><![endif]><span style='font-size:10.0pt;color:black'>Can’t turn off the Parameter dialog popups for users (remove all parameters from a report)<o:p></o:p></span></p><p class=MsoListParagraph style='margin-bottom:12.0pt;text-indent:-.25in;mso-list:l0 level1 lfo2;background:white'><![if !supportLists]><b><span style='color:#1F497D'><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span></b><![endif]><span style='font-size:10.0pt;color:black'>Can’t hide Crystal Report Viewer export button <o:p></o:p></span></p><p class=MsoListParagraph style='margin-bottom:12.0pt;text-indent:-.25in;mso-list:l0 level1 lfo2;background:white'><![if !supportLists]><b><span style='color:#1F497D'><span style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span></b><![endif]><span style='font-size:10.0pt;color:black'>The new Crystal Report Viewer hides or gets away from tons of fun functionality.<o:p></o:p></span></p><p class=MsoListParagraph style='margin-bottom:12.0pt;text-indent:-.25in;mso-list:l0 level1 lfo2;background:white'><![if !supportLists]><b><span style='color:#1F497D'><span style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span></b><![endif]><span style='font-size:10.0pt;color:black'>Can’t inject parameters into the Report object property.<o:p></o:p></span></p><p class=MsoListParagraph style='margin-bottom:12.0pt;text-indent:-.25in;mso-list:l0 level1 lfo2;background:white'><![if !supportLists]><b><span style='color:#1F497D'><span style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span></b><![endif]><span style='font-size:10.0pt;color:black'>Can’t use SQL Expressions injected into the Crystal Report property: no more dynamic SQL.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.25in;background:white'><span style='font-size:10.0pt;color:black'>This last one is a killer….as you can no longer build your SQL Statement on the fly, drop it into a Crystal Report and KaZaam…..new Groupings, SubSelects, Conditional Joins, literal values in the SQL Code, Sort Orders…..
You can still use ONE (1) Stored Procedure, which returns one cursor, and has a popup parameter for the user to type something in.
You can still use SQL Views (which don’t use parameters at all, ever),
You can still enter a Where Clause condition at runtime……yea! But it can’t be a SQL Expression…..<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.25in;background:white'><span style='font-size:10.0pt;color:black'>Bottom Line…..we either need workarounds for the above, a new solution, or punt……..<o:p></o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-size:10.0pt;color:black'>RJ Samp
Manager - SalesLogix Support and Projects
Cognizant Technology Solutions - EAS
Sanofi – Building D 4<sup>th</sup> Floor: </span><b><span style='color:#17375E'>55CD-4570</span></b><span style='font-size:10.0pt;color:black'>
55 Corporate Parkway
Bridgewater, NJ&nbsp;&nbsp; 08807

Mobile:&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;201-509-3493&nbsp;&nbsp;&nbsp;&nbsp; 1 630 561 3249<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><img width=250 height=41 id="Picture_x0020_1" src="cid:image001.png@01D0CBB0.D427B8C0" alt="cid:image001.png@01CFD27C.B4E0E910"></span><o:p></o:p></p><p class=MsoNormal><o:p>&nbsp;</o:p></p></div>

Attachments