We are adding to an AREV application using OI32.

We will continue to use the AREV database and application for about 75% of the new application. All was going well until we had to print an Invoice.

We are trying to use Revelation Reporter.

We setup a Blank Report with no Report Header

We have a Page Header with Customer info . (both text and data)

A Detail section with item and price info (which are Multi-Value Fields)

A page Footer with totals and other info. (both text and data)

If I set all section to min size all prints well except there is no data in the page footer section .

If I increase the size of the page footer to 50% of the page or so then the data in the footer will print out however only one or two Detail items will print per page.

Can Revelation Reporter be used for invoices???

Could it be a bad install??

It is running on a nt2000 server single user no network.

Any suggestions would be appreciated.

Paul,

As many here know, we do not use nor recommend the Revelation Reporter. Others have had better success that we have but overall we are still suspicious of the tool and it's quirks. With that said…

Can Revelation Reporter be used for invoices??? In theory yes. However, this was the specific area we struggled with for a long time before abandoning it. Get anything to consistantly print in the footer area was nearly a miracle, especially totals. Could it be a bad install?? Anything is possible. If anything it would be a bad install on the computer and not a bad install on the CD. I would reinstall to make sure. It is running on a nt2000 server single user no network. This is not an issue. Only Win98SE machines can't use the Reporter. Since this is a migration from AREV, I assume you already have an invoice printing solution there. How was this being done? Your solution in AREV will help me recommend the best approach to take with OI32. [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 24 DEC 2002 07:29AM Don Miller - C3 Inc. wrote: === <QUOTE>I second Don B.'s comments. Frankly, OIPI is just so much easier. I, too have AREV apps that used standard PRINT statement logic since REV-F and worked well for many years. I tried doing a direct port into OI-16 and had a devil of a time. Coded it from scratch in OIPI in less than a day (same general logic, updating, etc.) and got very precise control over text placement, page overflow, etc. .. all the things that are necessary. I don't know if you tried Banded Report Writer in AREV, but I didn't have any luck with that one either. Just my opinion, though. Don Miller C3 Inc. </QUOTE> —- === At 24 DEC 2002 03:06PM Richard Hunt wrote: === <QUOTE>Paul, If you do not want to use the other mentioned products, you could crate a program to print to your printer. There are six functions that I use within my "reporter". 1) SUCCESS=PRINT_INIT(1,REPORT_NAME,WINDOW_HANDLE) 2) SUCCESS=PRINTSETMARGINS(TOP,LEFT,RIGHT,BOTTOM) 3) SUCCESS=PRINT_SETFONT(FONT) 4) SUCCESS=PRINT_TEXT(TEXT_STRING) 5) SUCCESS=PRINT_END() 6) SUCCESS=PRINTPAGESTATUS(1) I use this to be able to manually control headings. This will allow you to print to your printer. Takes some programming, although it does work. I have created my own scripting code for my "reporter". It allows for report headings, column headings, column spacing, column justifications, column conversions, column totals, column grand totals. What I like the most about it is that it truncates and or handles the overflow column data very nicely. Even the overflow of multi valued associated column data. I have special needs for my reporting. I need to be able to display it on the screen, print it, or save it to a file. And to be able to print the saved report to any type of printer. </QUOTE> —- === At 25 DEC 2002 12:19AM Donald Bakke wrote: === <QUOTE>Richard, How do you handle right-justified displays using the Print functions? I'm curious as to why you used these functions rather than the OIPI for your custom reporter. [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 25 DEC 2002 10:09AM Richard Hunt wrote: === <QUOTE>Don, Using the "FMT" command allows me to right justify. Ofcourse the "FONT" needs to allow it. By default I use the "Courier New" font. I had created the programs before OIPI, so I just did not have a need to make the change. </QUOTE> —- === At 25 DEC 2002 12:06PM Donald Bakke wrote: === <QUOTE>Hi Richard, Right…you need a fixed width font to use FMT when printing. Unfortunately for us we needed (and wanted) the ability to use any font. That's just what our clients expect when they use a Windows based application. Now if Splaver's DirectPrint utility had been available from the beginning then many problems would have disappeared or at least been deferred. [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 25 DEC 2002 03:47PM The Sprezzatura Group wrote: === <QUOTE>Happy Christmas Don The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 25 DEC 2002 05:42PM Donald Bakke wrote: === <QUOTE>Christmas, what's Christmas? [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 26 DEC 2002 09:25AM Richard Hunt wrote: === <QUOTE>When not using a fixed font, I use the utility "textrect". In simple terms you would textrect to find the width of the string of data. Textrect a single blank space. Then calculate the amount of blank spaces to prefix (for right justification), suffix (for left justification), or both (for center justification). That is the way that I format the columns with left or right justification. I also use "textrect" to calculate the font size automatically. That way the report remains a single page width. Landscape or portrait. And I do realize that OIPI probably is "alot more". </QUOTE> —- === At 26 DEC 2002 11:55AM Donald Bakke wrote: === <QUOTE>Hi Richard, We use TEXTRECT for similar purposes. However, I have to believe that you aren't getting precise right-justified alignment because padding with spaces doesn't give you that degree of control. [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 26 DEC 2002 01:39PM Paul Bogdanovich wrote: === <QUOTE>Thanks for the info. With the many things I tried to get Reporter to work with no success I was afraid I?d get a answer that Reporter just did not work. In the Arev app. I used Merge report to print to a dot matrix printer. </QUOTE> —- === At 26 DEC 2002 01:43PM Paul Bogdanovich wrote: === <QUOTE>What is OIPI? Where do we get it? </QUOTE> —- === At 26 DEC 2002 02:53PM The Sprezzatura Group wrote: === <QUOTE>If it's of interest we have a product that prints AREV Merges under OI without conversion. The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> —- === At 26 DEC 2002 02:54PM Donald Bakke wrote: === <QUOTE>Paul, The OIPI comes with OpenInsight. Look in your online Programmer's Reference guide under Appendix C:Advanced Printing Examples and Techniques or look for the Set_Printer and Get_Printer functions. [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 27 DEC 2002 01:00PM Paul Bogdanovich wrote: === <QUOTE>What is the name of the product? That could be a way to go for now. </QUOTE> —- === At 27 DEC 2002 01:05PM The Sprezzatura Group wrote: === <QUOTE>Uncomfortably close to a Bond film villain - S/Merge. Rather than turn the forum into an advertising medium please drop us a line at [email protected]. The Sprezzatura Group World Leaders in all things RevSoft </QUOTE> View this thread on the Works forum...