Ask Your Question
0

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run? [closed]

asked 2013-11-22 00:52:49 +0100

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let me select the query I want to use. Or if not I could set up a template report, copy it and rename it for the most popular queries then change the query attached to that report. I'm open to any suggestions, books, tutorials, or better practices.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 21:37:03.416381

1 Answer

Sort by » oldest newest most voted
1

answered 2013-11-22 14:05:53 +0100

m.a.riosv gravatar image

Maybe could be helpful for you the use of parameters in a query.

LibreOffice help about parameter queries

edit flag offensive delete link more

Comments

+1 for really good information. Some I knew but it is great to see it expanded and explained. Some I'm not sure I understand until I play around a little. It seems a little different that what I was asking, in other words I have 2 querries that run fine. I have a report that displays what I want however when I run the report it was set up to use querry A and I prefer that it use query B, Is there a way to force the report to use query B? Or is this a totally invalid question?

dshimer gravatar imagedshimer ( 2013-11-24 03:52:43 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-11-22 00:52:49 +0100

Seen: 853 times

Last updated: Nov 22 '13