473,320 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Have a Sub-report display a Print Preview rather than the Report View

108 64KB
I've been trying to figure this out for some time now to no avail. Is there any way to make a sub-report in a form or a report to show up as a print preview instead of the report view? There are several differences in the way these two are formatted. I've tried setting the default view to "Print Preview" for the report that is inserted into another form or report, but this doesn't help. There have been many occasions where the report view falls short of what I wanted to portray, and I feel like this knowledge could help a lot of users.
Jan 16 '14 #1
5 6876
zmbd
5,501 Expert Mod 4TB
AFAIK: You can not directly embed the print-preview within a form. There was a method using the snapshot viewer; however, I do not recommend this route as this control has been removed as of ACC2010 (Access 2010 deprecated features and components


Question, why do this in a form?

As for subreports... I've never seen this happen. If I open a master report in print preveiw, it opens all subreports as resolved. Perhaps some more detail there?
Jan 17 '14 #2
GKJR
108 64KB
Hi zmbd, in certain circumstances I use a form to select filter criteria for a report. I embed the report as a sub-report on that form so you can monitor what it will look like. I would like to show the print preview so that I wouldn't need a vertical scroll bar and I could use page selectors. It would make it a lot easier for some of my co-workers to follow. Also, the page numbers would be accurate to the printed report, as opposed to always saying Page 1 of 1.

As far as reports with embedded sub-reports, the problem I have is when the sub-report is either more than one page or it is split up into two pages because of where it starts it doesn't show the page headers for the sub-report. It is essentially the report view of the sub-report.
Jan 17 '14 #3
zmbd
5,501 Expert Mod 4TB
The problem with what you are doing is that... the report preview isn't ment to be dynamic.

Your only workaround her is it let the user set the filters in the form and then show them the report in a normal print preview pane. If the report is good then they can print it. Even the new acc2010-NavigationControl has this limitation.

As far as reports with embedded sub-reports, the <..>starts it doesn't show the page headers for the sub-report. It is essentially the report view of the sub-rep
Page headers
or
Report headers

These are very easily mixed up. I had an individual at work that swore to me that his page headers/footers were not showing up in the sub-reports. What was actually happening was that he had set the report header to repeat and because report header do not show up in sub-reports, these were suppressed. We moved his report header to the page header and all is well.

Once again, I do not recall having seen the issue you describe in subreports in the report-print-preview. I'm at home; however, Monday when I go to work I'll open the EOY report I have, does a monthly summary with usually 3 to 10 pages for each subreport for each month (I don't run this often anymore) just to be sure I'm not overlooking something (^_^)
Jan 18 '14 #4
GKJR
108 64KB
Thanks for your help zmbd. At least I know I can stop trying to look for a solution that doesn't exist. I was more concerned with the sub-reports in forms because I use that method for a lot of different aspects in my application.
Jan 18 '14 #5
NeoPa
32,556 Expert Mod 16PB
As for the Subform/Subreport control, this is a control on the main form or report. I'm pretty sure there is nothing in the design/properties of the control that allows for specification of how it runs.

Thus, it is opened automatically at the time the main form/report is opened and so will take the context from the parent open call. Subforms are not ever opened by any VBA call. They are opened by virtue of the main form/report being opened only. Thus there cannot be a parameter that can specify what mode to open in as there is for the call to open forms/reports normally.
Jan 18 '14 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Matt | last post by:
If I do the following, it will pop up print dialog. But i want to produce "File->Print Preview" Screen. Is it possible to do that? <input type="button" value='Print Preview'...
1
by: Marty | last post by:
How do you print preview a crystal report in C#.NET? Thanks.
2
by: AG | last post by:
I am using PrintPreview control in my VB.NET application. But when we display print preview, only the last document is shown, and I cannot see five or six documents there. Seems like as soon...
2
by: Dean Slindee | last post by:
Anybody written code in VB.NET to: 1) show a print preview window of reports already written and stored in an Access 2002 database; or 2) execute the print of a report stored in an Access 2002...
1
by: jj | last post by:
I created a dynamic report and the fields is displayed base on the query. The report contains about 34 fields so if the query has 34 fields, all 34 fields in the report shows up. But if the query...
0
by: Andrew W | last post by:
Hi All. I have a form with a subform. When viewing the form via 'form view' the subform does not appear. But when I go to 'print preview' the subform appears. This leads me to believe that...
1
didajosh
by: didajosh | last post by:
Hi, I am working on a accounting report.it looks like ------------------------------------------------------------------------------------------- Group code (group by) Org Code(group by) ...
0
by: kaybaj | last post by:
Please i want my report to display "Print Ribbon" when the report is in 'Report View mode' it only shows when the report is in "Print Preview mode" what can i do
2
by: Jewel8368 | last post by:
Hi I have a subreport in the report footer of a report. When viewed in report view the subreport and data appear. In print preview only the subreport text label appears. There are additional...
5
by: Yousaf Shah | last post by:
Hello everybody. I am developing database for my patients. I have almost the needed stuff but now struck at report level. At the end of all required data entry, I want to give prescription to my...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.