Search results for query: *

I have a formula that shows meeting times. If IsNull{@hour} Then "" Else ToText({@hour},"hh:mm") In v.7 the output was 10:00 or 12:00, etc. We recently upgraded to v.9 and some of the output is now 9:59 or 11:59, etc. (Some are still showing the correct times). Is there...

I am creating a manual crosstab report that shows the company schedule by location (rows) and day (columns). It is grouped by location. I have placed the text fields in the detail section because I haven't been able to summarize on them in the group header & footer. My problem is that I have...

Since the new year, the only way my reports will show 2002 data is to change the setting on my computer to 12/31/02. The report selection is based on two parameter fields, beginning date and ending date.The formulas in the report are calculated for each month, for example: If {JOINALLSales...

I need to count the number of records that appear on a report. I am using date parameters and the Select Expert that shows only those records where the SUM of the sales are zero (0). My current count formula is counting ALL records, even though they all don't appear on the report. Here is the...

I need to sort data in a group footer based on the following formula field: If Sum ({@casetotal}, {JOINALLSales Journal.CustomerID})=0 Then 0 Else (Sum ({@netrevenue}, {JOINALLSales Journal.CustomerID}))/Sum ({@casetotal}, {JOINALLSales Journal.CustomerID}) Is this possible? Many thanks, Anne...

I have many percentage formulas in a report footer that are not calculating correctly. I tried PercentOfSum, but I don't think I used it right as the values all equaled zero. Here is an example of one of the formulas: If Sum ({@dollartot}, {JOINALLSales Journal.customer id}= 0) Then 0 Else...