Reports :: Redesigning PDF Report From Portrait To Landscape Mode
Jan 11, 2015
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 ....
View Replies
ADVERTISEMENT
Oct 23, 2013
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.
View 3 Replies
View Related
Dec 20, 2004
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
View 1 Replies
View Related
Mar 11, 2013
I 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.
View 6 Replies
View Related
Jan 14, 2014
i have a button opening forms however when they open they appear in window mode and not full screen. is there an option or a line of code of code i am over looking to make it open in full screen mode?
ps. i am using access 2010
View 4 Replies
View Related
Aug 7, 2014
I have a report which is accessed via a hyperlink in a form. I have the default view for the report set to Print Preview yet everytime I click the link the report opens in report view which I don't want.
The event for the hyperlink is as follows:
Private Sub cmdPrint_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
[Code] .....
I have tried changing "acViewPreview" to "acViewReport" and "acViewNormal" and each time it is either going straight to print or opening in report view. I just want the report to open in print preview mode so I can decide if to print a hard copy or send to pdf.
View 10 Replies
View Related
Dec 23, 2004
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 Related
Sep 22, 2014
I have several subform tabs and one that I have updated no longer shows up when I run the form on Form mode. The tab is there but no content or details of the subform
View 3 Replies
View Related
May 21, 2014
I have a button on my form that should open a report in Preview node.
On SOME users machines, it appears that absolutely NOTHING happens when the user clicks the button. (preview mode)
Report parameters that may have some bearing are as follows. (Default settings in most cases)
Default View : Report View
Allow Report View: Yes
Allow Layout View: Yes
Auto Center : Yes
Auto Resize: Yes
Fit to page: Yes
Pop_up: Yes (This is NOT the default setting, as I would prefer the report to pop-up. If the report does not open in pop up mode, the users tend to close the DB instead of just the report.)
On the user machines where the problem exists, I have turned off the pop-up blocker in their web browser. It seems to work when opening in Report View.
Button Macro parameters are:
Report Name: My_Rpt_Name
View : Print Preview
Filter Name :
Where Condition :
Window Mode : Normal
Environment
SQL back end (ODBC Connection to server)
Access 2010 Front end
I am developing the DB in the bog standard install with no special permissions / add-ons. Also, my developer (log on) account is as a standard user, so there should be no (network) permission issues.
When troubleshooting on the user machines, If I open the report in design view and then open in Preview mode, it works.
Is the problem with the Form or the Macro or the Preview mode or maybe some Reg key that must be changed to allow reports as pop-ups?
View 1 Replies
View Related
Jan 12, 2005
how do i format a chart into landscape view. My charts always format to portrait view, but my data is in the chart as landscape, so i loose information. I cant figure out a way to get access to make my chart in landscape view.
View 1 Replies
View Related
Oct 16, 2014
I am currently trying to export a query to PDF, but I want it to be in landscape. Is this possible? Here is the code that I have so far as well.
Code:
If Not IsNull(displayQuery) And displayQuery <> "" Then
DoCmd.OutputTo acOutputQuery, displayQuery, acFormatPDF, OutputString, True, "", 0, acExportQualityPrint
Else
MsgBox ("You Must First Select a Query to Export!")
End If
End Sub
View 1 Replies
View Related
Oct 2, 2013
I have been an MS Excel man all along my career and I am a novice in MS Access.I have created a table, [Initial Customer Approval] which records data from a Form, [Initial Customer Approval]. Once the data is entered in the Form, I need to do some calculations based on the data entered in some of the fields in the form.I created 6 different queries for the six possible values in those fields. now for each of those queries I created respective reports.I placed a Print command button in the Form.
1. When I press the Print button it should open the report for the current record in the Form. (Currently It Opens all the reports simulatneously, with only one relevant report containing the current record; other opened reports being blank.)
2. If user presses the Print button before pressing Save button then system should prompt user.
Here is the code (Please note [reference number] is the unique ID generated for each record entered in the tabe through form):
Private bSaveClicked As Boolean
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Not bSaveClicked Then
MsgBox "You are trying to navigate away from the active record. Please either save your changes, or press ESC to cancel your changes.", vbOKOnly + vbInformation
Cancel = True
[code]...
View 5 Replies
View Related
Dec 28, 2014
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).
View 2 Replies
View Related
Nov 16, 2014
The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...
View 3 Replies
View Related
Dec 21, 2014
How do I hide the report footer based on the report's data ?
I'm trying to hide if number of users = 1
The report's data is a query built inside the report's RecordSource, not a self standing query.
View 10 Replies
View Related
Apr 10, 2014
I've done this once entirely by accident and can't seem to duplicate it...
I have a report. It has the following:
Report Header: Logo and title
Department Header
Supervisor Header
Group Header
Detail
Department Footer: Totals
Report Footer: Overall Totals for all departments
Here's my question.
I have combo boxes on my main form that filter this report. The combo boxes are referred to by the query that runs the report. How do I get proper unfiltered overall totals in my report footer?
View 4 Replies
View Related
Apr 18, 2013
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'.
View 3 Replies
View Related
May 24, 2015
We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))
At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?
I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.
View 2 Replies
View Related
Jun 26, 2013
I have an odd thing happening with my reports. There is a main report that gives class information (from query). There are two subreports (from queries also ) with scores (one for each type of test). There are some unbound controls on the main form that display a count of how many scores are recorded which are totals from the subreports. The controls all report the correct numbers however, when I scroll down to view each record, some of them change to #error, or #name, or similar for a moment. Sometimes they will stay in error form when I stop scrolling but change to correct if I scroll up just a bit. Is this because the controls won't calculate unless that report record has focus?
View 1 Replies
View Related
Dec 18, 2013
Is there a way to hide a label on a report if the sub report count is 0?
View 2 Replies
View Related
Feb 18, 2015
Is there a way to have say five different reports that give out information and at the bottom the totals. I would like to take each of those separate reports to create one report with just the totals.
View 3 Replies
View Related
Mar 20, 2015
So I have a text box in a report that I want to pull in data from a field in another report, so the 'control' for my text box looks something like this...
=[Reports]![rptSalesReceiptSub]![Text141] (i.e Text141 is the data I want to pull into my report)
...the path is completely correct but when I run my report I get.#Name? If I run the report that has the data I want, it's fine (in other words Text141 has valid data in it)
View 4 Replies
View Related
Jul 11, 2013
I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks.When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output!
View 3 Replies
View Related
May 25, 2013
I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:
Code:
Me.txtAddrMainLine2 = "NAME " & UCase([Forms]![frm_OrderRx].[txtPatientName])
This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.
I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.
View 3 Replies
View Related
May 5, 2013
I have debit & credit column.
Which I use this in the report --> =IIf([PaymentMet_trans]=2,"",[Amount]) debit = 1 , credit = 2...
Now, i would like to have the total sum of it. according to the debit & credit separately instead of the whole total sum.
i did this : =Sum(IIf([PaymentMet_trans]=2,0,[Amount]))
error pop up : this expression is typed incorrectly or is too complex etc etc ...
View 1 Replies
View Related
Jun 24, 2006
I have designed many queries in my db and report for every single query. Each report has count filed. =Count(*).
Now I want a report to show these count fields. Which will serve purpose to get overall summary report. I have tried using
[Report]![name of field]
but it does not work.
Could somebody please help?
View 1 Replies
View Related
