[Solved] List box fields in report show only numbers

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved] List box fields in report show only numbers

Postby adj » Sun Jan 06, 2008 11:35 pm

I'm using several list box tables to make input easyer. ID numbers of the list box table are stored in the main database.
When a report is generated it shows the numbers from the database. I'd like to show the related fields from the list box tables.
Suggestions anyone?
Last edited by adj on Tue Jan 08, 2008 11:28 pm, edited 2 times in total.
adj
 
Posts: 4
Joined: Sun Jan 06, 2008 11:22 pm

Re: List box fields in report show only numbers

Postby DrewJensen » Sun Jan 06, 2008 11:55 pm

You would use a query to join the tables together based on those ID fields, then display the text from the joined table versus the ID value.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: List box fields in report show only numbers

Postby adj » Mon Jan 07, 2008 12:28 am

Thanks for your quick response. Could you please explain a bit more. I'm a novice user of databases in general. Started to use base last week.
adj
 
Posts: 4
Joined: Sun Jan 06, 2008 11:22 pm

Re: List box fields in report show only numbers

Postby adj » Mon Jan 07, 2008 12:41 am

I added a list box table and see the what you meen. Now I get 5 lines with the same data. With what funtion of criterium can I shorten this list to one relevant line?
adj
 
Posts: 4
Joined: Sun Jan 06, 2008 11:22 pm

Re: List box fields in report show only numbers

Postby DrewJensen » Mon Jan 07, 2008 12:43 am

Well you need to JOIN the tables.


So in the query designer click on the field in the Main table that holds the ID to the other table, then drag this to the ID field in the second table.

When you let go of the mouse key you will see a line between the tables

Run your query again.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: List box fields in report show only numbers

Postby adj » Mon Jan 07, 2008 8:49 am

Yes, thanks for your help!
adj
 
Posts: 4
Joined: Sun Jan 06, 2008 11:22 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests