mm972
-
Posts
22 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by 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
-
Error executing SQL statement for : null - Please help me
mm972 replied to dezconocido's topic in Products
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
-
thank you gert for your suggestion, now i try to use a crosstab instead of Table...
-
Ciao Massimo, dal tuo profilo presumo che sia Italiano anche tu, anche io mi chiamo Massimo, volevo specificare che nel dettaglio le visualizzazioni si riferiscono a 2 Report diversi creati in modo diverso uno dall'altro, visto che sono alle prime armi con Jasper Studio, non mi è ancora molto chiaro il contesto delle variabili e dei campi, come mai in un report posso accedere ai campi e alle variabili sia del MAIN DATASET che di quello creato successivamente, mentre nell'altro sembra che pur avendo i DATASET nel report non sono utilizzabili i campi nell'Expression Editor..?? sbaglio qualcosa quando creo il report??? Grazie Massimo
-
Hi to All, in My Table report, i would formatting my cell with a conditional formula, then I create a Style with 2 condition (over the Average, under the average) and in the expression editor I insert the formula [ new Boolean($F{field_1}>$V{avg_field_1}) ] where $V{avg_field_1} is calculated as average of field_1 but the cell is not colored, and I realized that the variable $V{avg_field_1}) is calculated only at the end of the table is possible that..?? thanks Max
-
Hi All, in Jasper Studio, I created 2 Report with Table using DATASET but i don't know why, only in the second Report , when I open the EXPRESSION EDITOR, i view the DATASET under the FIELDS and Variables Context (see image) i how is possible to use the Dataset variable in the first report???? is possible to change the context or i wrong something when i Create the Report..?? thanks in advance Max
-
Thanks very much Gert ! I know is possible to use a group by expression in Sql statement but i want to know if is possible group the result directly in the table in the statement I extract other data and if I use Group by expression i lose other data do you know if is possible group only the Table Data..?? thank Max
-
Hi All, in a table report i have created a Variable $V{SUM} as sum of fields of first column. Calculation = SUM -> Expression = $F{Field1} If i put a "Text field" with the Variable inside and put it in column header the Value is 0. How is possible to show the Sum of value for one Column.??? Thanks a lot Max
-
Hi All, i'm a new in the community, I use Jasper Studio 6.0.3 Community Edition and have a problem with a Table Report. in details, my dataset extracts the value and i' trying to build a Table Report with Fields and Vairiable !! the Result is this : $F{Field1} - $F{Field2} - $V{Variable1} - $V{Variable2} A 20 10 4 A 10 5 2 B 30 10 1 B 40 20 1 C 20 10 3 now i would like to GROUP the result on the $F{Field1} .... $F{Field1} - $F{Field2} - $V{Variable1} - $V{Variable2} A 30 15 6 B 70 30 2 C 20 10 3 how is it possible with Jasper studio 6.0.3...?? Thanks to all Max
.png.1c247fce03b98f8ec2fd2510ac94d3e9.png)
