Search results for query: *

This is my current SQL: Select xawWorkCenterID,xawDescription,Est_Hrs,Act_Hrs,Prod_Eff From WorkCenters left outer join (Select jmoWorkCenterID as WeekWC, (sum(jmoSetupHours)+sum(jmoEstimatedProductionHours)) as Est_Hrs, (sum(jmoActualSetupHours)+sum(jmoActualProductionHours)) as Act_Hrs, case...

I already have my tables where it should be pulling from to sum the correct data. How do I put in the date range for it to sum up six months and not just a certain month? WorkCenters left outer join (Select jmoWorkCenterID as WK1WC, sum(jmoSetupHours) as WK1_Setup_Hrs, sum(jmoActualSetupHours)...

Hello, I have a Sql query that currently shows me the last 6 weeks of rolling information. I need to change that report to show me the sum of the last 6 months of data. I am extremely new at SQL and have been trying to find some things online but not sure where or how to get the "sum" of all...

Okay. That makes sense. So I essentially need the qarJobID from NonConformances to = the lmlJobID in the Timecardlines. How would or should I write that then? I tried from NonConformances where qarJobID = lmlJobID from Timecardlines but it gave me an error on the from.

I'm hoping that it's appropriate to post here. I'm working on my first SQL query and I am running into some issues on the "select" and not sure what I am doing wrong. Hoping someone could help. Here is a piece of it: (Select qarNonConformanceCategoryID as WK2NC...

Its hours but not a date. So the reason i recieve the error is become I am pulling a grid that shows me what every guy is clocked in doing. If he is in a job, it shows production hours. If not its blank.

I put this in and I get a valid formula but then recieve an error when running the grid. This is what I put in: app.iif(fields("lmlTimecardType").value="2","Style1",app.iif(isnull(fields("jmoEstimatedProductionHours").value) ="","Style3",app.iif(isnull(fields("jmoActualProductionHours").value)...

Its a grid formula within M1 but I am asking if anyone would know what I could put in there because you've all worked with Crystal. Our reporting is done with crystal and that's why I am apart of this group and most formulas that you can put into crystal can be put into M1 grids.

I know they don't, ECI M1 uses crystal for it's reporting but it's slightly different for the grids in the actual system. Hoping someone would know what I could put in place to ignore the blank values in the production hours to make the formula work.

Hello, We use a system called ECI M1... I am working on a grid in M1 and trying to put in a style format. Here is the formula: app.iif(fields("lmlTimecardType").value="2","Style1",app.iif(fields("jmoActualProductionHours").value >=...

That's okay! Thanks for your help. What I sent is a snapshot of the underlying fields that it is reading from in order to fill the check box in the production complete field that shows on the report. If I was to try and create a "And, If" formula to register those 6 fields as true or false...

Hello, I realized that the field doesn't hold any data to check to but rather goes through 6 other places to determine if the box should be checked. The above that I posted is a parameter needed for the program that we use to run the report and I have the options to select None, True, or...

Hello All, I work in a program that only registers certain parameter fields when running the report through that program. I am trying to create a true of false dropdown parameter that will read true of false based on if a box is checked. Can anyone help me? Here is the prompt text I have...

No, I don't want to export. I want to replicate the view of the document I attached. It is an analysis that was built in Eci M1 and I would like to create it in a report form.

Sorry, I should've been more specific. I have attached the format that I am looking to create below. https://files.engineering.com/getfile.aspx?folder=a0d00f06-9063-4a79-b1c6-1e71bc7bdb7b&file=Snip.PNG

I am trying to create a report in crystal reports that is a landscape view. I would like my fields set up similar to an excel document format. Is there an easy way to make this work?

Thank you! That was super helpful.

I am trying to create a formula to calculate efficiency. I need to divide production hours by the sum of 3 different hour totals *100 to get a percentage. Here is the formula I am using. TIA Dim nReturn As Number If {#ProdHoursByWC} <> 0 Then nReturn = ({#ProdHoursByWC} / Sum...