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
Version: IBM Maximo for Utilities 184.108.40.206 Build 20081212-0732 DB Build V7110-172
Base Services 220.127.116.11-LA20100917-1647 Build 20100522-0325 DB Build V7117-47 HFDB Build HF7117-09
Common PMP 18.104.22.168 Build 201006041645 DB Build V7117-02
Server OS: Windows Server 2008 R2 6.1
Pinned topic I am having an issue with a Crystal Report displaying Clobs in Maximo.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-30T15:34:47Z at 2012-05-30T15:34:47Z by JAntley
JAntley 120000BGD0135 Posts
Re: I am having an issue with a Crystal Report displaying Clobs in Maximo.2012-05-30T15:34:47ZThis is the accepted answer. This is the accepted answer.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.
developerWorks Feedback Team