Search results for query: *

Using CR 8.5 and Oracle 9i tables: I thought this would be easy, and it probably is. I just can't come up with the solution. I created a parameter that I want the user to enter either "ALL" or a gun serial number. If they enter anything else but "ALL" they get the weapon with the matching...

I am working with Crystal Reports 8.5 and Oracle 9i tables. I have run into this issue often and have not figured out a report "game plan" for dealing with it. The problem is with time-period reports that count actions or activities. As long as something happened during the period, there is...

Using Crystal Reports 8.5 and Oracle 9i tables: I have a bunch of "dates" in a text table field that Crytal Reports is incapabible of converting with the todate function. They are all in the format of, for example, 26FEB2008. Any suggestions for a formula that would convert a intended date...

Using Crystal Reports 8.5 and Oracle 9i tables...... I need guidance on a game plan for a report on "assignment" productivity. All activity for a completed assignment is in one table (LABREPT). The activities involved in completing an assignment are the analysis, the review and the final...

I am using Crystal Reports 8.5 and want to create a report using an Excel 8 xls table. I can't remember how to load the table into Crystal Reports (I know I have done it before in the past!). When I try "ODBC - Excel Files" it comes up with "no items found". What might I be doing incorrectly??

I am using Crystal Reports 8.5 and Oracle 9i tables. I have a table called ANALYST that contains the information about employees doing lab work. I have a table called LABREPT that list information about lab assignments including when they were completed and by whom. I have produced many...

Using Crystal Reports 8.5 accessing Oracle 9i tables: I have a series of over a dozen "daily" reports that I have created and run early each morning. PDF files are created from each report and store in a communial server folder so that the Administration and Section Supervisors can determine...

Using Crystal Reports 8.5 and Oracle 9i tables: I have a report grouped by one identifying number. The detailed section contains other information. The vast majority of the groups only contain one detail line. However, some groups have two, three or more lines indicating there are multiple...

I am using Crystal Reports 8.5 and Oracle 9i tables..... Are there any utilities around (commercial or freeware) that would automate the running of a 8.5 Crystal Report? It would have to load the report at a particular time (and dow), provide the password to the Oracle table and print the...

I am using Crystal Reports 8.5: Our admin needed a report that would total pending/backlogged (>30 days/>30 days) open assignments as a snap shot of the last 7 years. I created a cross-tab report that totaled the desired numbers but had to run it 7 times (9/5/2002 through 9/5/2007) using a...

Using Crystal Reports 8.5: I want to count the number of years and fractional remaining time between two dates. Lets say I have a table field {Date_Of_Hire}. If {Date_Of_Hire} = date("06/07/1971"), I know that currentdate - {Date_Of_Hire} = 36 years and 88 days or (the value I want), 36.24...

Using Crystal Reports 8.5 and Oracle 9i tables: I have a table with a text field ("{Asset Name}") where, for the most part, the first word indicates the manufacturer. I wish to create groups from the first word. Is there a function to pull off the first word/string before a space in a text field?

Using Crystal Reports 8.x and Oracle 9i tables: I have a report that prints bar codes (3 of 9 font) for DNA samples using the following formula: "*O " & {CODNA.DNA Case Key} & "*" {CODNA.DNA Case Key} is a six digit number. On work stations that do not have Crystal Reports installed and...

In Crystal Reports 8.5, what would be the syntax to use a LIKE FUNCTION formula select? For example, lets say I had a table of training courses and I wanted to see who attended a particular course. Since my users will probably only know or want to enter part of the course name I want to use a...

We are using Crystal Reports 8.5 and Oracle 9i tables. In the tables I am using, a "Case" is a singular. There is only one case. However, a case can gather multiple "Assignments" which have starting dates, ending dates and some other activity dates collected along the way. My report is...

Using Crystal Reports 8.5 and Oracle 9i tables: Let's say I have a Cross Tab with a summary count of data for possible columns A, B, C, D and E. Sometimes there is data for all five columns (A through E), sometimes not. When is there no data to count for one of the columns, that column is...

In Crystal Reports 8.5 is it possible to somehow create a date range that is independent of any table fields that could be used to create a Grouping? If I could create a separate table, I would. But I am unable to create tables (Oracle 9i restrictions).

Twenty years ago when life was much simplier I did a lot of report creations using dBase III tables and the dBase programming language. There was a very nice feature where you could create variables from table data by a concatination process. Here is an example of the syntax (I have...

Using Crystal Reports 8.5: When combining text with data in a formula to print out a result with a text description, I have often wanted to format some of the text (or text converted data) differently from the rest of the final string. Is it possible to embed text formatting codes into a strings.

Using Crytal Reports 8.5 and Oracle 9i tables..... I have a report that tracks three activities (or sets of stats). A main reports that tracks assignments received. A subreport that tracks assignments completed. Another subreport that list assignments pending. Problem is that if there are...