We are printing a report with a various number of rows and columns, depending on the user's options. We would like to give the user the ability of setting each column's width, text, and justification before the report is printed. We are considering displaying an edit table on the screen with the user's selected number of rows and columns and allow the user to adjust the column attributes of the edit table and then calculate those attributes to the report.

Has anyone tried this before and have any other suggestions that would allow the user more flexibility over the report layout?

Thanks.

1) You are on the right track from what I read.

or…

2) You could use an edit table and fill the edit table with the actual report. Each column of the report would be a column in the edit table. Then the user could adjust the column widths. Then when the user is all done they could click a button that would print the report using the edit table column's properties (widths) to modify the report.

If you are planning option 2, then I would suggest a seperate window for the edit table. And you could have all the report windows open this edit table window and fill the edit table. That way you would only have to build the edit table part only once for all your reports.

I did something very similar, except mine is enhanced so that I can pass the report heading, column headings, formats, conversions, totals, etc. Actually, I store this info in a data file. That way when a customer requests a "tweak" to a report, I don't have to change the "program". All I have to do is to change the data in the file. Very convienent.

A bit hard to do. And once it is done, all reports go thru that one edit table window and the hard part is over!

You could use a developer copy of S/List and just use the justlen etc overrides.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...