paris11

Please I have 2 metrics on my chart : number (integer ) and amount (with 2 decimals) I set this option : plotOptions.series.dataLabels.format = {point.y:.2f} In this case , both metrics are displaye with 2 decimals. I would like to display number with 0 décimal and amount with 2 decimals. Maybe it is not possible

Hi In an adhoc view, is it possible to set a date filter ? For example, I would like to set start_date filter = 1st day of current month regards

https://community.jaspersoft.com/wiki/unexpected-results-andor-performance-issues-group-summaries-ad-hoc-v50-and-later I do not understand, it is already like that in applicationContext-adhoc-dataStrategy.xml <bean> <property name="name" value="DistinctCount" /> <property name="functionName" value="distinctCount" /> <property name="calcMethod" value="sqlUnionAll" /></bean>

I have defined 2 basic metrics in a jasper domain measure 1 : number of cheques = count (distinct cheque id) measure 2 : amount of cheques = sum (amount) 1st ad hoc view, I select the measure 1, here is the jasper query : select count(DISTINCT "cheque"."id_cheque") as "CountDistinct_cheque_id_cheque" from "public"."cheque" "cheque" that s ok 2nd ad hoc view , I select measures 1 and 2, here is the jasper query : select Sum("cheque"."montant") as "Sum_cheque_montant", "cheque"."id_cheque" as "cheque_id_cheque" from "public"."cheque" "cheque" group by "cheque"."id_cheque" limit 2000001 Why the jasper query is not like that select count(distinct id_cheque), SUM(montant) from cheque The jasper query works but gets 1 million rows instead of 1 row and uses 30Mo in memory instead of 0.1

not really, sorry

We have defined a collection parameter filled by a sql query, the list of values is long (more than 2 hundred values) . Is there a way to limit the number of values selected by the user? For instance, the user can not select more than 10 items from the list.

In my report, I have 2 input controls "period start date" and "period end date", jasper is not able to test if the user has selected a startdate greater than enddate?

All is explained there http://www.vikramtakkar.com/2013/03/jaspersoft-passing-parameter-to-tables.html

I have the same problem as you but I does not understand your resolution What did you do to pass the parameter to the data set?

Have you found a solution? I am facing to the same problem regards

How can I pass to Jasper Server the language of the user to have the Jasper interface in the right language (on jasper login page without CAS mode, we can select a language in a list of values).? http://localhost:8085/jasperserver-pro/login.html?userLocale=fr_FR --> it works like that but the userLocale is not dynamic , but how can I replace the value of userLocale by a parameter?

I answer to myself, it seems yes JIProfileAttribute is also included in Jasper community

Little question I use this kind of query to limit the datas in my report parameters select Domain from domain where $X{IN,Domaine,LoggedInUserAttributeValues}So, I do not remember if the JIProfileAttribute table is only included in Jasper Server Pro or also in Jasper Community?thanks

I have the same question Do you have a solution since april?

In my report, I have 2 parameters (start-date and end-date). By default I would like to fill parameters like that "start -date = 'current date - 1 month' ", "end-date 'current date - 1 day' " to select datas of the rolling month. It's easy to do that by SQL, but I would like to do that on Jasper in the definition of the parameter . It seems a lot more difficult in Jasper Is anybody there to help me? please