| Hi list,
Some months ago I have asked for help with generation of Excel from inside a D2W app. This has worked perfectly. But now the customer wants more - and I have no idea how to solve this.
I have a model that goes like this (simplified): Document <-->> Textblock (simple one to many). Each doc and each textblock has a short identifying code (this is not the primary key). For the customer seeing the code is all he needs.
I can create an Excel from a ListDocument-PageConfig and I can create Excel from ListTextblock-PageConfig. What the customer now wants is an Excel that looks like this:
1 , "doc_a" , "text_1" , "text_2" , "text_3" , " " 2 , "doc_b" , "text_1" , "text_3" , "text_15" , "text_16" 3 , "doc_k" , "text_3" , "text_4" , " " , " " etc
So the customer wants to see a document and all its text blocks. Ideally the text block would be listed in sequence each in a column but it would also be ok if we had only one column containing all text blocks. Each document can reference the same or different text blocks and not every document has the same number of text blocks.
As the number of text blocks is variable I cannot simply create a database view and model this as a read-only entity in EOModel.
Any idea how this could be solved
Thanks a lot ---markus---
|