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 IamaSherpa 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: *

  1. pmenonsmitka

    Sub Report confusion

    Yes, we did resolve this. Thanks so much for checking in on this.
  2. pmenonsmitka

    Sub Report confusion

    We are using Actuate 7 under a Maximo platform. We are having some issues with Sub-reports. When we create the sub-report and link the tables of the sub-report to the table of the main report, we get the rows in the sub-report duplicated. We are displaying the data in the sub-report under...
  3. pmenonsmitka

    Grouping Issue

    I am using Crystal Reports 9 over an Oracle 9 platform. Problem : Report has 2 date based parameters : Start Date and End Date. In my record selection I have : {WORKORDER.WORKTYPE} in ["LUBE", "PM"] and ({WORKORDER.STATUSDATE} in datetime({?Start Date}, time(0,0,0)) to datetime({?End...
  4. pmenonsmitka

    Arrays in Crystal 9

    Sorry:) but that is still not it. PMSEQUENCE is the table and INTERVAL is the field in the database table. PMNUM and JPNUM are also fields in the table. Here is the hierarchy : PMNUM JPNUM and every JPNUM has an interval value. Now, for every JPNUM in the details section I run a...
  5. pmenonsmitka

    Arrays in Crystal 9

    Actually, what I'm trying to do is rather complicated. For every row in the details section, I'm trying to insert all the values of table.field ({PMSEQUENCE.INTERVAL}) into the array interval_arr. By doing this, I'm able to go through the array and perform a calculation and come up with one...
  6. pmenonsmitka

    Arrays in Crystal 9

    Crystal Version : 9 Database Connectivity : Oracle Server to Oracle 8i database Trying to put all the values of of a database field into an array in Crystal. What I have so far : numberVar cnt_interval := DistinctCount ({PMSEQUENCE.INTERVAL}, {PM.PMNUM}); NumberVar i; numberVar array...
  7. pmenonsmitka

    Recursive Join

    I'm trying to do a recursive join : If LABOR.craft = 'Y' then LABOR.NAME (GOOD TO GO!!) else if craft = 'N' then we have to go back into the table to get the craft code for the labor and get the labor.name for the given craft code. What I have so far in the formula called Labor which is...

Part and Inventory Search

Back
Top