Why is my report SO big - corruption or calculations in controls?

[Madison06]

I have a report that is way larger than I think it should be. It's a basic invoice for an order but it's around 20MB. I need to have several different versions of this invoice so this is causing my FE to be huge and run slow.



It's got about 9 calculated controls (with lots of IIF situations that apply) on it and the reason why I'm not running the calculations in the underlying query is because these calculations rely on whether or not the embedded subreport .hasdata.

So for example, if an order has add-ons (from a table on the many side), the report needs to calculate that subtotal and then calculate things like adding sales tax (IF it's a taxable order), processing fees (IF it's a certain type of order) etc etc.

Could this be reason why the report is so large? Is there a better way to do these calculations? I *think* I've ruled out corruption. I recreated the report by copying and pasting the controls into a new report but it's still huge. Did I copy the corruption over? I have a form that runs these calculations as well and it's also pretty large (around 24 MB) so that also makes me think it's not corruption.

[mike60smart]

Hi
Are you able to upload a copy of the Db with no confidential data?

[June7]

I am curious, how did you determine sizes if these objects?

[Madison06]

Not really. But maybe these screen shots will help? That's it. That's the whole report. Nothing out of this world. Just a basic invoice with some calculations. There's a page break after that with some contract text (identifying info so I'm leaving that out) and a footer with some basics like page count and generated date.

[Madison06]

I am curious, how did you determine sizes if these objects?

Check file size, then deleted the object, C & R, then checked the new file size. Every time I deleted one of these offending reports, file size went down by about 20MB

[June7]

Why does EventType combobox show green triangle issue flag? Why using combobox on report anyway?

Would have to examine your db.

I tested with my largest db (24+ mb frontend). Deleting one of largest reports (includes several graph objects) reduced file by <500kb.

[Madison06]

Why does EventType combobox show green triangle issue flag? Why using combobox on report anyway?

Would have to examine your db.

I tested with my largest db (24+ mb frontend). Deleting one of largest reports (includes several graph objects) reduced file by <500kb.

I've been messing with things to see if I can figure out the issue so you can ignore that green flag. EventMenuPkg doesn't need to be a combo box - I can fix that. Don't think that's the issue though.

[Madison06]

I figured it out. I feel so silly but I have to share in case anyone else runs into a similar issue or does the same bonehead thing I did

The header of the report contains the company logo / letterhead and instead of inserting the logo as a teeny image file, I somehow inserted it as an unbound object linked to the word document that contained the letterhead *facepalm*. So of course when I copied and pasted all the controls over into a new report, I brought over the huge file size. Had I included that in my screenshot (withheld for obvious reasons), you guys would have figured it out instantly. You would have asked about the image.

Thank you all for your help!

[June7]

Image issue crossed my mind but didn't see indication of an image in your post. I should have asked anyway.