AVEVA Community
AVEVA Community
  • Site
  • User
  • Site
  • Search
  • User
General
  • AVEVA World
General
Show Off Your Work! Reports....
  • Forums
  • Resources
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
  • Replies 62 replies
  • Subscribers 1 subscriber
  • Views 128 views
  • Users 0 members are here
Options
  • Share
  • More
  • Cancel
Related

Reports....

Jose Contreras
Jose Contreras over 17 years ago
 
  • Sign in to reply
  • Cancel
  • Shrivallabha Sharad Redij
    Shrivallabha Sharad Redij over 11 years ago
    [QUOTE=zero99;81222]Hi

    I am exporting the COG coordinates using a report I have created.

    Q GCOF = E 2948164.627mm N 4235361.487mm U 17759.231mm

    Can I get the E ,N & U coordinates to go in to separate columns in Excel ?
    Are you using Utilities >> Reports >> Create option for creating reports?
    q gcof[1]
    q gcof[2]
    q gcof[3]

    Or alternatively you can delimit them in Excel using Text to Columns.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Admin
    Admin over 11 years ago
    you can't stop it until you put RETURN command in the code of function running within some condition
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Sri
    Sri over 11 years ago
    WE CAN call !!pipemtoreport()
    How to stop it ?like kill_form we can do...
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • rian afrianto
    rian afrianto over 11 years ago
     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • rian afrianto
    rian afrianto over 11 years ago
    are any limit character on pdms report
    [ATTACH=CONFIG]7785[/ATTACH]

    some text report was missing ,
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Josef Geltl
    Josef Geltl over 11 years ago
    Hi to all,
    esp. to Prashant!

    I testet your Macro, and I got this Message in Commandwindow:

    ...
    (2,754)   Argument 1 to REPLACE is unset
    In line 209 of PML function pipemtoreport
          !eledesc = !eledesc.replace('#','LB')
    ......

    The created XML is corrupt.

    What is wrog there???
    Depending on PDMS-Version???
    I`ve installed 12.0.SP6

    Regards Josef!
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Shrivallabha Sharad Redij
    Shrivallabha Sharad Redij over 11 years ago
    If variable !eledesc is remaining unset then it will give you that error. Maybe dtxr (rtext of detref) is unset for some elements where this error is coming.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Bobby Nguyen
    Bobby Nguyen over 11 years ago
     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • vs
    vs over 10 years ago
    Can you please share code?
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Mehrdad
    Mehrdad over 10 years ago
    [COLOR=#417394]Hi, Dear Mr. [/COLOR]Shrivallabha[COLOR=#3e3e3e],
    [/COLOR][COLOR=#444444][FONT=Segoe UI]Unfortunately, this route "TXT_TO_EXCEL.zip"
    is broken if possible email this file for me.[/FONT][/COLOR]
    [COLOR=#444444][FONT=Segoe UI]thanks
    [email]mehrdad.lashgari1@gmail.com[/email][/FONT][/COLOR]
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
<>