I have
problems making a comparison with two different fields.
We have
orders and then there is maintenance orders (these order types has different
order numbers). Now I need to make comparison with these two order types with
help of two different fields.
I have one
field that have an order number and other field which starts with the order
number and has a other letters too. Now I need to make a report in which there
should show the original order and the maintenance order both.
For example
I have original order no. 123 and I have a maintenance order which has a field
that starts with 123 but it has a different order for example no 456.
Order No Name Text
123 ABC ABCDEFG
456 CDE 123 maintenance
I have this
kind of formula in the Select Expert
{TEXT}
startswith {?parameter which gives the order no} but this only shows the maintenance order in report. And I have no clue how to continue this formula that it shows the other order too..
How can I
make a report that shows these both orders?