lisaws

Hi, I am having trouble with a report that has a non-mandatory input which cascades to a mandatory input. In MySQL the report runs perfectly fine, but once I converted it to MS SQL Server and also to Snowflake (which is ANSI SQL), I get the following errors: MS SQL Server: "java.sql.SQLException: Unable to convert between java.util.Collections$EmptyList and JAVA_OBJECT." Snowflake: "net.snowflake.client.jdbc.SnowflakeSQLException: Data type not supported for binding: Object type: class java.util.Collections$EmptyList." For this report the user is required to select a newsletter aka brief, but they can opt to first select an industry. If they do, the list of newsletters should be limited to only that industry. --query for industry input: industry_multi_opt--multi select query--not mandatoryselect distinct categoryfrom dim_brief_subcategory_categorywhere category <> 'Unknown'order by category-- query for brief input-- multi select query-- mandatoryselect brief_key, brief_name from sb_dwh.dim_brief bwhere b.brief_activestatus like 'A%' and b.brief_key <> -999and b.is_main = 1and b.is_dedicated_send = 0and case when $P{industry_multi_opt} is null then 1=1 else b.brief_key in ( select brief_key from link_brief_subcategory_category l inner join dim_brief_subcategory_category c on l.brief_subcategory_category_key = c.brief_subcategory_category_key where $X{IN,c.category, industry_multi_opt}) endorder by b.brief_name[/code]

Hi, I am trying to run a report using Snowflake in iReport. I have the Snowflake JDBC driver as a jar file which I have added to Tools > Options > iReport > Classpath. I have also added it to Window > Services > Databases > Drivers. However, when I try to add Report Datasources via the button at the top of iReport, I do not see the driver listed in the dropdown.

I am having this problem as well. When I click on "Other" and start to type the driver name, I don't see an "Add Driver" button anywhere. Where can I upload my jar?

Sorry for the repost, but I was hoping @hozawa would see my question again since he usually has a lot of good Jasper insight. This is a repost of Limit the amount of data rendered in page? To speed up returning 40,000 rows. I have a report that could potentially return 40k rows, and while the query performs relatively well (~40 seconds), the Jasper interface takes ~6 minutes to render the report. It also makes the browser window very unstable, as 40k rows is a lot to render in the browser. The user does not need to see all 40k rows in the browser - rather, the Excel export is what is important to the user in this case. I googled around and saw an example using SSRS (SQL Server Reporting Services) which has something called Interactive Paging where you can limit the height of the data returned. In this example he/she was able to limit the data rendered in the browser, but upon export to Excel, all of the data is succesfully exported. I'm using iReport version 5.6. (Of course we would like to upgrade to the newest version but that is not an option at the moment.) Is there anything in my version of Jasper that can give similar functionality to the example? To be clear, I want to limit the amount of data rendered in the browser, but include all data ~40k rows in the Excel export.

@Hozawa : I want to retain all 40k rows in the Excel export. I just want to limit the data rendered in the browser.

That looks like a simple report in Jasper. Try reading this wiki: https://community.jaspersoft.com/wiki/basic-report-creation

deleted

I think Jasper schedules are user-specific, unfortunately. For this reason our workaround was to create one user jasper_schedule_user and give everybody the login for it.

I think a quick mock up of what you're trying to achieve would help us understand your question.

On the text element set the property net.sf.jasperreports.export.xls.formula and set its value as the formula you need. Here is an example from one of my reports: <propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA["ROUND((A" +($V{PAGE_COUNT}+9) + "/1000)*M" + ($V{PAGE_COUNT}+9) +",2)"]]></propertyExpression>[/code]Then once my report is exported, the formula for that cell in row 1 (for which $V{PAGE_COUNT} = 1) is as follows: =ROUND((A10/1000)*M10,2) Note that for some reason when I tried setting the property through the report designer it didn't work - it only worked for me when I edited the XML directly.

Question is not clear. What are you having trouble with specifically?

What is the layout of your report, i.e. are you using a table, or are theese text elements in the main report? If in the main report, which bands? Are 'Bankovky' and 'Mince' group values? I've never tried having a row label extend down over several rows. However I would think you could achieve this if you set the stretch type on that row label, then put the rows within it as a table element and pass the value for ex. Bankovky into the table datasource. It would require two separate queries - one query in the main report to pull Bankovky and Mince, and one query in the table datasource that pulls the row details.

Pass the field value as a parameter to the subreport.

I have a report that could potentially return 40k rows, and while the query performs relatively well (~40 seconds), the Jasper interface takes ~6 minutes to render the report. At first I thought it was because of grouping/aggregations in Jasper, but once I moved those to the SQL query the report is still just as slow. The user does not need to see all 40k rows in the browser - rather, the Excel export is what is important to the user in this case. I googled around and saw an example using SSRS (SQL Server Reporting Services) which has something called Interactive Paging where you can limit the height of the data returned. I'm using iReport version 5.6. (Of course we would like to upgrade to the newest version but that is not an option at the moment.) Is there anything in my versin of Jasper that can give similar functionality to the example?

Nevermind! I realized that my workaround #1 actually does work (keeping Detail cells but making their height = 0 px).