Parameters inconsistently null (iReport)

0

I have several datasets in my report all if which refer to the same parameters : UserName, reportstartdate, mpcodes.

(A text field, date and a list)

I added a new dataset today, cutting and pasting the same parameters, eg. UserName which has ${UserName} as Default Value Expression, exactly the same as all the existng datasets.

However, this dataset was not returning any results. So created another one as a test which simply did select  $P{reportstartdate} as f1, $P{UserName} as f2

Then added a table for this data set and just get a table with 'null' and 'null'.

So it appears the original datasets have the parameters passing through (including a new one I created yesterday) but today all new datasets have parameters coming throough as null.

I've spent hours now trying different things to work out what's happening to no avail.

There's no difference in the way these parameters are defined.

Anyone seen anything like this before? Any ideas?

Thanks

 

 

sjbradshaw's picture
Joined: Aug 4 2015 - 7:19am
Last seen: 3 weeks 4 days ago

1 Answer:

0

My mistake.

Parameters being visible in the outline control on the left doesn;t mean they are being set. Right click and view data source and there's a maping in there.

Once set it works as expected.

sjbradshaw's picture
Joined: Aug 4 2015 - 7:19am
Last seen: 3 weeks 4 days ago
Feedback
randomness