1 2 Previous Next 15 Replies Latest reply: Nov 13, 2012 3:32 AM by 623708 Go to original post RSS
      • 15. Re: Show image on report
        623708
        Hey there Garcol,

        The proplem here is that somehow apex demands your image 'blob column attributes' on the report to have the same TABLE.ID as the TABLE.ID in colmn selected in the report query.
        In this report the ID from XXX_WEDSTRIJDEN is used and in the report attribute for the image the ID from XXX_CLUBS is used. This looks to me like a bug or am i missing something here.

        The workaround / solution is to create a view XXX_V_WEDSTRIJDEN where we join te XXX_WEDSTRIJDEN and the XXX_CLUBS and inlcude all report attributes including the image attributes needed. Te view uses 1 unique ID.
        Now we can use this view XXX_V_WEDSTRIJDEN in both the report query and the 'blob clomn attributes' as the base table.

        Regards,

        Swa

        Edited by: Swarudi on Nov 13, 2012 1:31 AM
        1 2 Previous Next