[Solved] Parameter Report based on lookup

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

[Solved] Parameter Report based on lookup

Postby gkick » Thu Oct 24, 2019 10:39 pm

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.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 246
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Parameter Report based on lookup

Postby Villeroy » Thu Oct 24, 2019 11:36 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28422
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Parameter Report based on lookup

Postby gkick » Fri Oct 25, 2019 5:20 am

Thank you,
Gruss aus Chile
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 246
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest