Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: SQL Server - how to generate document readable in StarOffice

    Can anybody please answer this :

    From SQL Server, how to generate a text document which can be read in StarOffice Writer ??
    SQL Server may call another application to do it, but how ?
    I have no clue -- please help.

    Note: The text document should NOT be an MS Word document.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What exactly do you want? An application to produce text files from a query? A schedulable task to copy a table or tables to a flat text file? Something to produce a script for an entire database?

    Your needs aren't defined very well, at least as far as I can tell.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    It's an application. I want to generate a report to be readable in StarOffice.

    Thanks in advance.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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.

    -PatP

  5. #5
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    Thanks.
    I thought of that already ... but what's the concrete techniques ??

    Note that on the user's PC, there is no MS Office running but only StarOffice.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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.

    -PatP
    Last edited by Pat Phelan; 10-26-04 at 08:40. Reason: Formatting correction

  7. #7
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    It is StarOffice version 7. Thanks.

  8. #8
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    Is there anybody knowledgeable enough to answer my question ??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •