Jump to content
We've recently updated our Privacy Statement, available here ×

marciokoko

Members
  • Posts

    19
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by marciokoko

  1. Hi guys,

    Ive been working on some reports on iReportDesigner for Jasper Server.  I have a couple of questions:

    1) How do I add commas to my numbers, so that they dont just look like a long string of numbers?

    2) When I create a crosstab, how can I order Descending by value instead of just alphabetically by category name?

     

    Thx in advance

  2. Ok I opened up the report again and I clicked on Read Fields, this time it did display both name fields, I checked.  But it wont import them to the report designer because it turns out both name and id are duplicate fields, so I get a duplicate fields error, for now, for the id field.  I guess the same thing will happen for the name field once i resolve the id duplicate. 

    My question is, how do i resolve that duplicate issue?

  3. I created a simple xls file with 4 rows:

    1 - year

    2 - clientname

    3 - invoice

    4 - value

    I create a crosstab placing the year in rows, the clientname in columns and value in data.  When I try to preview it I get this error:

    Error filling print... Error incrementing crosstab dataset
    Warning:  Property storage name for 5 is empty - setting to Root Entry...and some jaspereports.engine.fill lines

  4. I ran the installer for JasperServer and everything finished just fine.  I have saved jrxml reports into my jasperserver repo and can view them on my ipad thru safari.

    However, when I direct the JasperMobile iOS app to:

    myIP:8080/jasperserver/login.html

    I get an invalid response.  I read on a post that it has to go to

    myIP:8080/jasperserver/

    but when I do that I get an http401 unauthorized user.  My settings are:

    Name: MyCompany

    URL:myIP:8080/jasperserver/

    Organization: SomeName
    Username: jasperadmin
    Password: jasperadmin
  5. Im working with iReport and Ive connected to the db of openERP.

    I already pulled data from the invoices table, but it contains a partner_id which is the client name.  I need to get the client name from the res_partner table.  So i think I have to use a join, right?  So I did this:

    select * from account_invoice JOIN res_partner ON account_invoice.partner_id = res_partner.id

    The problem is that I am not getting the res_partner.name field available from the left pane to drag over to the report designer view.  I only get the account_invoice.partnerid which is no good to me.

    If I do select * from res_partner, the res_partner.name field is there, but I need the data joined to the invoices table.

    What am I doing wrong?

  6. I have an existing openerp installation with data.

     

    Upon installing jasper server I'm asked if I want to use bundled or existing tomcat.  I have no idea if I have a tomcat installation or not.  I have openerp 6.1 but don't know if tomcat got installed automatically or not.  What option should I choose.

    I'm also asked is out PostgreSQL.  I know my openerp client runs on port 8069.  I found the programfiles/OpenERP 6.12xxxxyyyzzz/PostgreSQL/bin which is where vacuum and pg_restore are, but psql is not in there so when I select the bin folder I get an error saying the binaries are not there.

     

    can someone help me out please.

×
×
  • Create New...