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

Report can customise or not?

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


Joined: 22 Jul 2004
Posts: 4
Location: mas

PostPosted: Tue Jul 27, 2004 1:48 am    Post subject: Report can customise or not? Reply with quote

in Data Sources have Report
when we make report this report automatic
create for origin style, it's can modify or not
follow user style if can how to make it
Back to top
View user's profile Send private message
Llelan D.
General User
General User


Joined: 15 Jul 2004
Posts: 21
Location: CA, USA

PostPosted: Tue Jul 27, 2004 4:30 am    Post subject: Reply with quote

Confused Um... I'm going to take a wild stab at this and guess that you're asking how to edit a report template using your own styles. If this is not correct, find a translator.

There are two kinds of report documents: A Writer template that defines how the report will be laid out, and a Writer document created from the template and filled with data from the linked database. If you choose "Edit Document" from the context menu of the linked report in Data View, you will create a Writer document from the template, fill it with data, and leave it open for editing. It has exactly the same effect as "Open Document" (Don't ask me why). You will not be editing the original template.

To edit the report template, from the menu choose "File | Templates | Edit..." and open the STW report template file.

I hope you find this of some help. Cool
Back to top
View user's profile Send private message Visit poster's website
tedbar
Newbie
Newbie


Joined: 02 Jul 2004
Posts: 3

PostPosted: Tue Jul 27, 2004 5:25 am    Post subject: Reply with quote

As Llelan D has pointed out the template can be modified, however, there is still a problem with dates - at least I have not found a solution. If the report contains dates from a DB, MySQL in my case, they are converted to integers. Modifying the template so that the table is formatted to date is not persistent - the next time the template is used the format reverts to integer.

Creating the report and then modifying the column to a date format results in garbage for any 'nulls' that existed as they become an incorrect date.

If ayone has a solution to this it would be greatly appreciated.

thanks
Ted
Back to top
View user's profile Send private message
achimoe
Newbie
Newbie


Joined: 19 Oct 2004
Posts: 1

PostPosted: Wed Jan 05, 2005 12:20 pm    Post subject: Reply with quote

Maybe this is obsolete by now, but just in case it's not:

With OOo version 1.1.4 the date format is correctly being put into the report
template now Smile Unfortunately the problem with nulls is still there Sad
A null-value is being formatted as 01.01.1900, but if you don't have nulls you
should be alright.

If somebody has any idea how to get around this null-problem too, I could
finally get rid of my StarOffice 5.1 installation which I'm keeping for more than a
year now just because I can't get my reports working properly in OOo.

Regards,
Achim
Back to top
View user's profile Send private message
Alex Thurgood
Power User
Power User


Joined: 07 Jan 2005
Posts: 64

PostPosted: Sat Jan 08, 2005 12:59 pm    Post subject: Reply with quote

Hi,

achimoe wrote:

With OOo version 1.1.4 the date format is correctly being put into the report
template now Smile


Yes, this was a bug in all versions from 1.1.0 to 1.1.3. It has also been fixed in the 680 development branch (future V2) in a version soon to be released.

achimoe wrote:
Unfortunately the problem with nulls is still there Sad
A null-value is being formatted as 01.01.1900, but if you don't have nulls you
should be alright.


I didn't know about this one. I suspect that this has also already been raised as a bug issue, but I can check on that.

Alex
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