Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Create Report

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

Create Report [message #1841247]

Fri, 07 May 2021 15:55

Eclipse User

Hello,

I need some advice on structuring data:

Example

1 data | U.I | SUM (DATA 1) divided by weeks

Clearly I have put some report items to define the start date and end date

The query used to structure the data is as follows

select PVSSAVG.AI_AVG_1DAY.START_TS,
max (decode (PVSSAVG.AI_AVG_1DAY.ELEMENT_ID, 3847938376193, PVSSAVG.AI_AVG_1DAY.MAXIMUM)) Temp_Max
where PVSSAVG.AI_AVG_1DAY.ELEMENT_ID = PVSSAVG.ANAG_ELEMENT_ID.ELEMENT_ID and PVSSAVG.AI_AVG_1DAY.START_TS between? and?

Attached is the image of how the table should be in birt

Thank you for suggestions

Attachment: Esmpio.PNG
(Size: 54.48KB, Downloaded 88 times)

Report message to a moderator

Previous Topic:	Footer is floating in web viewer/HTML
Next Topic:	The sound in my device cannot work.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 13:10:51 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter