[Replace default Jasperserver CE 4.0 login.html image (the one with pigtail stew) with custom logo]

Right click the default2 folder in the repository tree and select "Set as Active Theme" this dosn't appear if it's alread set as the active theme.

 

Also you don't have to download and install all the files as the new theme. just the ones you have changed. so in my theme folder I have the new logo in the Images directory, a new theme.css and PageSpecific.css and thats about it

Finally, this forum is purely for help regarding creating jrxml report file. there is a forum for asking questions about JasperReports Server here:

http://jasperforge.org/projects/jasperserver/forum/

Post Edited by baggypants at 03/18/2011 10:23

[Linux != Windows?]

it could be down to having slightly diferent font renderers or fonts on  each system.

 

Have a look at this page and maybe try forcing your own fonts

http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/

[How to merge the row]

If you use the CrossTab element it will you do this for you.

[Invalid credentials supplied. Could not login to JasperReports Server.]

the login password isn't the MySQL password, it's jasperadmin again.

[Help on using iReport variables]

If things are in headers then you do have to play around with the evaluation time. Maybe Try setting the evaluation time to "Page" or "Auto"

[DATES - Oracle Database]

I just split the date into component parts using a view

<Dimension type="TimeDimension" name="Period">
    <Hierarchy name="" hasAll="true" primaryKey="ID">
      <View alias="TIMEVIEW">
        <SQL dialect="generic">
          <![CDATA[sELECT
TRANSACTIONS.ID AS ID,
EXTRACT(YEAR FROM TRANSACTIONS.TRANS_DATE) AS YEAR,
EXTRACT(MONTH FROM TRANSACTIONS.TRANS_DATE) AS MONTH,
EXTRACT(DAY FROM TRANSACTIONS.TRANS_DATE) AS DAY
FROM TRANSACTIONS]]>
        </SQL>
      </View>
      <Level name="YEAR" column="YEAR" type="String" uniqueMembers="true" levelType="TimeYears">
      </Level>
      <Level name="MONTH" column="MONTH" type="String" uniqueMembers="false" levelType="TimeMonths">
      </Level>
      <Level name="DAY" column="DAY" type="String" uniqueMembers="false" levelType="TimeDays">
      </Level>
    </Hierarchy>
  </Dimension>

[Conditional Formatting]

I find it's down to type casting. by putting the 1 in quotes you're trying to say it's a String when you want it to be a number. Try either not having any quotes at all or casting it properly with

$F {Filed_Name}.equals(new BigDecimal(1))

or

$F {Filed_Name}.equals(new Integer(1))

[Help on using iReport variables]

In iReport for nearly every visible element there is as "Print When Expression" property, you could have something in  there using something like

( $V{currentPage}.equals(new BigDecimal(1)) || $V{currentPage}.equals($V{pages}) ? new Boolean("False") : new Boolean("True")  )

Or Something

[if then else]

try using

$F{YTD}.intValue().equals( new Integer( 0 ))

as the test

[PHP + SOAP client + JasperReports Server 4.0 - Need help implementing]

Have you read this?

 

http://jasperforge.org/espdocs/docsbrowse.php?id=74&type=docs&group_id=112&fid=305

[Combining jasper server with another reporting site]

Have a read of this

 

http://jasperforge.org/espdocs/docsbrowse.php?id=74&type=docs&group_id=112&fid=305

[Issue in displaying image]

This may help. Worked for me on an Oracle DB

 

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=14215

Post Edited by baggypants at 02/24/2011 23:40

[Crosstab design advices needed]

Employee, Locations and Cost should all be additional row groups, not measures.

Or you could try concatenating them into one row group but you'd lose the column formatting.

Post Edited by baggypants at 02/24/2011 23:22

[LoggedInUserRoles How I Got It Working in JasperReports Server 4.0]

The advice on using Roles in JasperReports that I've found is cryptic and fragmented so I'm writing here how I got it working.

 

In JasperServer 3.5 what I would do is create a parameter in the report which used com.jaspersoft.jasperserver.api.metadata.user.domain.Role)($P{LoggedInUser}.getRoles().toArray()[1])).getRoleName()

