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 dencom 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: joeg23
  • Content: Threads
  • Order by date
  1. joeg23

    Strange Formula Behavior

    Hi, I'm using CR XI with an excel database. I'm trying to create 3 outputs for one group based on three separate date ranges. The ranges are pulled from parameter fields. They are: Week (Start/End) - WTD Month (Start/End) - MTD Cumulative (Start/End) - Cum My report looks something like...
  2. joeg23

    Combining Values from IF Statements

    Hi, I'm using CR XI with an Excel Database. I've tried a few ways to do this, but I was given an example where this worked, so now this is what I'm trying: I need to consolidate data from 3 columns. The database must stay in Excel, so a Command Object based on Access is out of the question...
  3. joeg23

    SQL Syntax?

    Hi, Using CR xi with an Excel 8.0 ADO Database connection. I am trying to write my first CR SQL Statement and can't figure out the proper syntax to connect to a table. Can someone please help me...i've searched everywhere :( and can't figure it out. I'm trying something like Select...
  4. joeg23

    CR XI - Can't cosoldate data across columns/fields

    Hi, This is my second attempt at a post for this problem...i'm new to the forum, but i'll do my best to describe my problem. I'm using CR XI to access an Excel database. The data is arranged as follows: Transaction Date[tab]Error Type 1[tab][tab][tab]Error Type 2[tab]ET3...
  5. joeg23

    Grouping on Muliple Columns

    Hi, I have a database with 3 fields that contain the same data. They record up to three errors in a transaction. These errors are of the same group(Major or Minor). They can have multiple types (majorError1...n, minorError1...n) In my report, I want to group the three columns together and...

Part and Inventory Search

Back
Top