amit.barkai
-
Posts
24 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by amit.barkai
-
i know you can schedule adhoc report , but i thought if a dashboard behaves like a report with many subreports it could also be scheduled ( or at least it would be nice if it did :) )
-
Hi All i've created several topics that allows users to create adhoc reports , these adhoc reports are used for creating Dashbords . 1. can i create this dashboard as a sceduled report ? 2. since adhoc report are regualr generated report , i want to create a new report with the report designer containing several ahdoc reports for server is that even possible ? thanks
-
i want to know if there is a way to create aggreated function ( MAX , MIN , SUM , etc') on ad-hoc report. for example when creating a Ad-hoc report table from a Topic report if my fields are InspectionDate , ObjectName , Endpoint i want to have the ability to use the max function on the Date field * i know it can be done on DOMAIN , i just whant to know it thats possible for Ad-Hoc
-
Hi All i'm trying to connect to remote database with windows authentication without any success using this connection string jdbc:sqlserver://localhost:1433;databaseName=jasperserver;SelectMethod=cursor;integratedsecurity=true and replaceing the sql_auto.dll to alow windows authentication. whats waired is . windows authentication the connection works only for local databases (even if i used the domain administarator) when trying to connect with sql user everything works fine thanks
-
i know you have the IReport option to create reports for jasper ( i didnt find a way to defined hard code colors for each series ) i want to have the ability to set / edit the chart on Ad-Hoc report
-
Thanks is there any "BigMemory" product you can recommad ? not sure i understood what you ment by tweaking ehcache settings in WEB-INF could you send me an example link ?
-
Hi when queries return huge amount of data .. my queries return ~40 million and even more rows ( a topic report - to give the user the ability to create any report he would like ) 1.jasper fail to load all data ( even when changing the Ad-Hoc Cache limitation) - takes lots of time 2. machine is stating to work very slow 3.memory grows to 3GB and more is jasper build for BigData? thanks
-
Hi All when creating an ad-hoc report with chart element the series color are automatically selected is there a way to change these colors ? thanks
-
JDBC driver is not recognize sql server drives
amit.barkai replied to amit.barkai's topic in Products
it finally worked !! i guess the last step fixed the problem , just did the most common thing that fixes all problems ... restart :) thanks for the help -
JDBC driver is not recognize sql server drives
amit.barkai replied to amit.barkai's topic in Products
still having the same problem i placed the sqljdbc4 file on: 1.Program Filesjasperreports-server-5.1apache-tomcatlib ( on this folder there was another file sqljdbc-1.6-2206.100.jar) 2.Program Filesjasperreports-server-5.1apache-tomcatwebappsjasperserver-proWEB-INFlib 3.Program Filesjasperreports-server-5.1javajrelibext and still i cannot create a datasource for sql server thasnks -
Hi All i'm tring to understand want i'm doing wrong , my steps are : 1.installing the jasper 5.1 server & IReport 2.install the lateste JRE ( the current version is 7.21) 3.download the JDBC 4.0 version 4.coyied the sqljdbc4.jar file to the "Program Filesjasperreports-server-5.1javajrelibext" folder 5.refresh tomcat & postgreSql services 6.tring to create a sql datasources connecting with com.microsoft.sqlserver.jdbc.SQLServerDriver the drive selection item is in red color and i cannot create the datasource (getting a message that the drive is missing) thanks
-
i had the same problem you could also create a reports /view from a "domain" while creating a domain you have diffrent kinds of avaliable fields to add to you dataset ( the domain dataset) and calculation fields are one of them.
-
Hi All im trying to creat an ad-hoc report with a procedure that has insert into temp table and the execution is failed it seems the problem is with the insert into temp table becaouse event a simple procedure didnt worked ALTER PROCEDURE [dbo].[ER_GetScanStatistics]AS declare @aa as table (ID int) --insert into aa values(2) insert into @aa (ID) values(2) select * from @aaget an error nullcheck username as password , is DBMS active ?i am using JDBC connectionthanks
-
well it did worked BUT i used the dataset filer as the following for the left pies $V{REPORT_COUNT} % 2 == 1 and fill the Print When Expression = $V{REPORT_COUNT} % 2 == 1 the the right pie $V{REPORT_COUNT} % 2 == 0 and it looked like this ** when both had the same values it worked fine
-
yes and it didn't help at all
-
yes and it didn't help at all
-
Hi All i am trying to show a list of pies side by side to save place on my report i create 2 pie chart that connect to the same report query create a filter on both pie charts the pie are removed but the removed pies are shown as blank instead being reduced
-
the only way i could generate a report is with single query meaning there is only one dataset ( create from the report query) drag the wanted fields to the report ( or chart in my case) and then the report could be generated another wired problem is when i created a report with parameters and upload the report to the server i still had to manually add the reports parameters (contorls) to the report
-
I tried without any success so far to understand to IReport logic i have a stored procedure with 2 parameters , all i want is to display the procedurte result in a simple table i am using IReport 5.0.0 with sql server 2008 R2 can somone tell me what am i doing wronge 1. i create 2 parameters ( the procedure paramters) on the report 2.create 2 parameters for the procedure dataset 3.create a table object and conected it to the dataset 3.edit the table dataset =>go to the parameters tab and mapped the report parameters to the dataset paramers 4.complied the report while tring to generate the report the user is asked to enter the parameters and noting happen ( the procedure is not executed at all) thanks
-
while trying to add a report that uses procedure with parameters i am getting this exception in the attached file i am guessing i did something wrong thank ahead
-
Hi All i have few questions 1. i want know if there is a way to add a parameters to an Ad-Hoc view ( the parameters need to be sent to the stored procedure) 2. if my procedure contains insert into temp table the creation of the dataset is failed. thanks
-
Hi All after creating an Ad-Hoc report with flat data , i can give the user the ability to create and view he wants . when selecting on of my field as measurable , i can select the summary function ( count / with distinct ) but when trying to set a filter or any other action . the filter is done on the field and not on the measure result is there any way to do so , without the report designer ? thanks
-
while creating a view that contain columns that thier name contains spaces for example Host Name while trying to apply filter on the columns an exception is thrown is it a know bug ?
-
Hi All after adding the wanter row and colunms to my cross tab view , as far as i understood . to see any data a mesureable field was needed. what i wanted to know if there is a way to use a text field for example if my regular data is HostName ItemType ItemValue Host1 AAA 111 Host1 BBB 222 Host1 CCC 333 the wanted CrossTab should be HostName AAA BBB CCC Host1 111 222 333 thanks
