jlopez_13

Hi, for months i have been trying to get arround this error. net.sf.jasperreports.engine.JRException: No results at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.runCommand(MongoDbQueryWrapper.java:214) at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.processQuery(MongoDbQueryWrapper.java:115) at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.<init>(MongoDbQueryWrapper.java:93) at com.jaspersoft.mongodb.query.MongoDbQueryExecuter.createDatasource(MongoDbQueryExecuter.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:456) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at com.jaspersoft.studio.data.reader.DatasetReader.fillReport(DatasetReader.java:264) at com.jaspersoft.studio.data.reader.DatasetReader.start(DatasetReader.java:332) at com.jaspersoft.studio.property.dataset.preview.DataPreviewTable$5.run(DataPreviewTable.java:318) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56) this is how the code looks like: {'runCommand': {'aggregate': $P{collection}, 'pipeline': [ {$match: {'$and': [ {'comapany': {'$regex': ${company}, '$optioins': 'i'}}, {'timeCreated': {'$gte': $P{bDate}, '$lte': $P{eDate}}} ]}}, {$project: { 'Z0': { $cond: [{'$not': {'$or': [{'$eq': ['$final', 'Zona 1']},{'$eq': ['$final', 'Zona 2']} ]}}, 1, 0]}, 'Z1': { $cond: [{'$and': [{'$eq': ['$final', 'Zona 1']}]}, 1, 0]}, 'Z2': { $cond: [{'$and': [{'$eq': ['$final', 'Zona 2']}]}, 1, 0]} }}, { $group: { _id: null, 'NUM_CNT':{$sum: 1}, 'CZ0': {$sum: '$Z0'}, 'CZ1': {$sum: '$Z1'}, 'CZ2': {$sum: '$Z2'} }}, {$sort: {_id: 1}} ], cursor: { } }}