Search results for query: *

Hi Karl! Sorry to not respond sooner, I was called away with other duties. I ran the query you first suggested and it only took a second to come back with the data. I tried looking at indexes, but did not get too far with that. I am not able to update these tables as they are defined by the...

Hi Karl! I tried running the sp today and it is the performance hog you were afraid of. I gave up after an hour and half. The query did not return any rows when ended. I tried doing the second one you suggested (with a few modifications) and it ran just as long, but when I stopped there were...

Hi Karl! I have been working with the stored proceedure you sent and am able to get it to create the proceedure and the function. The problem now is this is my first time to even work with a stored proceedure and I haven't a clue how to pull the data out of them. I have been looking in books...

Sure, here is a sample of the data using two chapters and three years (I do want five years, but to keep from being too redundant in the sample I have done three years): ID Name Date Amount 1 Chapter 1 4/1/2004 $50.00 1 Chapter 1 1/1/2004...

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

Thanks to both of you. It worked great! - Colleen

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

Nevermind, it looks like it was the field name I gave it. Thanks! Colleen

Thanks for the tip on constructing the query, it worked great. But for some reason Crystal will not use this query. It says there is a syntax error on line one near the column title. I also notice it adds a period in front of the column name (I called it '2001-2002' and it is reporting it...

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

That worked like a charm. Thanks a bunch! Colleen

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

Both of the subreports are in the main report. I have them in the group footer, same footer, two different sections. When I try to run the report it will run one of the subreports, but not the other. I do have both of them linked to the same report on the same field.

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?

Thanks! That did the trick.