msuarez
asked on
Grouping Datareport more than 1 level and using functions
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','O ther Color').
Thanks in advance.
Miguel
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','O
Thanks in advance.
Miguel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Per recommendation, force-accepted.
Netminder
CS Moderator
Netminder
CS Moderator
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept roverm's comment(s) as an answer.
msuarez, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer