Solved

report generator

Posted on 1997-11-10
2
165 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

895 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

15 Experts available now in Live!

Get 1:1 Help Now