Getting text attachments on SQL reports

[bkg73123]

Hello,

Our JDE Support personnel can't find a way to get text attachments from within JDE to print out on a specialized report through SQL.

We desperately need to be able to print out routers with their text attachments on a specialized report.
Is this possible?

It has been nearly a year and we cannot figure it out.


So I have a router with a line entry on it and labor hours.
That line entry has a text attachment.
I need the report to look like this:

Work Center----------Oper Seq#----------Description----------Run Labor----------Run Machine----------Setup Labor
999----------------------1----------------------Desc / Comment----------5.25

***CORRESPONDING TEXT ATTACHMENT PRINTS HERE***

(Repeat for next router entry)

Thank you,
B

 

[Alex_Pastuhov]

Have you looked at our One Attachment Manager software?

 

[Larry_Jones]

B,

you didn't share your JDE version or your database config. Both of which have an impact on my answer to you. So I'll take a shot in the dark and assume you are Oracle DB with 8.9 or higher version of JDE.

The answer to your question can be extracted from this Post from the Crystal forum.

<edit>
More background information can be found here

 

[Larry_Jones]

One more comment . . . why in the world use direct SQL for reporting???
There are better tools available.

 

[Adrian_Chimirel]

1 You may create a E1 report that reads all the text attachments you like and writes every one of them into a custom detail table, using a 2000 character string field
2 Later, the report writes into another custom header table things like totals, dates, bla bla bla, and
3 finally create a SQL trigger on the header table's Insert to execute your SQL report
PS Of course you can complicate things further, but, as dr. Larry asked

why not printing all the things you need using the E1 RDA?