patrick.dewitt

Hi, The security file in the example was based on 1 table. I got challenged when I had to include another table and joined them together. The security file doesn't match the items in the domain anymore and the row security is gone. When you go back to the domain designer and go to the tab display, you can see the name of the join. If you have selected both tables completely, you will not see the join. In that case just remove the table from the selected ones and jou will see the join on the left pain. Standard, creating from scratch, the name will be "JoinTree_1" which is important for the security file. Below you will find the solution based on the previous security file. <securityDefinition itemGroupDefaultAccess="granted" xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema" version="1.0"> <resourceAccessGrants> <resourceAccessGrantList id="JoinTree_List" label="JoinTree_ListLabel" resourceId="JoinTree_1"> <resourceAccessGrants> <resourceAccessGrant id="bv_tab_orders_and_rates_row_access_grant_1"> <principalExpression>authentication.principal.tenantId != null</principalExpression> <filterExpression>orldev_bv_tab_orders_and_rates.sender_cd in (groovy('authentication.principal.tenantId.toUpperCase()'))</filterExpression> </resourceAccessGrant> </resourceAccessGrants> </resourceAccessGrantList> </resourceAccessGrants> </securityDefinition> Kind regards, Patrick

Hi Guys, You are not the only ones. When I make a calculated with a constant there is no problem. If I am using a if-statement, which is transformed in the query as a case-statement, then in Table mode it works, but when going to Crosstab it gives an error. The strangest thing is that when I create a custom field in the ad hoc view, it creates also a case-statement in the query, which works fine when I go to Crosstab mode. The only thing in my case is that the constant gets cast as numeric before dividing. So maybe the value has to be cast as numeric first. Kind regards, Patrick

For the ones who are interested I have found the solution myself. As usual it was simple but hard to find out. Put the tags of the principalExpression and the expression itself on one line. Do the same for the filterExpression and the authorization on the domain goes well. In the original security file I didn't do this. In my original post I did. Example:<securityDefinition itemGroupDefaultAccess="granted" xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema" version="1.0"><resourceAccessGrants><resourceAccessGrantList id="orldev_bv_tab_orders_and_rates_List" label="ListLabel" resourceId="orldev_bv_tab_orders_and_rates"><resourceAccessGrants><resourceAccessGrant id="orldev_bv_tab_orders_and_rates_row_access_grant_1"><principalExpression>authentication.principal.tenantId != null</principalExpression><filterExpression>sender_cd in (groovy('authentication.principal.tenantId.toUpperCase()'))</filterExpression></resourceAccessGrant></resourceAccessGrants></resourceAccessGrantList></resourceAccessGrants></securityDefinition>Kind regards,Patrick

Hi Guys, I am using Jasperserver 5.5 on AWS with the multi-tenant option. I created 2 organizations, one data source, one domain with a security file. Through the security file I would like to filter the data for each organization. I have created the file and uploaded it on the domain tab. When uploading and submitting the file gets checked. So far no problem. When I try to build a Ad Hoc View on top of the Domain I still see all data instead of the data from the organization I am logged in. As the superuser I enabled the debugging mode of several options and I found out that I am getting a null-response from the principal expression. As I searched on the internet and the documentation I found two ways, which still didn't do the job, although I think both ways should work. Option A. <principalExpression>authentication.principal.tenantId != null</principalExpression> <filterExpression>sender_cd in (groovy('authentication.principal.tenantId.toUpperCase()'))</filterExpression> Option B. <principalExpression>authentication.getPrincipal().tenantId != null</principalExpression> <filterExpression>sender_cd in (groovy('authentication.principal.tenantId.toUpperCase()'))</filterExpression> The thing is that the principal expression gets the null-response. That is what the log file showed me. So can there be anything else I could do to make the security file work? Please let me know. I am open to any suggestion. Thanks, Patrick

I have found the problem for my Mac. I just entered the wrong port in the connection. I tried it from an instance on AWS and I also got the error. Within AWS it only seems to work when you enter the IP-address instead of the public DNS name.

