sandra.borchert

The empty records had nothing to do with the changes I made to ROLE_USER. There are additional permission checks in our SQL ( not all user are allowed to see all data). I took a user for testing who wasn't customized in the permission tables and therefore had no right to see any data. I was not aware that I changed the user for testing and thought the change of ROLE_USER would be the reason for the empty records. But that was wrong.

We use LDAP Authentication to connect with an Active Diretory. It works, but the users get their ID as user name and user id both. Is there a possibility to get the name from the AD instead of the AccountName (ID) for the user name? Regards Sandra

Thanks, narcism. I understand it now.

I need to transfer all parameters from a main report to a subreport. Can I use the parameter REPORT_PARAMETERS_MAP for this purpose? How is it to be used?

Thanks a lot, Lucian, you are right. The width of the detail elements was to big. I'm new to JasperReports and it seems I make the same errors with different negativ results the whole time. Regards, Sandra

I have a report with some columns. One of the columns is filled using a subreport. The subreports consists of a detail section and a summary. In Java / HTML I can see all data of the subreport. But when I save the result as Excel the detail part of the subreport is missing, only the summary is exported to the excel file. This occurs within Jaspersoft Studio and on the JasperReports Server. What can I do? Is there something I have to consider when using subreports and Excel Output?

We have an Oracle database with charset WE8ISO8859P1. Whenever a report reads a Euro-character ('€') from the database it isn't displayed correctly. Is there any possibility to adjust the character set for the jdbc connection?

Problem solved. There was a different reason for the empty result set.

Hallo, can anybody help my and list the permissions of ROLE_USER ( for Reports, Data Sources, jdbc...) , please? I changed some permissions to "execute only" with the intention that the normal user shouldn't see technical resources. But now the users without ROLE_ADMINISTRATION get empty results when executing a report. Unfotunately we have only one server at the moment because we are still evaluatiing the server features. Thanks a lot. Regards Sandra

We have lots of input controls and therefore we use the "seperate page" setting for the input controls. But there is a long scrollbar and it would be much nicer when the controls would be in two columns instead of only one. Is there a possibility to get this done by changing the default JSP files? Another thing I would like to change is that the input controls are movable by the user. Is it possile to switch this off?

I made a few reports using table controls. But at the moment it is not clear if we want to have them as an interactive reports. Is it possible to switch of the interactivity for a single report running on jasperserver? Best Regards Sandra

We are using Jasperserver and are implementing lots of reports that need both a nice PDF output and an excel output. The PDF output has different fields in one column, different height of different fields and other things that make them rather inappropriate for excel export. Therefore we decided to make two reports one for PDF and the other for excel export. At first sight the table control looked very nice for the excel report. You don’t have to worry about alignment, height and other questions to get an excel output without all these small cells filling the gaps. But we need a lot of parameters. They must be declared for the main report and the table dataset and linked together. On the other side we would like a row at the end of the excel sheet that uses the fields of the table dataset and therefore these have to be made known to the main report. Looks like much work unnecessary if you don’t use these nice table controls and put your field together manually. My question is: Should we use the table controls or not? What do you advice? Best Regards Sandra

I managed to delete the control and make it new with exactly the same properties. It works fine now. ( I had to edit the control list in the postgres database to get the new control at the position of the corrupted one) Therefore there is no issue here any longer.

I included a cascading input control in my report. But the second control always displays only the first entry of the selected list. I changed to multi selection and there is one entry only again. I changed the select to a static one, still only the first entry is diplayed. My problem is that this is the 5th of more than twenty controls (all the other work fine) and I don't want to delete them all to create them new to see if the bug vanish. Is this a known bug? What can I do?