Search results for query: *

Hello there I have a report using two diferente tables 'finance' and the other is 'Contact history'. I manage to draw a list of 'income' and next to it a description of the 'contact history'(Ex. Direct Mailing) Unfortunatelly at every new transaction all the list of contact histories is...

Hi, I created a report that pre-populates a form from our database using our unique reference numbers. In the parameter field I set the value type as 'number' and 'allow multiple values'. When you refreshed the form and entered more than one reference number you used to get different forms for...

Hi Is it possible to create a formula for a mergefield in a word document. I need to show 25% of an amount paid for Gift Aid e.g if paid £500 need to show Gift aid claimed will be £125 Thanks

Hi, I need some help please. I have created a report to show the financial results for the previous year. Our data consists of a main centre with individuals linked to that centre. In the group footer I have the following fields showing. fbFINANCEINFO.UALPHA_2 (this is the main centre record)...

Hi there I need to provide an excel spreadsheet of all our addresses for a mailing. The mailing house has requested that the columns are cleaned up as follows:- Column 1: Name Column 2: First line of address Column 3: Second line of address Column 4: Third line of address Column 5: Post Town...

Hi, I need some help please. I have a PDF file that I need to insert into the details section of a report. However, Crystal resizes the PDF file and makes it smaller. When I increase the size of the PDF file the quality of the file is reduced and looks fuzzy. Any suggestions tips please. I am...

Hi there I print a report that shows the total monies received between in a time frame e.g. 1 January until 31 March. My report includes all donations received between the period stated, however, I need to show the date of the last payment received. If someone makes monthly payments of £20.00...

Hi there I am trying to create a report that shows me a date/time field that is blank when another field has the Yes checked. In my select expert I have said Gift Aid equals 'Y' I am looking to find all records were this field has a Yes checked, but no corresponding date. The Gift Aid Date...

Hi there, I am new to Crystal and am struggling with a formula, the formula is as follows: trimleft ({title} + ' ' + {initials} + ' ' + {surname}) The problem is if there is a title but no initials (or visa versa) then the report has no data showing. Any help/suggestions would be...