Recent content by Jillp

Hi lbass, Thanks for your response. Our periods are run on a 4-4-5 calendar that are identified in our database. If I understand you correctly, the dateadd('m',-1,currentdate will get me back to the previous month, regardless if it is in a different year - therefore, it is not necessary to...

I am trying to automate a report that I have previously been running manually. When running manually, I am able to enter the Year and the period of the data that I would like to select. I have come up with the selection criteria below that seems to work properly. My concern is in January...

Thanks for the reply - I'll take a look at this.

We have several jobs with the same operations; we would like to average the lowest (3) Act Times. I'm not sure how to select the lowest (3) numbers. Any advice would be greatly appreciated. - Jill Product Operation Est Time Act Time Handwheel 50 4.50 5.25 Handwheel 50 4.50 2.25 Handwheel...

Thanks for the suggestion. I have tried this - but haven't had any luck.

We have a report where users would like to SEE all groups listed regardless of if there are details records within the group. I have not been able to find a solution to display a group 'title' if there are not records in the group. Would anyone have suggestions? Thanks for any advice! Jill...

Thanks for the suggestion, this didn't work for me.

We have 30 groups of machines. Within each group we have 3 status types, Frozen, Planned and Available. When printing this report we double side to printer and so only want to print a total of 2 pages per group. Since each group has a varied number of orders in each status group as well as 4...

Thanks LB I will give this a try

In previous post I attached a screen shot of the desired result.

Hello, I have a report that I am trying to recreate from a form created many years ago by an ERP company. The ERP company used a temporary subset of the original data that resides locally. I would like to share a similar report outside of the ERP system via our intranet and so I am connecting...

thanks again.

Thanks for your reply. Is it your belief that we will be required to set up an ODBC connection at each user workstation in order for user to run crystal reports through crystal runtime, or will the ODBC connection on the server handle this? Thanks again, Jill

Hello, *Our company plans to share crystal reports via a crystal runtime client that connects through an ODBC connection to a SQL server. *Our current solution is web based and does not rely on an ODBC connection. *When we develop the report each developer has a local ODBC connection...

The G/L for subcontract ops come from the Product Code in the job. Below is a direct quote from the Vantage Job Header Help Screen. Below is a section that I copied from the help screen. "Subcontract Subcontract is the General Ledger account that should be used for subcontract transactions...