millernegro

Using JExcelApiExporter I can password protect an excel generated file from being edited . But a simple copy/paste from all the cells in excel file to another excel file, takes a perfect copy of it and the copy is obviously not password protected, so a simple save using the same filename of the original file creates a (possible) changed file. is there a way to create this password protected excel file, with it having all cells in it protected from being copy/paste (if they cannot even be selected would be better) using JExcelApiExporter or any alternative ? thanks

here is an example using your json (see attachment) of the query, see the FIELDS part, and the report generated. for some reason that i dont know, if the field has a NAME but has no description (or a description different than the name) it prints as null. so when create the field, set the name (path of properties in the json), the type and set the description with the same value of the name

in the "report query" you have selected SQL as query language, use "json"

yes, it is not automatic, it doesn´t "read" the fields (like when you a sql query) add the fields manually to the "FIELDS" list in the "TREE INSPECTOR" panel (right click - add) the fields will appear at the bottom, on the right side it shows parameters send from "outside" the report. check in the samples folder, there is jsondatasource example with the ireport download.

whats an example of the JSOnData you will use ? basically you add the fields and ignora that message, for example a json: {records:[{id:int, description:string},{id:int, description:string},.........,{id:int, description:string}]} in the "report query" you will add the property that contains the data (above example "record") then manually go to the FIELDS option in the tree selector and add the fields ("id" and "description" in the above example, with the correct datatypes and description) then just drag and drop those fields into the report and generate sample

Hello, im new with jasper and ireport, but so far I could get a report exported to PDF using JsonDataSource coming from a file with JSON data in it. Now what im tryying to do is get the same report filled with Json data coming as a String, is there any example or pointers to help me achieve this ? In particular, I have a PHP application working, and using JavaBridge i get to connect jasper to it using JDBC or XML, I have all my querys working in the PHP application, what im trying to get is using the results of the PHP queries (that pop up as Json Strings) as input for the report, so i dont have to write my whole queries twice (one for reports and the same ones to display on the Web). Thanks

when using datasource dont read the fields automatically i get that error shown. just add the fields manually in the datasource. and in the top part you put the property of the json that you need to get into to reach the fields

when downloading jasperreports-4.5.0 (not ireports) you can check a sample at /demo/samples/jsondatasource im also new and trying to find out about jsondatasource i can't seem to find much, but APPARENTLY expression in json would be the property in the json body where you'd get the information you will show, APPARENTLY