[Help! no way to create data source!]

I gave up with it and uninstalled it.  then I reinstalled selecting the option to include all demos and samples.  THIS does at last give the option to add a datasource. It seems a major bug that you you cant install Jasper Server without the demos and samples.

[Help! no way to create data source!]

Hi, I am logging in with jasperAdmin. Under user management, there does not seem to be a user called superuser. I tried logging in with superuser and superuser as pass, but says account does not exist. jasperadmin is in the admin group/role. The only other roles are user and anon.

[Nested reports no longer work with studio + report server. Anyone know when it will be fixed?]

Unfortuantely, this forum system wont let me cut and paste the answer directly, but here is a link to the solution I put on stack overflow:

http://stackoverflow.com/questions/25973670/jasperserver-cant-find-sub-reports

 

[Nested reports no longer work with studio + report server. Anyone know when it will be fixed?]

thanks for the reply. Ufnortuntaely, jasper server makes no translation from file.jasper to repo:dir/file.jrxml. I had to do it all by hand - it took hours. This makes using nested subreports almost unusable

[Nested reports no longer work with studio + report server. Anyone know when it will be fixed?]

We have a report with 3 levels of sub report.  iReport + jasper server used to support this.  It used to take the reports with their references to xxx.jasper and rewrite them to repo:xxx.jrxml.

Report Studio does not do this when you deploy reports to server (5.6).

It does recognise the top level of sub reports, and does upload them as jrxml resources, but it doesnt edit the main report, and when you try and run the main report on the server, it always fails as it cant find the sub-reports.

We went through many "solutions" to this posted by people with the same problem, but they are all for older versions, and do not work on the current version. (e.g. there is no resources folder in 5.6).  E.g. we manually changed every instance of xxx.jasper to repo:/reports/report_files/xxx.jrxml in all reports, deployed the main report, then added all the sub reports jrxml files as resources using the "Add resource" link in "Controls and REsources" of the "edit" function of the main report on the server.  No luck.

Not sure what to do at this stage. Runs fine in report studio, but not possible to run on server.

[multiple subreports - deploy on Jasperserver]

jasper server 5.6 doesnt have a resources folder in teh root/repository view

[Help! no way to create data source!]

After insalling Jasper Server 5.6 (without the sample reports),and loggin in with jasperadmin, when we select view->repository, there are only two folders: System Properties and Themes.

There is no Data source folder, and no way or option to add a datasource.

 

We tried uinstalling and reinstalling, same problem.

 

Have tried googling - noone else seems to have this issue.

 

Howe do we add a datasource if there is no datasource  option or folder?

 

 

[Padding within a text field]

I have yet to find any way to get cells padded. By default, jasper studio tables contents overlap the tables borders. It looks terrible. There seems to be no way to apply any formatting to the whole table. You have to edit every cell individually. This is too much work to be any use.

[how to set table row and column heights?]

I created a table with 10 columns, and it created them with a tiny widht (22), and a huge height (30).  So it looks terrible, and takes up 3 pages instead of 1.

It seems there is no way to get the columns to spread out to fill the full width of the table.  you have to work out by hand the required witdth of each column, then set it by hand on every cell.  It takes hours.

Then comes the height.  for some reason, the jasper studio default cell height is twice as high as it should be.  To change it, requires guessing the correct height in pixels, then manually editing EVERY CELL by hand. This also takes hours.

Why on earth is ther not a table property for row height and column width?  OR at least if you select mutliple columns/rows, and edit it, it should edit them all, not just a single cell.

It is also worth mentioning that setting every cell's strech value to "relative to tallest object" has no effect.

It makes tables unsable, unless there is some magic I am missing?

[How to insert another data band?]

I have a report with something like two tables, one above the other. The problem with my report is it has only ohe column hearder, one detail band, and one colum footer. The problem is any headers for example for my saecond table always appear on top of the headers for the top section.

Is there any way In studio to add more column headers, detail bands and colum footers?  I certainly cant find anything in the GUI.

[blind - no way to debug?]

The biggest problem we have is that when the report just gives you either a blank page, or a page with only the column headers, there is no way to debug it or see why.  

 

