Base report data field formula for 2 tables

English
, ,
#1

I have a database with two tables:

  • “Friends” (Name, CountryID)
  • “Countries” (ID, Country)

I want to build a report displaying a list of friends names and relative country (USA, Italy, France…) instead of country ID.

Which formula I have to use in Data field of “Country” Text Box properties?

Is SQL allowed?

I tried SELECT "Country" FROM "Friends" JOIN "Countries" ON "ID" = "CountryID" but it doesn’t display anything in the report :frowning:

Thank you!

#2

Hello,

Report builder only allows one input for data: table or query. You need to create a query resulting in all information needed for your report based upon the two tables and then use that as input to the Report Builder.

Report Builder does allow for creation of fields based upon other fields such as calculated totals and others.

#3

Thanks a lot! This solved my problem :grinning_face_with_smiling_eyes:

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.