Go Premium for a chance to win a PS4. Enter to Win







SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post


I want to increase the width of label border to 1 pt as for now it is only hairline.
The options available in the format section are single border, double, dashed and dotted.

I will be exporting this report to excel, so how to avoid the unwanted spacing of sections?

Attached is the report:
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Dear Experts,

I have the following VBA code which is structured like that the SAP login details are in MainStream(), which calls the XK02_ReconAccount_AQ1() sub to fill the SAP screens through SAP scripting:

Sub MainStream()

login = InputBox("Please provide SAP user")
pass = InputBox("Please enter password")
system = "AQ1"

Set SapGui = GetObject("SAPGUI")
Set Appl = SapGui.GetScriptingEngine
Set Connection = Appl.OpenConnection(system, True)
Set session = Connection.Children(0)

Dim LastRow As Long
Dim StatusBarText As String
Dim StatusBarMessageType As String
With ActiveSheet
    LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
End With

' Modify here the credentials and SAP system

session.findById("wnd[0]/usr/txtRSYST-BNAME").Text = login
session.findById("wnd[0]/usr/pwdRSYST-BCODE").Text = pass
session.findById("wnd[0]").sendVKey 0

Call XK02_ReconAccount_AQ1

End Sub

Sub XK02_ReconAccount_AQ1()

session.findById("wnd[0]/tbar[0]/okcd").Text = "XK02"
session.findById("wnd[0]").sendVKey 0

ActRow = ActiveCell.Row

For i = 1 To LastRow

session.findById("wnd[0]/usr/chkRF02K-D0210").Selected = True
session.findById("wnd[0]/usr/ctxtRF02K-LIFNR").Text = ActiveCell.Offset(i, 0)
ActiveCell.Offset(i, 0).Interior.ColorIndex = 6
session.findById("wnd[0]/usr/ctxtRF02K-BUKRS").Text = ActiveCell.Offset(i, 1)
ActiveCell.Offset(i, 0).Interior.ColorIndex = 6
session.findById("wnd[0]").sendVKey 0

Open in new window

How can I achieve the date in "DD MMM YYYY" format in formula field of Crystal report.

I have one formula, where I am concatenating the Country name with the Date.

It takes the system format when the report is generated.

How can I fix the format to "DD MMM YYYY"

Currently on my system is displaying "DD-MM-YY" and on my colleague's System is s displaying "mm/dd/yyyy"

Attached below is the image and the shareable link for the Crystal Report.


I want to replace the Column A with the adjacent Column B if column A data is NULL (dynamically shifting).

For more reference kindly find the attached image
Good Day All

I have a client who recently migrated from Exchange 2010 to 2016. After decommissioning their old 2010 Exchange server, they are now unable to send mails from SAP as the receive connector is now not on the Exchange 2016 server and needs to be recreated.

I tried recreating it as it was using old screenshots of all the settings. And the SAP has been changed to point now to the 2016 servers IP by the client.

SAP is still unable to send any mails via the Exchange.

Can someone please assist? Is there anything that needs to be restarted from the SAP side after make such a change?
I have two Stored procedures in one crystal report. Both having same parameters.
But when One stored procedure data is NULL then other stored procedure data is not visible on report which has data in it.

If I do Browse Data for another stored procedure which has data then the data is clearly visible in Browse Data Dialogue box but not on  report.

For example, refer the attached report link : https://drive.google.com/open?id=0By-_z66pGEGrb3RtVHd6cTNPLXc
Is there a standard report in SAP showing contract number and ship to?  I see a lot of sold to and contract reports, but I need to see the ship to’s for all sales contracts. Thanks.
TQ77 contains a characteristics 'attribute' but I cannot figure out the relationship to CABN/CABNT/CAWN (perhaps over an additional table) - can anyone help on this?

I want to achieve a row layout detail section and at the same time column layout detail section.

For example, I want my detail section a to detail section f as normal Row Layout detail section.
Similarly, detail section g should be Column layout detail section.
I would like to know if there is a report I can run in SAP to show me the project codes opened per WBS and each end date. We want to monitor the opening of codes, so instead of the individual asking for the code once it has disappeared from their time sheet we want to run a report to flag up any codes due to expire in 2 weeks time then we can ensure the end date is changed.
Vote for the Most Valuable Expert
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

I made a c# program that will display crstal reports. it works on my local computer by using start. when i publish the program and try to run on another computer i got this error Asembly 10g4net version be installed.
i installed sap crystal reports runtime (64bit)to the computer i want the program on. it than installed.

when i try to get to the report i get the error of the type initialer for crstaildescsions.shared.shardUlitis threw an execption

