Recent content by JKrumins

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...

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

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...

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...

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...

[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...

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...

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?

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...

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...

Thanks. Unfortunately I'm using only Crystal 8.[sad]

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...

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

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...

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...