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 ? 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> </o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'><o:p> </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> </o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p> </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> </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> </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. 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> </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> </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> </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"'> </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"'> </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"'> </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"'> </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"'> </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 08807
Mobile: 1 201-509-3493 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> </o:p></p></div>