Can't get a report to show in print mode (1 Viewer)

[MarlonVisser0408]

When I put my report in a main form, it keeps showing the white lines. The only way so far that I've figured is that if I put it to print mode, it shows correctly on the subreport. In the options, I've put the default view to Print mode, but yet it seems that it's either calling the wrong mode or is adding those same white lines; just this time to the print aswel.


Objective:

Currently:

 

[theDBguy]

You might want to annotate your images to help identify which part of the image you're referring to.

 

[CJ_London]

Why are you using a report? Why not a form? And you appear to be showing 2 reports but you say ‘my report’

Best guess is you need to resize the subform controls

 

[MarlonVisser0408]

Why are you using a report? Why not a form? And you appear to be showing 2 reports but you say ‘my report’

Best guess is you need to resize the subform controls

As far as I understand it, you can't use can grow and can shrink in forms, can we? The only reason for me to use it is so that I can minimize the report that we use daily to only hold the information that we have while using an add or edit form to access the 'new fields' that we didn't have the information for earlier.

 

[CJ_London]

agreed - but your problem, based on the consistent size of your report rows, is the subform control. If you were to print the form, the subform control can use can grow/shrink.

you can mimic the effect by calculating the required height. Not sure if it works with reports, you'll have to try it but with a form you would use code along the lines of

mysubform.height=mysubform.form.section(1).height +(mysubform.form.section(0).height*(mysubform.form.recordset.recordcount)+mysubform.form.section(2).height

Section(1) is the header, section(2), the footer and section(0) the detail. Leave out of the above calculation those you don't use. You may also need to put a bit of a margin on to allow for padding.

You could also just use white rather than black for your main form and set the subform border style to transparent

 

[LarryE]

When I put my report in a main form

How did you insert a report inside a form?

In the options, I've put the default view to Print mode

Where did you find a Print mode default view option?

 

[MarlonVisser0408]

How did you insert a report inside a form?

Where did you find a Print mode default view option?

This is where I'm inputting it

~
The print mode default: Even though I'm pretty sure that's about the view in the report itself and it doesn't have anything to do with how the report prints in a form/subform.

 

[MarlonVisser0408]

You might want to annotate your images to help identify which part of the image you're referring to.

The red lines are rows that are generated automatically somehow. I need it to grow to the point it shows all data, I need no extra line there

 

[MarlonVisser0408]

agreed - but your problem, based on the consistent size of your report rows, is the subform control. If you were to print the form, the subform control can use can grow/shrink.

you can mimic the effect by calculating the required height. Not sure if it works with reports, you'll have to try it but with a form you would use code along the lines of

mysubform.height=mysubform.form.section(1).height +(mysubform.form.section(0).height*(mysubform.form.recordset.recordcount)+mysubform.form.section(2).height

Section(1) is the header, section(2), the footer and section(0) the detail. Leave out of the above calculation those you don't use. You may also need to put a bit of a margin on to allow for padding.

You could also just use white rather than black for your main form and set the subform border style to transparent

That's the first time that I hear about this. This absolutely great. This is something I can use for almost all the problems I faced that made me turn to a report instead. That just leaves 'logs (long text) as the only problem left, but it still downsizes the database by like 15-20% in trade for code.