[Date pattern consideration for the adapter]

Hi,

I am using this adapater. In order to specify the date pattern, I am using net.sf.jasperreports.json.date.pattern property to let jaspersoft know the date pattern appears in the JSON data. This is working fine. Now I want to expose the report as a topic. When I create adhoc view, I am getting exceptions on date fields. Is there any way, we can set configuration for this adapater about date patterns?

Please suggest.

Thanks

Gowtham

[UNION in webservice queries]

Hi,

I would like to know how to define "ALL" for input control queries. I am following below syntax for input conrol values which is working fine. But I want to add "ALL" as an additinoal value.

The working format without "ALL" value

{

  "fieldsMap" : {

    "key" : "key"

  },

  "getparameters" : { },

  "fields" : [ {

    "name" : "key",

    "expression" : "key"

  } ],

  "options" : {

    "contentType" : "application/json",

    "rootPath" : "aggregations.groupby_value.buckets",

    "baseUrl" : "groupby_value(field='cityName')"

  },

  "headersMap" : { },

  "queryData" : "",

  "GETParameters" : { }

}

 

Thanks

Gowtham

[Dashboard Export Error]

PhantomJS is installed on the computer hosting JasperReports® Server. For information on configuring PhantomJS for dashboards, see the System Configuration chapter in the JasperReports® Server Administrator Guide.

[How to show/hide input controls in Jasper Reports in Jasper Server 6.1]

Hi Hozawa,

 

Thank you for your response. But I want to have this feature in jasper portal itself. Please suggest how to ahieve this.

 

Thanks

Gowtham

[How to show/hide input controls in Jasper Reports in Jasper Server 6.1]

Hi,

I have a report which is published to Jasper Server 6.1. I have serveral prompts in the same report. I would like hide few prompts based on other prompt values.

Please suggest if anyone has come across similar requirement. Any guidance is very helpful.

Thanks

Gowtham

 

 

[ROLE Navigation control for roles defined for multiple tenants]

HI,

I defined few custom roles to control menu navigation for Create Report, Create Adhoc, Create Dashboard and Create Domain. 

The conditions defined as part of actionModel-navigation.xml is working well for ROLES defined at ROOT level. But if I create the same ROLE at tenant or organization level, the menu control is not working.

These new custom roles are present in all my organizations. I have close to 500 organizations. I want to apply the menu control navigation to all these tenants.

Any one please suggest, how to enable menu control navigation to roles for all tenants? I am able to do it by specifing "|" symbol and tenant name. But I want to apply it to all tenants.

Please help.

Best Regards

Gowtham

[Ad Hoc Domain parameters]

Hi,

 

I am unable to access given link: https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/profile-attributes

 

Can you please check once?

 

Thanks

[Math.round() to two decimal in Ireport V5.0]

Hi,

Can you please share your experience in migrating from cyrstal to Jasper. I am in the similar situation.

Best Regards

Gowtham

 

[Can we split PageHeader and other bands the way we do in Crystal Reports?]

Hi,

I am trying to replicate a report developed using Crystal Report.  The crystal report has a pageheadera and pageheaderb. I mean to say the pageheader splitted as two separate page headers.

Can we do the same thing in Jasper?

Best Regards

Gowtham

[How to compare constant value with multi value parameter in Jasper?]

Hi,

I have a paramter named as param_multi. I would like to add this as part of my sql as follows:

Select * from employee where  184 in ( $P{param_multi} ).

Can anyone suggest on how to do this?

Thank you

Regards

Gowtham

[Clear differences between normal http way of embedding vs visualize.js way of embedding?]

Hi,

I would like to know what are the exact differences between the way we embed report susing HTTP based way vs embedding by visualize.js.

Is there any performance issue? I stil see its taking time to load when used using visualize.js.

Thanks

Gowtham

[Browser error on first visualize.js attempt]

I too faced same issue. When I used localhost, if I place the files in the server, then only it worked.

But its working well when using JSFiddle. Why its not working in a different machine fi we create a nromal html file?

Any info please?

Thanks

Gowtham

[How to calculate % over total calculations?]

I looked at the Report State. Somehow its not displaying the information in the Console section in ReportState Pane. I raised a issue with Jasper Soft Support Team on the same.

 

