Search results for query: *

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

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

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

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

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

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

Hi I'm using Crystal Reports 8.5 and would like to suppress the details section using the following formula [CnPrProp_1.CnPrProp_1_Date_Asked} <= DateTime (2007,07,31,00,00,00) OR {CnPrProp_1.CnPrProp_1_Date_Funded} <= DateTime (2007,07,31,00,00,00) Currently only records that meet the first...

I'm using CR8.5 and trying to insert a formula to count gifts if they've been received after a certain date. My attempt is if{Gift.Date} > Date (2006,07,31) then sum ({Gift.Amount}) I then want to put a subtotal in for each group, but that isn't going to well either because it seems to be...

I'm using Crystal 8.5 I have a simple report that has groups and the sub totals of the donations received as well as the status of the gift. Example Received Pledged Target Individuals £100,000 £250,000 £500,000 Corporations £50,000 £45,000...

I'm on CR8.5 and trying to write a report which needs a formula to suppress certain data. A section of the report has 3 columns Gift Amount Ask Amount Potential the first 2 columns are numeric with Potential being a text table. What I would like is if for a value to appear in only one...

Hello I'm using Crystal 8.5. I have a cross-tab report that is running very well, however I was wondering if there is a way to show the changes in the numbers between each running of the report? Either to display the old number, the % increase/decrease? Anything that will show a change. I...

Hi I'm on cr 8.5. I have the following formula if {CnBio.CnBio_Age} in 18 to 25 then "18-25" else if {CnBio.CnBio_Age} in 26 to 30 then "26-30" else if {CnBio.CnBio_Age} in 31 to 45 then "31-45" else if {CnBio.CnBio_Age} in 46 to 60 then "46-60" else if {CnBio.CnBio_Age} in 61 to 80 then...

Hi I need a formula which uses to tables, the problem I'm having is that the tables are of different data types. If numeric.table equals 0.00 then text.table else numeric.table I'm sure this is straight forward but I just can't crack it. Many thanks Pete

Hello All Help needed, I'm very confused. I'm using Crystal 8.5 on an access database. I have created a cross tab report to show a Target Gift Amount in the rows and the Completion Deadline as columns. The completion deadline is grouped into quarters. It looks like...

Hi I've tried looking on the forum but can't find quite what I need so I thought I'd give posting a go... I've got an access database and I'm using CR8.5 I need to create a report that puts the gift amounts in to categories: <£10,000 £10,000 - £49,999 £50,000 - £99,999 and so on. These will...

Hi I'm using Crystal 8.5 and am having problems with subreports when linking them to third party software. I shall do my best to explain... This is the first time I've tried to use Sub Reports so I get the feeling I'm missing something obvious. In 'Details a' I have 'subreport a' which picks...

Hi I'm sure this is answered somewhere in the forum but I just can't find it. I'm using Crystal 8.5 I would like to write the following report Asked Name Status Amount Canvasser Not Asked Name Date to Target Canvasser be asked What I would like is if a record in the report has a...

Hi I am having an issue with displaying information on a Pivot report and I wondering if the problem is with me or with the way Excel handles data... I have a pivot report with the following info Column A Column B Column C Age Range Country1 Country2 18-25 26-30 31-45 The report works...