Search results for query: *

I have a report field that is vertically expandable an can have up to 2000 characters. Below it on the layout are other fields. The problem that I am seeing is that the large (2000 char) field is expanding, but the below fields do not shift down, such that the large field overwrites some of...

I have a requirement to reverse the Page-up, Page-down vs the Ctl-Page-up, Ctl-Page-down on a single form, but it remain normal for all other forms run from the same bin. So I cannot use Oracle terminal to change the values of the key-strokes since other forms in the same bin should not be...

I have a 6i report that includes a matrix that wraps to multiple pages (vertically, not horizontally). The problem is that even though the matrix covers about 8 pages, it is putting a blank page (heading but no data) between each one. I have taken page protect off the frame that includes the...

I have a column that is a varchar2(4000) for the user to enter lots of text. This column is selected in two different reports. In one of them, it reflects all the carriage returns and/or tabs, in the other one it does not. I have checked the property palette of both and they are identical...

I have a request to provide a windows pop-up to allow the user to specify the desired directory path (but not a file name) where the user wishes to save a file. The user will fill in the file name on the form, but desires to have a tool for specifiying the path to insure that the user gets it...

I have a strange request for a report that I am hoping someone can give me a suggestion on how to handle it. There is a multiple page report that the user wants a form feed after the first page. This is so the first page is printed with nothing on the back, and the rest of the pages are duplexed...

Is there a way using strickly Oracle products & tools for a PL/SQL procedure to read external files when we don’t know the file name, but do know the file location and that only files needed for this procedure are located in that location? After reading the file, I need to move the file to a...

I have a procedure that uses UTL_FILE to open and read a file. I am in an 8.1.7 database. Is there any way to programmatically move or delete the file after I finish with it so that the procedure doesn’t read it again?

I have a student using a form and entering information. I have in instructor looking over his/her shoulder. When the instructor is satisfied with the student’s work, he/she is to enter his/her username and password to approve it to the system. Is there a way in forms or PL/SQL that I can...

I have created a report consisting of its own section (command) and 3 sub reports. Each of the sub reports is located in the details section of the main report. The sub reports print on top of each other unless I spread them out a lot in the design screen. Is there a way to make each sub...

I am running Crystal Reports against an Oracle database. Is there a way I can have Crystal trigger a procedure in Oracle before it executes the commands to fetch the data for the report?

Is there a way in Crystal Reports 9, to make multiple Groups to list horizontally across the page instead of vertically? I have checked the ‘Format with Multiple Columns’ and the ‘Format Groups with multiple columns’, but this still list the groups down the first column before moving to the...

I have a matrix report where the layout was created by the wizard where all but the last couple of rows and the last column fit on the first page. The second page list the last column for all the rows from the first page, then starts listing the remaining rows but the columns that line up with...

I am obviously a novice at Crystal Reports. I need to create a report with columns where the group object is the column heading and the details are under it. My report has all the data I need on it, but it just list the results in a single column down the left hand side of the report. I tried...

I have a report with a signature OLE in it. It looks good when I run the report in normal environment. If I use the 'Generate to file' option and choose pdf, the OLE does not show up. The client wants to be able to email the report to its clients and wishes to use the pdf format for the...

I have a 9i form that needs to be able to print a bar coded label to a printer attached to the client. When I make a HOST call, it trys to print to a printer attached to the server. I found some notes on Metalink that indicated that with java beans, this can be accomplished. My shop knows...