none
Download a report RRS feed

  • Question

  • I want to create a report where i have to connect to oracle database and generate a report based on an sql query. The end user has to input the dates for this report.
    Thursday, March 31, 2011 4:59 AM

Answers

  • Hi NewCub,

    Thanks for posting in the MSDN Forum.

    Would you please clarify whether you want to generate a Word document as a report automatic? If it is, I suggest you create a Word template solution to handle it.

    This is the steps which I will recommend you follow:

    1.      Edit the content which will never be changed in you template document.

    2.      Set a content control such as Rich text content control, Plain Text content control and Picture content control etc. in the places where you need to fill the data.

    3.      Connect to you data server and fill the data to the dataset in the ThisDocument_Startup method.

    4.      Iterate you dataset and fill the data to the specific content control in the document in ThisDocument_Startup method.

    I hope it can help you.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Bessie Zhao Friday, April 8, 2011 10:04 AM
    Friday, April 1, 2011 5:33 AM
    Moderator