Reduction of report pages.

[sneuberg]

If i could do this i could reduce the report from outputing say ~ 3300 (all locations for each year shown) pages to `330 pages hanged).

Given the size of this report there's something you should be aware of that I forgot to mention. The code I provided creates a table each time the report is run. I couldn't find anyway around this. This means the size of your database will increase by the size of that table each time the report is run. To recoup that space you will need to run compact and repair. There's an option in the Current Database section of options to "Compact of Close". You might want to consider that option. Alternatively you could put this table in a separate linked database and have that database compacted as part of the code that runs the report. If you want to do this and need help setting it up, let me know.

 

[CybranACU]

Thanks, im probably going to have it compact on close, unless theres some reason this is a bad thing? Also i did have a question about the non-text data types, currently it pulls the data in this order, checkbox, number, text, and then repeats. Im thinking about leaving the checkbox out but would rather leave it in. How would I include these with this code?

 

[sneuberg]

I've modified the attached database so that the datatypes of the other data are Yes/No, Number, and Text so that it more closely resembles your system. You can see from the INSERT statement in this code how will need to create this SQL. The text fields in this statement are wrapped in the SQE function and have single quotes on both sides of them while the number and yes/no fields do not.

If you have problems creating this statement you can give me a list of the fields and their types or upload a portion of your database that has the input to this report and I will do this for you.