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

    setting up parameter fields and passing value to multiple formulas

    Hello All, I am trying to create a report in 8.5 that will give me four columns of data. Two (one actual the other a percent) columns reporting on the current month and the other two reporting on year to date totals (actual and percentage). All this data is in one table. I tried to create a...
  2. ppatel2

    Locking List Box Value after adding first record

    So I have this listbox that I set to a country. I also have two text boxes where I enter in information. Currently the List box reset after each submit command. I was wondering if I could lock the value in the list box until I clear all table contents (already have a command button for this)?
  3. ppatel2

    Solving one to many relationship between two tables

    Software used: Crystal 8.0 Microsoft Access Database So I've linked two tables togethers. Table(A) has a one to many relationship with table(B). I've used data from table(A) in 4 out of the 6 columns in my report. Table(B) supplies 1 out of the six columns in my report. I've linked table...
  4. ppatel2

    Finding single Average of multiple columns

    So I'm trying to get the one mean value of three columns from my table. I had to use the three columns because the intial SQL statement uses an outer join on a single table three times to pull three different values. I'll Provide an example of the data below: C1 C2 C3...
  5. ppatel2

    Linking Created Tables in CR 8.0

    I'm trying to link two created tables in Crystal (8.0). The tables are Peoplesoft queries. Every time I try this in Crystal I get a message saying that I can't link SQL stored procedures. I'm trying to create a report based on somewhat of a cross tabbed report. 5 out of the 6 columns of...

Part and Inventory Search

Back
Top