I can reach the public DNS from my old laptop (Windows) through iReports. I can't ping either the public DNS name or IP-address from both laptops, but that's probably how AWS works. I tried to use the IP-address in the server properties without success. If I put the IP-address in a browser (Google, Safari) on the Mac, I can reach the machine.

Hi, I have bought a MacBook Pro (10.8.5) and installed iReports Professional 5.2.0 (Commercial edition). I can make the database connections and run my local report. Now I want to connect to Jaspersoft Server on AWS (AWS license). I can add a server, its properties, through the dialog, but when I try to open that server it gives me an error saying "java.net.ConnectException: Connection timed out". On my other laptop (Windows) I have no problem connecting to the Jaspersoft Server. I want to get rid of this old machine. Does anyone have a solution for this problem? Kind regards, Patrick

Hi, I want to thank you. It is very clear and it works fine. Kind regards, Patrick

Hi Gary, One more thing about the sort component. Look at the sort components if they are overlapping with each other. My second sort component seem to be overlapping a little bit with the first and now the first is gone for a piece of a second and comes up again. Maybe if the overlap is too much you won't see it at all anymore. Kind regards, Patrick

Hi Assaf I tried the connection from the EC2 Manager and it works fine just like Putty. I also have tried the SFTP from the plugin menu and it works fine also. For now I have no reason to use Winscp. AWS has provided the tools to make it work. Kind regards, Patrick

Hi Assaf, Thanks for the answers and the link. I will try stop and start command tomorrow. I am now using Putty and PSFTP (from Putty), but maybe I will try the stuff from the link. Kind regards, Patrick

Hi Gary, I am glad that it helped you. I have 3 columns with a sort component. Click on column 1, column 1 gets sorted ascending, leaving column 2 and 3 unsortedClick on column 2, column 2 gets sorted ascending within column 1, leaving column 3 unsortedClick on column 3, column 3 gets sorted ascending within column 2 and column 1In this order I got no problem at all. But now if I click on column 1, it looks like column 1 is not in the lead anymore, but follows column 2 and 3 in that order. With this answer, which is not totally an answer to your question, I showed my experience with it. It does work for me as long as I am in step 1 through 3. It doesn't work as properly as it should. Now about the symbol I have the following. I have changed some options, symbol style, color, and it did change within iReport, but you don't see it getting changed when you publish it to the server. Although I can see it in the XML that it has been changed correctly, it doesn't show. I think that somehow on Jaspersoft Server gets interpeted in the wrong way and gets the defaults. I will try some more, but it will take some more time to figure it out. I will let you know if I find anything. Kind regards, Patrick

Hi, I am having trouble with importing an export from my laptop to Jaspersoft on AWS. I am using the command line for export and import. For the import the Jaspersoft Server should be stopped to avoid issues, like the manual says. So I want to bring it down, but only Jaspersoft, not the EC2 instance, because I need to work on it. Now I can't find the stop/start command's on the EC2 instance. Can anyone tell me where to find them and how they should be used. The file recommended in the installation guide "ctlscript.sh" is not there. Kind regards, Patrick

Hi Peter, I have solved it. The sort component has three phases. The first phase is "Not sorted" and therefore shows no symbol. The second phase is "Sorted ascending" with the arrow up. The third phase is "Sorted descending" with the arrow down. After the third phase, the first phase starts again and there is no symbol again. I have made the sort component the same hight and a little bit wider then the header of the column. Position the sort component on top of the header of the column. Then unmark the property "Opaque" so that it will be transparant and you will see the header. Next you have to set the property "Handler Horiz. Align." to the value "Right". If you now publish the report to the repository and run it, you can click on the header itself, activating the sort component. Thank you again Peter for giving me comments to go further. Kind regards, Patrick

Hi Peter, You are right. It is exactly as you said. End users will not like this, trying to figure out whether it is there is and where it is. It does work though. Thanks Peter. Does anyone know why it doesn't show up the first time and how to resolve this? Kind regards, Patrick