Which did work but was difficult and cumbersome to use. The main step change is that in JasperReports Server 4 the LoggedInUserRole parameter isn't in the report jrxml, It's in the Input Control.

You need to create either a "Single select Query" or "Multi select Query" which links to a parameter in the jrxml.

At the Query stage you generate a statement somthing like

SELECT column FROM table WHERE $X{IN, column, LoggedInUserRole}

If we unpack this a little the $X{} part is an input control for the query. It will be expanded at runtime into

column IN('ROLE_USER','CUSTOM_ROLE_1','CUSTOM_ROLE_n')

as long as the ROLEs you have created match what is in column then you should see them appear in the Input Control when you run the query.

If you change the query or what roles are assigned to the user you need to Log out of JasperReports Server each time as the server appears to cache the results.

[JasperReports Sever 4 CE repository on Oracle10g]

found the answer over here

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=83889#84090

stop tomcat and delete <tomcat>/conf/Catalina/localhost/{web-app-name}.xml

restart and it's all good.

Top Drawer.

[JasperReports Sever 4 CE repository on Oracle10g]

Here are the full log files from an attempted start with the changes made above in case anyone stumbles on this thead and can make sense of them.

[how to generate reports in a single JRXML]

Easiest way to do it is by using the List and table componants, each object can have its own query and be effective as embedded sub-reports.

[Reports in ZIP File?]

I Think when you generate the report initially it generates it in some complicated internal XML format which is stored either in MySQL or in memory or somewhere. Then this raw report is then transformed to be either the HTML or the PDF, XLS , etc on demand which dosn't take long at all.I don't think it re-runs the report for every export type.

[Reports in ZIP File?]

helyair is talking about something completely different to what you want.

I don't think user reports can be generated encapsulated in a zip ad they're generated in memory not on the filesystem.

[JasperReports Sever 4 CE repository on Oracle10g]

I thought I had this pinned down from doing it with version 3.5 and 3.7 but I've not.

I've used the handily provided DDL files in the buildomatic folder to create the relevent tables in user jasperdb40 on a local server 192.168.2.203

I've edited META-INF/context.xml to

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="jasperdb40" password="password"
        driverClassName="oracle.jdbc.driver.OracleDriver"
        url="jdbc:oracle:thin:@192.168.2.203:1521:ORCL" />

I'e altered META-INF/jasperserver-DS-jdbc.xml to

  <jdbc-driver-params>
    <url>jdbc:oracle:thin:@192.168.2.203:1521:ORCL</url>
    <driver-name>oracle.jdbc.driver.OracleDriver</driver-name>
    <properties>
      <property>
        <name>user</name>
        <value>jasperdb</value>
      </property>
    </properties>
    <password-encrypted>password</password-encrypted>
  </jdbc-driver-params>

I've changed WEBINF/hibernate.properties to

metadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

and edited js.jdbc.properties to

metadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

metadata.jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
metadata.jdbc.url=jdbc:oracle:thin:@192.168.2.203:1521:ORCL
metadata.jdbc.username=jasperdb40
metadata.jdbc.password=password

and yet in the apache stdout_<date> .log I still get things like

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

and

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

when I stat the MySQL database it all sets going like nothing has changed, even though I've deleted work\Catelina multiple times.

 

what do you think? What did I miss?

[Theming JasperReport Server 4.0.0]

the the JasperReports repository there is a folder called Themes. There are two folders in it and you can download them as a zip file using the context menu. In these are a bunch of CSS files and an images foldler. Changes to these will alter the theme which you can then zip back up again and upload the the server.

 

[JasperReport Server 4.0 and Input Parameters of DATE Format]

this may make no difference at all but all my parameters use java.util.Date or java sql.timestamp but never java.sql.date

Actually this

new java.sql.Date(new java.util.Date().getTime()) 

 

would make more sense as a timestamp surely? i.e.

 

new java.sql.Timestamp((new java.util.Date()).getTime())

 

[JasperReports Server 4.0.0 Release Available!]

Still not gone with the XHTML web renderer? thats a little dissapointing, but the rest of it is all good stuff.

[JasperReports Server 4.0.0 Release Available!]

Thank you, Downloading now! I'm looking forward to this.

[Cascading control]

If it's a single select list then use $P{parameter}

$X{} is specificaly for multi select lists.