Search results for query: *

Hi, I am working on SQL reports. The problem is if i use two select statements in the SQL file then there are two new pages but my requirement is i want to display both the SQL outputs on same page. I am using breaks,compute,columns and Set commands for formatting.

Hi, The problem is in MASTER_DEATIL report in SQL I have the value of job column in variable job_var. Now my requirement is when SUM is done for every job i want the label of the sum = SUM of <JOBNAME>. I am not able to do it.This code displays records job wise when job changes the page break...

Thanks Mufasa I alreday tried this thing but actually this line also creates problem beacuse we have 50 coiumns in our query which we have to dispaly in 4-5 lines . So this line also diplays in header and wraps in header when the columns wraps according to linesize. So i want underline for...

I have a query with five columns. I have to dipalay third column without the heading as i have to concatenate the label with the field value so how can i supress this third column heading in SQL report. i am using column,break and all to format the Report. please suggest.

Thanks What is DDE.I will try the package u suggested.If i have problem then will tell u. Thanks again!

Hello everybody! Can anyone tell me how to open the MS-Word file. I want when i click the button the Word is opened with the named file. Thats it! Thanks! Saket

Several Options 1. Use Dynamic cursor , so u can make ur full statement in string and opem it later 2. make a function which checks the prod_reference in array Select * from product where if_exists(product_reference, array) =1 so the function if exists can be function if_exists (...

Dear All, I need some actions like loacking the user terminal / killing of database session if user is inactive for more than 5 min. So if user is not doing anything in FORM , and FORM is just open i want to lock the form after 5 min. Any suggestion or tip. Regards, Saket

Thanks My main purpose was not to set the REPORTS60_PATH manually and this i will have to do before setting the file name with extension only. --Can this variable value be set in Report through some Method? So main purpose is i Don't want to set it manually I am calling the report from FORM...

Hello In Master-Deatil From In Master I have one field having LOV and this field has relation with Detail. So my requirement is that in query when i change the the value of this field in Master using LOV the Detail records should get clear MASTER Block |Item|------>whenever value changes...

Thanks for ur quick reply But when i set the image file name without any path then it shows error cannot find the file source This error comes when i come out after setting the Source file property of Link file object And i have put the RDF and BMP file in same folder. But i can not make REP...

Hello I want to display an Image in report .I have used Link file tool. But in sourec file i Don't want to Hard code the Directory path of the image file.I want the directory path as entered by user in parameter. There is variable setting REPORTS60_PATH in which the directoy path can be...

Thanks for ur reply actually i want to repeate the column headings for every page only once So can't we do something related to Page No. And i could not undrestand the above explanation becuase the group break rise when the value of group field changes.So how cs_1 works with counting...

Dear ALL, i have one report (matrix) which has groups in row now the problem is whenever the row group ends column get repeated The output comes like this C1 C2 Gr1 R1 v v R2 v b ----------------- Sum() sum() C1 C2 -----------> I don't want...

Hello Sir i did the hiding of label also but no sumarry field used . In format trigger of label I write the select staement and get sum or max of filed in varaible and check the value if null then return false else return true Is it right way ?If any other way then please tell? Thanks!

Yes I can hide the label with sumarry field.But for one column As i set it's source to field B. As i wrote i have 30 columns then i will have to make 30 sumarry columns for supressing the labels.Because any number of columns can be null out of these 30 columns. Thanks for ur quick reply...

Sorry I am not able to understand the use of summary field in hiding the label for null column.Please explain I am new in report. And in my report there are 30 columns out of which 10 can be null I can hide and shift the null columns in tabular report by using repeating frame for each field.And...

Hi I have to make repeating frame for each fields and set the horizontal elasticity to variable of frames It works for fields but now problem for heading display:- My headings are in simple frame.Now i want to supress the heading label also when the field is supressed.And the label should...

Thanks U are a Star** Yaa it works Now i made new fileds manually and repeating frame for each. But i am not able to place existing fields which are in default rFrame in layout in a new repeating frame.

Hi nagornyi I am not perfect in report. AS abezuide asked for supressing NULL column in form tyope report Will it work for tabular type report Field A Field B Field C ------- ------- ------- If field B column is NULL for all rows then HIDE ,Supress the space of this column and...