Grouping Datareport more than 1 level and using functions
Posted on 2001-08-28
Can anybody give me an example on how to group up to 2 levels?
Say you have Customers table, then Orders, then Products table. I want to group by CustomerID, OrderIR, an then see the products the customer bougth.
I'm using a DataEnviroment with a child command for the first group, but I don't know what to do next. I'm using the VB 6 Datareport Designer.
Also How can I insert functions not coming from the recordset in the report, say "iif(cColor='W','White','Other Color').
Thanks in advance.