Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lewes
  • Content: Threads
  • Order by date
  1. lewes

    Current week a year ago

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

    Set paper/ label size in crystal v9

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

    Group by Month-Year

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

    New Page After Query using CR9

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

    Save Crystal 9 report as 8.5 version

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

    Parameter Selection Problem

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

    13 Months Before Calculation

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

    Previous Year

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

    Is there a lookup function in Crystal 9?

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

Part and Inventory Search

Back
Top