[adding adhoc report as subreport]

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 :) )

 

[adding adhoc report as subreport]

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

 

[aggregated function on Topic fields]

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

 

[Connect to remote database with windows authentication]

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

 

[setting colors for Ad-hoc reports]

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

[Bad performance on Bigdata]

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 ?

[Bad performance on Bigdata]

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

 

[setting colors for Ad-hoc reports]

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]

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]

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

[JDBC driver is not recognize sql server drives]

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 

 

[Ratio of Measures in Adhoc View]

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.

[insert into temp table doesn't work]

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 @aa

get an error  nullcheck username as password , is DBMS active ?

i am using JDBC connection

thanks

 

[print pies side by side]

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

[print pies side by side]

yes and it didn't help at all

[print pies side by side]

yes and it didn't help at all

[print pies side by side]

 

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 

[generate report with parameters]

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

[generate report with parameters]

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

[Exception while trying to generate a report with parameters]

 

 

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

[how to add parameter to Ad-Hoc view]

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

[add filter on measurable field]

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

[Filter cannot be applied on columns names with spaces]

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 ?

 

[text value on CrossTab view]

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