Solved

report generator

Posted on 1997-11-10
2
163 Views
Last Modified: 2011-09-20
I am looking for code for a simple report generator.
0
Comment
Question by:aktis
2 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 100 total points
ID: 1440373
You know, many of King Arthur's knights of the Round Table were known to have died in search of the Holy Grail, too!
That's probably why you haven't gotten any answers or even comments yet, nobody wants to throw themselves on your spear as well as their own spears!

One of the most frustrating problems in Windows is the printing problem.  With all the proportional fonts and device context settings, this getting a simple report is far from simple, and the easy methods are practically useless (printform, for instance).    

I have found a reliable conrol that I would recommend to you that simplifies printing in Windows somewhat, and provides preview capability: VS View from Videosoft.  At least you can send it a line at a time, and it works, which is a start towards a simple reporting engine.

Can you tell me more about what you have in mind?  That is:

Are you thinking of traditional summary type reporting, similar to the old "greenbar" reports from mainframes?

Are you talking about printing simple forms, or forms and graphics with text flow?

And what data sources are you generally working with?

An approach I have used successfully in the past is to break the problem down into two components, which I like to call "StepnFetch" and "FoldnMutilate", after the late, great, now defunct IBM corporation.

In "StepnFetch" you collect your field/data items to be displayed, and in "FoldnMutilate", you merge the collected data with a template format for your output report.  This works directly in one pass for a form, and you can wrap the process in a simple driver to position and repeat the cycle for multiple master records, with your From template set for report lines, rather than a form image.  You then have only two small and simple engines.  Each report is defined by two control lists, sharing a common name.  Then when you run the report, you can start it using the report system name, and optionally a starting key to locate on your data of interest.  

If interested, let me know and I'll go into more detail.  

0
 
LVL 1

Author Comment

by:aktis
ID: 1440374
please give me more details
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now