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
