Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Help: Date as column name
Help: Date as column name [message #987316] Sun, 25 November 2012 21:36 Go to next message
Crystal W is currently offline 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

Re: Help: Date as column name [message #987511 is a reply to message #987316] Mon, 26 November 2012 17:42 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Do you mean like the attached?

Jason
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:
  


Current Time: Sat Aug 30 22:27:17 EDT 2014

Powered by FUDForum. Page generated in 0.03249 seconds