ytoro
|
| Posted: 11/05/2002, 12:44 PM |
|
i need to read from 2 tables (customers and orders) and produce this report
customer 1, field 1, field 2...
order 1, order1_filed 1, order1_filed 1,...
order 2, order2_filed 1, order2_filed 1,...
....
....
customer 2, field 1, field 2...
order 1, order1_filed 1, order1_filed 1,...
order 2, order2_filed 1, order2_filed 1,...
....
....
like a report in access with subform
CCS, ASP, MSAccess
Appreciate any help
ytoro
|
|
|
 |
jerry
|
| Posted: 11/05/2002, 11:02 PM |
|
Please refer to CodeCharge 2.0 Users Guide.pdf page 100
|
|
|
|
Lee Irving
|
| Posted: 11/06/2002, 9:15 AM |
|
I am having the same problems trying to figure out grids within grids. As with many answers mapping CC solutions into CCS does not really help.
Has anyone actually managed this in CCS ?
|
|
|
|
Elena
|
| Posted: 11/09/2002, 2:32 AM |
|
Hello,
You can download sample CCS project from: http://www.gotocode.com/UserImages/Elena/ReportLikeGrid.zip
It uses sample CCS db.
It is not the same form as you ask for, but it demonstrates how to create such, i.e. the approach would be the same.
You should create detail Grid form and insert addition row from master table in given places. To insert custom row you should:
- use custom template variable that will be substituted with custom code or empty value;
- look up (probably using CCDLookUp() function) the fields from master table;
- and build custom html code with retrieved data included.
|
|
|
|
|
