Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dianne2n
  • Content: Threads
  • Order by date
  1. dianne2n

    SubReport field has different field type than main report

    I'm using CR 8.5 trying to report "Hours Available" for a work center and "Hours Scheduled" for that same work center. In my main report (Hours scheduled) I've created parameter fields for choosing the work center, starting day to report, ending day to report. The two date fields in the Oracle...
  2. dianne2n

    Can you create a calculated field using alternate column titles

    Is it possible to create a calculated field using the alternate column names? I’m getting an “PROJECTED_OUTPROC_COST - Invalid Identifier” error. Here’s my statement from Oracle 9 SELECT JOB_ID, CUSTOMER_NO, (Std_Dept_Cost + Std_RawMtl_Cost + Outside_Processing_Cost +...
  3. dianne2n

    Created View not available to Crystal

    I'm running Crystal Reports V 8.5 I created a "view" using SQL+ and now I want to use that view for my Crystal Report. Are there some permissions, grants, or other things that I also need to do at the SQL level in order to see my newly created view in my list of available ones to...
  4. dianne2n

    Is it possible to link a string field to a memo field (2 tables)

    I need to do a Crystal Report from tables that have the following fields (plus more fields, of course): Table A contains a string(20) field named MRB_Number. Data looks like 27 Table B contains two memo fields: The first field named Key_Value has data...
  5. dianne2n

    Removing blank columns from Cross-Tab Report

    Is there a way to actually remove a column from a cross-tab report? Supressing it still leaves the cell showing (although it's empty). For this particular report, all I'm really interested in is the totals. I'm using CR 8.5. What I'm trying to report is hours by Dept & workcenter by month...
  6. dianne2n

    Crystal Rpts- select recs with date/time field=null

    How do I select records from a table using crystal reports where the records I want to retrieve are the records where one of the date/time fields is null
  7. dianne2n

    Create a formula requiring the contents of a specific field's value

    I have a table which resembles the following: ------------------- ID | Cost ------------------- 100 | 23.50 ------------------- 200 | 12.00 ------------------- 300 | 4.25 ------------------- I'm trying to...

Part and Inventory Search

Back
Top