jme14

I get a java.lang.NullPointerException when I try to alter de default "SimpleStyle" after creating a style template (jrtx) in Jaspersoft® Studio. Im am using Jaspersoft Studio 6.1.0.final Do I something wrong? Regards, Jan Meijer

Create an "input control" with type "single select query". Enter a SQL query to select the date values you want, like "to day", "yesterday" and "last month" like: select current_date() as id, 'Today' as name union select date_sub(current_date(), interval 1 day) as id, 'Yesterday' as name union select date_sub(current_date(), interval 1 month) as id, 'Last month' as name You can add as much "union select..." as you want

After installing Acrobat Reader X on the client PCs, users cannot open reports in Pdf (in Internet Explorer). We didn't have this problem with previous versions of Acrobat Reader. We use jasperserver-ce-3.7.0. Acrobat Reader X can view the Pdf output of Jasperserver, after first saving de Pdf to file. What can we do (beside installing a previous version of Acrobat Reader)? Regards, JanM

I have created an input control to select a specific error-code for an error-report. This input control selects also the error-messages and the number of times a specific error occurs (with count(*)). select vme.id , left(vme.code,3) as code , concat(vme.ernst ,lpad(vme.id,3,'0') ,' - ' ,vme.message ,' (' ,count(*) ,')' ) as message from hls_verwerking_melding vme join hls_verwerking_verslag vve on vve.id_vme = vme.id and (vme.ernst = $P{p_error_code} or $P{p_error_code} = '0') group by vme.id This works fine, but.... Jasperserver does not (always) refresh the selected data. When I use the input control, I get the same data as yesterday. (Yes, I am sure the data has been modified in the database) How can I instruct JasperServer not to cache the data in this input control? I use JasperServer CE 3.7.0 Regards, Jan

I have exactly the same problem with 3.6.0. using compatibility of 3.0.0. I am sure my group footer does not contain new features, because I have created the report with iReport 3.0.0. Regards Jan Meijer

You can use Runjasperreports. Website: http://gtwebmarque.com/wikis/gtwm/index.php/RunJasperReports_Usage Regards, Jan M

How can I search in the postings on this forum with more than one keyword? Is it possible? When I use more than one keyword in the "Search Forum" search field, this search is handled as a phrase... Regards, Jan

How can I search in the postings in this forum on more than one keyword? When I use more than one keyword, this search is handled as a phrase... Regards, Jan

I have had the same problem on Windows Vista. I fixed the problem by changing the default MySQL engine to InnoDB. Regards, Jan M

Thanks for your reply, but I do not understand your answer. I will rephrase my question: I have a folder e.g. "My Reports" with a sub-folder "MyReportsFinancial Reports". I want to define "Financial Reports" to be the default folder for the end users of JS (role_user). How can i achieve this in jasperserver-servlet.xml? Regards, Jan Meijer

Is it possible to set the default folder after logging in (JS 3.0)? Regards, Jan Meijer

Sherman Wood Wrote: Have a look at using permissions. If you want normal users to not see particular folders, just give them "No Access" to those folders. Then they will never see those folders in the repository manager or in the report list. Sherman Jaspersoft When you set folders to "No Access" (like the images-folder with logo's), a user does not have permission to view reports with logo's. I am looking for a kind of "run-but-invisable" permission. Regards, Jan meijer

Is there a possibility to hide folders for users (role_user) in JS 3.0? Users get confused when browsing trough folders they don't understand.... Regards, Jan Meijer

Thanks, I found some useful information in posting "Row level security logged in user as parameter?" There is also an example in JasperServer, /Reports/Samples/Sales by Month Report Regards, Jan Meijer

In JasperServer, you can define users an roles to controle authorization. I want to pass the current user as a parameter to my jrxml report, to filter the data for this user. Is this possible in JasperServer v3.0? Regards, Jan Meijer

I want to create a new XML/A connection to connect to the mysql schema "Regas". When starting an analysis view (for this new connection) I get an error: com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBC01 fault string=XMLA connection datasource not found fault actor=Mondrian While creating the xml/a connection, I looked at the definitions of the sample connections FoodmartXmlaConnection and SugarCRMXmlaConnection. Questions: - Can I create a xml/a connecion in Jasperserver, or do I have to create addional files in a apache/tomcat folder? - What values do i have to fill in for "catalog" and "data source"? I used: Catalog: Regas Data source: Provider=Mondrian;DataSource=Regas; Regards, Jan M

I want to create a new XML/A connection to connect to the mysql schema Regas. When starting an analysis view I get an error: com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBC01 fault string=XMLA connection datasource not found fault actor=Mondrian While creating the xml/a connection, I looked at the definitions of the sample connections FoodmartXmlaConnection and SugarCRMXmlaConnection. Questions: - Can I create a xml/a connecion in Jasperserver, or do I have to create addional files in a apache/tomcat folder? - What values do i have to fill in for "catalog" and "data source"? I used: Catalog: Regas Data source: Provider=Mondrian;DataSource=Regas;

I don't have any clue yet... Any ideas? I am still interssted. Regards, JanM

Thanks for you reply. For each group, I calculate a subtotal with expression: $V{v_sum_amount_1}.min( $V{v_sum_amount_2} ).multiply( $F{factor} ) this means: subtotal := minimum(amount_1, amount_2) * factor Example group: a_1 a_2 charge ---- ---- ----------- 69,0 48,5 € 2.968,03 22,9 34,0 € 985,42 38,5 22,8 € 1.653,96 ---- ---- ------------ 130,4 105,3 € 5.607,41 ==> € 4.527,90 (factor = 43) This factor can be different per group (72.5 or 43) amount_1 stands for the total hours per employee (130.4) in January 2008 amount_2 stands for the maximum amount to charge per employee (105,3) in January 2008 The subtotal value = min(130.4, 105.3) * 43 = 105.3 * 43 = 4527.90 So, I want to calculate the sum of $V{v_sum_amount_1}.min( $V{v_sum_amount_2} ).multiply( $F{factor} ) on report. Any ideas? Regards, JanM

I want to create some kind of timesheet with data of multiple employees. I have created a group on employee lastname. To calculate a subtotal per employee I have created a variable V_SUM_PER_EMP: - variable class type: java.math.BigDecimal - calculation type: sum - reset type: group - reset group: lastname - increment type: none - variable expression: $F{minutes} This works fine. Now, I want to create a summary total to calculate the sum of all minutes for all employees on report. Therefore I can simply create another variable, like V_SUM_PER_EMP with reset group = report. BUT in my report I want to compute the sum of minutes on report, based on variable V_SUM_PER_EMP (because in my real life report the variable expression of V_SUM_PER_EMP is more complex then in this example), so I created a new variable V_SUM_PER_EMP_REPORT: - variable class type: java.math.BigDecimal - calculation type: sum - reset type: report - reset group: - - increment type: none - variable expression: $V{V_SUM_PER_EMP} The result value (printed in the summary band) of this calculation is NOT right. The first group subtotal: 65.92 The second group subtotal: 22.42 The report total: 611.42 How can I calculate the right value?