One more last quesiton I would like to check with you. Can a script returns data collection and multi dimensional array? I would like to know if I can use the result of scriptlet as a source dataset for Charts. This would help in dealing with complex calcuations.

 

Best Regards

Gowtham

[How to calculate % over total calculations?]

Thanks a lot. Any idea how we can see the "Report Output" in Jasper Studio?

 

You are providing all the needed help with lot of patience. I appreciate your helpingness.

 

Thanks

Gowtham

[How to calculate % over total calculations?]

Thanks Ankur for detailed explanation. I understand the first one. But it seems when I used system.out.println, the output is not being displayed anywhere in the report. I am wondering, how we can verify this. Please suggest.

[How to calculate % over total calculations?]

The jar file contains only class file. can you please provide the java code too to undestand better?

 

Thanks

[How to calculate % over total calculations?]

Thank you Ankur for your response. I have couple of questions on the way scriptlets work.

 

1. There are some methods beforeDetailAvail, BeforeReportInit(), AfterReportInit() and so on. I have defined system.out.println(). But when I run the report, the output is not being deisplayed in the report by default. My understanding is that, these default methods will be called whenever we define a scriptlet and assign to the report.

 

2. After using scriptlet function, we run the report first time. Assuming that the values appear correctly. When we referesh the report to fetch latest data, does scriptlet uses previously saved values?

 

Please share your thoughts on this. Thanks a lot!

[Why are null values in my crosstab blank spaces and not '0']

One caution here is that, this setting this option will change "Null" values as "0" for reports created using Adhoc views. For reports created using Jasper studio, the null values will appear as null. In order to handle nulls, we should put a condition as follows:

<field Name>== null ? 0: <fieldname>

HTH

Gowtham

 

[How to calculate % over total calculations?]

Hi,

I have a requirement where I would need to perform calculation as % over total.

Here is the sample data format I am looking for. 

Product	Type	Sales	% over Type Sales
P1	G1	10	25%
P1	G2	20	50%
P1	G3	10	25%
		40	100%
P2	G4	30	30%
P2	G5	20	20%
P2	G6	50	50%
		100	100%

I tried multiple ways to reach this layout. But I am not succedded. I tried using Grouping over details band. I also tried using Cross tab.

Any suggestions or help is very much appreicated.

Best Regards

Gowtham

[Different Authentication methods for Different Organizations]

Hi,

I have three organizations. I would like to use different authentications for each organization.

For First organization, I would like to use LDAP and for Second Organization I would like to use CAS and to use default authentication for Third Organization.

Any suggestions on this please.

Best Regards

Gowtham

[Enforcing "Group By" Clause for Domain based reports]

Hi,

I am trying to enfource group by clause for reports based on domain.

I am using the tag <group> to enforce group by clause. But its adding "Order BY" cluase. 

Link: http://community.jaspersoft.com/wiki/parameters-domain-based-reports

Is there any way we can change the behaviour of this by enforcing it as "Group By" clause?

Thanks

[Data Preview is showing 0 records when report is created using domain]

Hi,

I have created a report using domain. I am facing the following issues:

1. Data Preview tab is not showing data.

2. Drag and drop option for selecting fields from domain for report is not working. I need to manually edit the xml text fields.

When the report is exported, the report is showing data as expected from Jasper Server. But the same is not showing any data in Jasper Studio.

Any help is useful.

Thanks

Gowtham

[Creation of Domain based Report using Jasper Report Studio]

Hi,

Can any one please explain how to create a report based on Domain in Jasper Studio?

I dont see any option in Jasper Studio. The same can be done using iReport Designer.

Thank you in advance!

Gowtham

[Scriptlet Methods are not working well when using in Charts?]

Hi,

I created a scriptlet to define a custom method. The custom method captures the last 2 values and do an average with the current value. Its like 3 month Moving average. 

This is working fine when placing the custom method using a text field or a variable in the Details section.

I would like to use the same in charts. I created a chart in Summary Band. It seems, the calculation is not working.

Any suggestion please?

Best Regards

Gowtham

[Error loading class while using scriptlets in Jasper Studio]

The scriptlets are working when placing the Java class and the report in the same project. If both are in different projects, as you mentioned we need to add the jar file using the above mentioned method. But the option you have mention is disabled.