Stimulsoft Business Intelligence System | Forum

Code: Select all

if (!queryStr.isEmpty()) {
                            StiJsonDatabase stiJsonDatabase = ((StiJsonDatabase) stiDatabaseCollection.get(0));
                            stiJsonDatabase.setEmbeddedData(queryStr);
                            stiJsonDatabase.setJsonData(queryStr);

                        }

Code: Select all

 
if (!queryStr.isEmpty()) {
                            StiJsonDatabase stiJsonDatabase = ((StiJsonDatabase) stiDatabaseCollection.get(0));
                            stiJsonDatabase.setPathData(null);
                            stiJsonDatabase.setEmbeddedData(queryStr);
                        }

Code: Select all

StiWebDesigerHandler handler = new StiWebDesigerHandler() {
            //Occurred on loading webdesinger. Must return edited StiReport
            public StiReport getEditedReport(HttpServletRequest request) {
                try {
//                StiReport report = StiSerializeManager.deserializeReport(new FileInputStream(reportPath));
                    StiReport report = reportPath == "" ? StiReport.newInstance() : StiSerializeManager.deserializeReport(new FileInputStream(reportPath));
                    if (reportName == "") {
                        report.setReportName( request.getParameter("report").replace(".mrt",""));
                        RequestContext requestContext = new RequestContext(request, response);
						//json format data
                        String qryStr = JsonUtils.objectToJson(request.getAttribute("reportJsonReturn"), requestContext.getMessage("date_format"));
                        StiJsonDatabase jsonDatabase = new StiJsonDatabase("json");
						//set json data source
                        jsonDatabase.setEmbeddedData(qryStr);
                        report.getDictionary().getDatabases().add(jsonDatabase);
                    } 
                    return report;
                } catch (Exception e) {
                    e.printStackTrace();
                }
                return null;
            }

            //Occurred on opening StiReport. Method intended for populate report data.
            public void onOpenReportTemplate(StiReport report, HttpServletRequest request) {
            }

            //Occurred on new StiReport. Method intended for populate report data.
            public void onNewReportTemplate(StiReport report, HttpServletRequest request) {
            }

            //Occurred on save StiReport. Method must implement saving StiReport
            public void onSaveReportTemplate(StiReport report, StiRequestParams requestParams, HttpServletRequest request) {
                try {
                    FileOutputStream fos = new FileOutputStream(savePath + requestParams.designer.fileName);
                    if (requestParams.designer.password != null) {
                        StiSerializeManager.serializeReport(report, fos, requestParams.designer.password);
                    } else {
                        StiSerializeManager.serializeReport(report, fos, true);
                    }
                    fos.close();
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        };

Code: Select all

public StiReport getEditedReport(HttpServletRequest request) {
	            try {
	                StiReport report = StiReport.newInstance();
	                StiJsonDatabase jsonDatabase = new StiJsonDatabase("json");
	                String jsonData = StiIOUtil.toString(new FileInputStream("c:/2.json"));
	                jsonDatabase.setEmbeddedData(jsonData);
	                report.getDictionary().getDatabases().add(jsonDatabase);
	                DataSet dataSet = StiJsonToDataSetConverterV2.getDataSet(((StiJsonDatabase) jsonDatabase).getJSONObject());
                            for (DataTable table : dataSet.getTables()) {
                                StiJsonSource source = new StiJsonSource("json." + table.getName(), "json." + table.getName());
                                source.setDictionary(report.getDictionary());
        						report.getDictionary().getDataSources().add(source);
        						source.setColumns(new StiDataColumnsCollection());
        						for (StiDataColumn col : table.getColumns()){
        							source.getColumns().add(col);
        						}                                
                            }
	                return report;
	            } catch (Exception e) {
	                e.printStackTrace();
	            }
	            return null;
	        }