Search results for query: *

Hopefully I can explain this. I want to be able to create a report that has a beginning and ending balance by vendor where it would show the beginning balance - checks + invoices = ending balance. The problem I have is that there are two date ranges: The beginning would be 10/1/06 to 10/28/06...

I have a report that was created in CR 9. This report has a subreport in it. I can send this report to different printers and on some the subreport prints and on other printers it doesn't. Has anyone else had this problem? If so, how did you fix it?

I need some help. I have an erp system that I want to write a report in crystal. I need to create a report for a workorder. A workorder will have main header cards that have an ID number. Behind each of the header cards could be another set of header cards with ID numbers. For example...

Let's see if I can explain this. I have a COS report that I need to get data for the current year and the month of December. I've figured out that formula by using DateAdd to my start date parameter. But now comes the hard part. I also need it to show me info for all customers in the current...

I was wondering if anyone out there has had problems after running updates to bring Syteline from 7.02.10 to 7.02.16? If so, please let me know.

Ok guys, I need some help. I have a report that reports on our weekly incoming orders for the year. Here is my problem. Let's say that week 1 had a total of 49 order and week 2 had a total of 25 orders. For week 1 the cumulative would be 49 and week 2 cumulative would be 74 which is 49 + 25...

Does anyone know if you can have a summary total of a parameter? If so, can someone please explain to me how to do it? I have a number parameter that I enter and I need it to be totaled at the end of the report.

I want to be able to show only the last 2 years of info in my database. I know I can go into the query and tell it to show only >=2003 but I need to make it automated so that I don't have to change it every year. Does anyone of a formula that I can use that will do this? Lori

I have a form that contains a subdatasheet. When you enter a quote number, it will show any previous quotes entered with the same quote number and revision number. This way the person entering the info knows what the next revision number should be. For example. Form entry: quote #...

I have an accounting report that needs to pull info based on the accounting period. My database contains a table for the acct period with the begin date (9/28/03) and end date (11/1/03). The other table contains the invoice trans date. I want to be able to put in a begin date (let's say...

Here is the scenario: I have 12 fields (lot1, lot2, lot3,etc)in a report that any one or more can have the same lot number in it per record. I created a parameter called ?mixlot. In select expert, I need to be able to take each of the twelve fields and if any of them enter the parameter...

I need some help. I need to make a library database for all the books we have in engineering. Here what I would like to do if I can. All books will be given a letter and number. The letter will be the first letter of the company and the number will be autonumber. However, there's a twist...

We are currently using SQLBase on our ERP system. We are going to upgrade this to SQL Server 2000. Does anyone know what kind of problems, if any, this will cause in my reports?

I'm trying to create a report. At first I was going to link my sql tables but then I read about pass-through queries. I need the info to be up-to-date everytime the report is run. All I want my people to be able to do is run this report and then print it. If I use the pass-through query will...

I have a report that works great until I try to get rid of some records in group selection. Here's what I have: I group by Part ID with running totals for Qty on Hand, Usage Qty, Excess Qty, Excess Value, and Total Amt for QOH. This all works fine but I need to be able to have any part that...

I'm trying to install FAS onto a 98 machine. I keep getting the following error: richtx32.ocx unable to access ole registry Does anyone know how to fix this problem. We are also running Office 97.

We are running an ERP system with sqlbase. We are thinking of upgrading to sqlserver. Can anyone tell me the advantages and disadvantages between these two? Also we currently run this ERP with the actual applications on the server with the sqlbase. Can this be done the same way with sqlserver?

I'm using the following code. It might not be the best way but it works so far. However I need to add something to it and when I try what I think is correct it bombs. Private Sub txtPart_ID_Exit(Cancel As Integer) If IsNull(Me.txtPart_ID) Then DoCmd.RunMacro...

I have code for my form. Is there a way to have the code stop if the conditions are met. Let's say that I have a msgbox popup if the contains a part number that requires the length to be entered. Once I enter the length, if I click on the part number field again and tab to another field the...

I am using the following code which is working fine but I need something added to it but I can't seem to get it to work. Private Sub txtPage_Ln_AfterUpdate() If DLookup("Page_Ln", "tblPhysicalEnter", "Page_Ln = '" & txtPage_Ln & "'") Then...