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
Audigy 4? and XP?Arggggg,? i have used a turtle beach for so long, i didnt realise that the soundblaster stuff had changed its methodology, and feeds off of microsofts trash so highly (direct show/play) with the turtle beach i was always able to sele [More]
Hi Guru's, While I am testing a Proxy to File Interface, using SPROXY transaction i am sending a message from  R/3 to PI. the message showing successful in R/3 Moni,but in PI moni I am getting the following Error.. <?xml version="1.0" encodin [More]
I tried to open up one of my programs Mac Keeper and it wouldn't open - so I contacted tech support and they sent me a link to reinstall the program. after a reboot and trying to reinstall I received a message "The item Mac Keeper could not be moved [More]
Hi, How can I get the text content out one by one in order for a linked textframes? Thanks. Henryfor ID 2.0.2 in VBScript for a=1 to myStory.TextFrames.Count myContents = myStory.TextFrames.Item(a).TextContents next for ID CS1 and ID CS2 in VBScript [More]
Hi, I want to send a notification to the action center of Windows phone 8.1, when I get a callback from the lower layer code which I have registered for(I have implemented). I am able to do it when my app is in the foreground. How can I achieve the s [More]
We never call an SO from within an SO. Instead we do the following : MySO is mapped to MySOclass. MySOclass is a facade which has an attribute for every Policy Manager related to this SO. Each Policy manager is instanciated in MySOclass. Each Policy [More]
I am fairly new to APEX and was wondering if there was a way to pass more than the 3 allotted values in the Link Column of an Interactive Report. My report is generated from a query that pulls from several tables. My link column navigates to a form t [More]
Hi, I had a report with more than 20 variants & was working fine. Now I have modified its selection-screen as per the requirement. But after this, all the varaints starts giving error like Variant 'XYZ' of program 'ABC'  is not the current version. T [More]
When attempting to burn photos to a DVD, I get the errror code ox8002006e. What does this mean and what do I do? Airstream1Possibly an issue with your optical drive. Are you still under warranty? Have you tried other media? Have you tried slower spee [More]
The native installer will display an error as shown in the screenshot. But the native installer can execute normally after install A ir 2.0 public Beta First. Therefore, I think that the problem is not the system requirements problem. How can I run t [More]