[stampa di un sottoreport prima di ogni pagina]

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

 

[stampa di un sottoreport prima di ogni pagina]

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

 

[Use Data Staging with Jasper Studio Report]

Thanks very Much

max

[Use Data Staging with Jasper Studio Report]

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

 

[Histogram in Jaspersoft]

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

[Histogram in Jaspersoft]

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

 

[Data Staging]

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

[difference between Data Staging and Data Snapshot]

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

 

[Data Staging]

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 

[.jasper file and .jrxml file Server location]

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.jasper

at 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

[Conditional Formatting]

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]

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

[is possible use main dataset in Table Report??]

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

[is possible use main dataset in Table Report??]

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

 

[Desing a report]

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   
 

[[Jasper Studio] Group Value in Table Report]

thank you gert for your suggestion, now i try to use a crosstab instead of Table...

[Dataset Context ??]

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

 

[Conditional Formatting]

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

[Dataset Context ??]

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

 

[[Jasper Studio] Group Value in Table Report]

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 

 

 

[[Jasper Studio] Table - Sum Column Field]

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

 

[[Jasper Studio] Group Value in Table Report]

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