OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

No Data in Report

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
hermanj04
Newbie
Newbie


Joined: 26 Jul 2012
Posts: 2

PostPosted: Thu Jul 26, 2012 11:52 am    Post subject: No Data in Report Reply with quote

I have a very basic database with two joined tables. I am attempting to use a query to join the tables and filter results. However, whenever I try to create a report based on that query, the "dummy" data is not replaced by any actual data. For one previous table, I was able to develop a workaround by creating a view and then running the report off of that view. However, the view does not work with a filter, so I cannot use this workaround here. Can anyone explain to me how to create a report off of a query?
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Jul 27, 2012 8:06 am    Post subject: Reply with quote

hermanj04 wrote:
I am attempting to use a query to join the tables and filter results.

You first need to compose ( write ) the Query, that will contain the records and fields you need in your report. This Query can be, what is called, a Parameter Query.

You can read about Parameter Queries, in Base Help ( F1 ), with the Search term, parameters;queries (Base)

A Parameter Query has pop-ups, asking the user to enter one or more values, so, the Query will only return the desired records, from your database tables.

Please see the following links, for examples:

  1. Graphic showing prompt query: http://www.oooforum.org/forum/viewtopic.phtml?t=53530

  2. User asking about report, and, Parameter Query: http://www.oooforum.org/forum/viewtopic.phtml?t=63974

  3. Another Prompt Query: http://www.oooforum.org/forum/viewtopic.phtml?t=67823

  4. Parameter Query, multiple prompts: http://www.oooforum.org/forum/viewtopic.phtml?t=69868

  5. Parameter Query, multiple prompts: http://www.oooforum.org/forum/viewtopic.phtml?t=74131
I strongly recommend, you write your Query, after clicking on Create Query in Design View... from the Query sub-system. This will prompt you add the tables and fields you want in your result table. With a Parameter Query, on the Criterion line, if you enter a colon ( : ) and characters ( withOUT any spaces, so, I like to use underscores for readability ) this will result in prompt(s) presented, where you enter values, for example, numbers, text, a date, time, etc and the Query is performed with the 'dynamic' results returned.

This way, when you compose your Report, and, use this Parameter Query, you will be prompted so the Report results will only be what you want.

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
hermanj04
Newbie
Newbie


Joined: 26 Jul 2012
Posts: 2

PostPosted: Fri Jul 27, 2012 10:01 am    Post subject: Reply with quote

The query is already set up and working fine. It is the report based on the query that is the problem.
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Jul 27, 2012 10:51 am    Post subject: Reply with quote

hermanj04 wrote:
The query is already set up and working fine. It is the report based on the query that is the problem.

  1. Please show ( copy and paste ) the SQL of your Query here. You can 'see' the SQL after you open, for edit, your Query, and, Either :

    1. On the Toolbar, press the icon: Switch Design View On/Off
      ( this is the icon with a gold coloured triangle in the southwest corner )

    2. From the Menu: View -> Switch Design View On/Off[

  2. Are you using, ORB ( Oracle Report Builder ) extension, as your database reporting tool, or, the default, Writer Wizard ?
Sliderule
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group