[Don\'t work parameters]

Hello alexx1,

you have to add "Input Controls" for your Parameters in JasperServer.

Log into JasperServer, select repository, right click your report, select "edit",
->Controls & Resources -> add Control
Use same name and datatype like you setup in your report.

Dont forget to also check the Box "Always prompt", to get asked for the parameters at report startup.

HTH Stefan

Post Edited by englbrechtful at 01/27/2010 16:14

[Cascading input controls for reports - Pro only?]

Hello regw,

 

yes it also works with the community edition. Its really no biggie to set it up.

 

 

By the way: This feature has been added to JasperServer in the current version 3.7.0, so if theres anychance you can upgrade to 3.7, do it! Way more easy to use there (no editing files needed...) :)

 

HTH

stefan

[Bugs? Cascading Input Controls]

Hey Sherman, thx for the hint, but doesnt seem to work for me

 

org.springframework.webflow.definition.registry.NoSuchFlowDefinitionException: No flow definition 'removedReportsList' found

[[SOLVED] CustomDataSource not working with js3.7]

Thats it. Works!!!!

THANK YOU SO MUCH!!! Ive been sitting on that problem 24/7 for almost a week, completely rewrote my classes and shit, and its just those two lines, haha.

again thank you !

[[SOLVED] CustomDataSource not working with js3.7]

UPDATE: just upgraded from RC to final version of jasperserver 3.7.0 CE and theres still the same problem. Jasperserver application is not starting, while same configs works for Jasperserver 3.5.0

[[SOLVED] CustomDataSource not working with js3.7]

Hey everybody,

I recently updated my JasperServer 3.5 CE installation to JasperServer 3.7 CE RC.

My custom datasource isnt working anymore since then. I did not change anything and cannot explain the problem myself.

I found a similar error on the bugtracker (http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4466)

I need my custom datasource to be working, so my question is if that is a problem on jaspersoft or on my side and if it will be fixed soon or if i have to downgrade back to 3.5.

Thanks!                                                

Code:

Post Edited by englbrechtful at 01/25/2010 13:16

Post Edited by englbrechtful at 01/25/2010 14:42

[Bugs? Cascading Input Controls]

Thanks Matt for your quick help.

Problem 2 I already solved myself.

 

"This is intentional." Thats a pitty. I liked the old html view, the repository is very confusing for "non-developer". And also the report specifications get cut off ugly.

Am I the only one thinking that way?

[Bugs? Cascading Input Controls]

Thats not Analysis View, its a Report.

 

If you want to know how to do this with a report, let me know.

[Bugs? Cascading Input Controls]

Hey,

i just upgraded my JS to 3.7.0 CE,

and this looks pretty buggy too me. Im wondering if something went wrong during upgrade or if this is just because its not a final version.

 

problem1: when i click view->reports i get the same view like view->repository

problem2:

im using a singel cascading input control. Its working so far, i get the expected reports.

BUT i dont see what i choose. the dropdown menu is just to small to see anything.

check attached picture to see what i mean.

 

[Wrong Values in Analysis View]

Thank you very much Sherman, thats it, exactly.

 

:)

[How to use JRMapCollectionDataSource in JasperServ]

Hey,

I created a report using data from a JRMapCollectionDataSource and I can run the report from my Java Application. Works great.

But I need to add the report unit to my JasperServer!

How can I do this? How can I tell JasperServer to use my JRMapCollectionDataSource custom class which returns the List<Map> which is used for my report?

 

// from my java app:

public void report(ArrayList<HashMap> al) {

        JRMapCollectionDataSource ds = new JRMapCollectionDataSource(al);
       jasperReport = JasperCompileManager.compileReport(this.getXmlsource());
       jasperPrint = JasperFillManager.fillReport(jasperReport, parameter, ds);                    JasperExportManager.exportReportToPdfFile(jasperPrint,"customhashdatasourcegraphtest.pdf");

}

Post Edited by englbrechtful at 12/09/2009 16:08

