Crystal report selection

[DrsMen]

I have made a rather complicated report with sevaral tables.

Table1
article1 price1 defaultprice:TRUE
article1 price2 defaultprice:FALSE
article1 price3 defaultprice:FALSE

Now i need to calculate with the defaultprice.
is is not possible to filter on this field, while it is a table which is on a lower level with several one-on-more table couplings.
How do i find the correct price (or make a sum of all the prices with the false reset as zero)
Who can help me?

With kind regards,

 

[IanWaterman]

I do not see why you can not filter table as Defaultprice = true

Ian

 

[DrsMen]

While the following is happening:


Table0 -> Table2
1-more relation

Table0 -> Table1
1-more relation

When i filter in Table1 on "defaultprice=TRUE"
this will result in not finding all details out of table2

 

[IanWaterman]

What fields are you linking on?

If defaultprice:FALSE in table 1 is not a valid choice why do you want the records from table 2 related to those invalid records?

Ian

 

[lbass]

You should show actual sample data that illustrates the issue and also show sample desired results. You should label the data by table and field name. If you have duplicate values due to the table joins, you can use running totals that evaluate on change of some field so that you get non-duplicated amounts.

-LB