Search results for query: *

Here is how my report currently looks like: Group Header: Part # : ZZZ OnHand qty: 100 Detail : Job #1 (qty used) 25 Detail : Job #2 (qty used) 15 Group Footer: Balance: 60 what I would like to do is suppress...

We have 2 tables LaborHed and LaborDtl. LaborHed contains EmployeeNum, ClockInDate ans some other info. LaborDtl contains EmployeeNum, ClockInDate, JobNum and some other info. Example of LaborHed: Example of LaborDtl: To show the records the qry I wrote is : SELECT PUB_LaborHed.EmployeeNum...

I am making a report to calculate the "# of parts in stock" vs "# of parts not in stock". Overall the report is complicated because I am calculating some values in subreport and then passing the values to main report to make the decision. *- The main variables are defined in the main report...

I have some old open orders in the database that I would like to close. The way the table is design the value is 0 if the order is open and -1 if the order is closed. I want to close all orders older than 1/1/2004. Can I update all records by using the query?

I am working on a paycheck report and the report has to be grouped for each 2 weeks. I set the grouping and everything is working correctly except CR is grouping wrong weeks. CR might be grouping week 1 and 2 together but the way my company payroll works it has to be 2 and 3 together. Can...

I am thinking about making this report in a cross-tab. So each row will be part # and each column will be order_qty. What I want is to group the order_qty in a way that it will count all the part ordered on a same price and make column and put price in summarize field. So the report will look...

I need to change the existing production forum and like to add couple of new fields (date and a check box). I still like to use the existing table but will connect both of these fields to empty spaces in the table. Can somebody tell me how it can be done. Thanks

Posting the pic for better answer. As you can see the report is grouped by week then Dept then Employee ID. The second column is subtotal of the employee hours for the whole week. I used the function for the third column to calculate the over time which is If sum({employee.payhour}...

Here is what my original report looks like Part #: XXXXX On-hand 10 job#1 -3 job#2 -5 Subtotal 2 Now when I add another field which is to see if we have any more parts coming the job field repeats it self. The new report look like this Part #: XXXXX on-hand 10 PO # XX...

First of all here is how my report looks like Labor hours Employee ID Date 01/01 5 100 10 101 Sub total 15 01/02 8 100 2 103 Subtotal 10 01/03 15 102 3...

I recently start using crystal report 8.5 at work. Today I was working on a report and it requires data out of 2 different tables. Here is how the tables look like Table 1: Customer# Order Packed 001 True 002 True 003 False 004 False Table 2...