Search results for query: *

I am using Oracle Forms 6i... I have a block including lots of records sorted by date column, assume that I have the detail of a specified record, how could I locate and let the cursor stay in that record? Which built-in can I use?

Ok, I will !

I realized I can not change print condition automatically. So I try to change to other way, it is use embeded report for the front pages, but I have no idea about embeded report, do you know can I use embeded report in Oracle Report Builder 6i? Thanks a lot!!!

I have a report, user have two choice, one is printing on double sides, one is printing all first side pages then following the last converse side page. So how can change the 'print object on' property in trigger? Or other way, how could I tell which page is the last converse side page? Thanks...

I have a report, user want it to popup a message if there is no records in this report, I'd like to perfome it using Before Report Trigger, but how could I get the number of record fectched by query? Thanks a lot!

Finally we got a conclusion, Thanks a lot... *_*

I followed you to perform the steps, now the report is better than before, thank you so much! But in the third report, there is still some problem, I have no idea how to handle this, http://ca.pg.photos.yahoo.com/ph/rose_echo2002/detail?.dir=c577&.dnm=ee37.jpg&.src=ph Thanks again!

The second page is a subtotal according to every Diet Order face every Facility, and the third page is total according to every Diet Order for all facilities, how to count it out? My result is always wrong.

I tried a lot, seperated the query to several groups, but I have not got the desired result until now, and here are the layout of the report, the first page is the detail listing, the second page is a sub total according to each facility, and the third page is the total for all facilities...

Now I have three querys in one report, they have same filter(where clause), but different group by and sum columns, and they are printed in seperated layout frames. I think I use too many querys, and every query has long where clause, the report will run slowly, how could I combine the three...

I have a report, one column is long, so the sizing is expand in vertical and fixed in horizontal. The problem is when I preview the report, the data of this column was cut by the last two or one letters in every line, even though I expanded the column length. But the print report is perfectly...

Change logical page property to 2 pages. In the main section, 'Horizontal Panels per page' or 'vertical Panels per page' mains how many phasical pages in one logical page.

Your idea is really helpful, I'll try it. But in this report, there is some other difficult points, The upper columns will expand to two or three lines depending on the data, so I can not predict the height of the comment text.

Here is my report sample. http://ca.pg.photos.yahoo.com/ph/rose_echo2002/detail?.dir=/c00d&.dnm=f928.jpg http://ca.pg.photos.yahoo.com/ph/rose_echo2002/detail?.dir=/c00d&.dnm=1882.jpg&.src=ph Thanks a lot!

I have another question. I have four sections in every page, I need to put four records in every page, and one of the columns is very long, and the value is variable, if it's too long to fit in the section, it will go to next section, and put other records to the below sections, but the result...

Thanks a lot! I realize it by adding a frame involving the upper columns, so they can expand in a same level. Your idea is really helpful! [bigglasses]

I have a report was asked to be formatted to wrap columns to the next line when the column is too long. I have several columns need to do so. I set the column property "Vertical Elasticity" to "Expand", they really expanded, but they covered the columns right beneath them. I want them push the...