Hi,
Can you tell me if it is possible to create a main report with a Portrait view and then add a sub report to the main report and print this out in landscape mode. If you can please can you advise on the best way to do this. Thanks PWF
I have an existing report generated in Access 2007 that is currently in Portrait mode and I want to reformat the data so that it fits into Landscape mode.
The report consists of a main report and 2 subrports.
I have managed to do the majority of the reformatting to both the main and subreports except that I can't figure out how to change the layout of the actual data that is displayed.
What I'm talking about is the "slider" control (if this is what you call it) that is displayed on on the main report.
I have attached a few screen shots ....
Is it possible to have part of a report set to portrait, but another part set to landscape? Like you can in Word by adding section breaks and setting the page layout separately for each section?
I have a "MainReport" comprised of 5 sub reports which are all portrait. Now I've been asked to add a 6th section and it will need to be landscape. I tried and tried to get it all on a portrait page but it's just too cramped.
I could keep them as two reports and have the command button simply run the second one at the same time. The thing is, that button "prints" the main report to a PDF file and emails it. And I don't want the new report to be in a separate PDF.
If you can't have separate sections, then is there any way to print separate Access reports into a single PDF? I'm using CutePDF but would be open to trying a different PDF printer if appropriate.
must i install a printer in order for me to change my report to landscape?.. This doesn't sound right to me.. currently my report is set to portrait and when i go to page setup (menu option) i receive a msg saying i must install a printer first.. is this the only place where i can set my report to landscape?.. is there a property i've overlooked?.. thanks!
View 4 Replies View RelatedI have a landscape oriented report which is A4 size. When I select Landscape in print preview the result is cut off on the right. In the form's design mode I get a little green triangle on the top-left which tells me that the form is wider than the page size. Is this because I am using a default printer with a portrait setting?
I want to avoid having to change the default printer for each different form orientation. I am printing to a pdf printer (pdfCreator which doesn't appear to have a landscape output setting) while testing my design so as not to waste ink & paper.
I am using Windows XP SP3 with Access 2007.
I have a report that displays incidents, their details, consequences and a photo. Among the details is a severity rating high medium or low, I have been asked to make the report shorten the records which have been given a low severity (because it takes up as much space as the more important/severe ones).
The only method I can think of is to use the onformat event, to shrink and make invisible all the fields that I don't want to see if the severity field shows 'low'.
In Access 2010, I have a simple sub-report I use to count a field. Works perfect by itself. However, when I place it in the main report the results change. And it doesn't matter where I place it in the Main report, it still returns a low count. Is there some filter I am missing?
View 5 Replies View RelatedBelow is the working version of the code works for single report filtering. say a report called "rptduedate_census2" and i can filter out using form instead of hard coding query of that report (say lastname=form!frmsample!txtlastname). I dont want to hard code query and there are reasons for that.
I am using a Main report called "rptDueDates_Dept' and there are about 10 different subreports (see print screen). The main report is not bound to any query. It has many subereport. Each subreport is bound to some query and i need to be able to filter them before data appear on the main report. Am i making any sense, LOL.
How can I implement my working code below to do this. PLEASE PLEASE PLEASE HELP. I AM NEW TO ALL THIS. I have attached a print screen of the main report, just to show how i put subreports in their.
===== MY WORKING CODE ======
Private Sub cmdPrv_Click()
Dim strFilter As String
strFilter = "[Mail_Census_Date] BETWEEN #" & txtStartDate & " # AND # " & txtEndDate & " # "
' Apply the filter and switch it on
If SysCmd(acSysCmdGetObjectState, acReport, "Report") <> acObjStateOpen Then
DoCmd.OpenReport "rptduedate_census2", acViewPreview
With Reports![rptduedate_census2]
.Filter = strFilter
.FilterOn = True
End With
DoCmd.Restore
Exit Sub
End If
End Sub
I have seven (sub) reports put on to a large report. How can I get the reports to shrink or grow according to how much info they have in them. I have tried Detail - Can Shrink, Can grow - but this doesn't seem to work. At the moment I have them all lined up but they are all overlapping each other.
View 3 Replies View RelatedI have a main report with one subreport. The main report contains details of a payment being made to a supplier. There is the total amount being paid, and the cheque number being transferred. There is also a field called payref which is made invisible. This is used to link up with the subreport. The amount is the total of several invoices for which payment is being made.
The subreport contains details of each of a number of the invoices being settled. The subreport is linked to the main report via a common field called pay-ref, and the subreport is 'visible'. The subreport prints when placed in the page header section of the main report. However when there is a large number of invoices being shown in the subreport only a certain number appear. It appears that the subreport can only hold a certain number.
When the subreport is put, as it should, in the detail section of the main report, it does not appear at all in the main report. I have no clue why and I have made several reports like this one before.
Access 2007
Windows 7
Trying to get a subreport total to show on my main report
getting #error no matter how I code
Running a subreport containing a total in report footer (only field that
name of subrpt total fld subrpt
[SubRptExp].[Report]![gramtrcvd]
I am trying to get my totals from my subreports, and dividing the number by 2 or 4, and put the new number on the main report.
for Operator/Trainer Productivity, I used:
=([rptEmployEvaluationOperator subreport].[Report]![OPTotal]+[rptEmployEvaluationOperatorTrainer subreport].[Report]![OPTotal])/2
for Auditor/Trainer Productivity, I used:
=([rptEmployEvaluationAuditor1 subreport].[Report]![OPTotal]+[EmployEvaluationAuditor2 subreport].[Report]![OPTotal]+[EmployEvaluationAuditor3 subreport].[Report]![OPTotal]+[EmployEvaluationAuditorTrainer subreport].[Report]![OPTotal])/4
These both work if there are values in all totals subreports. When one of them might not have a total, I get an error message.
I tried to use :
=IIf([Orders].[Report].[HasData], [Orders].[Report].[txtOrderValue], 0)
=IIf([Orders].[Report].[HasData], Nz([Orders].[Report].[txtOrderValue], 0), 0)
=iif([rptEmployEvaluationOperator subreport].[Report].[HasData],([rptEmployEvaluationOperator subreport].[Report].[OPTotal]+=iif([rptEmployEvaluationOperatorTrainer subreport].[Report].[HasData],[rptEmployEvaluationOperatorTrainer subreport].[Report].[OPTotal])/2
and the same idea for the second one. I tried both methods and did not work. I am not sure what I am missing.
I have a database (Access 2007) that handles a large number of consultants. Each consultant has a number of skills, has worked in a number of countries, and speak several languages. As contracts come in, I wish to generate a report based on the skill set, language and country/countries that best suits the contract; thereby identifying a group of most suitable consultants. I have designed a report with three sub reports for skills, languages and countries. Each sub report is linked to the main report through Link Master/Child fields using the ConsultantID. That's all fine; I get a report showing all consultants listing all their qualities.
Now, I want to be able to filter the sub reports on the three aspects: Skills; Countries; and Languages.
In the past, for other applications, and with the unfiltered form in preview I have used a popup form with unbound Combo Boxes to generate a string to use in the reports filter. I think I got that technique from Allen Browne, and it has really served me well.
Now, however, I can't use this technique since I can't set the filter for the sub reports. I thought that I might be able to use the Link Master Field with text boxes on the main report, but haven't managed to figure that out.
I have a subreport with bitmap files attached, the sub works great until I link it to the main report then the sub shows nothing.
View 2 Replies View RelatedI have a button on my main form that allows me to view one of my reports. In order to view the report I have to close my main form. My problem is how do I reopen my main form when I close the report that I have viewed? Some code that would reopen my main form when clicking on the X in the upper right hand corner of the report to close it?
View 13 Replies View RelatedI have a subreport that works fine on its own. But, when I link to the main report I have an error, which I am attaching here.
View 1 Replies View RelatedI am relatively new to Access. I am having difficulty summing up totals and bringing them into the main report. To be more specific I have two sup reports called WOExpenseTotalSubreport and WOServiceTotalsubreport. These two subreports are based off of queries that gather the description, price and qty of either services or expenses and then produces a "total" for me on the query.
When I bring these two queries into a report as sub reports I am able to Sum the "total" field in the subreport footer which works fine. What I would like to do is add those two totals together for a grand total on the main report. The two summed fields are called ExpensesSum and ServicesSum. It seems most things I have tried do not produce an expression error but the result is either #error or #name? Here are a few different scenarios I have tried both on the main report details section as well as the footer section.
=[Reports]![qryWOExpenseTotal subreport]![ExpensesSum]+[Reports]![qryWOServiceTotal subreport]![ServicesSum]
=Sum([qryWOExpenseTotal]![Total]) + Sum([qryWOServiceTotal]![Total])
=[qryWOExpenseTotal subreport].[Report].[ExpensesSum] + [ qryWOServiceTotal subreport].[Report].[ServicesSum]
I have a main report with 2 subreports. My main report has a header section, the 2 subreports are in the detail section of my main report. How can i prevent my report from splitting up my header and my subreports. (Header section of my main report is a company and the subreports are the detail of the company.. i don't want my compnay name on the bottom of a page and then the detail on the next page.. it does this sometimes. thanks!
View 5 Replies View RelatedI have fields on the main menu where folks put in a start and end date prior to running a report. I'm doing a monthly report that pulls current month, and two prior months of data. For example, the user selects a date range of 10/1/14 to 10/31/14 the report will show August, September and October results.
I need the column headings to change each month depending on the date range they select to run the report so in November they will pull 11/1/14 to 11/30/14 and get September, October and November.
The headings for the columns would then adjust.
I put an unbound text box with the formula as follows in the control source of the report page header to pull the month that is equal to the current month minus two (I'm just showing one of the column headings formula):
=Format([Forms]![Main Menu]![EndDate]-2,"mmmm yyyy")
This is not working. It's pulling the current month which I have set to run for October so it should show August 2014.
I'm trying to create a report that contains data from a "main" form and a subform. However, I can't get the main form data to populate no matter what I try. I've been through all sorts of queries and just can't get it to work. The main form and subform are both separate tables, and there are no redundant fields.
Basically, the main form is an inventory of assets, and the subform is designed as a way to submit trouble tickets when one of those assets requires maintenance or repair.
I'm working on a database that produces employee contracts. To make it look as professional as possible I hide the Access main window when the splash screen loads using the ShowWindow function. The various forms to check and enter details all pop up without any problem, but when I get to the last stage where I use a report to produce the contract and then open it in PrintPreview mode, it won't display (unless I show the main window again , which looks very untidy!). Is it actually possible to display a report with the main Access window hidden?
View 6 Replies View RelatedI have VBA code for a Print Preview button on the main form that previews the current record in a separate Report using this code:
Code:
Private Sub cmdPrintRecord_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
[code]....
I use this Print Preview code on a Button in the Form Header. The Main form lists head of household information. I also have a tabbed control with three tabs that have SubForms for Address, Children and Contact details. The problem I have is that if any of the subforms are left blank I get a Run-Time Error '3021': No Current Record. If I Debug (press the button), it takes me straight to this line:
Code:
varAge = DateDiff("yyyy", varBirthDate, Now)
highlighted in Yellow.Anyone on my database must have an address, should have contact details and could have children. If any one of these is blank then the print preview will not work.I would like to know how to stop this error happening for blank records in my subforms.
I am trying to create a P&L statement in access. I know what I want to come out at the end. I am just starting to play with access and having trouble getting what I want to come out of it.
On the sales side I have a query that gathers all the revenue sources and calculates a total for each date. I then use a second query to just take out the data I want for the P&L report. I created a sub-report that displays the data I want. I use the grouping and grand total features to get the total into the report footer. So far so good.
On the expense side I created a form of a query to manage the one to many relationship to capture the data for expenses (one purchase with many line items). I created a query based of this query to get the relevant data for my expense sub-report. I created the sub-report and got everything looking and calculating the way I want it to. I use the same grouping and grand total features to display the data in the report footer. Still good.
I created a new main parent report with the two sub-reports (sales & expenses) on it and even was able to pull the totals from the sub-reports into the main (so currently the subtotals of the two sub-reports are displayed twice). Now when I try to use the textboxes I used to pull the sub-report totals into the main report to perform additional calculations (sales - expenses) I get #error. I have tried different things and gotten ?name.
Control source for the two textbox controls on the main that display correctly, but don't let me do any further calculations.
=[rptP&LExpensesOverview]![AccessTotalsAmount]
=[rptP&LSalesOverview]![AccessTotalsTotal Sales]
To do the subtraction I have tried using the references above, as well as just using the names of the unbound text boxes in the report that bring the totals into the main report.
As a work around, I tried to build one query with all the data from sales and expenses, but can't "filter" based on date and get the data I want in the query results because the two sets of data are not necessarily related. I either get a long list of records, or no records (I am currently only playing with about 5 days of data).
Does the MS Access Report support Hide/Show specific fields according to parameters or even by click?
View 3 Replies View RelatedI'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.
I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.
The code I am using is as follows:-
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'make sure a selection has been made
[code]....