Why is format event code running on the first record only.

[tstoneami]

I have a report with several sub reports that run and fill a table conditionally. The third sub report displays the records from this table. It works perfectly.

If I print a batch of records, it also works perfectly - but only for the first record. Previously, I had another report with several sub reports where the visibility of objects were controlled - this worked fine in a batch. Every subreport had the correct visibility settings.

In this case, I have a similar design, but instead of setting visibility on the various subreports, I am filling a table based on data in the subreport. As stated it works great for the first one in the group, or any single print.



Any ideas? Bottle of red for the first helpful answer!

[June7]

What do you mean by 'fill a table' and 'filling a table based on data in the subreport'? How does a report fill a table?

[tstoneami]

Based on the values in objects on the form another table is filled with relevent data in the format event using insert statements.

So, when the batch finishes running I had hoped to have a table filled with the correct data for the final sub report on the report. But it only works for the first master record in the batch.

I am probably going to attempt to fill the table before the report runs if this is just not do-able. It was a pretty convenient way of doing it though.

[June7]

It may be doable but probably difficult. I've never even considered anything like it.

Why save data that can be calculated when needed?

[tstoneami]

Jah, well, I am now going to try and fill a table before hand. Its not hard for a single record. ANyway, thanks.