Sitemap

Amicuk Programming Answers

Please help me Urgent

2015-10-11   Views:0

Advertisement

Hi, I am building following dynamic where clause in my reports 6i through one of the formula column. But I am getting the error while running the report. Please hel me how to correct this. function C_List_ReprintFormula return Char is LIST_REPRINT va

Hi,
I am building following dynamic where clause in my reports 6i through one of the formula column.
But I am getting the error while running the report. Please hel me how to correct this.
function C_List_ReprintFormula return Char is
LIST_REPRINT varchar2(100);
begin
if :P_PICK_LIST_REPRINT ='No' or :P_PICK_LIST_REPRINT='N' then
     LIST_REPRINT :=' AND we.attribute4 != '''||Y|||''''';
ELSE
     LIST_REPRINT :=' AND 1=1 ';
END IF;
RETURN(LIST_REPRINT);
end;
I need to pass the following condition
AND we.attribute4 !='Y'.
Plese help me what is wrong that I am doing here.
Thanks,
Srini

The replay answer
Advertisement
Hi
Try this:
function C_List_ReprintFormula return Char is
LIST_REPRINT varchar2(100);
begin
if :P_PICK_LIST_REPRINT ='No' or :P_PICK_LIST_REPRINT='N' then
     LIST_REPRINT :=' AND we.attribute4 != ''Y''';
ELSE
     LIST_REPRINT :=' AND 1=1 ';
END IF;
     RETURN(LIST_REPRINT);
end;
Regards, Gicu

Go to See the other 3 answers

Logical command in ABAP.....Urgent

Category:DefaultRelease time:2015-10-11Views:130

Hi,   i am pretty new using ABAP program so i neeed help urgently. i am trying to move a file on the application server from one directory to the other and i was using the open dataset function to do that. but the file i am trying to move is pretty b[More]

Confirmation of balance - urgent

Category:DefaultRelease time:2015-10-11Views:130

Hi, We are using print program SAPF130K and SAPF130D for vendor and customer respectively. My query is can we bring even the cleared items alongwith the open items in the same print program??? Now we have line items of open line items only?? As per o[More]

FUNCTION IS NOT WORKING WHEN RUN IN SRW.RUN_REPORT, URGENT

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a report. it has got 1 Query and 2 groups. Q1 | | __G1__ |F1 | |F2 | |F3 | | | | __G2__ |Items| |Sales| | Qty| |Store| |Func4| |Func5| |Func6| The Query looks like above. Now In the report I have a 3 User parameters . For Each record in G2[More]

How can I get a list of IP's that have got access to my account I have a court summons and the information could only have been gathered from my Icloud account. Apple cant or wont help me. Urgent please have to go to court tomorrow.

Category:DefaultRelease time:2015-10-11Views:130

Need some urgent help please. I have a court summons for some information that has been taken from my Icloud account. I believe my ex employer has hired someone to hack into my account. They have had my laptop inspected by a forensic company. Orginal[More]

Please help me to run this CMP BEAN, I need help urgently, I am running out of time :(

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am facing this problem, Please help me, I am attaching the source files also along with the mail. This is a small CMP EJB application, I am using IAS SP2 on NT server with Oracle 8. I highly appreciate if someone can send me the working copy of[More]

Error while opening a module. plz help me, very urgent.

Category:DefaultRelease time:2015-10-11Views:130

when i try to open a module, the following error message appears on my screen.           " no j2ee component found in d:\krisp\programs\servlets".           i've installed bea in c: drive and my servlet program is in d: drive.           plz help[More]

Urgent: need help in creation of a simple PCUI application

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts,     I am new to this PCUI. i need the help of urs. My requirement is >>>>To create a simple PCUI application.This contains a Search and Result list. >>>>Then i have to find the BSP coding or the HTML coding for the the[More]

Urgent OSX data recovery question

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am in urgent need of assistance with recovering some data. Long story short I have a XServe that had two 40gb ADMs in it. I successfully backed up each disk to DMG files, then upgraded the ADMs to contain 500gb modules. I then blew out the m[More]

Error in Installation of SAP R/3 4.7 - Urgent Help Pls !!!

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a problem while installing SAP R/3 4.7. The Central instance has been successfully installed. Error occurred while installing the database instance. I am using SAPDB as the database. The error I get is the following: **INFO 2008-03-01[More]

Hr abap urgent

Category:DefaultRelease time:2015-10-11Views:130

hello experts, I have a requirement in the project .There is a programme which creates new hire sap account in sap r/3 manully in production server .Currently this programme SKIPS INFOTYPE 105 Subtype 0001.The requirement is mentioned below.we are no[More]

Tree in WD ABAP - urgent

Category:DefaultRelease time:2015-10-11Views:130

HI Experts, I am working on WD for ABAP. I am using a tree to display some data. Node1 points to Root and subnode1 point to node1. node1-->root subnode1--> node1 When we expand node1, it shows  ">"  (arrow)  for child nodes. and if we f[More]

Hot
ERROR: FAILED TO START VIDEO CHAT BECAUSE “I” DID NOT RESPOND Hi I am in New Zealand and am unable to connect via iChat AV with my sister (in USA). I can connect to someone in Australia, USA and UK. I am incredibly frustrated as I bought the iSight s [More]
please help and if u wanna know how did this happen i'll tell u..... well the first thing i made a game center account on my friends account so he doesnt knows the password cuz my iphone wasnt updated 4.1 it was 4.0 so i didnt have game center anyway [More]
hi i have 1 kr in my itunes accout and i need to change my country but i cant , what i do to get rid of the remaining value . thank youIf you can, enter in a credit card from your original country temporarily so you can buy something that costs more [More]
Dear sir I am a junior dba, now I have a problem while I drop a customerinfo snapshot from Oracle 9.2.0.4 database. It seem to be the snapshot has been dropped correctly. But I found it's still remained in user's schema and looks like normal table. I [More]
I have both Fusion and Parallels installed and have a question about how Windows is displayed . with Parallels, I get the usual Windows desktop and with Fusion I get a "menu" for navagating to different areas/programs/settings What can I do to g [More]
Since upgrading to OS X Lion my Mac's performace has really slowed down and I want to resintall the OS to see if it will imporve performance. The issues is that I don't know if the "Reinstall Mac OS X" option in the Recovery partition will erase [More]
Hi Not sure what I am missing. I wish to store XML fragments in variables so can pass around and concatenate with other fragments to make final XML document. Even before attempting to concatenate XML fragments, I am struggling to store any XML fragme [More]
Hi All, Is there any event in windows universal app (wp8.1&win8.1) that fires when screen locked and unlocked with in the app Right now, I am using this below mentioned event Window.Current.VisibilityChanged += CurrentWindow_VisibilityChanged;, but i [More]
I am trying to install soa 11.1.1.3 facing a problem when i am trying to start the admin server plz find the exception i am getting tried all options but unable to solve the issue. plz help me in solving the problem . until i cn solve this probelm i [More]
I see that this question has been asked before, but it doesn't appear to have been asked recently, and I'm hoping things have changed.  Is there a way to make the color categories from the Outlook calendar show up on my ipad calendar?  I have all my [More]