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: *

  1. dianne2n

    SubReport field has different field type than main report

    PERFECT !! Thank you EVER so much.
  2. dianne2n

    SubReport field has different field type than main report

    Hooray! We're REALLY close now. One more question: I'm getting the correct data from the subreport into the main report. However, when I run the report, I'm also getting prompted for the start/end dates that belong to the subreport. Somehow I haven't been able to link the start/end date...
  3. dianne2n

    SubReport field has different field type than main report

    OK -- I'm making progress. I now have data from my subreport showing in the main report. One last problem: The subreport needs to show the data for the same date range as the main report. In the main report I have two paramter fields (start_date / end_date) and I go after records with...
  4. dianne2n

    SubReport field has different field type than main report

    Main Report fields: Work_Center_No (data example = 01418) Op_Start_Date (data example = 1005-10-07-07.57.12) Op_Finish_Date (data example = 1005-10-08-15.54.42) Sub Report fields: Work_Center_No (data example = 01418) Work_Day (data example =...
  5. 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...
  6. dianne2n

    Can you create a calculated field using alternate column titles

    Thank you for those quick responses. The double select works perfectly! You're awsome!
  7. 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 +...
  8. 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...
  9. 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...
  10. dianne2n

    Removing blank columns from Cross-Tab Report

    Thanks for the hint. I did actually have the Group Option selected to print for each month. I think I discovered that the problem was that I had put the @Hours also in the columns to be printed. Now that I removed the @Hours field from the columns section it looks much better! Sometimes a...
  11. 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...
  12. 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
  13. 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