Use case: Display Orders and Orders' Lineitems from one Customer from the Snowflake sample database
Snowflake tables
CUSTOMER
ORDERS
LINEITEM
M&D Report
How to get there?
Snowflake Server Database datasource
Report Template
Customer and the corresponding Orders
Orders and the corresponding Line items
PARAMETERS
Customer
The Customer number is a parameter, for designing purposes, the default is set to 270001
CUSTOMER element
ORDERS element
ORDERS Repeater Element
Preparation Action
ORDERS Repeater Element
Levels
LINEITEM Element
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article