In SAP Crystal Reports XI, return records that match multiple conditions

Raja Ali
Published on 12-Dec-2017 09:59:14
It is advisable to use functions to pass such filter conditions in CR. Also try changing the order of your condition like −({PR.cov} = "A" and {PR.cov}="B") or {PR.cov} = "A" Try using function like this: {@A}:if {PR.cov} = "A" then 1 else 0To create custom functions in Crystal Report, ... Read More

SAP connector failed, use of port number 3350

Syed Nauman
Published on 12-Dec-2017 09:55:24
This port is used to provide a range of connections to SAP gateway for RFC connection. If you are getting this error, try to resolve your server name with “nslookup” or try connecting to IP address instead of server name.

Error while passing an image value to an OData request in SAP

Altamas Khan
Published on 12-Dec-2017 09:52:20
If you ImgData includes an image in Data URI format base64 then add the below line to Imgvalue to convert it to ImgData:var imgData = JSON.stringify(ImgValue);I suggest you to use AJAX to post image through OData as shown in below code:OData.request ({      requestUri:" SALES_VRS/DailySalesSet",      method: "GET", ... Read More

How to get a string leftpadded with zeros in Python?

Rajendra Dharmkar
Published on 12-Dec-2017 15:00:31
We can use the rjust(width[, fillchar]) method in string class that right justifies the string and pads the left side with given filler char. The default filler char is space. You can use it as follows:>>> '25'.rjust(6, '0') '000025' >>> 'Apollo'.rjust(10, '0') '0000Apollo'We can also use Python string formatting to ... Read More

In my SAP Fiori custom app, Back button is not working in Launchpad

Mohd Arshad
Published on 12-Dec-2017 09:37:36
Try to use “shellHash” property instead of “semanticObject” like below:-------------------------------------------------------- sap.ushell.Container.getService("CrossApplicationNavigation").toExternal({     target: {         shellHash: "#"     } }); --------------------------------------------------------

How to translate a python string according a given dictionary?

Rajendra Dharmkar
Published on 12-Dec-2017 14:50:19
We can use the method translate() which returns a copy of the string in which all characters have been translated using table (constructed with the maketrans() function in the string module), optionally deleting all characters found in the string deletechars.  examplefrom string import maketrans   # Required to call maketrans function. ... Read More

While changing Partner number, VBA code keeps running while interacting with SAP system

Mohd Altamas
Published on 12-Dec-2017 09:34:35
The best possible solution to avoid this issue is by adding breakpoints to the best places. This issue is common with VBA and C# while debugging code includes COM libraries.

How to convert lowercase letters in string to uppercase in Python?

Rajendra Dharmkar
Published on 12-Dec-2017 12:55:07
You can use the upper() method in Python to convert all lowercase letters in string to uppercase. For example:>>> 'HellO'.upper() HELLO >>> 'leaning tower of pisa'.upper() 'LEANING TOWER OF PISA'

How to invert case for all letters in a string in Python?

Rajendra Dharmkar
Published on 12-Dec-2017 12:37:03
String class has a method called swapcase() for swapping case of all letters. You can use it as follows:>>> 'Hello World 123'.swapcase() 'hELLO wORLD 123' >>> 'Make America Great Again'.swapcase() 'mAKE aMERICA gREAT aGAIN'

Using SAP T-code SM37 to check background jobs in SAP system

Paul Richard
Published on 08-Dec-2017 14:13:26
In SM37 you can only see the scheduled background jobs as it is not used for foreground jobs. Below shows an initial screen of SM37 Transaction code: