| View previous topic :: View next topic |
| Author |
Message |
hermanj04
Newbie
Joined: 26 Jul 2012
Posts: 2
|
 Posted: Thu Jul 26, 2012 11:52 am Post subject: No Data in Report |
 |
|
| 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 |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Fri Jul 27, 2012 8:06 am Post subject: |
|
|
| 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:
- Graphic showing prompt query: http://www.oooforum.org/forum/viewtopic.phtml?t=53530
- User asking about report, and, Parameter Query: http://www.oooforum.org/forum/viewtopic.phtml?t=63974
- Another Prompt Query: http://www.oooforum.org/forum/viewtopic.phtml?t=67823
- Parameter Query, multiple prompts: http://www.oooforum.org/forum/viewtopic.phtml?t=69868
- 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 |
|
|
hermanj04
Newbie
Joined: 26 Jul 2012
Posts: 2
|
| Posted: Fri Jul 27, 2012 10:01 am Post subject: |
|
|
| The query is already set up and working fine. It is the report based on the query that is the problem. |
|
| Back to top |
|
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Fri Jul 27, 2012 10:51 am Post subject: |
|
|
| hermanj04 wrote: | | The query is already set up and working fine. It is the report based on the query that is the problem. |
- 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 :
- On the Toolbar, press the icon: Switch Design View On/Off
( this is the icon with a gold coloured triangle in the southwest corner )
- From the Menu: View -> Switch Design View On/Off[
- Are you using, ORB ( Oracle Report Builder ) extension, as your database reporting tool, or, the default, Writer Wizard ?
Sliderule |
|
| Back to top |
|
|
|
|
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
|
