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

mrongen

Members
  • Posts

    3
  • 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

Everything posted by mrongen

  1. I have requirement where in a cross-tab a not found result should be set as N/A. How can I use/setup a whenNoDataCell property in a crosstab to set this? Is this possible in Jasper iReports 5.5, or do I need to use Jaspersoft Studio? Thanks Michel
  2. I need to create a report containing data from a MS SQL database AND data from within an XML file that is stored in the same database (so it is actually a databas within a database). Is this possible using Jasper 4.7.1 and how can I do this? I have some experience writing SQL queries, but this is really difficult. My thoughts right now are to export the XML file to a directory, although I do not know how to do that using SQL. From the main report (showing data from the MS SQL database) I need to create a subreport that can handle the XML file.
  3. I have a problem with an NVL statement. The field (called COMMENTS) is a varchar2 field with a maximum of 2000 characters. NVL(COMMENTS,' ') does not work, it will return NULL. Varchar2 fields with a less maximum of characters are performing with the NVL statement as expected. I am working on Jasper 3.7.1. Please advise
×
×
  • Create New...