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 bkrike 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: JKrumins
  • Content: Threads
  • Order by date
  1. JKrumins

    Can't paste from Citrix - intermittent behaviour

    Hi We use Citrix to connect to our ERP software. Sometimes a user may find that text copied from within the ERP app (under citrix) cannot be pasted into another local (non-citrix) app such as Excel. If the user opens a 2nd citrix session, he may well be able to paste from that. Problem only...
  2. JKrumins

    HIerarchical Query with Cumulative Quantities

    I am familiar with the CONNECT BY ... PRIOR function and have used it to get a multi-level Product Structure (i.e Bill-of-Material) with code such as: SELECT level, a.part_no, a.component_part, a.qty_per_assembly FROM manuf_structure a CONNECT BY PRIOR a.component_part = a.part_no START...
  3. JKrumins

    select statement using 'IN' and NVL

    Hi I want to write a query where the user can input either: (a) a single customer_id, to return all records for that customer or (b) a list of several customer_ids, perhaps seperated by commas, to return all records for those customers or (c) Null, to return records for ALL customer_id's...
  4. JKrumins

    easy way to copy report header between different reports?

    i have developed a 'standard' front page for my company's reports (ie the Report Header in Crystal). It includes some of the special fields (date printed, author, filename, comments) from Crystal's 'Summary info' and company logo (graphic) and some boxes and lines to make it pretty. The...
  5. JKrumins

    How do I total fields where table rows may not exist?

    Hi, I am new to Crystal, though have worked with SQL for some time. I guess this is a simple problem but I'm confused by all the different tools avaialble in Crystal... I want one row on a report for each product (table A.part_no, tableA.description, tableA.qty_available etc). I also want...

Part and Inventory Search

Back
Top