Eclipse Community Forums: BIRT » Variable number of columns

Help

Home

Home » Archived » BIRT » Variable number of columns

Show: Today's Messages :: Show Polls :: Message Navigator

Variable number of columns [message #691326]

Fri, 01 July 2011 08:42

J D

Messages: 9
Registered: June 2011

Junior Member

Hi,

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.

Report message to a moderator

Re: Variable number of columns [message #691547 is a reply to message #691326]

Fri, 01 July 2011 17:29

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

JD,

Will the query be against the same table every time? Just a variable
number of columns? Look at the attached example that adds columns
dynamically using the de api. You also may want to look at this post:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1210-hideshow-table-columns-based-on-input-parameter-selection/

Jason

On 7/1/2011 4:42 AM, JD wrote:
> Hi,
>
> 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.

Attachment: columnsbasedonparameters.rptdesign
(Size: 21.02KB, Downloaded 389 times)

Report message to a moderator

Re: Variable number of columns [message #691555 is a reply to message #691547]

Fri, 01 July 2011 17:44

J D

Messages: 9
Registered: June 2011

Junior Member

Thanks Jason for your reply.

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.

Report message to a moderator

Previous Topic:	is there any row size limit on crossTab in Birt reports
Next Topic:	Accumulations in CrossTabs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:25:28 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter