Search results for query: *

CR 10.0 SqlServer Hello All, I am trying to create a type of aging report for A/R. I need six formulas that will all be the same with the exception of the days. It needs to be like this: if {armast.fcinvoice} is 1 to 30 days old then {armast.fnamount} else 0 The report will look like this...

I need to have a date always be in the period of the last full year. If I run it on 9/30/04 it includes all ship dates since 10/1/03. I did not see this in the list of periods within the Select Expert. Help needed please.... CR 10.0 SqlServer Jeff C.

CR10.0 SqlServer Can anyone tell me how I would do this link within Crystal? SELECT SHITEM.Fpartno,SHITEM.Frev,SHMAST.Fcbcompany,SHMAST.Fcsono,; SHITEM.Fenumber,SOITEM.Fquantity,SHITEM.Fshipqty,SOITEM.Fduedate,; SHMAST.Fshipdate,SHITEM.Fshipno; FROM M2MDATA!SOITEM SOITEM INNER JOIN...

CR10.0 SqlServer I have a text field that may contain the word 'Expedite'. It is a small text field, but I want the report to only give records where poitem.fdescript contains 'Expedite'. How do I do this? Thanks, Jeff C.

I have two formulas that I need to do running totals: 1) @RemainingQuantity 2) @Ext I have the following formulas for the first (@RemainingQuantity): @SetManSum: (Suppressed in the Group Header) WhilePrintingRecords; NumberVar Mansum; Mansum:= 0; @GetManSum: (Suppressed in the Details)...

When I pulled up the Admin. Launchpad and had CMC open, it shows an error (red dot) on all but two servers; the Crystal Management Server and the Crystal Web Component Server. When I logged on to the actual server I opened the Crystal Configuration Manager, all servers show to be running. I...

CR 10.0 SqlServer I have two tables: POMAST POITEM I have one Group by Customer. What I want is to see the sum for orders that are past due from 'today', the sum of orders due remaining of the month, and the sum for each of the next three months. The field that I sum is poitem.ordamt. Here...

CR 10.0 SqlServer We have an Accounts Payable report that list all outgoing checks, the amounts, and what invoices they are paying. I have a distinct count on check number so we see the number of checks per vendor that we write per month. The report is grouped by Vendor. I do the distinct...

CR 10.0 SQL Server I have a report that list all customers. I am linking two subreports to this main report; Orders and Sales. I want to suppress the section on the main report if Orders = 0 and Sales = zero. Something like this in the suppress field in the section expert: If...

CR 10.0 SQL Server I have created a cross tab report for Orders Backlog by customer by month. Jan Feb Mar Apr May ABC Company 5000 6000 7000 5000 7000 DEF Company 5000 4500 6333 5555 8888 I would like to create a formula that takes the...

I have a main report that list all customers. I have a subreport linked that gives all orders for all customers based on a date parameter. If customers do not have an order, then $0.00 listed. This is good. Then, I have a subreport linked that gives all invoiced sales based on a date...

We are currently running on the following: Compaq ML370 Dual PIII 933 1 Gig of RAM Raid 5 ARRAY We do not know what the 'minimum' size should be. It is slow when logging in and going from folder to folder. Once you open a report, it is not too bad. Any suggestions? We are on CE 10.0...

I have a main report that list all customers. I have a subreport linked that gives all orders for all customers based on a date parameter. If customers do not have an order, then $0.00 listed. This is good. Then, I have a subreport linked that gives all invoiced sales based on a date...

I want to write an if then statement: if (field) CONTAINS 'Apollo' then "APOLLO" else (field) What is the syntax for contains? This is a field that may include several numbers before and after 'Apollo'. Thanks for any input, Jeff C.

All of our invoices begin with H, C or 0. I want to do a group on armast.finvoice but only by the first letter. That way I can sum the amounts of all 'H' invoices, etc. How can I accomplish this? Jeff

I am writing a report that would list all months across with all customers down: Jan Feb Mar Apr etc Customer 1 Customer 2 etc I planned on using 12 subreports; one for each month. I have the subreports written. However, I cannot just use the record selection to...

I currently have this formula in the section expert for the details section. It is to suppress: If{?Order Date} = {sochng.fdate} then False else True This shows only rows where the fdate field falls within the date parameter range. After this, I then need to suppress all rows where...