rodriguezum

you can go and overlap the components in the two bands in 1, placing them in a frame, and setting the print when expression condition on the frame, or you can place a couple of bands but in the same atribute (PWX) on the band set them to display just one, by default both get printed

i have the same issue but in piecharts from the flower template, i solved it by placing the compatibility mode to 3.5.0 and the deleting the lines of the ItemLabel, i'm using JasperServerPro 3.5.1, i can now the report but i have 4 pie charts in the backgroung and only one is displayed when i upload it to the server. any help?

i handled the splitType problem the same way you guys, but now upgrading to 3.5.3, it gives new errors for the jrxml, it runs fine in IReport but on server it throws me an error on itemLabel and that one i cant find in the jrxml, anyone with the same problem?

didn't quite understood what was your problem, but for casting in to an integer just do ' new Integer(int) ' , i use java for language

i got many errors of this kind when i was starting to develop schemas, and mostly were schema errors, even though the schema is validated (it has the correct formation) it does not mean that is correct, only by creating some mdx querys and running them you will get the full picture, also like sherman, i recommend restarting the server first

Hi i've generated a couple of report with Ireport 3.5.3, and applied the patch to jasper server 3.5.1 , i've done some reports already, and the problems i've encountered are in the xml definition, wich i assume are from jasperreports 3.5.3, Since JS just uses jasperreport 3.5.0 jar i wonder if there is any way i can modifie it to take jasperreports 3.5.3, i've tryed replacing the jars in the tomcat \jasperserver pro lib , but that didn't work. Any thoughts?

i'm using JasperServer Pro 3.5, it already has the oracle driver in there i suppose ojdbc14.jar, since my oracle connection is working. just not of a balanced DB.

Sorry Sherman did not follow, the way i have to show some users some reports and some users anothers is to define their permissions by role. My question is how can i give reading permissions to someone but not show them the report, for instance i have the same report created twice, one for report visualization and printing purposes, and another to view as part of a dashboarb, with de parameter _ViewDashboardAsFrame or something like that active. I want the user be have access to both, but in the View/reports tab just want to show one. Just didn't understood how i can achieve that with your answer. The home page feature is nice, just started into doing that :) thanks for your time

Thanks for the reply, and it cleared a couple of things. Just still need to know how to connect or put where to put my URL connection in order to work, i'm using the whole Jasper Suite that is, JasperETL, Jasper Analysis, Jasper Server, Ireport. Suposing now that i just need to define my balanced connection in the ETL and Server, do you know how i can achieve it? thanks for your time

i use ireport to create a .jasper file, and then upload it to the server, i've never hanbled a .jasper file before, just the xml that is generated by the jrxml, but in there it dows not figure any of the connection parameters, for that i have to define a connection/datasource, and i don't know how you can link it to tnsnames.ora since, i use a Database JDBC connection, and in the jdbc URL try to provide it with my tnsnames.ora connection (the on i display above) and it does not work for me. Do you write de .jasper ? , i thought that was the job of ireport, i jsut tryed to open one with wordpad :) , and can't view it properly. What do you use, i'm realizing that there is still a lot i need to learn :/ Thanks for your reply

i use this to uri to connect to my oracle DB, through tnsnames and it's working, since i use other tools with that connection. I'm using all of the jasper suite, and i tried mostly on jasperETL to connect with that string for my migration, but also on jasperserver and ireport. But failed in all of them. I use a generic jdbc connection. Am i doing something wrong?

Hi, i'm just starting to define the security and permissions for the users as superuser, the thing is i have some reports that will go only on dashboards, and i dont want to show them when the user clicks my reports. I can not show them if i don't give permissions to the user, but them i cant see them in the dashboard, even if i give permission of viewing the dashboard. The same applies the other way around. Is there anyway we can give permisions to the users but not to show them the reports?

yeah, i've working like that, but the idea is frowned upon by the manager in the production stage :(

Hi is there anyway we can force a delete on a report unit. I have two report units wich i can't seem to delete. i enter as admin or superuser and try to delete them and it throws me the error that they have other objects refered to them, the thing is that referal is for the main report in that report unit, so its refering to itself. Anyway i deleted every configuration i knew, so now those report are just blank. So, is there anyway we can force a delete on report units?

hi, i was using ireport 3.5.0 with a mondrian report and subreport, everything was working fine, cause of a change in the mondrian schema (alias in the tables) it stoped working, so i chenged to ireport 3.5.3, so now i have everything working, in the preview perfect. The problem is now when i pass it to jasperserver pro 3.5 the sub_report doesn't show anymore, when i trie to use a simple report just a basic static text, with a field retrieved from a mdx query, in the preview all works fine, but in JS 3.5 just shows the static text. The only parameter i'm sending is $P{MONDRIAN_CONNECTION). Has anything changed regarding that? if you need the jrxml please let me know ---------------- kinda solved it, by fetching a report backup and macking the necessary changes, its all working now, but i still found it strange, guess i'm gonna figure it out in a little while has a continue using the 3.5.3 Post Edited by rodriguezum at 08/11/2009 11:52

