Search results for query: *

I would like to create a view that would show membership in a chapter for the past five years, based on a fiscal year running from July 1 - June 30. The data resides in an activity table that combines a hodge-podge of information you select out based on type. Here is the data that I would have...

I am trying to get the top ten percapita donations based on chapters. The data includes: ID Donation Date Donation Amount Total Membership The report is grouped by chapter to allow for summary caluctions. The report has five formulas that look at the date of the donation and if it meets the...

I am trying to compare percentage of growth from one year to a next. If there is a value for this year, but not one for the last year the value is coming through as zero. To show the percentage of growth. This is against mathmatical law to divide by zero and the report crashes when it comes...

The data I am working with is like this: ID Name Year (string value entered) Amount I want to have a view that would take that information and give the following: ID Name Amount (if the year value is X) AS X Amount Amount (if the year value is Y) AS Y Amount Right now we only have two years...

The zip code in my database store zip codes as zip + 4 in one field, but there are some tables that I would need to link against just the zip without the + 4 extension. Is it possible create a view that will show only the first 5 numbers? Any help is greatly appreciated. Colleen...

I have a small spreadsheet that needs to take the data in five columns, but when printing the five columns will arrange to be printed over two columns on the page. Like this: The data is stored in the workbook like this: ColA ColB Col C Col D ColE Name Address Phone Email Fax...

Am am sure there is a simple solution, but I have just been hitting a brick wall. I am using Crystal 8.5 have a problem with getting dates to appear as they need to. The date field in my database is a date/time field. When I go to change the format of this date, the option I need is not...

I am trying to get the officers for different chapters print out in a grid. My records will indicate the chapter along with office name etc... I have grouped the records by chapter and tried to allow underlay sections, but that does not seem to do the trick. Here is how I would like it to...

I have a report with two subreports. Each time I run it it will print one report, but not the other. What needs to be done for a report to run two subreports?

How do you change the vertical allignment for a text box from top alignment to bottom or centered?

I need to get a report to print a group twice with in another group. For example: Group 1 - Company Group 2 - Employee I need the information in Group 2 to print twice within Group 1 to provide duplicate copies. Is that possible?