thegametimemachine

I cant seem to find a "how to" on passing fields(parameters) from and to subreports. I am using ireports. Could you point me to a tutorial or document with instructions on the above? Thank you

I have a small app that handles inventory for projects. The database I am using is Mongodb. In one collection I have the following fields. _id product_code price qty location project <-- ObjectId(Holds a specific projects _id) The project schema has the following fields: _id project_num project_name manager active The report that I have now generates all of the inventory based on the first collection. Only problem now is that I would like to have the project number, name and manager on the report page header aswell. I was thinking about creating a dataset with a query to the projects collection using the projects field from the main report, but I have no where to start and I cant just use $F{project} in the query..doesnt work. If someone has some time to help me it would be greatly appreciated.. Thank you

I am trying to run the following query and I keep getting the error below. What am I doing wrong? {collectionName: 'foremanReport', findQuery:{'_id':{'$oid':'$P!{id}'}}} When I get the paramter popup in ireport i type in the id without quotes and get this error (example: 52d5759ec73fc0dc23000002) the class type of parameter is java.lang.String Error filling print... org.bson.types.ObjectId cannot be cast to java.lang.Boolean java.lang.ClassCastException: org.bson.types.ObjectId cannot be cast to java.lang.Boolean at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1270) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1233) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1577) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:149) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Print not filled. Try to use an EmptyDataSource... if I enter the parameter with quote marks I get the following error Error filling print... { collectionName: 'foremanReport', findQuery:{'_id':{'$oid':''52d5759ec73fc0dc23000002''}} } This works! But I cant manage to do it with parameters {collectionName: 'foremanReport',findQuery:{'_id':{'$oid':'52d5759ec73fc0dc23000002'}}}