Hi Team,
May I ask if this is possible or maybe a future design or consideration
for examples: I have 6 tables (to make it short demo) Customers and Products and 2 detail table with relationship for Customers and Products
eg
Customers
- Costumer's Order
- Costumer's OrderDetails
Products
- Product Details
- Product Comments
I want to this this in Reports Writer
I have a setup web base for mapping:
example
Customers
I will include the following table as a sub
Customer Order (5 Fields
Product Details (5 Fields)
Product Comments (5 Fields)
In Making a report
1ST STEP: Table Selection
In dropbox or listbox I will choose table Customer or Products Only,
2ND STEP: Mapped Table Selection
when choosing tables of course I can chose only the mapped table in customers (eg: Customer Order, Product Details, Product Comments)
3RD STEP: Field Selection
I can choose or tick fields I want in MappedTables or SubTable
4TH: Grouping, Summary
5TH: Totals, Tick Field to show
6TH: Templates, Stepped, Outline or Block
7TH: Sort
8TH: Style Editor
9TH: Set Report Title