![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
jbowman_1
-
Posts
2 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by jbowman_1
-
-
We are using SQL and a view to get our data.
We are using ad hoc views to back the reports.
The database has alot of records.
When it goes to load the filters it is taking 1.5 minutes per filter to load. There are 7 filters on the report that we are currently working with.
What options are there to minimize the load time for filters? In the ad hoc settings there are two policies. We have the Optimize Queries for Domain-based Reports checked and the Optimize Queries for JDBC-based Reports unchecked. What is the recommended setting values when dealing with SQL databases and views?
I have created a Jaspersoft Studio report and am getting Conversion failed when converting from a character string to uniqueidentifier with one of my parameters
in Products
Posted
I am creating a report and trying to filter it down to certain locations. Our IDs are all uniqueidentifiers. When i try to do
$X{IN,Table.LocationID, LocationID}
Where the LocationID is a defined parameter as a java.util.Collection class type I get the conversion failed.
How can I get results for my report where a Guid is in the passed in collection?
I have tried Casting the Table.LocationID as varchar and that didn't work.