Reports

Counting Based on the Data Content
Hi, I have a group footer and I am counting based on the values in the fields. So, for example, I will have a count of Math courses, Phys courses etc. for each semester. I have tried making a count similar to =COUNT(CourseType='Phys') but it counts ALL courses. How can I write conditioanl counts? ... 22 Jun 2008 09:08

Custom Label for data series with calculation
I have a report with a chart that compares quarters with the previous two years. I am wondering if there is a way to show the % of difference above the data series in the chart. For example in the first qarter my bar graph displays three bars one for 2006, 2007, and 2008. I would like to display the difference ... 21 Jun 2008 12:46

Display text based on date query
In my report "rSchedule" I have 2 text box-tbEmpStDt and tbEmpEnDt. The data type is binary, comes from a make table query. I need to compare those dates with text box startdate and enddate in my open form "frmDates". This form will always have Sun thru Sat as a date range. In the report I have a text box for e... 20 Jun 2008 20:29

Graphics in Report
I am designing a report which contains an Image Control. Within the application, I have a table, "ECP Schedule Picture",which is linked to the key sort field for the report and a second field containing the filepath "[ECP Picture link]" and name of the 5 GIF corresponding to the 5 unique "Pages" in the report.... 24 Jun 2008 03:06

Are linked table based subreport in Access possible?
I'm trying to insert a subreport into an Access report. Both the main report and the subreport are based on linked-tables (from an iSeries ODBC connection). If either report is run on it's own, they prompt me for my iSeries User ID and password (twice), then the report works. However, when I try to insert th... 21 Jun 2008 19:55

return column values with IIF
I have the following as a "control source". I get #error. What could be wrong? =IIf(IsNull([SumOfAmount]),[PIFunds],(IIf([AmountType]=1,[PIFunds],""))) ... 20 Jun 2008 19:27

re-associate label with text
A2007 Report created by wizard always associate label with its text. Sometimes I need to add field to the report. If I drag field to report, they both either stay in detail section, or page header section. If I cut label and paste in page header and leave text in detail, they are not associated anymore. How ... 20 Jun 2008 19:27

format/decimal places aggravation
My query returns the math properly however the report doesn't. For example: query: Field1 8.78 * 0.0937500000012 = 0.823125000010536 Field2 (0.823125000010536 * 0.1) + 0.823125000010536 = 0.90543750001159 Field3 0.90543750001159 * 1512 = 1369.02150001752 report fields are Fixed to 4 Decimal points: Field1... 20 Jun 2008 16:22

One problems remains
After proofing my tables and identifying a couple of duplicate records and a couple of Subject ID typos, I've been able to reclaim the missing Subject ID records and have eradicated all but one duplication of a Subject ID. I've looked several times but can't seem to figure out what the problem is with that part... 20 Jun 2008 12:15

average on dynamic report
I would like to have an average column in the last field of the report using crosstab dynamic report. I beleive that I can use avg(Myfield) for fix column. Because it is a dynamic report, the column name is unknow at design time. Can you please help how to add an average and sum column in the last field of the d... 20 Jun 2008 10:11