Search results for query: *

I have a matrix report set up and it runs perfectly when it is not too wide for one page. When it takes two pages to show all the columns the formatting gets really messed up. Lines I have in the repeating frames don't show up where they should. Has anyone had this problem or know where I can...

I'm printing to an HP LaserJet 8150DN. I'm not having a problem sending it to the printer, but I need to have the first page print to tray 3 (letterhead) and all the pages after print to tray 2 (plain). I got the printer codes from the HP manual - tray 2 (&l1H) tray 3 (&l5H). Is there a way to...

I created a matrix that displays data from a query that does all the sorting I need for the report. When I run it in SQL*Plus it looks perfect, but when I run it in reports it looks like the matrix is re-sorting my data in alphabetical order. I don't want it to be sorted in alphabetical order...

I need to put the value of sysdate in the &quot;Value if Null&quot; property for one of my fields. I tried just putting 'sydate' and '&<sysdate>', but I got this error: REP-0613: Value does not match mask: 'DD-MON-RR' ORA-01858: A non-numeric character was found where a numeric was expected...

Thanks for your response. How do I create a package variable in Reports? Justin

I have a format trigger that looks like this: function R_G_sample_idFormatTrigger return boolean is begin if (owa_pattern.match(:sample_id, '^\D')) then srw.set_foreground_border_color('black'); srw.set_border_pattern('solid'); else srw.set_foreground_border_color('white')...

I tried putting the object in the next page and it still gave me the same error. Is there anything else I can try? Thanks, Justin

I have a report with address info at the top of each page, a matrix box for the body and then a text box that is displayed at the end of the report. When I run it, the first few pages are fine, but at a certain point when I try to go to the next page I get this error: REP-1814: Report cannot be...

When I put a run a report on my machine a parameter form pops up and asks me for input, but when I put it on the server and run the report it gives me an empty report. Is there any way to have the server prompt me for the parameters? Thanks, Justin

I'm creating a report that will be selecting data from a about 7 tables with a bunch of columns. When I run my select query I get this error: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP The select statement I'm using is below (sorry about the caps, Reports generated...

i figured out a way.. destype=delimited. there's a tab at the end of the line though, does anyone know a way to get rid of that?

I have created a report and have it writing to a txt file (destype=delimited), but I need to add whitespace in certain areas (mainly between the header and the body). Does anyone have any suggestions? Also, when I look at the file in my text editor there is a tab at the end of the line, is...

i have a basic report (one column, no fancy formatting, etc.) and need to save it to a text file that can be viewed in an editor like notepad. i've tried using the parameter form builder and set the Destination Type to &quot;File&quot;, but that just saves it as a printer file (not human...

I created a grid datawindow that I should be able to add/delete rows and edit rows that are already in there. The delete works fine, the add and edit won't work though (when I add I can see the row it added, but I can't edit the content of it). I get an error when I run it and try to type...