Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Dynamic combo box doesn't pass value field
Dynamic combo box doesn't pass value field [message #1801411] Fri, 18 January 2019 14:07
Alex Davidson is currently offline Alex DavidsonFriend
Messages: 1
Registered: January 2019
Junior Member
Hi all,

Having a small bit of trouble setting up a dynamic combo box report parameter that will let me display a value, but pass another value through

I have 2 datasets - one is the main report SQL and the other is for the dynamic combo data

The main SQL consists of (among other things) the following:

select pm,part, fp.periodid, fp.fpstdat
from forecasts fp
where cast(fp,fpstdat AS Date) <= ? 
and cast(fp.fpstdat AS Date) >= ?

and then I've created two dynamic combo boxes that both link to the following:

select fpstdat, fperiodid, fpprisec
from finperiods
where fpstdat > DATEADD(day, DATEDIFF(day,0,GETDATE()),0)

I've linked the report parameters to the SQL parameters both as type date, and in the combo boxes I've set them as dynamic to look at the second dataset, with the value column looking at fpstdat and the display text looking at fperiodid

In BIRT I can preview the results to PDF and the combo boxes do drop down and show me the correct data (ie the fperiodid) but when running the report I get no results. Seems like for whatever reason the combo boxes aren't passing the value data (fpstdat) to the SQL in the first dataset and I can't see why

I have a continuation on this issue when I push the report over to our ERP but that's a separate issue unrelated to here

Any help or guidance would be appreciated :)
Previous Topic:Report parameter combo box not populating
Next Topic:Deploy BIRT runtime 4.8.0 to JDK7 failure
Goto Forum:

Current Time: Tue Nov 12 19:33:53 GMT 2019

Powered by FUDForum. Page generated in 0.01269 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top