Search results for query: *

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...

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...

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...

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

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?

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.

I want to suppress the "new page after group" after the last group in the report, so that the report totals print on the same page as the last group, instead of on a separate page.

I have a report using two files: project and unit. I am accumulating unit data to the project (group 2) level. I am using a numeric field from the project file in the group 2 total line. I want to accumulate that field to higher levels, but have not been able to figure out how to do it. The...