The BACKGROUND: I have been working on a phone listing and can generate a nice report based on a table with First Name, Surname, Phone Numbers all nicely laid out and sorted. Page breaks and grouping all under control. This was done using the "Create Report in Design View" method.
I decided it would be nice to concatenate the First Name and Surname and have created a query that does this using Concat function in SQL. I now have a Query with all the original data plus the concatenated names (alias 'WholeName').
The PROBLEM: When I try to create a new report, using "Create Report in Design View" the Query does not appear when I insert a Text Box. Only the original table elements appear in the Data/Data Field drop down list. No sign of 'WholeName', no choice of Table or Query. Report Builder seems to default to the original table.
The QUESTION: How do I get the report builder to point at the Query?
[Solved] Report Builder sees only table, not query
[Solved] Report Builder sees only table, not query
Last edited by weematt on Sat Mar 22, 2014 7:06 pm, edited 1 time in total.
OpenOffice 4.1 on Windows 7 Home premium
Re: Report Builder sees only table, not query
weematt:
You wrote / asked:
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit buton top right) if this isue has ben resolved..
You wrote / asked:
After opening your report . . .weematt wrote:The QUESTION: How do I get the report builder to point at the Query?
- Display ( show ) the Report Properties . . . EITHER:
- Press F4
- From the Menu: View -> Properties
- Display the Report Navigator . . . EITHER
- Press F5
- From the Menu: View -> Navigator
- Click on Report ( at the top ) of the Report navigator window
- Click on the Data tab
- Click on the Content type drop-down, and, choose: Query
- Click on the Content drop-down, and, choose the Query name you defined in your database
- From the Add Field window, you should now be able to include the desired fields to your report . . . in the section ( for example, Page Header, Group Header, Detail, etc ) you wish
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit buton top right) if this isue has ben resolved..
Re: Report Builder sees only table, not query
I seem to have found the answer:
When Oracle Report Builder window is active press F5 which opens Report Navigator.
Click on Report in the Report Navigator.
In the Editor, on right, click on the Data tab.
Go to Content Type and select Query or Table as required from drop down list. (The empty Add Field pop-up will appear.)
Go to Content and select the specific Query or Table required.(The Add Field pop-up will now list the fields from the selected object.)
Maybe there is another way but this worked for me.
EDIT: This post must nearly have collided with Sliderule's reply which put it better than I did.
Thanks again to Sliderule.
When Oracle Report Builder window is active press F5 which opens Report Navigator.
Click on Report in the Report Navigator.
In the Editor, on right, click on the Data tab.
Go to Content Type and select Query or Table as required from drop down list. (The empty Add Field pop-up will appear.)
Go to Content and select the specific Query or Table required.(The Add Field pop-up will now list the fields from the selected object.)
Maybe there is another way but this worked for me.
EDIT: This post must nearly have collided with Sliderule's reply which put it better than I did.
Thanks again to Sliderule.
OpenOffice 4.1 on Windows 7 Home premium