[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Remove footer from report

Posted on 2011-10-13
2
Medium Priority
?
585 Views
Last Modified: 2012-05-12
I created a report using InfoView, and want to export it as Excel, but the Excel file always ends up with an empty row at the bottom.  Since I import the data from this excel spreadsheet into Access, the import process fails because the empty row does not meet the constraint requirements.  

On the report block/table within InfoView, I unchecked Show Table Footers.  In Page Layout/Relative Position, I changed left edge and top edge to 0 (which eliminated the empty row and column at the beginning), and unchecked all of the boxes including Repeat footer on every page.

How do I eliminate the empty row at the bottom?

I also tried exporting the data from InfoView as a text/csv file, but that process only pulls the results of the query, not the report, so any calculated fields are not included in the result colums.  If anyone knows a way to force it to include the calculated fields, that would be an acceptable work around.

As an alternative work around, if anyone knows how to supress the error message when I try to import the data with the empty row into Access, that would be acceptable as well.  I actually have a table linked to these data outside of Access and then run a query to insert into a table, and it is this insert process that gives me the error message.  I have supressed alerts via the Access Options under Advanced, but the message I receive is asking me if I want to continue the insert statement and ignore the empty row, or cancel the insert altogether.  I would be fine with ignoring the empty row but I cannot figure out how to automate this.  

I am using Excel and Access 2007.  I don't know what version of InfoView we are using but when I click on About it says 12.1.0.  
0
Comment
Question by:tancat
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 36964044
<If anyone knows a way to force it to include the calculated fields, that would be an acceptable work around.>

use a query with columns that do the calculations.

< I actually have a table linked to these data outside of Access and then run a query to insert into a table, and it is this insert process that gives me the error message>

modify your query to have a criteria that will not include the empty rows..

                  where [KeyField] <> Null
0
 

Author Closing Comment

by:tancat
ID: 36964280
Thank you for reminding me to take a break and walk away for a while - your second solution worked, and was so simple I can't believe I didn't think of it myself, but this project has been dogging me for the last three days.  

Your first solution probably would have worked, too, but since I am no longer part of our corporate IT, I no longer have access to create custom queries - I am limited to existing objects only. :-(  

Thank you!!
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question