Reports

Charts on a Report
I want to display a chart on a report. I created a query named qryJanGraph, which contains 2 fields [SignInDte]& the other is a calculated field name [TotalStudents]. The expression used in the query for the calc field [TotalStudents] was sum([Current]+[New]). I placed the 2 fields on the report in the Detail ... 5 May 2010 23:49

Grouping and Sorting a Report On Open Event
I want to use a single report with pre-defined Group and Sort criteria and then Group/Sort on different Group Levels ( some or all groups). The following code works but gives me an Enter a Parameter False when running report. How do I turn off or suspend levels of Grouping rather than = False? If I remove th... 4 May 2010 19:06

display a total value
Hello I hope someone can shed some light on a slight problem. I am setting up a database to hold personal information about pupils at our school. I have set up a a Query by Form system linked to a report. I've displayed the total number of records found at the bottom of the report (Which I've done using a... 3 May 2010 09:50

Calculate Subreport totals in a main report Group footer
Hi all Apologies if this has been answered before but I can't find it. I have a main Report with a Group called “Product_Category” which lists a number of “Products” in the Detail I have a Subreport named “product_costs” which has a record for each date and Text Boxes named “materials” and “fuel” (there are ... 1 May 2010 22:00

Why are the values in my report bound to each other?
I created a report based on a cross-tab query using the wizard. It is handy in many ways, including keeping the values evenly spaced in each row and changing their horizontal order in the row by using the left and right arrow buttons. But can I turn off this feature? I want to insert a manually-created sub-t... 30 Apr 2010 16:19

Report Taking a Long Time to Print
I have a main report with 2 subreports in it. One of the subreports seems to be holding up the report when it comes to running and printing. When I run the query and/or report for the problem subreport it returns data within 1 minute. When I run the main report, it takes anywhere up to 5 minutes to run and about... 30 Apr 2010 15:10

copy format and formulas of one report to a second report
I need to copy a report to create a second report, and am looking to know how to globally change formulas to a different table/query. The fields in the two tables are identical, the data results are different. Example of a Current formula: =Sum(IIf([Customer Sat Results database]![The service or information yo... 30 Apr 2010 16:19

Crystal reports
Hello, How I view crystal reports (.rpt) with access 2007? Nico ... 1 May 2010 12:04

positioning a subreport
hello I have a subreport in my main report's Page Footer. The subreport shows a single column with from 1 to 5 rows. The subreport has a solid hairline border that can grow. I want the bottom of this border to always be 0.5" above the bottom of the main report's page. (When there are more rows, I want the ... 29 Apr 2010 23:41

Query works but report fails
I have a report based off a query that has started to fail. I have a copy of my database from 4-27 where it works and another copy from 4-28 where I've added a lot of functionality for something else completely unrelated to the report that fails. In the newer copy it works a few times but after a while it beg... 4 May 2010 05:44