Search results for query: *

Thanks for your suggestions...I actually solved another way. Since the checks will be written in order, I grouped by Check first, then manuevering the fields into the proper headings gets me the results that I need. Thanks again.

That works, thanks...

crystal 8.5, ODBC, Access Database How can I extract just the Date from a datetime field. I am trying to use the Datepart function, but it is returning errors... my format needs to be mm/dd/yyyy Thanks in advance.

Crystal 8.5, ODBC, Access Database I have a client (charitable) that assists their clients by paying utility bills in time of hardship. They will pay several utility bills with one check. I have created a database for inputing clients and their assists. While creating a yearly report for...

I thought that I tried that scenario. It works. Thanks...

I am trying to count the number of records in an Access database table based on double criteria. Here goes: child = DCount("[Status]", "[othersinhousehold]", "[Status] = 'Child'" And "[customerid] = " & "'" & ID & "'") "Status" is either "Child" or "Adult" "customerid" is based on the ID of...

Crystal 8.5, ODBC, Ingres DB How do you keep an entire group together. In other words, Group Header #1 Group Header #2 Details Group Footer #2a Group Footer #2b Group Footer #1a Group Footer #2b If there is not enough room on page for all of the above, don't print the GH #1, wait to print on...

I posted too soon. I solved my own proplem by using this: {start_time} = Currentdate - 1

BTW, the start_time field is a Date-Time field Ex: 11/4/2004 2:13:30PM

Crystal 8.5, Ingres Database, ODBC I need to setup a record selection that will generate a report for the previous day from a given time frame, say today is Nov. 5, I need the report to extract records for Nov. 4 from 12:00am - 11:59pm of a record field called "start_time". I do not want to...

Nevermind. I discovered the solution. Thanks for your help.

A little clarification: the * is for All and the ?Tool is for your example of ?Last_Name.

How would I incorporate a second parameter field into this formula for...let's say Date. I have the first half of the if statement...see below ( if {?Tool} <> "*" then {?Tool} = {ss_hist_base.tool} and {ss_hist_base.start_time} = {?Date} else if {?Tool} = "*" then true ) What about the else...

The formula editor does not like your formula. I receive an error message that the ")" is missing after the last {employee.lname} What is the purpose of the last "then true"?

If I do this, it will look for all last names that are "All". I have a list of tool numbers: 518 519 520 .... 725 When they select "All" from the selection screen, I want it to pull all tool numbers. Is there a wild card (*) character?

Ingres Database, Crystal 8.5, ODBC Is there any way to include an "Add All" button or command on the "Enter Parameter Values" dialog box upon opening a report? I have included a list of default values that appear in the list. However, the list is quite long (50 entries). The user of the...

I am grouped on Two different fields. See below Group1 - Press Name Group2 - Shift Details: Job GrossPieces RejectReason RejectCount I am pulling from two different tables. The scrap information (Reason and Count) are in a separate table from the Job info. I may be...

I am working in CR 8.5 to an OpenIngres Database. I am getting results from 18 categories and need to find the top 5 based on count. Example: Reason Count VariableName Scuff 10 ShScuff Assembly 25 ShAssembly Color 0 ShColor Dirty 2 ShDirty Flash...

Eliminating the subreport would be my next attempt. I thought this would be the case. Thanks for your help....

It is not getting a new page it is implementing a .04 "space" where the subreport would normally be inserted. Let me explain further. I have one report that shows details of jobs completed in a manufacturing environment that details start time, job name, total downtime, total pieces, etc...