-
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>
-
Dynamically change max bar color
How do i make the maximum bar in a bar chart red and rest blue. Value for maximum is dynamic. Thank you
-
export association
HI is there a way to export all the association from a workarea withing teamsite using PERL/Java? I am using open deploy to sync files from one environment to another but association is not getting pushed.
-
Select only the numeric values before - in string
<div>I have a string which has numeric characters or string characters at the begining followed by -.</div> <div> </div> <div>I want to select data based on following rules</div> <div> </div> <div>A. only the numeric value </div> <div> </div> <div>B.If any string value present before - then show null\blank</div>…
-
How to know if a file ever existed in D2?
Is there another way of finding out if a file ever existed in D2 aside from the query below? We cannot find a file that were supposedly present in D2 and we want to prove/validate if the file truly existed. select * from dm_audittrail where owner_name='johndoe' AND time_stamp > DATE('01/01/2000','dd/MM/yyyy') AND…
-
dataSource JSON
<p>HI, i need read a json from rest services to generate report. I used before rest XML and all ok, but now i need use a JSON. please help me.</p> <p> </p> <p>i have a url as <span style="background-color:rgb(250,250,250);color:rgb(80,80,80);font-family:OpenSans, Helvetica, Arial, sans-serif;font-size:12px;"><a…
-
Groups Level as crossbar header
<p>Hi, I created the crosstab in figure 1, I would like the groups levels to appear as titles as in figure 2.</p> <p>it's possible?<br><br> Thanks<br><br> </p>
