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; } } }

Populatind report library elements using DEAPI from beforeFactory method

actuser9 · 2013-09-05T18:08:28+00:00

Hi, I am trying to get the elements from the report library into the report using the deapi in the beforeFactory method of the report. My report library has the following elements. - An empty grid with two rows. - Line Chart - Bar Chart Using the before factory…

actuser9

Hi, I am trying to get the elements from the report library into the report using the deapi in the beforeFactory method of the report. My report library has the following elements.- An empty grid with two rows.- Line Chart- Bar Chart Using the before factory method, I would like to get the grid and place the line chart and bar chart in each of the rows. Any inputs are highly appreciated. Thanks,UY

Find more posts tagged with

Comments

micajblock

Maybe this will help. <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/1495-dynamic-content-from-library'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/1495-dynamic-content-from-library</a>

actuser9

Hi mblock, Thanks for the quick response. I have been using the same code to acheive what I am looking for. In the example, the report library has the grid along with the charts which is being populated. Basically for my reporting need, I need to get the empty layout(for instance, a grid with two rows) from the report library and then add the two charts to it in the beforeFactoy code. Any help is appreciated.

micajblock

Sorry, I am not sure how. Maybe someone with more DEAPI experience than I will help.

actuser9

Hi, Is it possible with DEAPI? or DE API only allows creating new elements on the fly and does not allow to use the elements from the report library? Please clarify.

micajblock

The BD Pro UI uses the DEAPI for everything. So if it possible to do something in the UI it is possible in code. Q

actuser9

Thank you. That is my understanding too. Appreacite any help with this.

actuser9

Hi, I have been going through the design engine documentation to find the classes that would be useful in populating the report library elements and would be able to edit the report library elements in the before factory code. Not much luck with this. A simple trial is to get the grid with two empty rows from the report library and be able to add new content into the empty rows of the grid. Any suggestions?

micajblock

I am not sure the exact code but below is a code snippet of a java program that adds a data item to a table cell, hope this points you in the right direction. <div><pre class="_prettyXprint">// table detailRowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 );CellHandle mydatacell = (CellHandle) tabledetail.getCells( ).get( 0 );DataItemHandle data = designFactory.newDataItem( "data_1" );data.setResultSetColumn( "MyCol1");mydatacell.getContent( ).add( data ); </pre></div>

actuser9

Thank you mblock.

I have tried to add a label to the grid cell as in the report attached below. Works fine since the label is created as a new element. And then extending it, I am using a chart with in the report body to be placed in the grid cell which fails. Error log shown as "The parent element "mychart" is not the top-level report item in components."

Any ideas? The report is attached for your reference.

micajblock

Can you explain in words the business case? Why are you trying to do this?

actuser9

Hi, I am glad I got that to work based on your post and JasonW. Thank a lot!!! Now lot more to do with the parameter implementation. The business case is user wants to choose the custom layout. The layout can be anything like grid with two rows, grid with two columns and gris with two rows and two columns etc., And user would also choose the report content(available in the report library) that should be part of these grid cells. The layouts(grids) and reports(chart/tables) will be part of the report library which have to be populated from the beforefactory code based on layout/reports as parameters.<pre class="_prettyXprint _lang-js">var libhandle = reportContext.getDesignHandle().getLibrary("Development_Library");var elementFactory = reportContext.getDesignHandle().getElementFactory( ); if ( libhandle != null ){ //adding the layout to the report grid = libhandle.findElement("TwoQuadrantHorizontal"); //get row1 of the layout var row1 = grid.getRows( ).get( 0 ); var cell1 = row1.getCells( ).get( 0 ); //get row2 of the layout var row2 = grid.getRows( ).get( 1 ); var cell2 = row2.getCells( ).get( 0 ); //add chart1 to the grid from the report library var Row1 = elementFactory.newElementFrom(libhandle.findElement("NewTable"), "1" ); //add chart2 to the grid from the report library var Row2 = elementFactory.newElementFrom(libhandle.findElement("NewChart"), "2" ); cell1.getContent( ).add( Row1 ); cell2.getContent( ).add( Row2 ); var grid1 = elementFactory.newElementFrom(grid, "Grid1"); reportContext.getDesignHandle().getBody().add( grid1 );} </pre>

actuser9

If you think of better way of doing this, please let me know.

micajblock

UY,I know that the member apaine has built this exact application (including UI). Maybe you can message him and he can give you some tips. Or even better use his services so you do not need to re-invent the wheel.

actuser9

Wow...so good to hear. Thank you!

apaine

Regarding your code, I would put it in onPrepare rather than beforeFactory. If you have it in onPrepare you can then put other code in the onPrepare script of your library elements to dynamically configure them before they are generated.Also, I recommend writing as a Java event handler rather than javascript as you can quickly find the quantity of code you need is difficult to manage and debug in javascript.<div> </div>Getting this sort of code working is pretty easy. The challenge is building a flexible, reusable framework that can be used for different types of content. e.g., what if you want to adjust the size of the components so that one of them spans two columns? The application I built is a rich framework of UI components to let users configure custom reports via a web interface. Users drag and drop prebuilt library components from a palette to build new designs. They can resize them, change component settings, choose master pages, choose themes etc before saving the result either as metadata to create the report or as the finished report itself. There are 100s of hours of work in building such a framework and we could help save you a lot of work if you want to use our help to get started. Andrew

actuser9

Hi Andrew, Thanks for throwing some light on this and providing valuable inputs. I agree with you on the below and suggested the same to my team. But then, we would want to visualize the output right away via report rather than the java program.<blockquote class="ipsBlockquote"> Also, I recommend writing as a Java event handler rather than javascript as you can quickly find the quantity of code you need is difficult to manage and debug in javascript.</blockquote>