Hi,

Is there anyway we can display the BY field value when the second BY field value changes.

eg:

Make Model Year Price
BMW 330i 2002 $50000
325i 2003 $45000

540i 2001 $60000
525i 2007 $75000

I need the data should be display as,

Make Model Year Price
BMW 330i 2002 $50000
325i 2003 $45000

BMW 540i 2001 $60000
525i 2007 $75000


The reason I am asking this is, when I make the BMW value for drilldown, it gives me the data only for 3 series not for 5series.

Hope I put my question clear,

Thanks

This message has been edited. Last edited by: Kerry,

TABLE ...
PRINT PRICE
 BY MAKE NOPRINT
 BY MODEL NOPRINT
  BY MAKE
  BY MODEL 
   BY YEAR
...

will display what you asked for.

But regardless of the display, you should be able to set up the drilldowns, by varying the fexname and/or the arguments, so that the drilldown report for the MAKE columns lists that make and all its models, while the drilldown for MODEL lists just that Model of that Make.

This message has been edited. Last edited by: j.gross,

That works, thanks