How to use Context and Reference?

Hello @maretval,

We want to use the Context and Reference fields in the kreport. But we do not know how to use them.

Our requirement is that we want to display week value equal to zero when we do not have any reporting data. We are using OR in the select clause and then added the new filter under the root.

Please guide us!

Context is meant to be used in charts.
Reference is meant to be used in unions.
What do want to report on?

We wanted the OR condition with the same field

For report, we have the date field, and we want to select from and to in it.

Could we select the two fields from the module and store into the reference and then use them in from & to fields? :thinking: :thinking: :thinking:

Then you need a group in the filter tab

1 Like

A from to filter is achieved by selecting the “is between” operator

1 Like