You're going to have to help me on the connectivity solution. How would I do that?
I downloaded the Oct. hotfixes this morning, hoping that it would solve the problem. No deal.
Another note: When I browse the data in that field, Crystal shows it as 9:59, 11:59 and so on (not for all records, though). Could this be an MS Access/Crystal v.9 problem?
I had to create {@hour}in v.7 because the date/time field output was both date and time & I only wanted to see the time.
I tried your formula, which definately makes more sense than what I had, but the time problem still wasn't resolved.
I ran the report in v.7 just to make sure I'm not...
Yes, {@hour} converts the date/time field into a Time field:
Time({CONSOLIDATEDCALENDAR.TIME})
I did check the database to make sure the time was entered correctly. Like I mentioned, this problem didn't come up until we started running the report in V.9. It works well in V.7.
Thanks.
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...
I didn't use the Date(y,m,d) in the formulas because we need a yearly picture of activity by month (Jan-Dec). The year (y) would limit the formulas to one year wouldn't it?
I am using the Select Expert with the formula below:
{JOINALLSales Journal.invoicedate} in {?Beginning Year} to...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.