How to add listbox/dropbox parameter descriptions to report without reloading listbox datablock [#2745577]

I can add parameter values on report like by using {parm.someparameter}.

But what to do for case when I need to output listbox description values?

F.ex.:

I have a listbox with values and descriptions:
1 Used
2 Unused
3 Failed

When first two are selected for report then we will see in report head:

Parameter A: 1 Used, 2 Unused

There are way to create specific datablocks for this reason, that will be almost the same as for parameter listboxes.

Are there any way to use existing data from parameter listboxes?

Comments

Comment #1

9 June 2016 at 10:40

janeks created an issue.

Comment #2

metzlerd CreditAttribution: metzlerd as a volunteer and commented 10 June 2016 at 03:07

If the data is in the database, I usually create a data block that looks up the parameter description from the table in question, or add it as a join clause on the data and pull it in that way.

If the data is XML data blocks then the only way to create the references in the reports is to use calc fields to look up values. The two tasks that you need to be able to do are:

1.) Add an FrxData element to the head of the report to load the data values. Unfortunately currently the report parameters lists are not loaded in to custom contexts yet.
2.) Create an frx:field element that uses a calculation to look up the value in the XML.

I'm not sure if I am making sense here, but I'd need to know a bit more about where your lookup values are currently stored in order to advise you on the most straightforward approach.