Search results for query: *

Thanks for the help! I'm using Crytal Reports 2016 and I'm trying to set the value of a field to zero if the sum of FG_Trans_Qty doesn't equal the Invoiced quantity. The trouble I'm having is there are many variations in the shipping records. Most times there is one record for each...

Hi Everyone and thanks for your help in advance! I'm using Crystal reports 2016 and I'm having a problem with passing a shared variable. Oh the subreport "Sub-PartActInv" I have the following formula which passes the Unit Price to the Main Report. Here is the formula for the shared variable...

I'm using Crystal Reports 2016 (32-bit) and trying to connect to spreadsheets created in Microsoft 365 (64-bit). The original reports were created with CR 2016 and Microsoft Office 2016. Now that we've updated to Microsoft 365 the Microsoft Office 12.0 Access Database Engine OLE DB (ADO) is no...

I'm using Crystal Reports 2016 and I'm having a problem with displaying the calculated running total in the report footer. As long as I don't Hide or Suppress the Detail or Group footer all of the formulas calculate correctly. If I Hide or Suppress the Detail or Group footer (which is what I...

I'm working with Access 2016 and SQL 2012. I'm trying to convert the following query from Access to SQL but I keep getting errors. I've listed the statement and the errors below. Any help would be very much appreciated. SELECT dbo_Employee.Employee, dbo_Employee.Last_Name...

Hi all, I'm working on Access 2016 and I'm having a problem showing a Long Text field on my Form. I have three tables they are TravelerChange, dbo_Job and dbo_Job_Operation. The two dbo tables are linked tables from a SQL database. The fields I'm using are TravelerChange.OrgChange (formatted...

Hi, I'm using Crystal Reports 2011 I calculate an average Machine Utilization based on the number of available hours vs. number of hours worked for a given time period and group it by Machine (workcenter). The calculation checks out but when I try to chart the daily utilization and average (by...

Hi, I'm using Crystal Reports 2011 with an SQL database. I'm trying to count the number of Workcenters who's utilization is equal to or below 75%. There are 39 different Workcenters in the report and it's grouped by Workcenter and Transaction Start Date. The Utilization spans over a date range...

I'm using Crystal Reports 2011 Does anyone know if it is possible to change the Y Position of an object (subreport in this case) based on a value? Thanks, Brad

I'm using Crystal Reports 2011 with an SQL database. I'm having a tough time trying to show the prior 3 months promised deliveries when the current month is January. The reason is because the promised dates are in the prior year (Oct, Nov and Dec). The report has 12 subreports, 1 for each month...

Hi all, I'm having an issue charting the % of Utilization on my report in Crystal 2011 using an SQL 2008 database The chart is on the main report and presently is in the Report Footer. I also had it in the Report Header. It's a simple bar chart. The "Change Of" is Work_Center.Work_Center The...

Hi, thanks for your help with this problem! I'm using Crystal 2011 and I have a report which shows the actual sales vs. sales goals for a given time period. The time period is defined by the user entering a start and end date into a parameter called InvoiceDate . Typically the start and end of...

I'm using Crystal 2011 and the report I'm writing is going to show the number of pieces shipped for a given part number. I wanted to insert a Cross Tab in the footer to show the part number and the total quantity shipped for that month. It works fine but the issue I have is the number of...

I have one minor problem with a report. When I pass the Job Count value from the subreport to the mainreport the values are off by one record. I've had this problem in the past and corrected it by placing the formulas in the correct section. I believe I have the formulas in the right sections...

I'm using Crystal Reports 2011 and what I would like to do is have the Main Report footer section grow based on the size of the Sub Report. Here is the layout of the report: GF1a has a Sub Report for employee's job punches (could be from 1 to 4 jobs) GF1b has a passed variable {@PassJobNumber}...

I am working with Access 2007 and in my form I have a combobox which populates an Unbound Textbox with a Specification Rev. I'd like to store the Rev in the same record as the Specification but I'm not sure how to accomplish it. Here is what I have: Lookup table: Specification Store Table: CofC...

thread181-1292653 I'm working on a form where I am looking up and Employee by their Employee ID then populating two text boxes with their First and Last Name. My question is can I store the text box data into a specific field in a table as I've done with the Combo Box that selects the Employee...

Having a problem with a formula that I could use some help solving. Below is my formula that works for the sum of {@Hours} if {@DayofWeek}="Saturday" and Sum ({@Hours}, {Attendance.Work_Date})>12.5 then 5 else ( if {@DayofWeek}in ["Monday","Tuesday","Wednesday","Thursday","Friday"] and Sum...

I'm trying to find the difference between two dates in minutes. Unfortunately there is an issue with using the DateDiff function. One date is a login date which would be a current date and time. The second date is a system defined start of shift. Here is the problem, when a shift is created you...

Hi everyone, I've been reading a lot of posts on this subject but I haven't found one that is the same as what I'm trying to accomplish. Here's what I'm trying to do. I have a linked SQL table called Employee, I'm trying to create a form that will enable the user to select the last...