englbrechtful

I guess by saying you dont want to display your text field when its null, you mean there should be _NO_ textfield in cases of null. Try this : $F{NODIFFMESS} == null ? : $F{NODIFFMESS}

Yes you can copy/paste multiple items. Just select them -> Hit CTRL+C -> unselect the items -> Hit CTRL+V. Most likely your pasted items are now above their source items, just select them again and move them and you will see...

Hi c33, To help you I need further information. Can you post a sample of your datasource? (e.g. if its a database list columns and some row examples ) And please try to be as detailed as possible with your questions.

Hi Rakesh, 1) Theres a free Community Edition. No costs at all. 2) No. You only add your input controls at iREPORT Repository Navigator. ( You add your reports to the server this way too, very simple ) 3) JasperServer runs on Tomcat too. Its working very performant from what i can tell so far. ( I have some big reports that take < 30 minutes to fetch the data from the db. No Problems at all. ) 4) JasperServer CE comes with some documentation. If you understand how to create reports, using JasperServer will be no problem for you. Hope I could help. regards, Stefan

Please Lucian! I dont know how to create a "breaker" that breaks every 5 Minutes :(

driver download: http://www.sybase.com/products/databasemanagement/advantagedatabaseserver/jdbc-driver BTW google is your friend!

Does it have to be SimpleDateFormat? new java.sql.Timestamp($F{EMPLOYEE_EMPHIREDATE}) should work.

Hi Lucian, thanks for your help. I understand your approach but can you please specify : "create a report groups that breaks every 5 minutes" how to do that in ireport? ( i use v3.5.0 )

Im not sure if thats what you asking for: iReport -> Report Inspektor -> right click on "report name" -> Page Format There you can adjust your page size. Hope I could help, Stefan

Hello Community, situation: Ive got a DB with a table "logging" that has the following relevant columns: time(timestamp), errorcode(string). I want a chart where i can see how often a certain errorcode appears in relation to the time. I tried this with a simple query "select * from logging where time between '2009-09-09' and current_timestamp" for example. then created a time chart with this data. this works. The problem is the big amount of data, there are about 5000 such entrys every day. So I figured i need some pre processing of the data, for example a lot of querys like this: "Select count(*) from logging where errorcode = '1x0' and time between '2009-09-09 00:00:00' and '2009-09-09 00:05:00'" That means if i want to see a graph for a certain error from 24 hours, i need 12*24=288 querys and those results i could use for my chart. Any suggestions how i could implement that? Im happy for every comment! If you dont understand my situation ask, i will try to concretise it. Thx, Stefan Post Edited by englbrechtful at 10/07/2009 11:04

Accessing seperagte databases for report data is no problem in JasperServer. IF you can store JasperServers report data redundant i dont know, probably not without modifing some xml files...

Hey everbody, Im having a very strange problem, which is pretty difficult to explain for me: I built a Schema and a MDX query, very simple and apparently working. Now when i check the view ( all positions are collapsed ) the shown values are just fine and correct. But now if i expand (for example all customers) i see wrong values for every position, i double checked with sql and i have absolutely no idea where JA is taking that values from. I know this could be any kind of problem, but i dont know how i can give you more info on the issue as i cannot give you access to my databases nor make screenshots with data in it :) Please help me! best regards, Stefan

Hey nseetha, i ran into the same trouble yesterday. Theres an easy way to fix that, dont ask me why but it works :) replace the first line of your query: old: [Measures].AllMembers ON COLUMNS working: {[Measures].Measure1, [Measures].Measure2 } ON COLUMNS Measure1 and Measure2 are you real measures. example: old(not working in JA): SELECT [Measures].AllMembers ON COLUMNS, Hierarchize(([Customer].[All Customers].Children * [Time].[Year].Members)) ON ROWS FROM [Revenue]; working: SELECT {[Measures].Count, [Measures].Sales } ON COLUMNS, Hierarchize(([Customer].[All Customers].Children * [Time].[Year].Members)) ON ROWS FROM [Revenue]; Hope I could help, Stefan Post Edited by englbrechtful at 09/30/2009 07:18

Hi Kumar, Im currently having the same problems/errors. Did you find any way to fix this issue? I dont know wether my schema and query are good, but both did work with the JS Workbench. Thanks, Stefan

I figured out a solution: Chart Details -> Detail -> Use more Series -> Add Key Expression: "column name" Value Expression: $F{FIELD} Label Expression: leave blank as Key Expression will be used Do this for every column and woahalaaa here is our Chart :)

Hi, my Report consists of a simple SQL query like that Select count(*) AS COUNTED, sum(something) AS SUM_A, sum(somethingelse) AS SUM_B, sum(...) AS SUM_C from table; I want to add a chart showing the percentace of SUM_A, SUM_B and SUM_C to each other ( for example a 3d bar chart ). Can someone tell me a proper Value Expression to make that possible? Charts using one column and a lot of values as Value Expression is easy, but I didnt figure out a way to create a shart with different columns in it. Thanks for any help, best regards, Stefan