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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JKrumins

  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

    Thanks for the post Gunjan. I will explore these options in the next day or two and let you know how I get on... br JK
  3. JKrumins

    HIerarchical Query with Cumulative Quantities

    OK, here goes: create table manuf_structure_test ( part_no varchar2(20) null, component_part varchar2(20) not null, qty_per_assembly number not null ) ; insert into manuf_structure_test (part_no, component_part, qty_per_assembly) values ('A1','B1',2); insert into...
  4. JKrumins

    HIerarchical Query with Cumulative Quantities

    Thanks, both Gunjan and Taupirho I guess Gunjan is right about Taupirho's solution. As I understand it, twhen there are multiple 'sub-branches' of the hierarchy then all nodes at a level will get accumulated. And this is indeed the case in my data - just gave a simplified version for this...
  5. 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...
  6. JKrumins

    select statement using 'IN' and NVL

    [SURPRISE] Wow! You've given me loads to work with, Gunjan and Dima. Thanks. I will post any comments when I have had a chance to try out and evaluate these suggestions. Yesterday I played around with Gunjan's first coding. That worked very well for a list of two items separated by a comma...
  7. JKrumins

    select statement using 'IN' and NVL

    Hi Sem If I understand what you mean correctly, I guess the answer is no. From within the application, a report is just a single sql select statement eg select * from cust_tab where cust_id like NVL('&Enter_customer_no','%') and part_no in (select part_no from part_tab where part_no like...
  8. JKrumins

    select statement using 'IN' and NVL

    Trouble is, I'm working within the confines of an ERP package where simple reports are single-command select statements. It can do select .... where cust_id in (select...) etc but it definitely can't do 3 statements or declaration of variables. Any other ideas?
  9. JKrumins

    select statement using 'IN' and NVL

    Thanks for the prompt answer. I'm afraid that cust_id is not a numeric field. I think the fact that the IN statement usually takes the form ... WHERE CUST_ID IN ('A123','A125','B444') with varchar values enclosed in quotes is part of the problem. Maybe I will have to have two queries as you...
  10. 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...
  11. JKrumins

    easy way to copy report header between different reports?

    Thanks. Unfortunately I'm using only Crystal 8.[sad]
  12. 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...
  13. JKrumins

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

    Oh, by the way, can I use the result of the sub-report in further computations within my main report?
  14. JKrumins

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

    Thank you both very much for your prompt replies. I have tried Jim's sub-report approach and it almost works! The @Initialize works OK, the formula that adds the 'found' records to the initialised value works OK... but the @DisplaySum in the footer seems to return the value set in @initialize...
  15. 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...
See more

Part and Inventory Search

Back
Top