George,
Can you create your table so it always has the maximum number of fields? If some are not used they can be filled with ' ' or .Null Then design your report to show all fields, but use the "print when" clause to remove any .Null or empty fields.
If you don't know whether there will be 2 or 200 fields this would be hard to develop, but if your total fields is within a reasonable range it would.
>Is there a way to create a report to based on a table that can have a varying number of fields? I create the table on the fly and it is possible that the table will have more or less fields the next time it is created. I know you can create a quick report on the fly but my problem is there are too many fields to fit on the page and the extras get truncated. Any ideas?
>
>Thanks,
>George