Eclipse Community Forums: BIRT » Help: Date as column name

Help

Home

Home » Archived » BIRT » Help: Date as column name

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

Help: Date as column name [message #987316]

Mon, 26 November 2012 02:36

Crystal W

Messages: 1
Registered: November 2012

Junior Member

Can anyone help me with below ? I am new to BIRT

I have a SQL returned below info

CLIENT_CODE, PROCESS_DATE, PRCOCESS_STATUS, TRANS_COUNT
1234 2012-11-26 E 1
1234 2012-11-26 S 10
1234 2012-11-25 E 2
1234 2012-11-25 S 8

I want to generate a summary report like below

Client_CODE 2012-11-25 2012-11-26
1234
E 2 1
S 8 10

Report message to a moderator

Re: Help: Date as column name [message #987511 is a reply to message #987316]

Mon, 26 November 2012 22:42

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Do you mean like the attached?

Jason

Attachment: clientcode.zip
(Size: 1.83KB, Downloaded 189 times)

Report message to a moderator

Previous Topic:	How to summarize rows in a Data Set without using the Data Cude
Next Topic:	Your Feedback Is Needed To Plan the Next Eclipse BIRT Release

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:58:18 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter