You are not logged in.

#1 2013-03-15 16:14:43

Fallon911
Member
Registered: 2013-03-01
Posts: 15

[Question] Using Libre Office Base to build Reports

I am taking my IT GCSE and I am working through some exam papers. I am finding things a little difficult as tutorials and questions are designed for Microsoft access and windows.

Anyway, I am on a task to print a report of a database of coffee products. I have the table, and have made several reports. I have installed the oracle report builder and tried with that too. The problem is that I need to only show coffee/tea products that match the country Colombia/Guatemala/Peru. I am able to click data sources and then select this to work. But the report never updates.

Without using the oracle builder, the report is an example, filled with random Latin :S

Using the oracle builder, I can see all products from all countries, it ignores my data sources thing completely. I have tried saving closing/opening rebooting to see if that updates it, but it won't.



Any ideas appreciated, even if they seem obvious (I had a problem before importing CSV, that had a ridiculous easy answer)

Thanks for reading smile

Edit: Pic to show what I mean
screenshot-031513-163052.php

Last edited by Fallon911 (2013-03-15 16:34:12)

Offline

#2 2013-03-15 16:38:05

Fallon911
Member
Registered: 2013-03-01
Posts: 15

Re: [Question] Using Libre Office Base to build Reports

[Op posting again] The only solution I have been able to find is to do this:
screenshot-031513-163539.php
It isn't perfect but it works...ish. (doesn't select data that I want, guess I can do that manually, but that's sort of cheating the exam :L )

If anyone reckons they know what I'm doing wrong that'd be great, I have a new theory. When I click on the data and apply filter, I'm not sure that is actually selecting this new data as my data. This info may be of use?

Edit:
I decided to move on to the next quesiton instead of wasting loads of time, Ill come back to it when (if) someone answers D:
The next section is more difficult, I have to produce a report which contains field cost and a tonne of other things...
anyways, when I try to produce the report I get a blank page. Why??
screenshot-031513-165214.php

Last edited by Fallon911 (2013-03-15 16:55:04)

Offline

Board footer

Powered by FluxBB