Ad Hoc

Synonyms: 
Adhoc
adhoc
ad hoc

How do I export an ad hoc view into Studio?

I've created a highly stylized, formatted report base in Jaspersoft Studio that I want to pull ad hoc views into, and for the life of me cannot figure out how to do this. I have found the ad hoc views in the repository, but cannot seem to get them to open on the page.

 

 

allyson.tessmann's picture
Joined: Apr 7 2015 - 8:42pm
Last seen: 2 weeks 2 days ago

0 Answers:

0

Unfortunately, AdHoc View is using a different layout format than Studio. It's possible to save AdHoc View into AdHoc Report and then to use Studio to customize the generated jrxml file.

hozawa's picture
3898
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 day 19 hours ago

Thanks for the response. I tried to save it as report and put it into Studio, but I couldn't seem to add the report to my formatted template, nor really figure out any way to edit the report when it opened in Studio. Any suggestions?

allyson.tessmann - 2 weeks 2 days ago

Pages

Pages

Adhoc editor slow

I am creating an adhoc view based on a domain. The query without filter brings in large amount of data and we are fine with the time it takes to load data. But while creating an adhoc view, the editor runs the query multiple times for adding columns, for grouping by a column, for adding a filter on a column. It takes really long time to create a filter and to group by a column even with sample data (vs. Full data) as the editor adds a group by clause. Using "No Data" is an option, but our users would probably end up trying the default option - "Sample Data".

natarajat's picture
Joined: Jan 7 2014 - 11:30am
Last seen: 3 weeks 6 days ago

0 Answers:

0

Few things to do here:

  1. The best one of course is a faster database - take a look at columnar database technology, this will give you a very fast boost! MySQL, SQL Server and now Postgres have columnar datastores available for them.
  2. There's the possiblity to work "in memory" instead of in-database as is the default mode. See the "Optimize Queries for Domain-based Reports" options documented here http://community.jaspersoft.com/wiki/configuring-ad-hoc-cache 
  3. You might consider the "no data mode" by default - I'm sure that toggling this requires some change in javascript or jsp somewhere in the server (not sure where!)
ernestoo's picture
814
Joined: Nov 29 2010 - 11:59am
Last seen: 1 week 2 days ago
0

Facing the same problem. Looking into using in-memory database and RAM drives (not SSD) if the data fits in memory.

There's also the problem with cache not being updated when underlying data changes but this is another issue. :-(

 

EDIT: Tried using columnar database without too much difference in performance. Performance problem is with Table - Group and with Crosstab - Columns. Filtering is also slow. The problem seems to be  with the JasperReports Server software architecture because I can process over 2,400,000 statement details to generate over 120,000 pdf files with just souped up JasperReports library in under 10 minutes.

Database is returning result set in under 10 seconds but the JasperReports Server is just too slow processing the result and displaying.

hozawa's picture
3898
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 day 19 hours ago

Pages

Datetime filter in ad hoc view doesn't work

Hi,

I have created a simple domain that gives access to a table with a datetime field. My data source is MS SQL and the date time format is yyyy-mm-dd hh:mm:ss 

I am trying to create a simple ad hoc view using that domain and I put the datetime field in the column. When I try to create a filter for the datetime it is created but nothing happens. 

When looking at the logs I see exception.

 

What am I doing wrong? 

guy.morgenstern's picture
Joined: Mar 23 2015 - 12:57pm
Last seen: 1 month 2 days ago

0 Answers:

0

@guy.morgenstern  Re: I think that the problem relates to the fact that Jasper is using timestamp type and I am using datetime type in my MS SQL Server. 

I think you are right here, you can change the default domain type mappings by changing them in /WEB-INF/applicationContext-semanticLayer.xml search in that file for the bean called "jdbcMetaConfiguration" you will see that it has a property (jdbc2JavaTypeMapping) that maps the DB types to the Java Types that jasper will use, make sure that the mapping is correct, I have not seen this issue with MS SQL server but it happens some times with some Oracle data types (you will see some of them commented out in the file).

Hope this helps.. either way @djohnson53 is also in the right path, this may be something that can be changed at the Domain level.

marianol's picture
2386
Joined: Sep 13 2011 - 8:04am
Last seen: 2 days 9 hours ago

Pages

Use Data Staging with Jasper Studio Report

Hello,

I have some reports created with Jasper Studio 6.0, in these Report  I have used a dataset to extract the data from DataSource,

In the Jasper Server, is possible create Ad Hoc View and Report with DATA STAGING functionallity to cache the data, Now , is possible to use the DATA STAGING functionallity also for the report created with Jasper studio..???

 

Thanks Max

 

mm972's picture
41
Joined: Jan 21 2015 - 2:58am
Last seen: 1 month 6 days ago

0 Answers:

0

Unfortunately that cannot not be done. Data staging is based off domain topic, which isn't part of jaspersoft studio.

 

nthapa's picture
455
Joined: Jan 24 2014 - 9:53am
Last seen: 1 day 3 hours ago

Thanks very Much
max

mm972 - 1 month 1 week ago

Pages

Pages

Report creation fails with ad hoc view using table with group on calculated field

I have an ad hoc view that has several calculated measures in the columns and a single calculated field in the group area (this is a table displaying totals data only). When I try to create a report using my ad hoc view, I'm getting the following error:

dwalton_1's picture
Joined: Feb 24 2015 - 10:12am
Last seen: 1 week 1 day ago

0 Answers:

No answers yet

Pages

AdHoc Pie Chart Adding Datalabels (AWS)

Hello,

using Jasperserver 5.6 on AWS.

I am trying to add DataLabels to the Piecharts in Ad-Hoc Editor For this I changed scripts/adhoc/highchart.datamapper.js as following

 

stegmann's picture
Joined: Jul 18 2013 - 6:50am
Last seen: 1 month 3 weeks ago

0 Answers:

No answers yet

Pages

Pages

Feedback