-
Editing Export Filename with parameters from Dataset
<p>Hello everyone, i've made a report that uses a dataset in wich, among the others, there are the "name" and "surname" fields. I wish that when i clicked on "export" it would automatically give me the filename "reportNameSurname.whatever". I just want name and surname to be added to the export filename of this particular…
-
Sorting X group based on Month
<p>Hi ,</p> <p> I tried to sort x-axis grouping by month . when Y-optional category used to form stack sort is not working Screen shot is mentioned in attached document. If we remove Y-optional category sorting is working fine. But we required Y-optional category as well. Please suggest any change required.</p> <p> </p>…
-
Variables on the On Create() event is not giving correct results
<p>Hi Team,</p> <p> </p> <p>I have attached the sample report where i have a Table nested inside the List. I want to show the Table total individually at the Table Footer and also the Grand Total (which is the List total) at the end of the report. I am using report variables to the get the values fetched in the data…
-
Taskspace workflow xform not translated
Hello all, I am trying to modify an old application implemented on Taskspace 6.5, to add a new step onto an workflow and I have the following scenario: - i opened the workflow template with Process Builder to edit it - i added the new step and i attached it with a form created in Forms Builder - i installed the form and…
-
Display of multiple parameters.
<p>Good morning!</p> <p> </p> <p>I have an issue with the display of multiple parameters.</p> <p>I am using mblock’s report design for reference (“InClauseTestâ€): I have</p> <pre class="_prettyXprint"> HR_APPOINTMENT.C_COURT IN ('****') </pre> <p>in my DataSet and</p> <pre class="_prettyXprint"> this.queryText =…
-
Conditional Highlighting from OnCreate Scripted Data
<p>I have a report with 3 datasets. The first data set [dataSet] gets the list of active employees. The other two datasets [avail_hours & labor_hours] use the list of employees from [dataSet] to get either the number of hours they were available [avail_hours] and the number of hours they recorded [labor_hours]. I use an…
-
How to write PL/SQL anonymous block in BIRT?
<p>Hi,</p> <p> </p> <div style="color:rgb(0,0,0);font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:16px;"> <div style="margin:0in 0in .0001pt;font-size:12pt;">I need the solution for declaring the pl/sql statement and i want to get the output from this declare statement in…
-
How to error out/fail reports in iHub?
<p>Hello BIRT Guru's,</p> <p>I want to error out the report for particular condition like when we don't have data or based on some flag.</p> <p>We are running batch reports and we don't want to post blank/empty reports to customers. </p> <p> </p> <p>Hence i want to know if i can error out reports based on particular…
-
Single colored line displayed for SVG output in pie chart
<p>Hi,</p> <p> </p> <p>In SVG output of BIRT pie chart there is a single colored line displayed for zero values, using color of the last item with zero value. See screenshot for a better idea.</p> <p> </p> <p> </p> <p>I replaced the zero values with null which removes them from pie chart, including colored line and keeps…
-
Dynamic Columns in a table
<p>Hello<br><br> I am running Eclipse Mars.1 with BIRT 4.5.0.<br><br> I need a table with a dynamic number of columns.<br> The table should look like the following table<br><br><span style="font-family:'courier new', courier, monospace;"> Plans used Element(1) Element(2) ...... Element(6)<br> <br> Plan 1 no - - 1 10 2…
-
dmi_queue_item
Hello, we have a client that uses Documentum and recently complained that the database is too big (1 terabyte). We have already set a job to clean the dm_audittrail table. I analyzed the tables in the database and I realized that the main responsibility for the database size is the dmi_queue_item (about 49.5% from the…
-
Java handler does not change vlaue
<p>Hi !</p> <p>Ive been searching for a while before posting.</p> <p> </p> <p>The issue im experiancing -</p> <p> </p> <p>I created a report through the eclipse plugin, and i have a data cell thats taken from the DB.</p> <p> </p> <p>The db can contain RTF format, so i created a java project and created a class that extends…
-
Jython scripting - performSearch setMaximumMatches to value greater than 5000
Hi, (using Collab 8.2 & jython script) I'm searching bmo a jython script for a specific type of objects (base on a specific ctd), if I set the parameter "setMaximumMatches" to 6000 to get all results ("performSearch.setMaximumMatches(6000)" ), i always get 5000 results back. I know for sure that there are more than 5000 of…
-
Sorting X group based on Month
<p>Hi ,</p> <p> I tried to sort x-axis grouping by month . when Y-optional category used to form stack sort is not working Screen shot is mentioned in attached document. If we remove Y-optional category sorting is working fine. But we required Y-optional category as well. Please suggest any change required.</p> <p> </p>…
-
Show all the dimensions in BIRT
<p>Hi All,</p> <p> Need a help in designing BIRT report. I am very much new to BIRT. Basically we have Groups(Dimensions) information which are Region Names from Region 1 to 10.Some of those do not have any values.</p> <p> </p> <p>Currently report shows only regions which have values but not empty ones. Also, how to show…
-
Using JQuery to toggle between two report variables
<p>I am trying to toggle between two report variables. The variables are basically two data rows; one will be a substr containing the first 15 to 20 characters, and the word "...more" will be appended, the other will be the data row with no character limit restrictions and the word "...less" will be appended. </p> <p> </p>…
-
Re-Configuring Delivery Stage
Hi, We have two nodes (cmsliv1 & cmsliv2) for Delivery Stage and installed under shared fileSystem. So, both Node's Config Agents are using same configurations from shared. I saw the Config Agent' configuration on Config Console, it pointed to Node1 (cmsliv1) only. If CA is not running on cmsliv1 then we are getting…
-
Style for Charts / NewReportItemTheme
<p>Hello,</p> <p>i've got a problem with creating a style for my charts.</p> <p>In this tutorial: https://www.youtube.com/watch?v=1exDwCCEnTY</p> <p>it ist made with a "NewReportItemTheme" but in my version of BIRT i can not find this.</p> <p> </p> <p>In my library there are themes and when i click on new theme, there…
-
Extending eclipse BIRT
<div>Summary:User is a non-technical person and doesn't know how to write sql/nosql queries.My idea is to provide some kind of interface where he feeds the dataset into eclipse BIRT and gets query predictions which he/she can use to obtain desired results. </div> <div> </div> <div>1]Consider a large dataset say 1 million…
-
Make file appear before folder in a directory in iHub
<p>Hi, I have been following this forum since past few months and it is a great place to exchange ideas.</p> <p>Recently I have a scenario where I was asked by a user to keep the report design file at the very top level( in his home folder) so he could run the report on demand soon after he visits his home folder.</p>…
-
tempobox login
Hi we recently installed tempobox on a complex environment. The tempobox server is sitting in a DMZ and the Content Server box is sitting out of the DMZ. after configuring tempobox I am prompted to login if i click on the following link <https://OpenText_AppWorks_Gateway:port>/webaccess however when i login the page is…
-
Join 3 datasource results
<p>Hi,</p> <p> </p> <p>I want to create consolidated report in which Status 1 (Datasource 1), Status 2 (Datasource 2), Status 3 (Datasource 3).</p> <p> </p> <p>I have created 3 separate queries for the same. But want to show the consolidated result of all 3 Status in one report. So, created joint data-set. But, don't…
-
How to call Channel MetaData fields in Navigation (channelNavRenderer.xsl)
Hi, We want to show Custom Value coming from ChannelMetaData on Navigation. Currently channelName Value is appearing on Navigation Tree / Breadcrumb and these are controlling by channelNavRenderer.xsl. The ChannelMetaData Bean name is "navName", Instead of channelName we want to display this value. Kindly please help me on…
-
Problems after installing R&D for Lifesciences
I had installed Q&M for LifeSciences and it was working, but I have Installed in the same application server the module R&D and now I can`t authenticate with any user except dmadmin c.e.d.d.a.InjectSessionAspect[ ] : {} com.documentum.fc.common.DfException: Se ha producido un error en la autenticación para el usuario…
-
Unable to Edit Channel from Preview Site
Hi All, Some channels we are not able to edit from Preview Site. However If I cloned the same channel then I can Edit. we are using Channel MetaData & Channel Localized MetaData. Attached Screenshot, kindly please help to fix this issue. Thanks Jayaram
-
how to set action for option showing in context menu
how to set action for option showing in context menu... when i right click context menu appears but when i click on any option like properties , checkout etc nothing happens. <dmfx:actionmultiselectcheckbox value='false' cssclass='doclistcheckbox'> <dmf:argument name='objectId' datafield='r_object_id'/> <dmf:argument…
-
Create a pie chart with 4 variables as source
<p>Hey Birt Communtiy,<br> </p> <p>I hope my english is not so bad.</p> <p> </p> <p>My problem:</p> <p> </p> <p>I have a datas with with an Id. This Id show me the state of a maschine (on, off, stanby, service).</p> <p>I add the time from every state to certain variable.</p> <p>Now I need to represent this 4 Variables in a…
-
How to display only a part of table which is drilled down in one file
<p>I made report with <strong>4 graphs</strong> as a Dashboard. Is there a possibility to <strong>drill down</strong> to detailed set of data but with displaying only a <strong>specific part of table</strong>, not the whole table?</p> <p>It works with drill-through, but unfortunately BIRT report for SuccessFactors…
-
Unable to use Sample RSSE example
<p>I've been attempting to get this up and running for about a week now with no avail. I downloaded the example RSSE (the non-OTDS version) from somewhere under Resources, and read the Integrating Applications into BIRT iHub manual to attempt to get it working. When I try to log into the information console using one of…
-
How to configure Sub list in rows
<p>Hi </p> <p> </p> <p>How can i have a sub list in the Birt .</p> <p> </p> <p>Please see the attached doc what i exactly want</p> <p> </p> <p>Alternatives are welcomed.</p> <p> </p> <p> </p> <p>Please help.....</p>