locked
Two word documents in to one report ? RRS feed

  • Question

  • Hello,

    I have  two seperate word documents.I want to create a report.

    I have a filter condition says GENDER  = "M ",then one word document should come as a report

    else, If GENDER = "F " then the second word document should come in the report.

    How can I paste the two word documents in the report.

    I am totally confused how to approad the issue.

    Can someone help me.

    Thanks

    Thursday, August 18, 2011 8:02 PM

Answers

  • Hi RajeshGutta,

    We can copy the content of one word document then pasting the content into one textbox control or other type controls. In addition, due to the render extension differences between word document and report, the format in word document will miss.

    However, we couldn’t copy the word document itself then pasting it into the report. To work around it, I would give you below suggestions.

    First, upload the two word documents into the Report Manager, then displaying the links of the two documents in the report, when click on the link, the document will be opened.

    Second, access the data in the two documents into database then use the database as the datasource of the report.

    Please refer these two relational threads:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/1e82550e-bda3-4b6f-9be3-4f25e03d51c0

    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/77ce9ff7-fd6c-4268-8541-d159f0de849d

    Hope them help you.

    Thanks,
    Sharp


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by KEROBIN Thursday, August 25, 2011 9:17 AM
    • Marked as answer by Sharp Wang Monday, August 29, 2011 8:49 AM
    Thursday, August 25, 2011 8:01 AM

All replies

  • Step 1: Insert two rectangles. Insert first word document content in first rectangle and second document content in second rectangle.

    Step 2: In the hidden property of first rectangle add below expression

               =iif(Parameters!Gender.Value = "M" ,False,True)

    Step 3: In the hidden property of second rectangle add below expression

               =iif(Parameters!Gender.Value = "F" ,False,True)

     

    Hope this will help

    Thursday, August 18, 2011 8:19 PM
  • As far as the solutin concern ,, it will not display report in word document

    however you can run this report and export to word

    which will work for u

     

    Thursday, August 18, 2011 9:10 PM
  • Hi RajeshGutta,

    We can copy the content of one word document then pasting the content into one textbox control or other type controls. In addition, due to the render extension differences between word document and report, the format in word document will miss.

    However, we couldn’t copy the word document itself then pasting it into the report. To work around it, I would give you below suggestions.

    First, upload the two word documents into the Report Manager, then displaying the links of the two documents in the report, when click on the link, the document will be opened.

    Second, access the data in the two documents into database then use the database as the datasource of the report.

    Please refer these two relational threads:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/1e82550e-bda3-4b6f-9be3-4f25e03d51c0

    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/77ce9ff7-fd6c-4268-8541-d159f0de849d

    Hope them help you.

    Thanks,
    Sharp


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by KEROBIN Thursday, August 25, 2011 9:17 AM
    • Marked as answer by Sharp Wang Monday, August 29, 2011 8:49 AM
    Thursday, August 25, 2011 8:01 AM