ERPstuff - Oracle EBS Community

Which type of Help you need i m not under stand

Najm

It's very easy you have to Create Formula Column and write a query in it function COUNTFormula return NUMBER is TOTAL NUMBER(25); begin SELECT COUNT(DISTINCT NO) INTO TOTAL FROM Tables Means Copy only the tables names from Query and as well as the conditions WHERE A = A AND B = B AND C = C AND B.NO ...

No you couldn't but if you want to run reports faster then you have to make a Views and then make a query from the views and if you want more faster then you have to make indexes and then make a views after you have to make a query your report runs 60% faster then the previous reports you made Thank...

we can't clear you question please write in a bit of detail

Chears

Najm

Yes i have it but i send you on friday.

Chears

Najm

Dears I have a report of Inventry in my database which is run on daily basis some day this Report Print on 1 Page and some time it's print on 2 or some times 3 Pages. I want to know any such way that when ever this report print on 1 Page there is no need to print page number on it but when ever it o...

use less

Najm

it's very easy just Shift the attribute of sum on top of a group fields if not understand just tell i put it with example.



Chears

Najm

Dear Admin i am watching from many days that when ever any one want to know about the Progress bar you mention that link http://www.erpstuff.com/forums/topic.asp?TOPIC_ID=12 dear we know that you made a sample but public wants to know how it is implemented on Form Procedures or a heavy Report please...

Asalam-u-alikum
Rehan bahi It's Najm how are you i am on 20 days Leave now i am back i want to know where we use this type of query or also mention the condition/concept of this query it's very typical



Chears
Najm

Najm

Dear it's nice but on my request please upload some reports samples / tips also and i have a question to you did you know any thing about Progress bar (Percentage bar) i have a Progress bar and i want to attach it with a Procedure and when i button press their is Progress bar display and show the Pe...

Sorry dear if you mind it I am sorry and Thanks a lot for an instructions
Thanks again




Chears

Najm

Mr Admin you are absolutely superve but i a have a little objection if you don't mind if any job have a null entry then what can i do becoz when i select any null entry there is no record show but I want only null records. Like when I select Manager in a parameter form all the Employees whose job is...

thanks it works but a little problem exists is that 1) when i select Blank Value for view those records which are null but it show all records as well as Entered values but i only wants null records. 2) and when i select any entered value it shows only entered value it's ok. Please resolve my proble...

Absolutely Mirza Bahi says correct as we see on many forums there is a facility to upload any report or a form or any other files in this forum their must be an uploading facility to a users.



Chears

Najm