How would you do this?

  • I have an application that will be saving pdf files. I have a query in my application that makes the results look nice and those results are saved in a pdf file. The application has an object that formats the results, etc. I am going to create a proc that will email those saved pdf files to a list of recipients. No problem.

    However, I might have an instance where a pdf file is not created but I still need to email the 'results' of the pdf file. Instead of sending the pdf, I need some way to get the results from the DB (not a problem) and format them in such a way that it is viewable to the recipient.

    The pdf's are a Bill Of Lading which users view in my application. I have a proc that creates all of the data to put on my BOL but what if I need to email one w/out a pdf file being saved from the app? I could also have mutiple BOL's needing to be emailed.

  • You could setup a report via reporting services using your query. From there you can have the report automatically emailed in the pdf format. I believe you can choose PDF or Excel. And if you do not want to automatically send the report, you could run the report in Reporting Services and export it to PDf or EXcel as well.

  • I'm not familiar w/ Reporting Services. Is this built in to SQLServer already? Can you direct my to where I might find out more information about this?

    Thank you

  • Reporting services is available for any version of SQL Server 2005, but the advanced features come with Standard and above.

    When you installed SQL Server 2005 Did you choose to install it? You check the SQL Server Configuartion Manager or Open IIS and see if it is a virtual directory of your default website. If not you can install it from the CD.

    More Info.

    http://www.microsoft.com/sql/technologies/reporting/default.mspx

  • ...all versions except the "plain jane" SQL Express... the SQL Express with Advanced services does have it.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • If I have it installed, how do I even access it?

    If I go to Sart/Programs/MS SQL Server I have

    Client Network Utility

    Configure SQL XML...

    EnterPrise Mgr

    Import and Export Data

    Profiler

    Query Analyzer

  • Access it the same way you would a website on the local server. Use the name in IIS to find out the exact path but you should open Internet Explorer and type in

    http://localhost/reports$DEV/Pages/Folder.aspx

    Note: you will have to replace DEV with the name that is in IIS.

  • Rog - if you have the "correct version" of SQL Serve Express installed, you should then either have something called Business Intelligence Design Studio (BIDS), or (if you already had Visual Studio 2005) new project types under Visual Studio.

    If not - then you need the "advanced Services" version of SQL Server Express...

    go here for that:

    SQL Server Express with Advanced Services

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

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