FONTS in Oracle Reports

[mcintysh]

Does anyone know how to get a font to be used in Oracle Reports? I see it and can apply it to my report fields or the whole report but it does not print this font. I also do not see this particular font in c:\windows\fonts, obviously this font came when I installed the printer. Is there something I need to add in my regedit to make sure the font I selected is used? Does anyone know anything about this? I asked about the uifont.ali file as well but no one has responded. I would appreciate any help.

Thanks.

 

[nagornyi]

Do you have access to Metalink? I didn't happen to touch your issue myself, but I see a lot of materials and Oracle tech papers comeing back if I type uifont.ali in the search window.

 

[mcintysh]

Hello Nagornyi! Yes I have access to metalink which is where I got most of the info. I guess I just don't know how to put the Tally Data Processing (10cpi) in the file - most examples say Arial = "Courier" and that just seems simple enough but again when I put the Tally printer fonts for everything in that file nothings happens.

Anyway, I finally got these bills to print but again it ignores the fonts that we really want and now I am convinced that it is a Windows problem because this is the same report I have been working on for months now with the initial lines per inch needing it to be 8 that I was told to use a printer definition file that also never worked for me. I think the customer is convinced that maybe going with a laser printer that also will printer preforrated paper is what they might look at next. Anyway, I appreciate all your help. I do have one more question that maybe you could help me with which is with this same report.

There is only 2 tables in this report, one is the master which would hold account number, bill amount, arrears amount, and some reading dates, then you have a details table which would have sewer details and a previous reading amount, present reading amount and bill amount and a service code. This works all great so I have a main frame, with a repeating frame which is from the main table and then I have a repeating frame which is the detail. Here is the problem, the only want to see 6 items of detail and here is what the bill looks like:

ADDRESS SERVICE REQUESTED

1000099999 (this is acct no)
312 Main Street
04/01/05 (date of bill)

03/15/05 03/30/05 100 250 WA 25.00
(service dates) 250 300 SW 50.00
300 200 WA 75.00
100 200 AD 25.00
210.00 100 200 WA 25.00
400 375 WA 10.00
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1000099999999

210.00 Jane Jackson
312 Main Street
Summerville, SC 29083


So the detail is the section up above that is the rows with the 100 300 WA 75.00 and so what it is they only can have 6 itmes on a bill and so what I did in the report was set the maximum records per page to 6 and this worked great but what happens when I have more than 6 the main data the account number, the prev reading date and pres reading date and the mailing address all do not come forward on the next bill I only get the 7th item of the detail. I tried to put a M frame around the details repeating frame and then anchor that to the main repeating frame and that didn't work and I also tried to anchor it to the main M frame that that didn't work, what would happen is the acct info would come with it but the detail rows would show all detail rows for all the accounts on a bill until it had 6 and then go to the next account bill and print 6 more and so on and so on and so the correct detail rows did not go with the correct account.

Any ideas on how I could have done this? What I ended up doing is writing sql that only pulled details where they were not more than 6 items and that is my main query in my report for my main layout and that works fine and then I wrote a package that goes out and pulls only the master data with details of over 7 and build a temporary table and then I copied the same layout and put it in the header section and instead of having a repeating frame for the details my table is set up like prev read 1 thru 6 for all the details row. I couldn't think of another way to get this to work but I really don't like it and was hoping you could help because I would prefer that the Oracle Reports could handle what was trying to do.

If it would help to see the report I could email you a copy so you could look at it. In the meantime I appreciate your help. I have always thought Oracle Reports could do just about anything in a report but maybe I was just working too long on this because I never could get it to work but had to come up with something. The bad thing about the way I did it is, I had to put test bills in my temporary table which the customer wanted so that they could line the printer up and without those test bills if no data was found which was greater than 7 details rows then I had page 1 as an empty page so I had to make sure the test bills stayed in that temporary table if nothing else to make sure I didn't have an empty page. I guess that isn't a big deal. One last thing, the main reason why I was needing all the bills together is that I have a barcode on the bill right above the address and so the query is ordering by zip code because the customer has a machine that separates the bills (there are 4 bills per sheet of preforrated paper) and so they go thru them and put them in zip code order and so now I have these items with 7 or more and then the main batch and so she is going to be off a couple of bills with zip code order. I was told that the most they would have of items over 7 would be able 13 customers so it isn't much.

Anyway ideas of a better way to do this would be greatly apprecaited.

Thanks so much.

Sheila

 

[nagornyi]

Sheila,
to have the fields of the outer repeating frame printed not only on the first page of the group, set their "Print Object On" propery to "All Pages".

 

[mcintysh]

That doesn't work for me - what happens there is that I only get the first bill with the first 6 items and then the next bill with the next 6 items which is a different account.

I fell I have tried just about everything which is why I went with the other way I did it but I am still convinced that Oracle can handle this but I sure don't know what I am doing wrong. Again I would love to send you the rdf file and let you look at it if you have time and maybe you could see immediately what I am doing wrong.

Thanks.

Sheila

 

[nagornyi]

That sounds like you selected "All Pages" for the repeating frame's "Print Object On" property also. You need this property only for the fields of the outer frame, not for the frame itself. The frame still should have "First Page".

 

[mcintysh]

Well that was it. I am so amazed. I worked on this for weeks and like I said finally went into production using sql that did a group > 6 and then a package that looked for items over 6. You were right I was putting it on the repeating frame the main one and of course I only would get one page and so I kept playing with it and finally just tried it on a couple of fields and it worked perfectly. I just got your email saying that it should have been the fields so I really appreciate your giving me some options to try.

The main reason why I wanted this to work this way is that the bills have to be sorted by zip code and with having to do it with 2 different layouts I was not able to keep all the zip codes together. Thanks again for your help you are a lifesaver.

Sheila