Search results for query: *

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...

Hi LB, Your questions sent me in the right direction. I was waiting until the main report to convert my nulls -- didn't make much sense now that I think about it. Once I redefined my nulls in the subreport everything fell into place. Thanks for your help! Best Regards, Jill

I have run into a problem that I've been unable to solve. I have passed several date variables from a sub report to the main report. Many of the Date Variables are blank. I have a fairly complex conditional format to highlight pastdue's based on these fields. My problem is that the null...

LB, Thank you so much! Such a simple thing, but so important. Thanks Again, Jill

My subreport is located in GH3a and my main report variable is located in GH3b. I tried putting the reset formula in GHa as follows; WhilePrintingRecords; StringVar Main_User := " " and moving the subreport to GH3b, and the main report variable to GH3c. The results were exactly the same.

I am trying to pass info from a subreport to the main report. I am creating shared variables in the sub (to store data) & main reports (to retrieve data). I have followed the BO "c2007600" article to a 'T'. It seems straight forward. Often the variable is blank, this works fine until the...