Inquiry Screen Custom Fields Missing on Export

SUGGESTED

I added a new column to an inquiry screen. Since the field is from a table not included in the inquiry, I used SPE code to populate the field in the inquiry.  This works fine, but when I export it via Excel, that field isn't populated.  Does anybody know why? Is there a better way to do this other than using SPE code?

Parents
  • 0
    SUGGESTED

    Which label are you using? Did you replace the LECTURE label, as the LECTURE label is called during the export. I have used this in all my SPE and it works fine for both the screen and the export (remember to use columns on your file if you looping over large datasets), something like this:

    $LECTURE

    Gosub LECTURE From CNS*****

    [V]GPE = 1

    # MY CODE HERE

    Return

Reply
  • 0
    SUGGESTED

    Which label are you using? Did you replace the LECTURE label, as the LECTURE label is called during the export. I have used this in all my SPE and it works fine for both the screen and the export (remember to use columns on your file if you looping over large datasets), something like this:

    $LECTURE

    Gosub LECTURE From CNS*****

    [V]GPE = 1

    # MY CODE HERE

    Return

Children
  • 0 in reply to Regard Hulsbos

    Hi Regard, 

    I am using the LECTURE Label as you described a head but I the field showed blank in Excel Global Export.

    $LECTURE
    If !clalev([M:NAT2]) Then
    End
    Endif
    Local Integer I

    Gosub LECTURE From CNSNATSTD
    GPE = 1

    #My spe
    For I = 0 To [M:NAT2]NBLIG-1
    [M:NAT2]ZGACC(I) = [M:NAT2]ACC(I)-"-"-func AFNC.TEXTRA('GACCOUNT', 'DESTRA', [M:NAT1]LED,[M:NAT2]ACC(I) )

    Next
    Affzo [M:NAT2]ZGACC
    Return

    It works fine on the screen, but to export it globally it's showen as blanks

    Thank you for your help

  • 0 in reply to boullaij

    As MARCOW wrote, the error is here:

    For I = 0 To [M:NAT2]NBLIG-1

    it should be 

    For I = 0 To NOL

    and it works fine also in the global export

    Regards,