[Looping a JRMAPCOLLECTION DATASOURCE in Ireport]

Im not sure if thats what your looking for:

 

Put your $F{Field} into details band, and reduce size of details band to the height of your field.

 

[requete mdx invalide]

Nobody can help you without knowing what your problem actually is.

Please post the whole error stack, your Schema and your query.

[How to integrate iReport with Java + PL/SQL?]

Hello Jagrut,

 

iReport is a GUI for creating Reports (JRXML/Jasper Files) to use with JasperReports.

You probably want to use JasperReports in your Java Project. To do that you have to include the JasperReports TAR file in your projects class path.

[Wrong Values in Analysis View]

Thanks a lot Sherman, its working!!!! :)

Theres only one question left: how does "artikelgruppe" fit in? where can i put it? as a level of Artikel?

( Artikelgruppe = articlegroup // the articles are divided into certain groups )

should be look like in the pic i attached

[Wrong Values in Analysis View]

come on swood, mdahlman, someone help me, or tell me at least if thats a bug or its problem on my side. Im totaly lost here.

[Problem with rules]

Where can I find that fix? I got same issue and its pretty important for me that certain users can only access/see certain reports. Using JS 3.5.0

[Date parameter problem. Urgent.]

What DB application are you running?

 

why do you want to do that such complicated?

 

I would use two parameters $P{START} and $P{END} both java.sql.timestamp type.

 

your sql query would look like this then :

select eno, ename, doj, sal from employ where

doj between $P{START} and $P{END}

[How to compare the field type "Double" field]

try this:

 

$F{delta}.doubleValue() > new Double(0) ? new Double(1.0) : new Double(0.0)

 

i didnt really understand what your up to as the boolean part is confusing me pretty much.

If thats not what you wanted please explain once again.

best regards,

Stefan

[Subreport produces error "Bad version number"]

Hey renek,

 

usually this kind of error appears when you run java files with a different/older JRE than the compiler that was used.

try java -version and javac -version

[Wrong Values in Analysis View]

I investigated a bit further and figure out the problem is that all shown measures are multiplyed with 1024!

 

Here some data to understand what im talking about:

PostgreSQL DB table: umsatz_cube

Columns: name, artikelgruppe, artikel, jahr, quartal, monat, menge, nettogesamtbetrag

 

now if I do a sql query like this : "select sum(menge) from umsatz_cube where name = 'certainname' and jahr = 2009 and quartal = 4"

I get the correct value: 21849

JasperAnalys shows if i drill down to that name the value 22373376

Same with all other values of my Measures its always original value * 1024 which JA shows!?!? how can that be?

; 22373376/21849
        1024
; 43602944/42581
        1024
; 45289472/44228
        1024

 

Im running JasperServer 3.5.0 CE on debian lenny.

My MDX query:

SELECT
{ [Measures].Netto, [Measures].Menge } ON COLUMNS,
{ ([Kunde].[All Kundes], [Artikel].[All Artikels], [Time].[Year].&[2009]) } ON ROWS
FROM [umsatz]
 

Attached is my schema, and screenshots to underline the problem.

PLEASE HELP ME!!!!!!

[Accessing printWhenExpression for field in iReport]

Try CTRL+TAB+7 or manually Windows-> Properties. You will see a properties on the right now. There you can set your printwhenexpression.

 

ps: use new Boolean with capital B

[i18n in subreport]

how about copy & paste to your xmls file?

[Can Jasper do this?]

I would need to know how your source is looking like to give you precise instructions.

But this should be possible with variables, doesnt sound like a big deal.

[Conversion from Integer to String]

Hi,

new Integer(Integer.valueOf($F{loc_id}))

This should work, assuming your loc_id field is called $F{loc_id}.

To get the N/A thing working you could use this:

$F{loc_id} == "" ? new String("N/A") : new Integer(Integer.valueOf($F{loc_id}))

(i.e. if string = "" then print new String N/A, else print integer value of string)

 

Stefan

 

Post Edited by englbrechtful at 10/20/2009 13:00