You could add a WHERE clause like this

WHERE (LoginID EQ '&LoginID') OR ('&LoginID' EQ '')

Hi Erica.

If I understand you correctly you have created a WHERE statement something like this:

WHERE Action EQ '&ACTION' AND LoginId EQ '&ACTION';

I am guessing that you are using autoprompting to produce the page the user fills in.

I would suggest two things. Since your WHERE statement uses an AND change it to be two separate WHERE statements (you can do this through the gui you don't have to go into the code):

WHERE Action EQ '&ACTION';
WHERE LoginId EQ '&LOGINID';

Then, rather than using autoprompting use the html layout painter to design a launch page. This is where it is easy to set an "ALL' option that translates into FOC_NONE.


Check out the following manual:
Developing Reporting Applications with Graphical Tools
Version 7 Release 6
DN4500798.0307
Chapter 5: Designing a User Interface for a Web Application With the HTML Layout Painter

At this point you are probably more confused than when you started. There are some things you can do to help yourself and to help us help you. Prarie gave you instructions for updating your signature, knowing what version you are on and what operating system is important.

Second, on the upper right hand corner of this page there is a link "Search the technical documentation library", you can download all of the manuals for your version there.

Three, on the upper left hand side there is a search button, it will let you search previous posts for similar problems. There have been lots of previous posts about using FOC_NONE for ALL.

Four, you can post your code. The link at the top of the reply window that looks like "< / >" will bring up code boxes. Open the source from dev studio and cut and paste it between the code boxes.

Thank you everyone for you comments! I will look into everything posted and post my solution when I get it figured out.

One other thing Erica, if you haven't signed up to receive the new messages by email you should, I still learn new things everyday.

Heres what I did to accomplish my task. It might not be the best way, but I thought I'd post it in case someone else had the same problem.

First I create a dialogue manager before my report. In my dialogue manager I put:
-SET &p_LoginID = IF &LOGINID EQ '' THEN 'FOC_NONE' ELSE UPCASE(&LOGINID.LENGTH,&LOGINID, 'A&LOGINID.LENGTH');

Second I went into my report to fix the where clause. Now my where clause says:
WHERE LOGINID EQ '&p_LoginID';

This made my report work the way I wanted. Thanks to everyone for their help!