Hello,
I had a report in 8104 that would show me a list of all my active reports with the distribution list. Now when i moved the report to 8204 the tables aren't joined the same.

In 8104 BOTDIST and BOTADDR could be joined on DistList = IBFSID

in 8204 that is no longer the case.

Below is my fex file to pull the report I want. I am not getting any results in 8204. The highlighted text isn't working anymore.

JOIN
BOTSCHED.BOTSCHED.SCHEDULEID IN BOTSCHED TO MULTIPLE BOTSIT.BOTSIT.SCHEDULEID
IN BOTSIT TAG J4 AS J4
END
JOIN
BOTSCHED.BOTSCHED.SCHEDULEID IN BOTSCHED TO MULTIPLE BOTDIST.BOTDIST.SCHEDULEID
IN BOTDIST TAG J5 AS J5
END
JOIN
 [COLOR:RED]LEFT_OUTER J5.BOTDIST.DISTLIST IN BOTSCHED TO MULTIPLE BOTADDR.BOTADDR.IBFSID[/COLOR]
IN BOTADDR TAG J7 AS J7
END
JOIN
J7.BOTADDR.ADDRBOOKID IN BOTSCHED TO MULTIPLE BOTDEST.BOTDEST.ADDRBOOKID
IN BOTDEST TAG J8 AS J8
END
DEFINE FILE BOTSCHED
DISTLIST2/A800V=
IF J8.BOTDEST.DESTFN EQ ''
THEN J5.BOTDIST.DISTLIST
ELSE J8.BOTDEST.DESTFN;
emaillist/A800V=
IF J5.BOTDIST.DISTLIST CONTAINS '@' OR 'marten' OR '.csv' OR '.html'
THEN J5.BOTDIST.DISTLIST
ELSE J8.BOTDEST.DESTFN;
END

TABLE FILE BOTSCHED
PRINT
     J4.BOTSIT.RUNEVERY AS 'RUN EVERY'
     J4.BOTSIT.INTERVALTYPE AS 'INTERVAL TYPE'
     J4.BOTSIT.WEEKDAYS AS 'WEEK DAYS'
     J5.BOTDIST.MAILFROM AS 'MAIL FROM'
     J5.BOTDIST.MAILSUBJECT AS 'MAIL SUBJECT'
    J8.BOTDEST.DESTFN
     COMPUTE EMAILLIST/A800V = IF J5.BOTDIST.DISTLIST CONTAINS '@' OR 'marten' OR '.csv' OR '.html' OR '.xls' OR '.xlsx' THEN J5.BOTDIST.DISTLIST ELSE J8.BOTDEST.DESTFN; AS 'DISTRIBUTION'
BY  LOWEST BOTSCHED.BOTSCHED.JOBDESC AS 'REPORT NAME'
ON TABLE SUBHEAD
"Webfocus Reports with Distribution List"
"&DATEtrMDYY <+0> "
" "
WHERE ( BOTSCHED.BOTSCHED.ACTIVE EQ 'Y' );  

This message has been edited. Last edited by: FP Mod Chuck,

Kelly

I have reproduced what you are seeing on my environment it works in 8.1.05 but not is 8.2.04. I think you need to open a case with techsupport to find out why.

I tried the code in my 8202M environment and it does not work either.

*Edit:
It didn't work for me because the code above is missing the END statement. Once I added that in (and removed the [COLOR:RED] & [/COLOR] tags), it works in my 8202M

This message has been edited. Last edited by: Hallway,

Didn't work for me in 8.2.04 until I added the synonym for BOTSIT and added LEFT_OUTER to the join to BOTDEST as I don't have any address books in RC.

But then works OK - 8.2.04 Gen 08172018

T

I had do the stuff Hallway mentioned in 8.2.04 but adding that last LEFT_OUTER join to BOTDEST made it work for me as well

The report will run if I add the LEFT_OUTER join to BOTDEST. however, i'm not getting the addresses in the address book then still.

I did create an issue with tech support but am not getting much help. Because it isn't documented they are having a hard time answering my questions.

sorry i didn't respond earlier i was out of the office.

Here are the results of my report.

REPORT NAME RUN EVERY INTERVAL TYPE WEEK DAYS MAIL FROM MAIL SUBJECT DESTFN DISTRIBUTION
Chart1 1 D 1111111 "Administrator" Chart1 . bus@localhost.com

And it shows the address under the DISTRIBUTION column not sure why it won't work for you. I am on release 8.2.04