locked
Use Report Stored on Database (office integration Pack) RRS feed

  • Question

  • Hi, 

    I have these code working fine, but i would like to retrieve word from a table on my database, like this:

    Me.DataWorkspace.IMCRM.ReportsTableSet.FirstOrDefault().Fichero

    Fichero is Binary Data and also there are a field named Name

    Working now: (Anyone can modify these lines to retrieve Binary, put in stream and use in these example?)

    Dim mydocs = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)
               Dim WordFile As String
               'Dim pdffile As String
     
               Dim nombre As String = Me.PresupuestosCabeceraSet.Nombre
     
     
               WordFile = mydocs & "\PlantillaSoftware.docx"
              
               If File.Exists(WordFile) Then
    

    Monday, August 18, 2014 10:38 PM

Answers

  • Working now: (Anyone can modify these lines to retrieve Binary, put in stream and use in these example?)

    For this issue, I think we need retrieve binary data from database first, and store and fetch binary data into a file, then use the Office Integration Pack Extension for LightSwitch.

    Resource:

    How to store and fetch binary data into a file stream

     the Office Integration Pack Extension for LightSwitch

    Please let me know if there is anything that I can do to help.

    Best Regards

    Angie


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Angie Xu Tuesday, September 2, 2014 2:48 AM
    Monday, August 25, 2014 1:00 PM

All replies

  • Hi, can anyone help me to solve these question?
    Wednesday, August 20, 2014 12:21 AM
  • Hi, anyone can help me?

    Monday, August 25, 2014 9:44 AM
  • Working now: (Anyone can modify these lines to retrieve Binary, put in stream and use in these example?)

    For this issue, I think we need retrieve binary data from database first, and store and fetch binary data into a file, then use the Office Integration Pack Extension for LightSwitch.

    Resource:

    How to store and fetch binary data into a file stream

     the Office Integration Pack Extension for LightSwitch

    Please let me know if there is anything that I can do to help.

    Best Regards

    Angie


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Angie Xu Tuesday, September 2, 2014 2:48 AM
    Monday, August 25, 2014 1:00 PM