[Solved] Multiple authentication prompts for label report

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

[Solved] Multiple authentication prompts for label report

Postby gkick » Fri Nov 08, 2019 7:01 am

Hi all,

Have created a label report for a dummy asset db to print some stickers containing the item id and name and location.
The db is registered, open writer and choose File,New,Labels ...

in the dialog select database name, table and fields all fine, then select New Document and then I get a authentication request for every single record before the label page shows up.
There must be something amiss, because if you have a table with 100s of records you do not wish to respond to 100s of prompts.

Had something similar happening with a standalone form which contained multiple table controls.
Anyway, anyone in the know how to stop these prompts as one should be enough ? Thks.
Last edited by gkick on Sun Nov 10, 2019 6:08 am, edited 1 time in total.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 116
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Multiple authentication prompts for label report

Postby Villeroy » Fri Nov 08, 2019 10:30 pm

The attached label document is linked to the built-in Bibliography database, query "Query1" which is a parameter query. My param query was SELECT * FROM "biblio" WHERE "Identifier" LIKE CONCAT(:P, '%').

Just enter a letter A, G or L when prompted.
I tested this with printing to a single file, to multiple files and printing to a printer queue. It always prompts only once for parameter P.
Attachments
MergeBiblioParam.odt
(14.35 KiB) Downloaded 1 time
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.x
User avatar
Villeroy
Volunteer
 
Posts: 27299
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Multiple authentication prompts for label report

Postby gkick » Sat Nov 09, 2019 7:17 am

Thanks for that, however no good as my backend prompts for authentication and the prompt appears as many times as there are records.
Funny enough no problems with the linked spreadsheet containing a pivot, only one single prompt and a subsequent one on refresh.

Feel inclined to think somethings wrong with my machine as yesterday I lost a couple of forms, one still sitting in the container but does not open and I can not delete it either.
Can not install extensions, another one I can not remove....
If one kills and reinstalls LO, are their some settings somewhere which persist from the previous version?
Also weird if, I create another writer doc, then new labels it comes up with the previous documents label settings

Was wondering why I do not see your query until it dawned I have a different bibliography db,
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 116
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Multiple authentication prompts for label report

Postby UnklDonald418 » Sun Nov 10, 2019 1:58 am

If one kills and reinstalls LO, are their some settings somewhere which persist from the previous version?

Yes, the user profile is not removed when you uninstall LO. Actually, resetting the user profile sometimes solves mysterious issues without uninstalling and reinstalling the program.
[Tutorial] Profile reset on Windows 10 - with images
Note that you will be looking for LibreOffice not OpenOffice.
for a more detailed tutorial and other operating systems see
[Tutorial] The OpenOffice User Profile
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1238
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Multiple authentication prompts for label report

Postby gkick » Sun Nov 10, 2019 4:59 am

Thank you, going to have a cleanup night, sort of taking me back to the days of Norton Gh :knock: ost
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 116
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Multiple authentication prompts for label report

Postby gkick » Sun Nov 10, 2019 6:07 am

Thanks a million, all working, label report working perfectly, had LO and OO sitting in appdata
you guys are fantastic !!! :D
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 116
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