Search results for query: *

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

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

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

Is there anyway to suppress or hide a subreport to keep it from inserting white space without damaging the integrity of the main report summaries? I have moved the subreport to a group header section all by itself, shrunk the subreport to .04 and made the header section as small as possible...

Crystal 8.5, ODBC connection on Ingres Database. How can I suppress an entire group (Group Header, two Detail sections, two group footer sections) based on calculations determined by a running total found in Group footer. For instance, I am reading records that may contain jobs that contain...

I am suppressing records that have a particular field that is equal to 0. (I can't use select expert to omit the record because I need another field value from the record for the following record.) I do not want the running totals calculated for other fields in the suppressed record. How can...

I have a database that contains production data from a reporting system. The way this database is built some records are "linked" or "related" to a previous record but does not contain all data needed. For example: JobName CycleTime GrossPieces NetPieces Job 1 62...