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 Chriss Miller 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. sskrobe

    ORA-00905: Missing Keyword????

    Yeah, I tried that because I was the thinking the same thing. The problem is that this query pulls back SOOO much data, that when I leave the date range out, it get the TEMP tablespace size issue. *sigh* I only have one patch of hair left and I'm about ready to pull it out :-! I appreciate...
  2. sskrobe

    ORA-00905: Missing Keyword????

    Yeah, the hardcoded dates ran fine. So how can I get the date params to take??
  3. sskrobe

    ORA-00905: Missing Keyword????

    On a hunch, I tried: ..... where (h.last_ship_date between to_date('{?startdate}' ,'YYYYMMDD') and to_date('{?enddate}' ,'YYYYMMDD')) and ...... But I get the message: ORA-00907: missing right parenthesis I also tried: ..... where h.last_ship_date between (to_date('{?startdate}'...
  4. sskrobe

    ORA-00905: Missing Keyword????

    THANKS!!! yeah, the hardcoded dates ran. So how can I get the params to take?? Woohoo!! Forward progress!!!
  5. sskrobe

    ORA-00905: Missing Keyword????

    I just tried putting it in a block form: Select h.whse_ind, h.instance_ind, h.ord_no, h.cust_no, h.cust_name, h.dest_id, h.wght, h.delivery, r.division, r.prod_fam, r.product_line, r.product_type, SUM(r.wght), SUM(r.act_qty) From v_rh_ordhead h, v_rh_orddetl r Where h.last_ship_date between...
  6. sskrobe

    ORA-00905: Missing Keyword????

    version: Crystal Reports 9.0 I'm trying to add an SQL query with parameters int eh add command window and I keep getting the message: Failed to open a rowset. Details: HY000:[Oracle][ODBC][Ora]ORA-00905: missing keyword. Below is my SQL statement: Select h.whse_ind, h.instance_ind...
  7. sskrobe

    setting up main variables to recieve values from subreports

    Thanks!!! That was the exact info that I was looking for (the 3 formula approach)
  8. sskrobe

    Sub Report CANNOT GROW!!!

    How can I go about suppressing the page footer on my report header?
  9. sskrobe

    Sub Report CANNOT GROW!!!

    I did consider that, but on my Report Hearder, I have a full page that absolutly needs to be printed in it's entirety. So if I make C the page footer it messes up my report Header. Any ideas???
  10. sskrobe

    Sub Report CANNOT GROW!!!

    Thanks, but that's not really what needs to be done. Basically, I need to set the MAX LINES of the subreport so that it doesn't grow or everlap. Unfortunatly, the max lines option is grayed out on the sub report.
  11. sskrobe

    Sub Report CANNOT GROW!!!

    Ok, here is what I'm trying to do. The goal of this crystal report is to reproduce the paperwork for Canadian Custom Invoices. I have a report that contains: a Group Header A a Group Header B and a Group Header C Group Header A (form header) is always 5 inches and must appear at the top of...

Part and Inventory Search

Back
Top