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

Oracle Report Builder - Chart/graph Tutorial

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


Joined: 18 Feb 2011
Posts: 131
Location: Two gangster planets and a cowboy world

PostPosted: Wed May 25, 2011 11:58 am    Post subject: Oracle Report Builder - Chart/graph Tutorial Reply with quote

Good afternoon everyone,

Is anyone aware of a decent tutorial for the Oracle Report Builder? Specifically, the charts or graphs? The vast majority of the ORB makes perfect sense, but the charts feel very clunky when I work with them.

I'm able to go into "edit mode" and adjust the X and Y axis, and make minor changes, but I'm really confused by the data ranges and naming conventions and that sort of thing.

I'll keep searching the forum, but if anyone has a link, I'd appreciate it.

Thank you,
-Tomn
_________________
"I'm a loner, Dottie. A rebel."
[Windows 7] [OO.o 3.3] [HSQL 1.8]

The Lazer Cat
Back to top
View user's profile Send private message Visit poster's website
sainttomn
OOo Enthusiast
OOo Enthusiast


Joined: 18 Feb 2011
Posts: 131
Location: Two gangster planets and a cowboy world

PostPosted: Wed May 25, 2011 3:11 pm    Post subject: Reply with quote

UPDATE: After searching around the forum and the rest of the internet, I still haven't found a good tutorial.

I did find a post that was talking about how the charts in ORB are exactly the same as in Calc, which helped. I've managed to build a working chart in Calc, which allows me to select data range by cells.

Is anyone familiar with how to do this in ORB?

Still searching...

-Tomn
_________________
"I'm a loner, Dottie. A rebel."
[Windows 7] [OO.o 3.3] [HSQL 1.8]

The Lazer Cat
Back to top
View user's profile Send private message Visit poster's website
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Wed May 25, 2011 11:54 pm    Post subject: Reply with quote

Lot of limitations in charts in report builder.
Now I updated report builder documentation, with my knowledge about charts in reports:
http://wiki.services.openoffice.org/wiki/SUN_Report_Builder/Documentation#Charts_in_report_builder
Back to top
View user's profile Send private message
sainttomn
OOo Enthusiast
OOo Enthusiast


Joined: 18 Feb 2011
Posts: 131
Location: Two gangster planets and a cowboy world

PostPosted: Thu May 26, 2011 7:08 am    Post subject: Reply with quote

Thank you r4zoli, this is about what I was looking for.

I've noticed that the Base version of the charts is certainly lacking compared to Calc. I haven't tried placing the chart inthe header yet, so I'll try that next.

I'll post some more after I try a few things.

-Tomn
_________________
"I'm a loner, Dottie. A rebel."
[Windows 7] [OO.o 3.3] [HSQL 1.8]

The Lazer Cat
Back to top
View user's profile Send private message Visit poster's website
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri May 27, 2011 4:52 am    Post subject: Reply with quote

This is one of the reasons why I always use spreadsheets for reporting. Spreadsheets can calculate and chart anything you throw at it and the layout capabilities are more than sufficient.
This "report builder" is another source of shame.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
sainttomn
OOo Enthusiast
OOo Enthusiast


Joined: 18 Feb 2011
Posts: 131
Location: Two gangster planets and a cowboy world

PostPosted: Fri May 27, 2011 10:00 am    Post subject: Reply with quote

After a lot of searching and trying, I have to agree with you, Villeroy.

I've managed to make some pretty nice reports with the ORB, but when charts come into it, the ORB is really lacking. I think that if I had simple data the report builder could handle the chart, but this report is 48 fields of data for about 50 people, and the ORB can't take it for a chart.

With regard to Calc and exporting from a query, how does one go about assigning that functionality to the query? Or is this a manual process?

Thank you,
-Tomn
_________________
"I'm a loner, Dottie. A rebel."
[Windows 7] [OO.o 3.3] [HSQL 1.8]

The Lazer Cat
Back to top
View user's profile Send private message Visit poster's website
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri May 27, 2011 2:04 pm    Post subject: Reply with quote

[Tutorial] Using registered datasources in Calc
http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727 (file #4 is a report with a chart)
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
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