On 7/1/2011 4:42 AM, JD wrote:
> I need to design a report that consists of one data set displayed as a
> table. The SQL query depends on report parameters and the number of
> output columns varies.
> I see that I can use the describe event on scripted data sets to specify
> the data set output columns.
> 1 - Is there a way to do the same with regular data sets?
> 2 - If not, how do I perform a JDBC query with a scripted data set?
> Thanks in advance.
My use case is this: I have items (rows) that can belong to several groups (columns); I need to show an observation for each item/group combination. The number of groups depends on the customer. What's obvious now is that this fits perfectly in a cross tab, with simpler SQL that what I was going for.
I'm not sure what I was asking for would ever be useful.