Topic
  • 1 reply
  • Latest Post - ‏2012-05-30T15:34:47Z by JAntley
JulieTarbert
JulieTarbert
1 Post

Pinned topic I am having an issue with a Crystal Report displaying Clobs in Maximo.

‏2012-05-29T23:37:16Z |
The main report is written off a command object with SR being the main table.
I have a subreport against the COMMLOG table linked to the main report where sr.ticketuid = commlog.ownerid
The subreport is showing CREATEDATE, SENDTO, CC, BCC, SUBJECT and MESSAGE.
In Crystal, they all look correct.
After putting the report into Maximo, the following fields do not show up (not even the text boxes that are associated with them):
SENDTO, CC, BCC, MESSAGE
The only thing we can find in common are that all 4 fields are Clobs.
Seems that even if there is something preventing Clobs from showing up on Crystal reports that are ran out of Maximo, the text boxes should still appear.

Any help you can give me will be greatly appreciated?

We are on Maximo 7.117
Weblogic 10.0.2.0
Version: IBM Maximo for Utilities 7.1.0.0 Build 20081212-0732 DB Build V7110-172
Base Services 7.1.1.7-LA20100917-1647 Build 20100522-0325 DB Build V7117-47 HFDB Build HF7117-09
Common PMP 7.1.1.7 Build 201006041645 DB Build V7117-02
Server OS: Windows Server 2008 R2 6.1
Updated on 2012-05-30T15:34:47Z at 2012-05-30T15:34:47Z by JAntley
  • JAntley
    JAntley
    136 Posts

    Re: I am having an issue with a Crystal Report displaying Clobs in Maximo.

    ‏2012-05-30T15:34:47Z  
    Hello Julie,

    The forum where you have posted your questions is primarily for those who have questions about using the developerWorks site itself. There is an active forum for Maximo here; you would have a better chance of getting the answers you want if you were to post there: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1119

    Let us know if we can be of additional assistance.

    Regards,
    Jeff Antley
    developerWorks Feedback Team