Search results for query: *

Hi Based on the curent date at the time of running the report. I would like to calculate the date for the Monday of the equivalent week to the current week a year ago. For example using Thursday 18th August 2011, I would want it come up with Monday 16th August 2010. Thanks for any help

I am trying to print on 1 across labels 4" * 2 15/16" or 102mm * 75mm using a tractor feed printer. There is no printer set up option for this size. I have set it to Custom Size Labels and Tractor Feed. I have sized the report section acordingly. It lines up fine on the first label but then...

Thank you Ibass. I will try this but I also want the year and month to appear on the x axis of a chart. Up until now it has either appeared as 2009.00/6.00 or I can remove the .00 using Cstr and they display alphabetically - 2009/1, 2009/10 etc. Here's hoping it will work this time!!

Thanks for this Madawc. It now sorts the Year/Month in date order. However instead of displaying 2005/10 it appears as 2005.00/10.00 Do you know how I can remove the decimal places? I tried it with Cstr(date,0) but this then stops it sorting in date order and goes back to alphabetical. Thanks

Hi I'm using CR9. I have records which have a created date in format dd-mm-yyyy. I want to be able to group the records by month and year ie. mm-yyyy. I am able to extract the month and year as a string from the date field but when sorting or grouping it displays in alphabetical order instead...

Hi Currently I print long reports grouped by a person's initials. I then split them into each person and distribute. I have now been given a duplex printer to save paper. However if I print my current reports using duplex and a persons information is one page long it prints the next lot on the...

Hi Is it possible to save a report written in Crystal 9 as a version which will run using crystal 8.5? If so how? Any help would much appreciated

Hi, help would be much appreciated. I have a parameter {?Person} which runs at the beginning of a report and asks the user to either enter the initials of a person or leave it blank to select all the persons. The report decides whether to display one person or all using the following process:-...

Thanks kskid this worked perfectly. I even managed to adjust it so it picks the last day of the month aswell. L

Hi MJRBIM, In answer to your question for May 1 2008, I want May 1 2007. Thanks

Hi, I'm using CR9. Does anyone know what I could put in a formula to automatically calculate the first day of 13 months before. For example if today's date is 11 April 2008, I want the result to be 01 April 2007. I'd be grateful for any help. Thanks

Hi, Help would be appreciated. Using CR 9 is there a function I can put in a formula which means it calculates the date a year before? For example, if todays date is 09/04/08, I want the formula to produce 09/04/07. Thanks

Thanks IdoMillet, I knew vaguely what an array is so I thought I would give your suggestion a try. Only to find an array can only contain 50 elements. I need to search about 3,000 records. PBE

I have a subreport which lists a table of information:- Jan 123 Feb 124 Mar 456 Apr 567 I then want the main report to search down the first column and pick out the corresponding figure in the second column. ie. for Feb it would return '124'. I also need it to return '0' if the month being...