Recent content by Crystalamateur

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, our records are not linked. I am displaying our supports name & address, current date and unique reference number. Sorry, don't quite understand detail-line value. All the information is shown in the details section of the report. Thanks

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 Macropod Many thanks for the links

Hi Macropod It worked! - many thanks

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, Thank you very much for that it worked. Peter

Hi LB Sorry the group field is UALPHA_2 How do you inserta maximum value at group level? Thanks Peter

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 Bruce Many thanks for your tip, it works! Cheers Peter

Hi Glenn Sorry about the confusion. I have exported the data from Crystal Reports into an Excel spreadsheet. Each row of the spreadsheet has 7 columns Column 1: Ref No. Column 2: Name Column 3: address line 1 column 4: address line 2 column 5: address line 3 column 6: address line 4 column 7...

Hi Geoff The format of my data: Post towns are in capitals Pots Codes (UK) are a combination of capital letters and numbers eg AL12 6PP or S1 5WW Does this help Thanks Peter

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