Export\View data from table in template

Hello.

There is a table in Word which fill in with data from CI (manually copy-past from CI to MS Word), further this document print out that the user put the signature on paper.

It is necessary that the formed the same table (like in word) with data from CI, but the data is taken automatically from CI (if this is list of CI - then for each of them on separate list)

 

 

  • I'm not so sure about your requirement, Due to my understanding, you can use join query to do the same in report. There are sample that you can check in SM help server.

    https://docs.microfocus.com/SM/9.50/Codeless/Content/database/reference/cross_table_query_two_tables.htm

  • No I need something like a report, the data in which will be taken from the device table.

    This report must be looks like my document in word - the table in which the cells will display data from the device table and some fixed text around the table and in the column headers

  • Why not a report? If this is just a part of a bigger document, you can refer to it as an appendix and do as report only the appendix.

    If report does not work out you could also access HPSM database/ws from Word using Macro.. but better would be just export from HPSM and copy to Word file,

  • Can you tell me more about report ?

    This is in SM ? then where is it ? my SM 9.31

  • HPSM 9.31 has an internal reporting tool, I think the name is SM Reports but honestly I never developed anything using it. I already saw in use but it was more for simple graphs.. I was thinking about a external reporting, like Crystal (it comes with HPSM in bundle) or any corporate reporting ... 

    if you don't have any corporate reporting tool in place it might be easier and faster fulfill it inside HPSM as you wanted .... of course it will depends on how complex is your report but if you are able to make it available inside HPSM you could at least copy the entire table for word... I would make try to make the whole report using a regular format.. you can check components and even make a nice one in HTM. check how it will shows when printing and adjust accordingly, the table for sure you will be able to do, the whole report will depends on the report characteristics.. 

  • HPSM 9.31 has an internal reporting tool, I think the name is SM Reports but honestly I never developed anything using it. I already saw in use but it was more for simple graphs.. I was thinking about a external reporting, like Crystal (it comes with HPSM in bundle) or any corporate reporting ... 

    if you don't have any corporate reporting tool in place it might be easier and faster fulfill it inside HPSM as you wanted .... of course it will depends on how complex is your report but if you are able to make it available inside HPSM you could at least copy the entire table for word... I would make try to make the whole report using a regular format.. you can check components and even make a nice one in HTM. check how it will shows when printing and adjust accordingly, the table for sure you will be able to do, the whole report will depends on the report characteristics.. 

  • I never use a report, so where can i read about this ?

     

    There is a word file where operator manually insert data (copy-past)

    templ.zip