Search results for query: *

If the max records was set to 1 then I would only have one record per page instead of the usual 10. I double checked all of the obvious repeating frame properties and even tried to use minimum window records. As my messages indicate, it only occurs whenever there is more than x items in...

They are both set to down/across and does not improve whenever I change either or both

What I have I essentially 2 repeating frames. The main repeating frame (student) contains a list of students. The second group (classes) contains a list of their classes. Now for each student (repeating frame 1), I want to list their respective courses (repeating frame 2). I set up repeating...

The elasticity is set to fixed for both horiz/vert for the repeating frame.

I have report that places info onto labels. There are 10 labels per page (5 x2) and I accomplish this by using a repeating frame. Whenever there is more data than can fit into the area of one label(repeating frame area) it carries over to the next page and continues instead of the next...

I ended up scrapping the report and doing it over. It works fine now. Thanks for your input.

Yes, I am generating PDF output

Yes I understand report designer, I failed to mention that it works fine via client-server. The margins are only affected when deployed over the web via our application server. The margin is stretched to the top adn the section size is the same as the paper size 8.5 x 11 and the printer is the...

I have report (mailing labels) that I need to start off at the top of the page. I have the margin set at the very top of the page, but still have the first line starting approx 3/4 inches from the top of the page. This throws off the alignment of the rest of the labels. Any help is always...

Thanks Sem, nothing like keeping it simple

My query uses a union to select two fields from table stu. The two fields are stu_id, class. My goal is to list classes from both semester 1 (S1) and semester 2 (S2) without duplicating classes that were taken in both S1 and S2 (hence the union). I then want a count of the number of classes...

sem and santamufasa Continuing with the problem, as I mentioned earlier my database has several owners who use the same reports and forms. The owner with the most populated tables is the one in which the reports hang. I can run the reports for the other with no problem. I have increased the...

That particular owner is no longer around and data is stored on tape so recovery not applicable. Any other thoughts?

SantaMufasa, I work with a multi-user database that contains several owners contained within a tablespace. Each owner then owns several tables with that tablespace. I was on vaction and we received an ora-01653 error, so one of my coworkers decided to drop an owner using drop table statements...

I have taken a look at the tables and they appear as though they never have been analyzed. Does this have anything to do with the fact they have indexes? Any ideas?

Preface: I am really a programmer who has been saddled with DBA duties. Now, I am not sure what you are asking, any chance of dumbing it down a bit?

I have an Oracle 8i database and recently had someone delete an owner using a variety of select statements. Since then I have been having extreme performance problems running reports. Since learning of the incident I have examined the following: report sql sort_shared_size shared pool indexes...

Thanks, but I am not getting any row returned with your query. I double-checked the audsid to verify it is still in v$session but nothing is coming back.

I queried v$session and came up with some data, but I am not sure what I am looking at

I have a couple of reports that used to run fine, now for some reason they take forever (if at all) to run. I am using Oracle 8.1.7 and have already examined the tables and indexes involved in the processing. I even dropped and recreated the indexes. Any clues??