May I begin by saying: That design sucks :-P If there's one really big 'n' and a bunch of really small 'n's, the customer going to waste a ton of paper. Plus, long text in a narrow column? Srsly?? ZOMG, I want to die noa!
Don't let them design. They don't know what they're doing. Let them tell you the requirements and you do the design ;-) I haven't used the excel generator before, so I don't know if it can handle this, but ERD2W has a grouping list page. With that, you should be able to get a table that looks something like product 1 statement 1.1 statement 1.2 product 2 statement 2.1 statement 2.2 statement 2.3 statement 2.4 statement 2.5 statement 2.6 product 3 statment 3.1 product 4 ... and so on. If the xls generator can't handle the markup ERD2W produces, but you could customize your own grouping list repetition component. If they really Really demand columns per statement, I'd just dump the text to a csv file and let them open that in excel. This may be the easiest route. Ramsey On Feb 6, 2013, at 10:13 AM, Markus Ruggiero wrote: > Folks, > I need some good ideas. I have basically the following model: > > PRODUCT (code, name, some other attrs) <-->> STATEMENTREF (status) <<--> > STATEMENT(text) > > STATEMENTREF is a join table that has one attribute (so it is not a simple > m:n join). The customer wants an excel file looking like this > > heading line: product code | product name | statement 1 text | statement 2 > text | ... | statement n text > data line 1 : 2345 | name of this | ref status 1 | ref status 2 > | ... | ref status n > data line 2 : 8976 | name of this | ref status 1 | ref status 2 > | ... | ref status n > etc > > The columns are the statements, the rows one per product and the cells hold > the status for the reference from product to statement text. Any idea how to > do such a thing? > This is pretty urgent and I am at a loss. The whole thing is a D2W project in > Neutral Look. Creating Excel stuff with ERExcelLook is no problem under > "normal" conditions. But here? I am pulling my hair but I have not made any > progress so far. > > Thanks a lot for any help > ---markus--- > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to rgur...@smarthealth.com
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
