BIRT Exchange Forum: birtprofi - Viewing Profile

Jump to content


 

No Latest Open Poll.

birtprofi's Profile User Rating: -----

birtprofi's Photo
Reputation: 0 Neutral
Group:
Members
Active Posts:
128(0.12 per day)
Most Active In:
Designing BIRT Reports (128 posts)
Joined:
22-July 10
Profile Views:
3617
Last Active:
User is offline May 16 2013 01:12 AM
Currently:
Offline
Icon   birtprofi has not set their status

  1. About Me
  2. Posts
  3. Blog
  4. Devshare
  5. Awards

Topics I've Started

  1. Problem with SQL message: ARITHABORT

    Posted 16 May 2013

    Hi guys I need your help. If I run the SQL Script below I get the following error within BIRT Report Designer:


    Quote

    Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
    SQL error #1:SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
    ;
    com.microsoft.sqlserver.jdbc.SQLServerException: SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
    )


    But this error-message is only within the BIRT-Designer. I tried to run the SQL Script on MSSQL Server 2008 and there I get no error.

    This is a test-script:
    create table tmp (col1 varchar(100), col2 varchar(100));
insert into tmp values ('1121',    'abc');
insert into tmp values ('1123',    'aee');
insert into tmp values ('1335',    'afg');
insert into tmp values ('1121',    'def');
insert into tmp values ('1121',    'abc');

SELECT 
distinct r.col1,
       STUFF((SELECT distinct ','+ a.col2
               FROM tmp a
             WHERE r.col1 = a.col1
            FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 1, ''),
       (select COUNT(*) cnt from tmp a where r.col1 = a.col1) cnt
 FROM tmp r


    If you run this script or something like this in the management console of SQL Server you got this result:
    1121 abc,def 3
    1123 aee 1
    1335 afg 1

    But if you run the same script in the Report Designer in a Dataset you get the error message as shown above. Please give me your advice what I can do.

    Best Regards
    Rafael

  2. javascript onclick with button

    Posted 14 Jan 2013

    Hi guys,

    I have a problem to run a javascript within a birt report. Please take a look to the following site:
    http://jsfiddle.net/...profi/3jrkA/17/

    If I press the "Save Data" Button, then I get the values of the checkboxes, that have been changed. You could try on yourselv if you press "run" and then "Save Data" Button (please dont press update).

    Now I am trying to do the same within a birt report. See attached report (sample database)

    I add 2 text html fields. Checkbox field and a "Save Data" Button. The report should run only as html. For testing purposes I insert "alert();" at the end of my function loopForm. So please take a look to these 2 html-text fields.

    Please help me. How I have to insert the function, that the script would work. Maybe you could change this report. Thanks a lot for your help.

    Best Regards
    Rafael

  3. Cross Tab Formatting

    Posted 23 Jul 2012

    Attached File  Cross-Tab.PNG (16.3K)
    Number of downloads: 0Hi guys,

    I have a problem with formatting my Cross-Tab Cell. I use the following script to highlight Saturday and Sunday with a bold line.

    if( cellInst.getCellID() == 4703)
	{
var linie = reportContext.evaluate("dimension['dayofweek']['Day Of Week']");
if (linie == 1)
{
cellInst.getStyle().borderRightStyle = "solid";
cellInst.getStyle().borderRightWidth = "medium";
cellInst.getStyle().borderRightColor = "black";
}
}


    My horizontal dimension is a date field and I get day 1-7 for each week. My CellID 4703 is the summarize cell. If I have data in a summarize field, the border line is displayed. But if the datafield is empty, there is no borderline. Look at the example.

    What I have to do, that my script also print the line, if the data field is empty?

    Best Regards
    Rafael

My Information

Member Title:
Senior Member
Age:
32 years old
Birthday:
July 21, 1980

Contact Information

E-mail:
Click here to e-mail me

Comments

birtprofi has no profile comments yet. Why not say hello?