[Solved] Parameter Report based on lookup

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

[Solved] Parameter Report based on lookup

Post by gkick »

Hi,

I have a generic inventory query as source for a report listing assets by room.
Since the table is populated by way of a listbox from a lookup table, the query inherits the pk and the report subsequently shows the integer as location rathen then the actual name.
How can one create some runtime procedure that will prompt for the location by way of a listbox which will pass on the location name to the report.
Any ideas will be welcome

Thanks
Last edited by Hagar Delest on Fri Oct 25, 2019 12:39 pm, edited 1 time in total.
Reason: tagged solved.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Parameter Report based on lookup

Post by Villeroy »

SELECT "Name" FROM "Table_A" JOIN "Table_B" ON "Table_A"."ID"="Table_B"."AID"

Table_A:
ID Name
01 John
02 Paul
03 Ringo
04 George

Table_B:
AID
03
02
04
01
04
03
02
04
01
01

Query Result:
Name
Ringo
Paul
George
John
George
RIngo
Paul
George
John
John
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Parameter Report based on lookup

Post by gkick »

Thank you,
Gruss aus Chile
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Post Reply