This content has been marked as final. Show 18 replies
Hi Jeff -
I'm trying to get this to work again but having problems. Table I'm querying is DOC_ECR_FORM
Here's what I did:
Created LOV item P81_SEARCH_ECR (only available LOV type is popup, I'm sure due to the number of records I'm searching)
Set it up the LOV with this query:
SELECT ECRNO D, ECRNO R
WHERE ECRNO = :P81_SEARCH_ECR
Setup condition as
Now the report of all items is not displayed. The search field is displayed but no data found.
Also set :P81_SEARCH_ECR as:
Enterable; show and store return value
Fetch first row set
I'm definitely missing something!!
Edited by: userRRRYB on May 25, 2012 5:47 PM
What made you think the East Coast was working today? :O)
I believe you want to set your Dispaly Null attribute of your LOV to Yes and the Null display value to something like --- All Documents ---.
Then the where clause of your report:
WHERE ( :p81_search_ecr = '%null%' OR doc_ecr_form.ecrno LIKE '%' || :p81_search_ecr || '%')
Edited by: jwellsnh on May 25, 2012 1:30 PM
You're there today! I just got slammed by another user because I opened another post asking virtually the same question figuring you'd never see this one again because it's so old. There must be new users about because it's been awhile since I've posted anything and the first reprimand I got was for not posting version/template/theme/server, etc... and then the next response was closing it up saying, "Do not duplicate." Trouble is I didn't mean to rock the boat, I'm desparately trying to resolve this and as I said, didn't know you'd see it.
Anyway, what ARE you doing working today? We'll probably be let off early as is usual before a holiday weekend.
But more importantly, I would prefer to make my master report into an interactive report, but don't know how. I've tried many times this week to create an interactive report and a tabular form on the same page, but kept getting an error when opening up an existing record and trying to add more records into the tabular form.
Is it possible to convert an already existing Master report in a Master Detail form into an interactive form or do I need to create from scratch? In the meantime I will give your other suggestion a try.
It's great to hear from you - thanks again!
I am leaving the office shortly but will be able to pick things up again from home around 3:00 EST.
Any standard report can be converted to an interactive report but once done; you cannot go back to the standard form.
To convert the report; edit the report region and over to the right under Tasks their is the option Migrate to Interactive Report.
Wait, one more thing. In my excitement getting this working to add the where clause I changed the master report from a structured query to a return one value query. Doing that made the search work upon quick test and it was then that I wrote back in my excitement. I'm not sure if this is going to work completely - sorry don't know difference between structured and non and have the feeling the structured query is what makes the master detail work - though no access to the code in the wizard to enter the where clause.
Sooooooo I'm going to test this one and go from scratch if it doesn't work. Once you get home it's your holiday so I don't expect you to have to dial in! ....welllllll only if you want to...:-) if we're off early we will leave at around 2:00 California time (there's pacific time, and then there's CALFORNIA time). lol
Thanks again -