You are not logged in.
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 ![]()
Last edited by Fallon911 (2013-03-15 16:34:12)
Offline
[Op posting again] The only solution I have been able to find is to do this:
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??
Last edited by Fallon911 (2013-03-15 16:55:04)
Offline