1) Pick a format supported by your version of StarOffice (different versions support different file formats)
2) Pick a report generator that outputs the desired format(s)
3) Write the reports.
4) Run the reports
5) Import the report output into StarOffice.
That's about as concrete as I know how to get without knowing a lot about your situation.
If you can figure a way to describe exactly which release of StarOffice you've got, maybe I can figure out what formats it can import. Then again, you can always use the "Shoot low boys, they're riding Shetland Ponies" approach and use just flat text files even though they are a LOT more work to import.
The reporting tools that work with SQL Server can produce nearly any format I can imagine... They won't be your limiting factor, although cost might if you want a really strange format.
Writing the report will vary a lot depending on which reporting package you choose. There are WAY too many possibilities here than I'm willing to start to describe until you've picked both the format and the report writer.
Last edited by Pat Phelan; 10-26-04 at 08:40.
Reason: Formatting correction