[Is jasper row level security feature available for community edition?]

I don't think it's possible in the community edition via the domain security, but on individual report you can do by means of a custom profile attribute of the LOGGED_IN_USER.

 

[Create numbered multi-level heading styles?]

Did you try using the book - object in JasperSoft Studio. It has a ToC object. The numbering I think you'll have to create yourself, in the SQL statement or with variables.

[Split a field on the basis of delimiter and print all the strings]

What database are you using ?

Can't you do this in the SQL statement ? Most probably SQL and your database will be faster then JasperSoft and Java (or Groovy).

[Jaspersoft duplicated sub report in detail]

Isn't it correct, if a query returns 2 detail records for 1 group, the detailed band is repetad twice.

You'll have to add both sub-reports to the group footer.

[Using a constant in $X{IN, <column_name>, <parameter_name>}]

$X{IN,} is by default an optional parameter ... So in case you do not select any value in your parameter on the server, it will return all records.

[Using a constant in $X{IN, <column_name>, <parameter_name>}]

That's a weird construction. $X{IN, ...} is used in a SQL statement where clause, to be able to filter for possibly multiple values.

In case you would like to verify if a parameter is a given value, I would use the normal where cluase syntax: where $P{someParameter} = 'SomeValue'

 

[how to dynamically adress a report unit as source for subreports]

What version of JasperSoft Studio are you using. When you save the report in JasperSoft Studio and it automatically publishes the report to JasperServer as well, it overwrites expressions for subreports, images, ... You have to make sure you do not overwrite those while publishing.

 

How do you deploy from local DEV to PRD ? I would suggest you do it by using the export/import functionality in JasperServer ... It will automatically copy your DEV structure to the PRD server as well ... You only need to be aware if you also export and import the dependencies, on PRD your datasource connections will be overwritten.

 

[jasper report: custom columns on crosstab]

You need to add that extra information in your total column.

[Dynamic connection to the db]

How do you connect to JasperServer ? What API are you using ?

Normally you should be able to send Username and Password to JasperServer ... Unless you enabled anonymous access, you should be doing so already ... If not you cannot acces Jasperserver. SO it would be a question of implementing some extra code in your Oracle Forms

[Table of Contents display level 1 entries once]

Did you set your bookmark level on the 'Bookmark' fields ?

Are your bookmark fields Level 1 grouped ?

The TOC is generated based on the vertical flow of the report. For each occurence of a bookmark in the report, a TOC entry is generated. So you need to make sure your ToC entries for level 1 appear only once in the report.

[how to dynamically adress a report unit as source for subreports]

Have you uploaded your header - subreports in JasperServer as jrxml files ?

Right-click in the headers folder on one of the jrxml files, and select the "Properties" menu-item

You need to make sure the path-info matches exactly to the "repo:..." syntax, including capitals. It might you have to omit any .jrxml, .jasper extension.

[Query between dates range]

Are you using a date or a datetime ?

What Query syntax are you using ?

• date between $P{p_Start} and $P{p_End}
• $X{BETWEEN,date,p_Start,p_End}

[Custom Visualisation build.js and unpkg.com]

All,

I was able to create a number of CVC elements based on d3.js (v4) and a local js file ... But lately more advanced projects have been created on unpkg.com. Anyone any idea how we can use those in JasperSoft Studio to create Custom Vizualisations ?

Regards,

[How can I arrange my sql result in jasper report in below mentioned format]

Make sure the result set is ordered on SI No. - Order By - Product - Colour

Create 4  groups on SI No. - Order By - Product - Colour

Put all your fields in the group header of Colour

Uncheck 'Print repeated' values for fields SI No. - Order Num - Order date - Order By - Product

Indicate 'Print when group changes'

SI No. -> SI No.

Order Num -> SI No.

Order Date -> SI No.

Order By -> Order By

Product -> Product

That should do the trick ...

 

[Conditional Style Templates]

Hi,

 

my apologies. I overlooked your remark. You can put these conditions in aconditional style. First create a regular style, then right click on that regular style entry and select 'add conditional style'.

In the conditional style you'll then have the opportunity to add a conditional style expression and provide some extra style information like for instance a different color.

 

[how to change alternate row color of sub report passing parameter]

Most probably more detailed information will be helpful to understand your problem ...

But I guess, if you change the colour based on a conditional style with a formula in it containing the rowcount variable, you could pass that rowcount variable to the subreport as well.

Regards,

[Is there a way to dynamically remove column in jasper CSV metadata output based on parameter values]

Can't you do it with a print when expression' ?

[Can we show duplicate row in cross tab.?]

In case the two rows with the same label have a different key value in your source, you can add your key as extra group level in your crosstab (and hide it if needed) so the crosstab will first group on the key and afterwards on the label, resulting in two rows (or columns) for the same label.

Be aware the crosstab will sort on the key in this case, not on th elabel anymore, so you might be creative and cancatenate label '_' key or something like that to preserve sorting.

Regards,

[Conditional Style Templates]

All,

 

I know this question has been asked a few years ago, but I couldn't find any answer for the question. So hopefully, since, the issue was solved, but no-one indicated in previous questions, solution is available now. But my problem is:

I have a jrtx file which contains 2 entries: st_details_odd en st_details_even. In my report I added a reference to the stylesheet, I added a style st_details, with two conditions (I know I could do this with one condition, but was testing the functionality):

$V{REPORT_COUNT} % 2 == 0 => style="st_details_even"

$V{REPORT_COUNT} % 2 != 0 => style="st_details_odd"

But it seems like the conditional styles are not processed at all, as when I deliberatly add a typo in one of the styles, the compiler does not complain at all. But in any case, the specifics for the conditional styles are not appliad at all in teh report.

Anyone knows if this bug has been solved already ?

Regards,

Filip

 

[Domain with two fact tables - How to define which join path shall be used?]

Ernesto,

 

what in case we need via a domain create a JasperSoft Studio report for both fact tables. Say fact_table_1 contains budget data (granularity: month and product), and fact_table_2 contains actuals (granularity: date and product [and customer]). How should we based on these two fact tables with different granularities create a report, which compares the budget on month level with the actuals for that month. In SQL I would create 1 aggregated query for the budget and 1 aggregated query for the actuals and join those. But not sure if I can do the same in JasperSoft STudio (or in the ad-hoc viewer).

 

How should we solve this ?

 

Regard,

 

Filip