SAP

504

Solutions

767

Contributors

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

Weird Behavior...

Hello friends:

I have developed a project using Sybase Power Builder 12.5. The application is using a mysql database and

running on Windows 8. The application works fine but I have found a weird behavior on certain windows. Let's

say, if you click on the "X" icon located at the top right, the window will be closed normally or if you try ALT

+ F4 as we know it will do the same.

This is what happen with certain windows... The final user wanted me to code the ESC key, so when the user hits

that its when the application window will close right away... I just added a simple command button and check on

the property "cancel" on that command and it will execute the script inside that button... for my own cdoulase I

just added the command "CLOSE(PARENT)" inside that script add thats all !! But this is what happens... I hit the

ESC and the application produces an exception and crashes. Any idea what would be the source or origin of this

problem?

Thank you in advance


Javier W. Barbieri
Lima, Peru
0
Windows Server 2016: All you need to know
LVL 1
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

I have two stored procedures in one report. My main stored procedure is procSSFTP_RPT_WorkAndRestDailyReport and 2nd stored procedure name is procSSFTP_RPT_GetCrewComments.

I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.

I have multiple rows for the comments against the single seafarer name.

Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".

Attached is the report for your reference

https://drive.google.com/open?id=1nb_DOgTVjFD1d-YdRR8jUX2omN5yO8KV
0
Hi,

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:
https://drive.google.com/open?id=1YTkq8UP5MtVJqMF_MvIlXkLVZm2DnDUe
0
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
session.findById("wnd[0]").maximize

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

0
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.
https://drive.google.com/open?id=1YHdKcGzXllrOV0-PHWZ7uxul0IELeBle

AnalysisError.jpg
0
Hi,

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
Image1.jpg
0
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?
0
Hi,
 
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
Purchasing_IssuePurchaseOrderReport.rpt
0
Hi,

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.
0
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

Regards
0
Get your Disaster Recovery as a Service basics
LVL 1
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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 13.0.10.1385 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 ...

Steve
0
Hi,

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

pp01:>oslevel -s
7100-00-06-1216

pp01:>lslpp -l | grep cluster.es.server.rte
  cluster.es.server.rte     6.1.0.14  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?
0
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 %
0
Hi,

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
crosstab-supplier-name.jpg
0
Hi,

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
Tool-Tip.jpg
0
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.
Error.PNG
0
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.
DuplicateValues.jpg
0
Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
  • Export Report
  • Microsoft-Excel (97-2003)
  • In Excel Format Option I select "Show Gridlines" field
PurchasingExportAnalysisTabReport_34.xls
0
Hi Experts,
How to check the status of Sybase database are online or offline.
I know sp_helpdb , But is there any other better command which shows state of database.
Thanks.
0
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.

Hi Expert,
We are not sure what is the use of SID_AUDIT database, but i understood we will created this as part of post configuration
Can you please tell us what is the use of CMS and Audit database.
Some times database  fills up and we need to add 20gb of space.
Can you tell us how can we analyse this situation.
0
Hello,

I am trying to achieve the conditional highlighting of a summarized fields in cross tab.

Basically, I want to compare which has the least value.

Attached image will give better understanding highlight-cross-tab.jpg
How can I find out which summarized field has the least value.
0
Hi Team,

I need to write a stored procedure to insert and delete a record in a table in sybase . Iam new to Sybase , below is the code I wrote in Oracle stored procedure
-- Oracle version
Create or replace procedure p1 (id number , status out number)
is
begin
insert into t1 values (id);

delete from t2 where empid=id;
commit;
exception
when others then
dbms_output.put_line(SQLCODE || SQLERRM);
rollback;
end;

I need to write the above logic in sybase , any help is really appreciated.  I have tried the below code  , need an help on the exception handling section

create procedure p1 (@id int , out @status int)
as
begin

insert into t1values (@id);
delete from t2 where empid=@id;
set @status=0;
commit;
-- Need help on how to write an exception block which can handle the error
end;
0
Hi

I am accessing in Access, using the sybase ase 15.7 driver, a sybase table that has date/time fieds. However, when accessing that table over an ADODB connection, the values returned are always only a date without time. If I use convert(varchar(8), <datetime field name>, 8) to get the time part, I invariably get a 00:00:00 time, although I KNOW that these fields all have a non-zero time value.

The weirdest is that, if I just open the table in Access (using the SAME ODBC driver to link the table), I see the time in these fields !

What is going on, and how can I get the time portion of these dates ?

Thanks for help.
Bernard
0
Hi,

I have a cross tab in a group header.

I want to sort cross tab according to the third row.

How to achieve this?

For example, the attached image.
LogBook.jpgI want to sort the cross tab as per Part 3
0
Hi

Is SAP Replication server 15.7.1 certified on Solaris 11 (sparc T-7)? Can anyone confirm please?

thanks
0

SAP

504

Solutions

767

Contributors

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
SAP
<
Monthly
>