mm972

penso che se il report è strutturato su 2 pagine potresti mettere sia il subreport che il report nel Detail e impostando le dimensioni(height) del subreport e del report in modo adeguato, automaticamente il sub report comparirà nella prima pagina e il report nella seconda, oppure potresti fare 2 report distinti uno con il primo che contiene i dati di riepilogo e poi cliccando sui dati di riepilogo richiami un secondo report (passando i parametri) e visualizzi il dettaglio !!! Saluti Max

non so se ho interpretato bene la questione, comunque potresti inserire nel PAGE HEADER un SUBREPORT al quale puoi passare dei parametri, che estrae i dati e te li mostra in testa ad ogni pagina del report , poi nel DETAIL mostri i dati estratti dal REPORT sempre dallo stesso foglio excel ho interpretato bene??? Saluti Max

Thanks very Much max

Hello, I have some reports created with Jasper Studio 6.0, in these Report I have used a dataset to extract the data from DataSource, In the Jasper Server, is possible create Ad Hoc View and Report with DATA STAGING functionallity to cache the data, Now , is possible to use the DATA STAGING functionallity also for the report created with Jasper studio..??? Thanks Max

Hello mynick you're right they are not exactly the same thing,I checked on Wikipedia and Histogram and Bar chart are different type of graph. i think now in Jasper report are not present the Histogram graph yet, but in the community answer I found this post http://community.jaspersoft.com/questions/515577/histograms-using-jasper-reports I hope will be useful for you Bye Max http://community.jaspersoft.com/questions/515577/histograms-using-jasper-reports

Hello, if you use Jasper Studio (commercial /community edition), you create a New Report, then create a DATASET for the data you want to show. After in the palette ELEMENTS in right side, you drag on report the CHART element, this open a Wizard for the chart, you select the BAR CHAR TYPE, select the DATASET cretated, and choose the category and the series. I hope I was clear Bye Max

thanks for the reply... but can you explain me better.. in Jasper studio, for my report if I create a dataset and a sql query how i set the data staging for this query??? bye Max

Hi, someone knows which are the main differences between Data Staging and Data Snapshot..??? my need is to cache the queries used in my report and subreport Thanks to all Bye Max

Hi all, I use Jasper studio to create my report, if I enable data staging on Jasper server, it's enable only for the Ad Hoc views or is possible to caching the query I use in the report DataSet and Sub report Dataset. Thanks Max

Hi, all i use Jasper Server Community 6.0 and Jasper Studio 6.0 on my Pc when I deploy my report, where are located the . jrxml and .jasper file in the remote server..??? I ask this, beacause sometimes when i execute a REPORT, occurred the following error the the SUBREPORT inside Caused by: net.sf.jasperreports.engine.JRException: Resource not found at : SUBREPORT.jasperat net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:145)at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:107)at net.sf.jasperreports.engine.fill.JRFillSubreport.loadReport(JRFillSubreport.java:383)at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:350)at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:408)at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:326)at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259)at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:455)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:320)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:256)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:124)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:540)at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:120)... 10 more Thanks Max

Hi Stas, I've tried how you explain me. I have created a subReport and then I inserted the subreport in the main Report... but I haven't the expected result.... in the subReport i have the sub_var1 , when I insert the the subreport in MainReport I map the sub_var1 with a variable created in MainReport main_var1 then to pass the main_var1 to the TableDataset, I create a Parameter and associate this Parameter with main_var1 but when I use this parameter in table or i use for create the consitional style for formatting the cell of the table the value is ever NULL.. the subreport is in the TITLE BAND and the main report in DETAIL BAND , I've tried to change band but it was useless.... Can you give me a little help.. Thank Max

Have you tried to change the SQL statement..??? for example without LIKE condition..??? to understand is wrong the syntax ??? try : proyecto."financiado" LIKE 'SI' proyecto."financiado" LIKE "%SI%" proyecto."financiado" = "SI" bye Max

hi butlerc, thanks for the answer... i don't understand, what do you mean with "dataset triggered" and "Hook up the dataset" in my report I have 2 Dataset (Main_dataset , Table_dataset) the Main_dataset query is (select * from dual) , create in the wizard report the Table_dataset query is (ex. select id_prod, product_name from products) create for my table what should I do in your opinion..??? Thanks Max

hello, in Jasper Studio i want to create a Table Report. when i create a Report, in the wizard I build the main Dataset with my DataAdapter/query. But when I create the TABLE element is not possible to use the MAIN DATASET, and i'm forced to use another Dataset. if I use the EMPTY DATASET-EMPTY RECORD as MAIN DATASET or insert a Query with no Rows the report will be blank, im my report now I insert the fake query (select * from dual) why I'm force to use 2 Dataset..??? thanks to all Max

Hi, I think is not possible to calculate runtime the % Value. I have the same problem with my report. if you create a Variable $V{total_prod} , you can insert in report this variable with EVALUATION TIME = "REPORT" and the value is shown correctly, but if you want the ratio ( prod_1/total_prod) is not possible to calculate the right value in REPORT Mode and even in NOW Mode, the only mode is calculate the TOTAL VALUE in SQL QUERY directly. bye Max