Frequently a report which works perfectly one day, will suddenly not work the next.  The DB and SQL are fine.  

 

The only option in this case, is to start again. Generate the same report from scratch, piece by piece.

 

Jasper is missing any kind of debugging.  There is not even a log4j.properties file anywhere in the distriution, although there are posts which say there is.  WE dont even know if jasper is making it through to the DB.

 

I tried to sumbit this as a feature request in the report studio "Send feedback", but it doesnt recognise my use/password which I can use fine on this site.

[how to debug what parameters are passed to a sub report?]

I was hoping to enable some kind of debug logging with the parameters in it, but this works also. Thanks!

[passing a date parameter into a sub report not working - any ideas?]

I found the problem.

It seems you have to compile the sub report every time before you want to preview the main report.  It just uses an old version without warning.

[how just to list the data returned by SQL?]

I have a long report which shows a lot of KPIs with columns for today, yesterday, last month, year to date etc.

Each is a sub report which returns one row with all the required KPIs for the given period, e.g,

registrations	deposits	games
3	1	23

There are about 30 of these KPIs (i.e. 30 column headers in the sub reports)

The report will look like this:

 

kpi	today	yesterday	this month	last month	this year
registrations	3	4	19	42	333
deposits	1	1	12	13	111
etc
etc

The problem is In the sub report.  i have to explicitly create a field for each KPI, then explicitly create a text box going down the page for each field.

Is there no way to simply list the data which comes back from the query going down the page?  I know there is a table component, but this only works if you ahve a single query which returns multiple rows, I have mutliple queries whcih return a single row each.

Any ideas?

[Jaspersoft Studio - Expression Editor - yesterday date]

DAY(DATERANGE("DAY-1").getStart())

does not work (at least with JS 5.6 on windows)

It gives the error "java.lang.ClassCastException: java.lang.Integer cannot be case to java.util.Date

[getting yesterdays date, last months dates etc.]

Also, yesterday variable express gives "The operator - is undefined for the argument types(s) Date, int.

I have no idea how you got this to work - my version of jasper studio (5.6) has none of the date options that your code seems to have

[getting yesterdays date, last months dates etc.]

I tried using your examples, but when I put the same parameters into my project, I get this error: "The operator || is undefined for the argument type(s) of void, void"

Any ideas?

[how to debug what parameters are passed to a sub report?]

If I run sub reports on their own, they work. If I call them from a main report, passing in the same parameters, I get zero values.

Is there any possible way to see what parameters either the main report is passing to each sub report, or, even better, to see what parameters the sub report is using in its queries?

I notice that report studio has no log4j.properties anywhere in its installation dirs.

[Help! cant get hello world sub reports to work - always get "Document is empty"]

The main report has a data source, but does not have any of its own queries, it only gets data from sub reports.

The workaround to fix this bug is to create a dummy querey (I use "select 1"), then it works.  Shame you cant have a main report which just has sub-reports.

[java.lang.ClassNotFoundException: com.mysql.jdbc.Driver]

In the end, I downloaded the MSI installer from oracle, then used 7-zip to extract the Jar. I tried installing the msi, but couldnot find where it puts the jar, so gave up with that one and uninstalled it.

[passing a date parameter into a sub report not working - any ideas?]

I have a subreport which I want to re-use 5 times on the main report, just passing in different date ranges (today, yesterday, lst month etc).

The sub report takes 2 java.util.date parameters.  If I run the sub report on its own, either using the prompt for option and chosing dates, or entering TODAY( ) in the "Default Vlue Expression", the sub report shows the correct values.

Now if I call the sub reports from the main report, passing to them the same expression (e.g. TODAY( )), I get all zeros back in all the sub reports.

In the Mail report I have this:

<detail>

<band height="340" splitType="Stretch">

<subreport runToBottom="true">

<reportElement x="80" y="0" width="80" height="200" uuid="7cd92266-e1d4-4394-a58a-67430889f229"/>

<subreportParameter name="P_FROM">

<subreportParameterExpression><![CDATA[TODAY( )]]></subreportParameterExpression>

