-
display one Measure for all dimensions sequentially in Cross Tab
<p>Hello,</p> <p> </p> <p>I need to display Sum of remittances for each currency then count of remittance for each currency</p> <p>as in attached samle :</p> <p> </p> <p>Any Suggestions please</p> <p> </p> <p>Thanks in advance.</p> <p>Dina</p>
-
BIRT Studio Groups On Different Levels
<p>I am new to BIRT Studio, so I apologize if this is an easy question. When I run a report in Studio and group on more than one column, I see the values of the groups columns displayed on different line levels.</p> <p> </p> <p>I am expecting to see</p> <p>ID1 Name1 Address1 Tract1</p> <p> Tract2</p> <p>etc...</p> <p> </p>…
-
Get Publish date of Edtion via java
Hi Guys, How can I get access to publish date of an edition via java. I need to locate edition via publish date. Any help is greatly appreciated, thanks?
-
IRM 5.1 SP2-Copy groups and polcies from one instance to another
I have a couple of queries on IRM 5.1 SP2 We have 2 a few instances on same database of IRM 51 SP2 and have groups and policies already set up .We wanted to create a new instance and replicate all the objects of another instance * Is it possible to copy the Groups and Policies from one instance (X) to another instance (Y)…
-
How to use cross tan inside the table
<p>Hi Team,</p> <p> </p> <p>I am new to BIRT Report. I have to display the vendors based on response of particular project. I thought of using crosstab inside the table. </p> <p>Attached the sample for reference.</p> <p>Please advice.</p>
-
xCP and D2 coexistance
Good afternoon, Has someone integrated xCP and D2 in the same repository and handled documents with them? xCP can adopt types adding it's layer of aspects but I'm not sure if this will interfere with D2 and it's processing ( I believe it adds it's own aspects). Regards
-
How to add style to hyperlink for aggregation element
<p>Hi ,how to add style "border-radius" to "aggregation" element which has hyperlink. In adding style we can add border- top, bottom ,left, right. but not border-radius. How can i add border-radius property? And i want to remove underline for hyperlink. Need to add custom style on hover? </p>
-
HTML button that calls beforeOpen() DataSet method
<p>Hi everyone,</p> <p> </p> <p>Im building a report that has some textboxes filters in it. Initially the report is created without any filter. My idea is that when the user clicks on a button, the filters are applied with the Textboxes that he filled and the Query is changed to have those "wheres". The concept that i am…
-
Inserting data into temporary table
<p>Hello there, probably not the right place to put this question but I didn`t know were else to put it.</p> <p> </p> <p>I`m trying to insert data into a temporary table from more than one select statement.</p> <p>So I have 4 fields which can hold a month as a 3 character entry and another 4 fields which hold values for…
-
Datadesign report parameters with BIRT reports
<p>I'd like to control how much data is returned with a BDO. Say we use ClassicModels as an example. As the "modeler". I'd like to force a where clause filter on CUSTOMERNAME that would be chosen by the user. How would I go about doing that and working with the BDO in Analytics Designer? I tried a parameter but I can't…
-
Dynamically change Meter chart scale and regions according column value
<p>Hi Team,</p> <p> </p> <p>I am creating meter chart using BIRT ,i want to change the meter regions value according fetched column value and also change scale according fetch column value+30%of that same column value ,this is actually meter structure and needle will show the another column value in the above mentioned…
-
Page Token definitions
I'm trying to setup two new Page Tokens to do their magic in TeamSite Preview. But for the life of me I can't find the right config file to change (plus a build) to get them to be recognized. Has anyone ever done it? To get this to work in our runtime environment I updated this file…
-
BIRT_ROOT div tag ID - how to change it
<p>I have developed a number of reports that are to be displayed on a JSP using JQuery for a tabbed page for multiple reports. When I pull one report into the page, everything works fine because there is just one report with a tag ID of "__BIRT_ROOT". However, when I open 2 or more reports, it corrupts them all because…
-
Perplexing issue between BRDPro and iHub with a report design
<p>Hi, all!</p> <p>I've run into an issue that has me tearing my hair out trying to find what the problem is (and I don't know if I'm even looking in the right place to solve it).....</p> <p> </p> <p>In my report, I am pulling a datetime in from the DB that is in UTC format, and we have a JS file that converts to local…
-
Cascading parameter always gets an empty first value
<p>Hello guys,</p> <p> </p> <p>I'm new to BIRT reporting and I'm having some problems, maybe you can help me out.</p> <p> </p> <p>I have two cascading parameters, each one being a list box.</p> <p>The first one is an ID I am selecting and the the second one can be a list of values (an array) that are linked to the first…
-
Display superscript * or # along with the data values
<p>Hi,</p> <p>i have got a requirement from customer that need to display * or # based on some condition when display the output.</p> <p> </p> <p>Eg: output field</p> <p> </p> <p> If product name is active then use * , if product name is inactive then use #.</p> <p> </p> Product ID Product Name 1 P1* 3 P2# 4 P2* <p> </p>…
-
Parameter needs to contain, not equal, user input.
<p>I have a 12 digit asset tag that starts with a series of zeroes, like so:</p> <p> </p> <p>000000039182</p> <p>000900458283</p> <p>000003957178</p> <p>etc.</p> <p> </p> <p>I've got my asset tag parameter working so that if the user enter in the whole number (including leading zeroes), the report will only show data for…
-
Set of metadata properties (creator) of PDF report
<div>Hi,</div> <div> </div> <div>I have problem with metadata of created PDF.</div> <div> </div> <div>In properties of this PDF file are metadata like Title, Author, .. these properties I can change.</div> * via report itself, or * by code: <div> <pre class="_prettyXprint"> /* ('design' is instance of…
-
BIRT report viewer progress bar disappears
<p>Hi All,</p> <p> </p> <p>In my birt report , I am fetching data from database and also from web service, but when user selects long date range , for exact 5 minutes progress bar appears and after 5 minutes progress bar disappears, though there are no exceptions in logs.</p> <p> </p> <p>But as progress bar disappears…
-
Inherited white space in crosstab
<p>Hi, I am just looking for some advice for where to look at whats causing my whitespace issue. I have highlighted (yellow) in the image attached the whitespace I am talking about. This is a crosstab and I have checked the "height" settings of each cell. The most right and bottom cell has empty "height" and all the other…
-
Table date horizontal,not vertical .
<p>hello everybody</p> <p>I am new in Birt and I want to display data horizontal,not vertical .<br><br> attach example File</p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p>
-
Using parameters - report results are outside the given range selected (time)
<p>I am not a SQL expert , and I am an absolute beginner with BIRT so please bear with me.</p> <p> </p> <p>I am trying to write a report where the user can input a given time range, and the result will show data from a postgres database within those times.</p> <p> </p> <p>I'm using parameters for the user input.</p>…
-
Transposing Date Rows to Columns
<p>I am trying to find any resources I can for turning a single date column into multiple columns based on unique dates. (a parameter will decide how many unique dates show up in the dataset)<br><br> I have attached an xlsx file (
-
Add Blank Pages in BIRT Report based on Total Pages
<p>Hi,</p> <p> </p> <p>I have a requirement for having blank pages (includes only Header & Footer) in report based on total number of pages.</p> <p> </p> <p><span style="color:#000000;">Number of report-pages must be able to be divided of 4; which means that the report will include 0 to 3 pages based on total page…
-
Export to Excel , dateTime has format tt.MM.jjjj HH:mm
<p>Hello there,</p> <p> </p> <p>I have a report with some columns of type DateTime. When i export this report to Excel, the excel shows up a error message that there is a Format problem. After further investigation, we have observed that there is a style set in the report as following.</p> <p> </p> <p><NumberFormat…
-
java.lang.NullPointerException
<div> <p>Hi,</p> <p> </p> <p>I'm using scripted dataset in beforeOpen() method.</p> <pre class="_prettyXprint _lang-sql"> var query=''; if(params["cmbMedium"].value !== "ALL" ) { query= " AND MEDIUM.MEDIUM_ID ='"+params["cmbMedium"].value+"'"; } if(params["cmbUsers"].value[0] != "ALL" ) { query= query+" AND…
-
Expanding all containers in a DCR
We are working on inserting a content in TinyMCE through javascript during onSave event. But as some of the containers are collapsed, it is giving error. So we want to expand all the containers and then insert content. Does anyone know any javascript function to expand all the items in a single go?. we have tried with…
-
Suppress duplicates is suppressing data on all rows after group by.
<p>Hi </p> <p> </p> <p>Please find the attached Sample report. I have three columns namely 'col1', 'col2' and 'col3'. I have applied Group By on 'col1' and 'col2'. Also applied "Suppress Duplicates" on 'col2'. As you can see in the attached report that it is suppressing all data under 'col2' for other Groups of 'col1'…
-
different Performance between eclipse.exe and tomcat 7
<p>Hi everybody,</p> <p> </p> <p>I need your suggestions or ideas.</p> <p> </p> <p>We have build a cross tab report with dynamic background colors. The reports works very well.</p> <p>If we run the report directly from eclipse designer as web viewer, then the report run very fast.</p> <p> </p> <p>If we start the same…
-
Display / Hide Crosstabs by Report Parameters
<p>Hi,</p> <p> </p> <p>I have made different crosstabs in a report. I want to display only crosstab which is selected by report parameter. </p> <p> </p> <p>Any solution please?</p>