Search results for query: *

Hi Lbass, The BPCurrency is a shared variable from a subreport. I realised this is causing the problem as crystal cannot sum up such. I removed this and the whileprintingrecords and I can now sum up. Thank you for pointing me to the right direction.

Dear Experts, I have two formulars with me : The first being 1. Global numbervar money; IF {@BPCurrency} <> 'KES' or {@BPCurrency} <> 'EUR' then Global numbervar money:= {ConsStatement.Win_FCDeb} else if {@BPCurrency} = 'KES' or {@BPCurrency} = 'EUR' then Global numbervar money:=...

fisheromacse, The will always be ordered that way, at no time will they come mixed up with the 'S' and 'I'. As they are input from a diffrent table with that ordering in place. Regards,

Hi Hilfy, The grouping should be as the parent item -- that is the item with tree type 'S' and the subsequent child items with tree type 'I' should be grouped together as one. where there is ever tree type 'S' all the subsequent 'I' should be grouped as one. I don't know if this helps ...

There is no convention for the item codes. See the sample data below DU05 A100 Z090 TR98OIKL POGHJK98

Hilfy, There is no naming mechanism on the item code and as such an item code could as well start with ZKL009 etc. Hence grouping with the prefix would not suffice as such. Thanks,

Dear Experts, I have data from a single table without an "obvious" relationship but whose data I need to group. I would like to create a group using formulas in crystal or SQL if possible that will allow me to create some grouping for the data. The data is as follows : ItemCode Qty...

From what I see in this, I am trying to group up data with no direct relationship. I guess we would have to create it. In crystal this could be possible though I have never tried it. Have you ?

There really isn't a field that determines the Father of the child. If we were to work only with the one table : INV1, would it be possible ?

Dear Experts, I have a formular in the detail area section of my report. the formular is like var x/var y. I would like to have a particular result from the rows to the group footer. Is there a known solution for this ?

This is the data from maintable. i.e. select qty, itemcode,treetype from maintable. ItemCode Quanti TreeTyp DocEntr LineNum MFx7 1 S 979 0 R219 2240 I 979 1 R223 840 I 979 2 R226 840 I...

Thanks lbass, what I have realised is that the script works where I have only one set of father child relationship on the main table, but when I get two or more then some fathers are left out and the quantity gets wrong. What change could be done to allow it to read multiple father child...

They are not present at all in this table.

As a rule in the software after each S will be an I. There can never been differences in that such as having an S then an N and later I . That cannot happen. There is a diffrent table that has the S and I linked as father and child. It has format such as childitemcode fatheritemcode Qty 1004...

I don't know if this would help but each row has a unique identifier. Am thinking of a way such that where is a row type S followed by I then this would have the same unique number and for a row type N a unique number giving us the possibility of grouping this way. Problem is I don't really know...

The information actually exists as hierarchical data in a different table. I wander if that would actually help ?

Just some more information, the data is actually like this : itemcode qty treetype 1001 2 N 1002 5 N 1003 1 S 1004 6 I 1005...

Thanks Bloke152, but when i group by that formula I get the data split into two. The first part is Treetype and the second type is S. The key thing is to get the S under the tree type and so add up the quantities of the child items underneath, to sum up and the qty to appear at the parent items.

Any other information required for this ?

Dear Experts, I have quite a problem here :- I am trying to add up data that sits on tables as some kind of hierarchy. The data is as follows :- itemcode qty treetype 1001 2 N 1002 5 N 1003 1...