</subreportParameter>

<subreportParameter name="P_TO">

<subreportParameterExpression><![CDATA[TODAY( )]]></subreportParameterExpression>

</subreportParameter>

<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

<subreportExpression><![CDATA["dashboard/dash-slice.jasper"]]></subreportExpression>

</subreport>

<subreport>

<reportElement x="160" y="0" width="80" height="200" uuid="de0997be-7f4d-4ee7-8b70-8636fe152b05"/>

<subreportParameter name="P_FROM">

<subreportParameterExpression><![CDATA[EDATE(NOW( ),-1)]]></subreportParameterExpression>

</subreportParameter>

<subreportParameter name="P_TO">

<subreportParameterExpression><![CDATA[new Date()]]></subreportParameterExpression>

</subreportParameter>

<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

<subreportExpression><![CDATA["dashboard/dash-slice.jasper"]]></subreportExpression>

</subreport>

</band>

</detail>

 

This should pass the parametes into the sub report. but I notice there is no way to define the type of the parameters going in - are they converted to strings or simlar?   Is this the problem perhaps?

 

In the sub report, the parameters are defined like this:

 

<parameter name="P_FROM" class="java.util.Date">

<parameterDescription><![CDATA[]]></parameterDescription>

<defaultValueExpression><![CDATA[TODAY( )]]></defaultValueExpression>

</parameter>

<parameter name="P_TO" class="java.util.Date">

<parameterDescription><![CDATA[]]></parameterDescription>

<defaultValueExpression><![CDATA[TODAY( )]]></defaultValueExpression>

</parameter>

 

In the SQL, I have something like this:

 

<queryString language="SQL">

<![CDATA[select * from

(select count(p.id) as registrations

from players p

where date(p.creationTime) BETWEEN $P{P_FROM} AND $P{P_TO}

 

[Help, cant post, saying Your submission has triggered the spam filter and will not be accepted.]

I was basically this post: https://community.jaspersoft.com/questions/842742/date-parameters-and-mysql-not-giving-correct-results 

In the end I had to remove about 1/3 of the post, which included more examples of SQL which I was trying.

[Date parameters and mysql not giving correct results.]

I tried today() instead of now() - same result. Its producing date for approx the last 7 days, not today.

[Date parameters and mysql not giving correct results.]

I also tried 

select count(p.id) as registrations 

from playeraccount p 

where date(p.creationTime) BETWEEN $P{from} AND $P{to}

 

and 

 

select count(p.id) as registrations 

from playeraccount p 

where p.creationTime BETWEEN $P{from} AND $P{to}

Etc.  all return the same incorrect result.

[Date parameters and mysql not giving correct results.]

If I use the following SQL direclty against my DB to query for a range of dates (not times, just the dates):

 

select count(p.id) as registrations

from playeraccount p

where date(p.creationTime) >= current_date 

  and date(p.creationTime) <= current_date 

  

it returns say 1, i.e there was 1 registration today. 

 

Now I turn this into a jasper report. 

 

I add the following SQL:

 

select count(p.id) as registrations 

from playeraccount p 

where date(p.creationTime) >= $P{from} and date(p.creationTime) <= $P{to}

 

And in my report, I create 2 new parameters of type java.util.date, and set the expression for both to "new Date()".

 

When I run the report, the result I get is 18, not 1! 

 

18 is not the total registrations (which is about 2000), nor is it the number of registrations since yesterday (which is about 10), it is seemingly a random number.

 

The problem could be java dates also include the time, I only want the date part. 

 

I also tried this: 

 

select count(p.id) as registrations 

from playeraccount p 

where date(p.creationTime) >= date($P{from}) and date(p.creationTime) <= date($P{to})

 

etc. 

 

ALL return incorrect values. 

 

1) is there any way to see what parameters are actually being sent to the DB (which I have no admin access to)? 

2) any other ideas how to restrict to a date (not time) range? I have tried all the examples I can find, and they are all wrong - i.e are not filtering between the two desired dates, but between some other values which are different. I also tried making the parameters prompt, and selecting todays dates on the calendar widget, but this gives the same garbage result.