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