Reports

OpenReport/OutputTo
Hey again guys, I have a simple form that lets a user type in an account number/year and get a report when you click a button. The button just has some simple code that does docmd.openreport and pushes the account number/year into the where argument of openreport. Now i'm trying todo it in mass and just have o... 27 May 2010 18:11

Use combo to print report between two sets of dates
I am trying to print a report that shows timesheet entries for two sets of dates. The report also prints out based on the data entry person selected. The user selects their name and then uses another combo box to select pre entered dates. My code is as follows: Private Sub cboDates_Click() Dim stDocNa... 28 May 2010 03:56

Force the group footer to print on the first page
Hello, Does anyone know how to force the group footer to print only on the first page of an Access 2007 Report? Thank you in advance. ... 7 Jun 2010 17:44

A Great Big Thank You!
Firstly, let me apologize for making this beautiful cross-post. I know it bad etiquette, but in this instance I'm hoping no one will truly mind (after all MS did it with their announcement...). I, like everyone else in this forum, owe each of the contrinbuting members a Great Big Thank You for all the time, p... 28 May 2010 13:46

Using select and crosstab queries on one report
I created a report based on a crosstab query which shows a count of items by therapeutic category (row field) and month (column field). So far so good. Now I want to add in a column on my report which uses a select query to count "unreviewed" items in each therapeutic category (ignoring month). So far I have b... 27 May 2010 18:11

Entering Report Parameters through a Form
Is ContractsAndHours or CallsPerDay a query? If so, then check them against this query. -- Build a little, test a little. "SSi308" wrote: I created a form called frmWeeklyReport and added 2 unbound text boxes one for start date and one for end date. There is also a button that is set to run th... 27 May 2010 17:04

Reference controls on a dialogue form as the parameters
I am trying to create a dialogue form which asks for start date and end date and includes a button to run a report. My goal is to enter the dates only once to run the report. Currently I have the date parameters set in the two queries and have to enter the date range twice when running the report. I tried follo... 1 Jun 2010 10:52

Friendly Report Names
I have 40+ reports with somewhat critic names that would confuse my users, Is there a way to assign a alias/friendly name to the reports and use it to call the report from a listbox? Thank you for any and all suggestions Gil -- Message posted via http://www.accessmonster.com ... 27 May 2010 14:52

Deleting page headers on pages w/o records
Hey guys, first post, be gentle. Doing my first access 2003/2007 report (file format is access 2003 but using 2007 as a front end, mainly due to network issues, but thats another issue) and i'm running into an issue where the report won't stop putting the record headers on pages w/o records (ie, footer section ha... 27 May 2010 18:11

Memo in Report causing blank pages/other issues
Hi, I have multiple headers in my access 2007 report. I have all of the contents of the DETAIL section set to Yes for Can Grow and Can Shrink. One of the fields in this section is a memo field- sometimes containing a lot of text. I've tried setting the Keep Together option to Yes for the DETAIL section. This ... 28 May 2010 17:05