Search results for query: *

Go to the repeating frame you want to add the field, then click on one field, copy and past it. This will create the same field you just copied from. Then double-click the new field to open the property sheet. Change the Name and the field source name. Move the field to desired position. Walah...

SELECT nash_spanish_letters + nash_english_letters total_letters FROM ( SELECT CASE WHEN NumLetters <>'0' AND SpanishLetter = 'Yes' AND Office ='NA' THEN NumLetters ELSE '0' END Nash_Spanish_Letters, CASE WHEN NumLetters <>'0' AND SpanishLetter <> 'Yes' AND...

When submitting the report thru concurrent request, click the Options Button and fill up the Name field(s). This will automatically send emails to the users. But you have to setup the users' emails too in order to send reports thru email.

Check the frame's properties.

Can the reports be halted when there's no data in the reports? I wrote a report that will be sent to the users for exception reporting, but the users don't want to receive the report if there's nothing in it.

I will suggest that you create a function that will calculate for the AGE of your data, and this function should be in your break group. This way, you will be able to group your data by the age: FUNCTION get_age RETURN NUMBER IS v_age NUMBER; v_return NUMBER; BEGIN v_age :=...

Thanks

I think this will work in some cases, but when the user enters 'ZZZZZZZ' values for the high segment values, the report is not returning records where it should.

you can also use third party software that will read the out file of the check you just created, and from that outfile, this software will reformat everything from that page. The software is called OPTIO. I don't know how much it is, but I thing you will be satisfied with it once you get the...

have you tried doing this? select * from table_name where field_name like '%whateverstring%'; ???

Thanks for the reply. I actually have this: where ... AND (gcc.segment1 BETWEEN :p_segment1_low AND :p_segment1_high AND gcc.segment2 BETWEEN :p_segment2_low AND :p_segment2_high AND ... is there any better way of doing this? In the...

Help! I need to create a report that will need to get Segment values (code combinations) FROM and TO range.