Hi,
I'm trying combine two sets of data that have some data in common ( French and English values). This is a bit complicated so I'll start by giving you some background info.
My data is coming from sql and the tables have the following info:
1.Ticket Table (this is what I'm reporting on)
- Region number field
2.Region Table (english and french records are two separate entities but the region number would stay the same)
-Region number field
-Region name
-language
In my report, I am grouping by a formula. What I need to do is set the group title to represent the french and english value ie. British-Columbia / Colombie-Britanique.
I am using a formula to perform the action but I only get " / British-Columbia".
here's the formula:
if ({Ticket_form.Region_Code} = {Region_Table.Region_Code}) then
((if {Ticket_form.Region_Code} = {Region_Table.Region_Code} and
{Region_Table.Language} = "fr_FR" then
{Region_Table.Region_Name}) & " / " &
(if {Ticket_form.Region_Code} = {Region_Table.Region_Code} and
{Region_Table.Language} = "en_US" then
{Region_Table.Region_Name}))
Thank you!