when i was evaluating the tool this was not a problem, i just need to connect it to the infraestructure and i'm done, this is a problem shared by all de jaspersoft BI, i'm using all the core tools (ETL, Analysis, Server, Reports) and in none of these seems to work. this is my tipical connect jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = machine1ip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = machine2ip)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = service_destination))) anyone with the same problem?

when i was evaluating the tool this was not a problem, i just need to connect it to the infraestructure and i'm done, this is a problem shared by all de jaspersoft BI, i'm using all the core tools (ETL, Analysis, Server, Reports) and in none of these seems to work. this is my tipical connect jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = machine1ip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = machine2ip)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = service_destination))) anyone with the same problem?

when i was evaluating the tool this was not a problem, i just need to connect it to the infraestructure and i'm done, this is a problem shared by all de jaspersoft BI, i'm using all the core tools (ETL, Analysis, Server, Reports) and in none of these seems to work. this is my tipical connect jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = machine1ip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = machine2ip)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = service_destination))) anyone with the same problem?

did you add it to the classpath?

:( didn't work, actually i have another dimension that has two hierarchies, one wich reaches down two the full name, and another the sex, none of the levels are the same, and the problem persists. In each dimension i tried a different aproach for displaying the full name, one with a key expression, and another with name and ordinal expression, thw two ways i found in the foodmart example. Both work in Drill down, but when it comes to drill through, the result is the same JSException: ORA-00918: ambiguous column. Can you tell me if this is Oracle specific?? Thanks

I'm sorry for the "drill Down" mistake, i meant drill through, i this the problem has nothing to do with personnel_type, since its merely a column in the database, and i've called the same level many many times in other hierarchies, lets say the time dimension, where the year has been predominantely my first level in many hierarchies. I can drill through the first hierarchie, where in the last level is just shown the first name, the problem is that i need all three names, otherwise all employes with the same name will be merged, and my measures get messed up, so the although i can show the full person names when i drill down in the second hierarchie, when i drill through it throws me the oracle error. I tried to follow the foodmart example, but just can't seem to get it right. Could this be Oracle specific?, please advice thanks in advance Post Edited by rodriguezum at 08/03/2009 07:31

Don't know about the sql but this is the schema definition for that particular class, <Dimension type="StandardDimension" name="PERSONNEL"> <Hierarchy name="PERSO" hasAll="true" allMemberName="TODOS" allMemberCaption="primer nombre" primaryKey="SK" caption="Funcionarios"> <Table name="DIM_PERSONNEL" schema="TICARES_DW_MIG"> </Table> <Level name="PERONNEL_TYPE" column="PERSONNEL_TYPE" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="PERSONNEL" column="GIVEN_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> <Hierarchy name="PERSONNEL" hasAll="true" allMemberName="TODOS" allMemberCaption="todosnombres" primaryKey="SK"> <Table name="DIM_PERSONNEL" schema="TICARES_DW_MIG"> </Table> <Level name="PERONNEL_TYPE" column="PERSONNEL_TYPE" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> <KeyExpression> <SQL dialect="oracle"> <![CDATA["GIVEN_NAME" || ' ' || "FAMILY_NAME" || ' ' || "MOTHER_NAME"]]> </SQL> </KeyExpression> <Property name="PHONE" column="PHONE" type="String"> </Property> <Property name="ACTIVE" column="ACTIVE" type="Boolean"> </Property> <Property name="EXTERNAL" column="EXTERNAL" type="Boolean"> </Property> </Level> </Hierarchy> </Dimension> the problematic hierarchy is PERSONNEL, but i printed the hould dimension just in case, in attachment i placed a couple of pictures one befor the drill down where we can se all the full names correctly printed, and the other is when i click on a value to drill down. both with the tomcat window on the side, don't know if it helps Don't know how i can show the sql, anything else you need i'll be happy to oblidge, cause this is a problematic issue for me

yes that is the problem, whenever i use key name ordinal expression the drill down just doesn't work anymore, cause of the ambiguous comlumn error. Like i said i have given family and mother name, and i wanted to show the client full name for obvious reasons, without having to perform 3 levels in hierarchie, but still be able to drill down. Heres the schema. THank you for your reply

hi, in ireport i'm using jasperserver and ireport, and i want to do a mdx query where the user tells me what attributes he wants to see, lets say we have an admission reasons a,b,c,d and i want to give him the oportunity to just select a and d, or a,c,d I can get that input from jasperserver from a mutlselectquery in the format of [a,c,d] , now since mdx doesn't have the in function like sql. How can i translate this to a valid mdxquery thanks in advance

unfortunately no :(, i have to run my etl on several machines through a ssh console, so i just export the job scripts and use the sh or bat file avaliable. the problem is that i use txt files to do my tables updates, instead of toraclerow comoponents cause they can only do an update at a time, so i just run the file. In export job scripts the location of the file i just wish it could be path/my_folder/myupdates.txt but thanks for the reply, this forum is almost dead, its good to see that we can still post and hope for a response. thanks