rmarut
-
Posts
4 -
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 rmarut
-
-
Hi, I've been battling with this the last few days. My report (with parameters)
executes perfectly in iReport Designer. When I deploy the report to Jasper
Server, configure the Input Controls, the prompt appears but the report returns
only 'The Report is Empty'.
I have a simple query like this:
{
'collectionName':'rpt3',
'findFields':{'Component':1,'Feature':1,'possible':1,'value':1},
'findQueryRegEx':{'Component':'/^$P!{COMPONENT}/'}
}
Created Parameter COMPONENT with class java.Lang.String and default value
$F{Component}
Example record created for collection 'rpt3':
db.rpt3.save({"Component" : "Certificate", "Feature" :
"Process.Certificate.X509.Generate.SignitureAlgorithm", "Possible": 2, "value" :
["MD5"]});
In Jasper Server I have defined the Input Controls as:
Always prompt is checked
Type: Single Value
Prompt Text: Component
Parameter Name: COMPONENT
Mandatory and Visible are checked
The Data Type is defined as:
Type: Text
Name: test
ResourceID: test
Are the Input Controls defined correctly?
Is there something else to configure to run this report on Jasper Server?
I´m using:
Jasperreports Server 4.5.0
MongoDB connector for iReport 0.14
JasperSoft iReport Designer 4.5.0
MongoDB 2.1.1
I attached the jrxml report. The report runs perfectly on iReport. Can anyone
help me figure out how to configure this report to run on Jasper Server?
I would be grateful for any assistance.
Renea
Post Edited by rmarut at 06/14/2012 12:36 -
I will throw this question to the forum
With MongoDB connector - the report (attached) runs in ireport
but the table is not interactive, i.e. I cannot sort columns
Is there an additional configuration that is missing?
The sample 'Table Component Blog Example.jrmx' with JDBC Connector
appears to create an interactive table -- without making any changes..
Any assistance would be appreciated.
Thank you
Tried exporting as html and xhtml.
attached the html file exported from my test
Code: db.shiraz.save( { "ServiceType" : "sms", "ServiceHealthState" : "ok", "DocumentID" : "11" } )db.shiraz.save( { "ServiceType" : "sms", "ServiceHealthState" : "ok", "DocumentID" : "12" } )db.shiraz.save( { "ServiceType" : "sms", "ServiceHealthState" : "ko", "DocumentID" : "13" } )db.shiraz.save( { "ServiceType" : "jms", "ServiceHealthState" : "critical", "DocumentID" : "21" } )db.shiraz.save( { "ServiceType" : "jms", "ServiceHealthState" : "critical", "DocumentID" : "22" } )
Post Edited by rmarut at 05/23/2012 21:08
-
Hi,
I have MongoDB shell 2.1.1
I have a Collection with elements Things, Value, List: where List is an N+ Array
of Strings, i.e.
"Things" : "Function", "Value" : "Element", "List" : ["loc1", "loc2","loc3]
simple to sum List by key: Things, Value on mongodb shell:
db.report.find().forEach( function(feature) { print(feature.feature + " " +
feature.value + " " + feature.processes.length); });
returns:
{ "result" : [{
"_id" : {
"Things" : "Function",
"value" : "Element" },
"List" : 3}, ],
"ok" : 1
}
I have not been able to execute this from ireports.
This is the MapReduce function I am executing:
{
'collectionName' : 'report',
},
'mapReduce' : {
'map' : 'function () {
emit ({thing:this.Things,val:this.Value}, {count : this.List});
}',
'reduce' : 'function (key, values) {
var total = 0;
for (index i = 0; i < values.length; i++){
total += values[i}.List;;
}
return {total : values[i}.List;}
}',
'out' : 'totalList'
}
}
returns:
_id.Things_____id.Value_____List
Function_________Element___loc1,loc2,loc3
Please tell me how I can return a count of List and not the values of List.
Can anyone assist??
Post Edited by rmarut at 05/17/2012 18:35
How to configure MongoDB report (with parameters) when deployed to server?
in Products
Posted
The examples I have found (for reports with parameter deployed to Jasper Server) use
a different data source than mongoDB.
I tried modifying the Input Controls to use single value query.
I added this query (SQL):
{ runCommand: {
aggregate : "rpt3",
pipeline : [
{ $group : { _id : "$Component" } }
] } }
to return distinct Component values from prompt.
I specified the data source (MongoDB)
This returns:
Error Message
net.sf.jasperreports.engine.JRRuntimeException: Parameter "REPORT_CONNECTION" does
not exist.
I am not sure where I should be specifying the report connection parameter..?
This is a report that takes a String input parameter and returns values based on
that parameter.
The report executes in iReport designer - but I am not able to configure
the report to run on the server.
Can anyone help?