Ask Your Question
0

Base report data field formula for 2 tables

asked 2017-10-21 18:47:03 +0200

Michele Salvador gravatar image

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 ☹

Thank you!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-21 18:56:30 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

Thanks a lot! This solved my problem 😄

Michele Salvador gravatar imageMichele Salvador ( 2017-10-23 01:50:45 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-21 18:47:03 +0200

Seen: 261 times

Last updated: Oct 21 '17