[Sorting data by variable]

I think it is considering as string like 15,16,17,18,19,2,21,22,23...it is considering numbers starting with 1 then again starting with 2, May be resolved by changing the variable type to integer if it is string type

[How to get values from database to ireport]

Hi,

You can achieve this with Crosstab. Explore how to create Row Groups and Column Groups then you can design this by using Crosstab.

[Adding an image from network shared drive into jasper report]

Hi,

I tried to retrieve image existed in network shared drive into jasper report. I am getting byte data not found error.

If any one already faced thisissue, please through some light here..

 

Thanks in advance

 

[Html5 chart(highchart) multiple yAxis]

Thanks for answer yar :)

[How to change checkbox value as parameter(input control) depends on String value (input control)]

write a query for your boolean paramter as 

select case when $P{StringTypeParameter}='k' then 'true' else 'false' end from dual 

 

then if you select 'k' in the first parameter then your second parameter will get true in that.

 

 

 

[Adding Vertical Scroll bar in jasper studio report.]

If you want scroll bar in the browser, then you can go for dashboard, there you can get vertical scroll bar for your report. But you can 't export in if you are using older versions .

 

[How to hide a textfield in main report based on the value returned by subreport in jasper ireport]

For this case, you need to execute that subreport before the textfield, then only you will get correct return value .

And in the properties of SubReport to can find the ReturnValues tab, there you need to add SubReport Variable and Main Report Variable abd calucation type nothing.

While creating the variable in main report the caluclation type should be System.

 

Hope this will work :)

[Error when running a main report using a subreport twice]

Hi Valeria,

If you see the properties of your subreport you can find the Expression , there you need to modify instead of MyDirectory/Subreport1.jasper place "repo:MyDirectory/Subreport1.jrxml".

 

[Domain DistinctCount]

Follow the functions syntax mentioned in "applicationContext-semanticLayer.xml", If u want to add your own functions  then u can add also.

After add any functions restart ur jasper.

Better take backup file before changes.

[Return previous value of the group]

check the running sum concepts in sql, it may helpful

[Linked resources are not supported by this application jasper]

This error occures when u disable the Linked Resources in Jasper Studio

Enable the Linked Resources , that u can find in the following path

Jasper Studio->Window->Preferences and follow the below screen shot steps

 

[Linked resources are not supported by this application jasper]

This error occures when u disable the Linked Resources in Jasper Studio

Enable the Linked Resources , theat u can find the following path

Jasper Studio->Window->Preferences and follow the below screen shot

 

[Email validation]

if you have ur mail like

name@company.e.com

then also it will work, end ur email with ".com" or some thing else u have, and check, it will work .

I think no need to disable validations for this .

[Reports in Dashboard not running.]

This error comes because of not able to find files related to that reports or clashes beacuse of your customization files.

check the customizations and replace the original files of jasper and check.

[Date format in url parameter]

For this try to manage in drill report query, In the query pass the date after change the date format....like

your DateField=Cast(DateParameterValue from URL,'mm-dd-yyyy')

If u manage like this in ur drill report query , then what ever the date format from url, throught query automatically it will change.

[can i send my report as attachment ? helpppp meee please]

send the screen shot of ur design in IReport, then atleast we can understand some thing related to tables positions.

[Print repeatetive value in table column]

HI, If u r getting empty cells through out the complete field then u can remove that empty cell row by "Remove Line when Blank " option. send the screen shot of ur result set to understand ur issue exactly

[Detail Report drill is not working for Adhoc-Reports created from XML/A connections]

Detail Report drill is not working for Adhoc-Reports created from XML/A connections, If I click on any drill of any measure ,I am getting error like below. How to get the detail report

The below adhoc report I have created using OLAP View (created using XML/A connection). In that OLAP View also the drills are not enable.

Please give any suggestions

 

[How to make my report like this?]

In the report properties you can increase the no.of columns,by default the property value set into 1

[Print N/A when field is null]

with a conditional expression you can print "N/A" when the field is null , But your field should be string type other wise u will get type casting error

$F{field_name} !=null ? $F{field_name} : "N/A"

[Error executing SQL statement]

Hi,I think the problem is with allias names of the columns, Give the allias names with in double quotes and check if it not works then check the right syntax to give allias names to the columns.

 

[How to associate color code to record in report]

Hi, You can achieve this one with conditional styling.Create a style with conditions like below and then apply that style in your style properties