Hi everyone,
I’m trying to create an output set element called ‘Research tab notes’ with a parameter of note type. I set up the parameter just fine and was able to construct my output set, but am running into an error with the element. When I try to execute the output set I get an error stating “the multi-part identifier c.id could not be bound.” Here’s how I’ve created the element:
Data select: !.notes
Data from: (select a.notes, b.customer_no from tx_cust_notes_ext a JOIN tx_cust_notes b ON a.cust_notes_no=b.cust_notes_no JOIN tr_cust_notes_type c ON b.note_type=c.id)
Data where: c.id in (<<p4>>)
(c.id being my element parameter of note type, pulled from tr_cust_notes_type)
Does anyone have any suggestions?
Cheers,Kathleen
I rewrote your Data from and Data where slightly:
Data from: (select a.customer_no, a.note_type, b.notes from tx_cust_notes a JOIN tx_cust_notes_ext b on a.cust_notes_no = b.cust_notes_no)
Data where: note_type in (<<p4>>)
Make sure you don’t have single row selected.
It should work now.
However, any note that is over 255 characters long will be broken up. I’ll continue to play with this a little longer to see if I can shoehorn a way of clumping notes into one long field (I wrote a report that does this, so that’s what I’m borrowing from).
Lucie
______________________________
Lucie SpielerIT Development and Training Manager
Florida Grand Opera