did i do something wrong when i publish it or what. I need to get this working someone is waiting on the program
dears, I use reorg rebuild index to maintain indexes on table with data lock ,

but what can I use with allpages locking table? how to maintain its indexes, then update statistics??

kindly help
Dears, kindly note this case,
we have Sybase ASE, I take a full dump daily at midnight, and an incremental dump every 30 minutes, I know the dump transaction truncates the log and this is what happened usually, but sometimes the dump transaction taken successfully while the transaction log INCREASE its size for a period maybe 3 days, I think this is because an open transaction which is not committed yet,
how can I be sure about my thinking, and how can I found what is the uncommitted transaction, such a transaction is executed by other employees and in the background of our application , i.e  no body know exactly what is a statement

Hi all,

We have a bit of a strange issue after an upgrade of SAP Crystal Reports for Visual Studio. All applications have build issues after the upgrade because all of the "CrystalDecisions" DLL's seem to have disappeared after the upgrade.

We were running Version and all was fine with the DLL's all being located and available for referencing. We upgraded to 13.0.21 and all of the DLL's no longer exist on the machine, and all applications using Crystal Reports now have build errors due to the fact that the CrystalDecisions.CrystalReports.Engine.dll, CrystalDecisions.ReportSource.dll, CrystalDecisions.Shared.dll have all disappeared!!

I tested further by removing the new version and replacing the older version and all the issues went away and all was good again. I then reinstalled the new version and the issues come back. There is no error from the install, and it claims that all was successful. I have searched the entire machine and there are no CrystalDecisions DLL files anywhere, so it's not that they have moved them.

It is all very strange ...

dear all

i have a web application where i have created a webform where i dragged and dropped inside a  crystal report viewer Version=13.0.2000
in order to load a report.
i need to know the time that takes a crystal report to load the report
i am using the below command:
 With CrystalReportViewer1
                .ReportSource = CrReport
                .ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None
                .ToolbarImagesFolderUrl = "~/Images/ReportToolbarImages/"
                .ToolPanelWidth = 0 'to hide parameter panel, do not open group tree
                .HasCrystalLogo = False ' to remove log sap crystal report from the viewer
            End With
how can i trace the performance of crystal report viewer.
I have replication server. REP 15.7.1
From last 2 weeks the replication delay is more.
When we check we can see some bulk insert happen and Identity_burn_max error for 2 tables.
So we just restart the thread and fixing the issue.
We need to fix it permanently.
I suspect identity_burn_max is the problem.
I checked the two tables in database. Both are empty.
Not sure why identify_burn_max error occurs for empty tables.

Is there any way to fix the issue permanently.

1. num_mutexes is greater than num_threads
2. dsi_bulk_copy is OFF -
3. sqt_max_cache_size is 20971520
4. dsi_large_xact_size is 100
5. dsi_max_xacts_in_group is 20

I have a cluster with two node with this version of OS and HACMP :

pp01:>oslevel -s

pp01:>lslpp -l | grep cluster.es.server.rte
  cluster.es.server.rte  COMMITTED  ES Base Server Runtime

I need to update both the OS and the PowerHA version, what procedure should i follow?
On the systems they know, there is a matrix of compatibility between sap versions and OS versions?
hi experts
how can I get this information from SAP ERP

1.      Current DB Size (non compressed) in GB
2.      Current Index Size in GB
3.      Annual DB Growth Rate in %

Can I separate the same column name two times?

Please refer below screen shot for better understanding.

If a single supplier is having two ports (As shown in image), then the supplier name is shown once. Can it be displayed twice
How to Use the Help Bell
LVL 11
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.


When a crystal report has a sub-report, then a tool tip is displayed on the report.

How to hide that tool tip?

Attached image is for more reference
Samsung DS5014S Landline phone

I have a Samsung OfficeServ DS-5014S with the message light flashing, even though there are no messages pending  does anyone have any ideas how to reset
sap Crystal server 2016, how to run and check, how to connect to Oracle, how to call the reports which is published in crs server using visual studio
I have created a desktop application and designed some reports using sap crystal report. First to design report I used database from sql server management studio and put all the field on report. But I have to deploy it client side with localDB after connecting my application with local db I am able to access database on my forms but cant getting data on report. I fetched data in datatable then I am setting datatable as datasource for report but I am getting error."Failed to open the connection Details: Database Vendor Code:4060"

Please provide me correct answer as soon as possible.

Is there any issue if we setup 'abort tran on log full' for primary database? Does sybase try to kill repagent process in case replication marker is blocking the transaction? Kindly advise.

I am trying to use "Suppress If Duplicated" on the cross tab's non summarized fields, but it is not working.

Attached is the screen shot for reference.






SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Top Experts In