nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Converting Actuate reports to BIRT trouble

amw2326

Hi all, I am working on converting some Actuate reports to BIRT. The one I am asking about in particular updates the database from the report. In Actuate the report runs a database query, then in onRead it sets up some variables (for example prefix, suffix, wonumber, etc). Then in the Fetch method it calls a custom method, updateDB(prefix,suffix,wonumber). The updateDB method then sets up a connection, sets a string for the update, and closes the connection. I am trying to recreate this in BIRT. I am not sure the best way to go about this. Any ideas/suggestions? Any help would be much appreciated. Happy Holidays!

Find more posts tagged with

Comments

wwilliams

Well the first gotcha is that you want to make sure no one is able to export from the viewer. (Or code it not to update based on output) The report actually runs again, say if a user chooses to export to a pdf the report is re-run. There is a section in the V7.5 report development guide "Miscellaneous Features" Database Update Functionality

micajblock

What exactly does this update do? In other words what are you trying to accomplish with this database update? BTW, are you aware you can run the Actuate Reports in Maximo 7.5 using ERI and purchasing Actuate BIRT? <a data-ipb='nomediaparse' href='http://developer.actuate.com/deployment-center/integrating-birt-into-applications/birt-with-maximo/'>http://developer.actuate.com/deployment-center/integrating-birt-into-applications/birt-with-maximo/</a>

amw2326

Thank you both for your responses! I found them both useful.

amw2326

WWilliams, I am curious about your solutions for the exporting report issue with reports that insert. Do you know how to remove the export report icon for specific reports? What exactly do you mean by '[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]code it not to update based on output'? [/color] [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Any help you could give in this situation would be helpful. Thanks![/color]

wwilliams

I don't know how to remove the export ICON for specific reports, but worth looking into.>What exactly do you mean by '[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]code it not to update based on output'? [/color][color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]With some help from the smarter Williams, Michael I came up with this in my before factory[/color] if(reportContext.getHttpServletRequest().getAttribute("attributeBean").format != "html" ){ 
reportContext.getDesignHandle().findElement("mainSet").drop(); 
flag = 1; 
} 
} mainSet is the name I gave the table.If the user attempts to export, they will get a blank report with the text "This report cannot be exported"Seems to do the job.

amw2326

Thanks so much for this! I will try it now:) Also just a heads up, I found the ToolbarFragment.jsp where the icon is located, but removing that would mean removing it from all of the reports, and I'm not sure that's what the client is looking for. I also haven't tested it to be sure it would work either.. Just for your reference! It's located in maximo, in a jar file called com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar. Thanks again!