Search results for query: *

I must not have explained well enough. I have a report with two levels of grouping. The first group is by housing project The second group is by bedroom size. There are totals at both group levels and at report end. But the report totals are only one line, for all projects and all bed room...

I have many Crystal reports (V7) with more than one level of grouping. I would like to have other-than-group-one totals at the end of the report, instead of just grand totals. Example: I have a report that groups tenants by project and then by bedroom size and shows average rent, etc. The...

But it is the mapping process that I do not know how to do. That is why I wrote for help in the first place. Set location was so easy in 7.0, but seems very hard to me in 8.5. I must be missing something.

Sorry for the sloppy wording. I appear to have rushed into merging the "set location" choice under the "Database Menu" with the "Database" menu itself. Please reconsider my request for help in dealing with "set location". We have not made any significant...

My company just updated from Crystal 7 to 8.5 Some of the new features are good, but I am having trouble with the set database feature. It was so easy in 7.0 Now I have to go thru a lot of confusing (to me) menus and end up with some sort of mapping window that I do not understand. When I...

StringVar array Isls:=["Oahu", "Maui", "Hawaii", "Kauai"]; isls[instr("OMHK",{s8_mast.CV_NUMBER}[1])] This formula takes the first position of a field: s8_mast.CV_NUMBER}[1]) Finds the matching position in a constant: 'instr' not 'in' or...

Thank you. I had a little trouble with the suppression formula, but your solution works well. Some of the tenants had multiple payments on the same date, and the report only shows one, but I don't see how that can be overcome. Thanks again Richard Miller

Boss wants report of tenant information: name, id, rent, etc. and latest payment transaction for each tenant. How can I link the files so that I get the latest tenant payment transaction from the history file, for each tenant on the master file? (some may have not paid in several months) Also...

Thanks for your help. I only got thru steps 1 and 2 How do I store the count in a shared variable? BTW, the subreport counts are all zero. What does "underlay it with the other header stuff" mean? There is no project field in the ethnic file records. r.m.

I am using a data-flex database. I am using CR 7, standard (no sql)

I have a file of tenants with project number, and another file of tenants with ethnic codes. Mgmt has requested a report showing the number of tenants in each project, and the number and percent of tenants that have a record in the ethnic code file. If I link the files on tenant id# (the only...

We have CR 7, standard edition. We can make stand alone report modules, but only those persons with crystal designer installed on their pc's can run the stand alone reports. What are we doing wrong? r.m.

I want to calculate tenant ages or length of tenant residence in years. When I subtract date of birth from current date, the result is in days. I have been dividing the days by 365.25 to get a figure in years. There must be a better way.

When I subtract one date from another, the result is in days. How can I get the result in years? ie date of birth 2/1/1980 report date 5/1/01 person's age should show as 21.25 years, not 7700 days. 21 years and 3 months would also be a good format Thanks in advance

Yes, that does what I wanted. Thank you.

I have two sets of files, same formats, different data. I often develop a crystal report on one set and then want to use it on the other set. All the file names are the same, but they are in different directories. I had no luck with the Crystal report copy function. Has someone else done this?

Acting on Ken's response, I exported the file to Excel and added the percents there.

You could change your headings to "1-Boat", "2-Car" ... and "5-Other"

If you use two parameters, start date and end date, you can just drag and drop them onto the report heading. If you use only one parameter, with a range, it does not work - at least in v7.0

I have a working crosstab report with rows of income ranges, and columns of age groupings. I would like to add a total column, and a total row, of percentages to show what percent of the existing total row/column the numbers in each row or column are.