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 Shaun E 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: spacemanspiffy04
  • Content: Threads
  • Order by date
  1. spacemanspiffy04

    Maximum Date Record to the Displayed

    Hi, I use CR XI with DB2. I am creating a report that has 2 groups as shown below. One of the fields in this report is a date field. I need to only pick up the latest date from this field for each of the distinct account numbers. So, for the example below, I want the report to just show...
  2. spacemanspiffy04

    Grouping By 1st 2 Characters

    Hi, I use CR XI with DB2. I have created a report where I need to group the data by Group "A" and then by Group "B". The problem is that the field for group "B" also has some other information, so my report comes out like this: A B01 B02 C01 C02 I need all the Bs in one group and all...
  3. spacemanspiffy04

    Picking Records from Various Groups and Totaling at End of Report

    Hi, I am a new CR XI user and have created the following report. The main group is by User ID, and within each user ID there are a number of US States. So, the report will look like this: User ID States Amount Bob MO 10 CA 20 TN 30...
  4. spacemanspiffy04

    Inserting Data from Date Range AND only End Date of Date Range

    Hi, I am creating a report where I need to insert data based on a user entered date range. This part is fine. However I also need to insert data associated with just the end date of this date range. So, if the user enters 01/01/06 - 02/14/06, I need data from this range and also data from...
  5. spacemanspiffy04

    Summing Two Columns

    Hi, I'm new to crystal reports, so this is probably really simple. I have created a report that includes 2 columns that I would like to sum. I would then like to display the summed column and hide the other two columns. Any help would be gratly appreciated! Thanks!

Part and Inventory Search

Back
Top