Post reply

Print/Format Help

  • October 27, 2006 at 7:29 am

    #170855

    Hi All,

    I have what I thought would be a fairly simple request to handle, but it's turned into a nightmare.  I've created a web report from a query  using sp_makewebtask and it came out nice.  Now the customer would rather have the report emailed.  No problem I thought, so I figured I'd use osql to generate the output.  Ugly output for sure.   So is there a way to format the output to make it look more presentable?

     

    Thanks,

    Dale

  • October 30, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 30, 2006 at 4:04 pm

    #668879

    BOL recommends you use SQLCMD instead of OSQL.

    I guess it depends what kind of formatting you are after. Looks like SQLCMD has some options available.

    Any chance you can output it to a CSV file so it can be opened in Excel?

    Hopefully this sparks something for you

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • October 30, 2006 at 4:12 pm

    #668881

    I looked at sqlcmd as an option, but the customer won't allow me to install the app. Ideally, I'd like to just be able to format using osql and email directly, rather than creating a csv file.

    Thanks,

    Dale

  • October 30, 2006 at 4:23 pm

    #668883

    I take it then that you are running this remotely from the server where sqlcmd would be installed by default - presuming that you are running SQL Server 2005.

    Not sure what your output looks like so it's a bit hard to make any suggestions that could be of real value.

    Personally, with the restrictions you have, I'd be looking to capture the output then re-present it somehow.

    Perhaps you can impress on your customer the need for a little flexibility in order to help you satisfy their requests.

    Sorry I'm not able to be more helpful. Good luck!

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • October 30, 2006 at 4:29 pm

    #668885

    I'm running SQL 2000 and it would require a download and install to run sqlcmd.  I'll post the output tomorrow from osql and maybe you can offer some expertise?

    Thanks,

    Dale

  • October 30, 2006 at 6:51 pm

    #668910

    so, when you download tomorrow you might post in an SQL 2000 forum with a new thread.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • October 31, 2006 at 7:43 am

    #668968

    Sorry about that.  Didn't mean to post to the wrong forum.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply