Search results for query: *

All the subreports are in the same report Footer section. The subreport that I thought was causing the problem had been created by copying another subreport. So I ended up recreating the subreport from scratch. Then it worked. Well as I continued to work on the Main program and the various...

madawc, I am running on 8.5. After testing and eliminating things I discovered that when I add this formulat to the subreport and then insert the subreport into my main report it wipes out the results from the other 5 subreports and this one. {Employee.AuthorizationDate} in MonthToDate...

I have a report that already contains 5 subreports. I want to insert another subreport. When I inserted this report, nothing shows up on the report. If I take the last subreport out the report works fine. So I traced it back to using a report selection in that subreport of monthtodate. That...

Crosstabs will do a total summary for the row or the column, but I need a ytd monthly running total. I cannot figure out how to do thatin a cross tab. ?? Please help if you know of a way.

I am using 8.5 with an access database. This is a report for a count using a date field. We are just counting how may date records are there. Pretty simple. The following is the report I have: 2003 MONTH YTD January 15 15 February 12 27 March 11 38 April...

Never Mind. When I took your advice and moved all of it to the footers it came out right. Thanks, So Much.

sdebo2, Thanks. But It is also adding 1 at the beginning. How can I initialize it to zero at the beginning? Kathy

I am creating a report of the count of authorization dates for the last two years by month and a running total for the year. I am using 8.5 and an access database. My report so far looks like the following: gh1 2003 gh2 Month YTD...

I am using 8.5 with an access database. We have a record for each transferee we do business with. In that record there is a field with a date in. I need to create a report that will count those dates . I need a total date for the current month and then a YTD total each month. The report...

I am trying to create a new formula to use in my cross tab, however when I create the formula it does not show up in my corss tab available fields. I can go into Formula Editor and it is there, but it is not in the available fields in the cross tab. Any help on this would be great. I am using...

I am working with 8.5 and an access database. I am fairly new at Crystal, but getting better. I need to write a report with a column of just the names of the months. the data will be counts of a date field for 3 years. Each year will be a column. needs to look like this...

Thank You so much! Kathy

Thank you k I checked the links but forgot to check each specific table. Thank you so much. I finally got it to work. Kathy

I tried the IsNull formula. It still doesn't work. What is happening is that I have Brokerage records. Some of these records have a Borkerage_Offer record Linked to it and some don't. If there is no Brokerage_offer Record then it doesn't print any of the Brokerage information either. In...

I am having to take a report from 9.0 and create it in 8.5. I am using an access database. I had this formula working in 9.0: If Not IsNull({Brokerage_Offer.ReducedAmount})and ({Brokerage_Offer.ReducedAmount}) > 0 then {Brokerage_Offer.ReducedAmount} else {Brokerage.ListPrice} I am...

I did create a formula for the second group using a different name and it worked. Still can't figure out why it worked in 9.0 and not in8.5. Thanks for all you help!!

The formula field is available but when I press that field it doesn't let me go any further. I cannot choose a sort and there is no OK available. I must exit out.

@dom is a calculation of the current date minus a date field to get the number of days they have had a listing. In 9.0 it worked this way. First I grouped this field to include 180 days or more, 120 to 179 days, 119 to 80 days and 80 or less days. Then I group this field in descending...

I have created a report in 9.0. Works fine. I have to convert this report to 8.5. I am recreating it in 8.5. we are using an access database. I have grouped a formula field @DOM by specific amounts using a specified order. Works O.K. Now I need to group the same formula field by descending...

I thought the current date only takes the current date as there is also a function of current time?