Suggestions about making reports with tables

[RedLion]

Hello I would like to get some suggestions about making some reports dynamically for printing.
I've got an table with all kind of results. The number of types and the number of results is unknown, so the report has to be totally dynamically. The report will start with a header (a few lines of info) and then a table with the types and their results. And know I'm searching for a way of making such a report?

Because in the VFP-reports you need to know the number of attributes (from left to right) in advance. You can only group by attributes up and down.

Any suggestions are welcome,

Thanks Charl

 

[fluteplr]

My suggestion. Go wtih the flow, group up and down like the report writer is designed to do. Is it really worth turning a 1 hour programming project into a 12-20 hour project? I have been doing report writing for about 20 years, if you explain it to the person requesting the report in those terms 99% you will find that vertical grouping is just fine.

 

[RedLion]

Is it really worth turning a 1 hour programming project into a 12-20 hour project? Yes, because there are a lot of test result that should be looked over in one eye view, and it is not very handy to browse through a couple of pages.

It's one big table, that has to fit on one table.....
into a 12-20 hour project? So it's possible? Any ideas about the basic idea, where to start?

Thanks Charl

 

[jimstarr]

Hi Charl,

What does your "results" table look like? Is it one result per record?

Jim

 

[RedLion]

Hi Jim, a simple look at the result table:

---------------------------------------------------------------
|Mac|ID|Am1|Bm1|Cm1|Dm1|<--and more...-->|tot.|
| | | m2| m2| m2| m2| | |
---------------------------------------------------------------
| 1|AA| 30| 27| 28| 30| | 115|
| 2|CC| 26| 30| 1| 10| | 87|
|... |
| ^ |
|and more.. |
|... |
---------------------------------------------------------------

There is:
Mac = MachineID
ID = employeeID
A = day that the machine has worked
m1 = result first half day
m2 = result second half day
Tot = production result

I hope you have an idea for it!

 

[jimstarr]

Hi Charl,

In the detail band of your report you need to have a space for every possible column in the table. In your case the detail band will be multiple lines. For each field use the &quot;Print When&quot; option, setting it to something like &quot;NOT EMPTY(field1)&quot;. Also, on the 2nd and subsequent lines of the detail band use the &quot;Remove Line if Blank&quot; option.

Hope this helps.

Jim

 

[RedLion]

Remove Line if Blank nice...

It is something, thanks Jim...

Only when not all columns can on one page, then there is a problem, because MAC and ID have also be printed on that second page...

I am going to think about it...

maybe I'll get a brilliant idea............ I hope ;-)

Charl

 

[jimstarr]

Establish MAC and ID as a Group Header. Then use the option &quot;Reprint group header on each page&quot;.

Jim