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...
Thanks lbass for pointing me in the right direction. Unfortunately the technical paper give the solution for CR 9 and higher and I am on 8.5. The good thing is I did able to solve the problem and here is what I did.
*-Made some shared variables and pass the calculated values to them in report...
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...
The only thing I wrote was
select table."UnitCost" from table
and I verified from database->show SQL query about the punctuation
The error I am getting is
ODBC error: [DataDirecrt-Technologies][ODBC PROGRESS driver][PROGRESS]Syntax error(7587)
Never used the SQL expression before, When I create a new SQL expression and even just save an empty screen it's giving me ODBC error, is there something I need to define in CR before start using SQL expressions.
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}...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.