Search results for query: *

Hello, I have 2 reports that I am working on in Crystal XI. The main shows the actual costs posted to a combination of GL codes, and the subreport shows budget amounts posted to the same combination of GL codes. The main report uses the DLtrans table, which is a list of all the actual...

Hi, I am doing a report which shows the totals of grants which were given within a fiscal year. However the grant years do not coincide with the fiscal year, and I must show how much posted to the fiscal year that is WITHIN the grant period (these amts are attributed to their respective grants)...

I have added an OK button to an invoice form. Users enter invoices on this form. After entering an invoice on this form, I want the user to be able to click an OK button that not only saves the record, but also moves on to a new window where the user could enter the next invoice. My database...

Hi all, I have a Sales Details report that is based on a query (Sales Detail query). I know that the query runs properly, because when I run it manually, it runs find. Upon running the report, there is a dialog box that I created that prompts for Location, Start Date and End Date. After I answer...

I have a rather simple but perplexing problem. I am creating a way for the use to enter and print invoices. To do so, I have an invoice form (InvoiceEntry) and an invoice details subform (InvoiceDetails) and they seem to work well except for one thing; when an invoice detail line is entered in...

Hi, I created a form using Form Designer and am now trying to add a field to the form. I know that if fields are in the field list, they can be added to the form easily, and I have done this. However, when I created the form, I must have forgotten to include one field, because it is not in the...

Hi, I created a subreport that calculates a value using a formula. I then shared this value with my main report by making it a shared variable. However, the shared variable always shows as 0 in every area of the main report. It shows correctly however on the subreport. Here are the...

Hi all, Im trying to pull account balances using a SQL expression, but am getting nothing. I tried multiple WHEN and THEN lines such as: CASE WHEN (tblGLBLBalance.sCodeIDf_2 = '0060' AND tblGLBLBalance.sCodeIDf_1 IN ('0160','0161')) THEN tblGLBLBalance.curDebit -...