Search results for query: *

Hi LB Sorry for the delayed response I have been out of the office. I did as you said above but I still cannot get the summary for the group. What I can't see is how you would order these records and know that they "go together" if there are more than two per ID. Do you match on subtype and...

LB - no problem with the questions, I knew when I wrote the original post that this wouldn't be straight forward. There is no maximum number of gifts per {GfCnBio.GfCnBio_Import_ID}. Unfortunately there is no exportable field for the pledge/payment pair. I have asked the company who supply...

Sorry - my mistake Gift Desigination - Gf.Gf_Gift_Subtype

The Gf table links to GfCn which links to GfCnBio table that holds the {GfCnBio.GfCnBio_Import_ID} Gift Designation is Gf.Gf_Type I have no record selection formula (are you refering to the Select Expert?) - all records produced in the export file should displayed.

I do have a date field, but all gifts brought through in the export will have a date for this financial year. Some of the original pledges are five or six years old and to bring those into the exported file would mean bringing all gifts in the database. It is a problem with the software I'm...

Hello Hoping someone can help me with this, I am on Crystal 8.5 using an Access 2000 database. I am writing a report on donations my organisation has received this financial year (Aug 2008 to July 2009). The report is grouped first by Gift Designation (sponsorship, annual fund, legacy...

Many thanks for both replies. Ian - I put your formula in my report and while I was in the formula editor it did not get and error message but when I ran the report itself I got the following message "A subscript must be between 1 and the size of the array" Any ideas? Peter

Hi I'm on Crystal Reports 8.5 with an Access database. I have a table that displays fundraiser's names when linked to a project. I currently have a formula to format the way a name displays in the report itself if "Smith, John" in {TABLE.Fundraiser} then "Smith" else if "Jones, Mark" in...

Works perfectly, thank you.

I am using Crystal Reports 8.5 and an Access database. I am trying to write a report counting how many meetings members of staff have had, split by the type of meetings. I wanted to group by staff member and then do running totals for each meeting type. The formula @Name to group by was if...

Hello I am using CR8.5 and an access database. I have a report that shows over the course of a year number of actions - Y axis type of action - x axis the stack is split by canvasser type The problem I have is that the software I have to use to produce the .db file limits the rows in a...

I must be doing something incorrect in the basic construction of the report. In Chart Expert - Data Tab - If I select 'For each record' the lines plot how I would expect. http://www.uploading.com/files/IB40QNZ1/Report3.rpt.html When I change this to 'On Change of' and include the formula you...

Update - I have now added Running Totals for the Forecast and Actual gifts. On the Chart Expert - Data Tab - I have it set on 'For Each Record'. This makes the report look how I want. However, the X axis is now 0 through 7 rather than months. Could any body advise me on how I can get the X...

Hello I'm using CR8.5 and an Access database. I need to create a combination line graph to show Actual Gifts vs Forecasted Gifts for the current business year (1st Aug 2008 - 31 Jul 2009). I have been using CR for a number of years but this is the first time I have needed to write a...

Hello I am using a Microsoft Word template that somebody else has set up. Whenever a user types on to a second page the follow message appears "Reference Error! Use the Home tab to apply Reference text to the text that you want to appear here" The text becomes active if you edit the...

lbass - I didn't see your post before responding to the earlier response. many thanks for your efforts.

many thanks for the suggestion, it led me on to "Contact Reports for Meetings held last week " +CStr(Minimum(LastFullWeek)) + "-"+ CStr(Maximum(LastFullWeek)) which does the trick. thanks Pete

Hi I'm using CR8.5 and an access database. I have a report that will be run once a week to show completed meeting contact reports. I would like the heading to show "Reports for last week dd/mm/yyyy to dd/mm/yyyy" Naturally, I don't want to amend the report every week to make sure that the...

Brilliant. Many thanks Peter

Hi I'm using CR8.5 and an Access Database. I have the following formula if {CnPrProp_1.CnPrProp_1_Amount_Asked}=$0.00 then {CnPrProp_1.CnPrProp_1_Source} else totext({CnPrProp_1.CnPrProp_1_Amount_Asked}, 0) what i would like is if the forumla returns the 'Amount Asked' for the field to be in...