[Pre-select all options for 'multi-select query'?]

 

gabrielinux

do not post a link to a 1000 pages of help or comments, a link to Google would have been more useful, your link was not.

moderators remove 

gabrielinux link..... just wastes time

 

[On y-axis of a bar chart, I am getting decimal number in place of whole number.]

thanks subashmy, this answer may work but we have all been trapped into not distinguishing between jasper reports via web browser and the jasper studio, MOST posts online do not help by saying which environment is being used. leading to wasted time and frustration all round. yet another classic documention fail, moderrators of this forum shoudl be activley marking each post for jasper report or jasper studio.... but they wont.

[Last day of the current month]

forgive me but the answers above will be fine for this year but if you want a date in the past year using 

YEAR(NOW()), will give the wrong answer.

its its June now, how do I get the date 6 months ago?

?

One answer is : use the apache commons lang time library

adding this to a jasper report was a difficult and awkward as the rest of jaspersoft and when you finally get it installed, guess what the expressions editor (which has a font that is too small to read) does not give you any intellisence on the classes/methods available, super helpful TIBCO NOT!

then you can add a negative amount of months to get desired result.

new SimpleDateFormat("MMM").format(DateUtils.addMonths(NOW(), -6))

 

[Passing Parameters to a hyperlink from within a Crosstab]

maybe not default functionality but why not create a column in your data for the report which contains the parameter tail for your hyperlink;

eg: client - city - salestotal - hyperlinkTail

John Doe - washington - 123.44 - JohnDoe&CrossTabColumn (this bit will be appended to the hyperlink prefix for reports on your server)

I've had time to test this theory but have done similar on other tools.

 

[how to run the scheduled job for every two hours]

sdinesh 

you have the answer here Hours = 8, 10, 12, 14 etc

Mins 0 for on the hour (as above), 15 for 15 mins past every "Hour's" specified above

[SOLVED - An error has occurred. Please contact your system administrator. (6632)]

can also be caused by calling a stored proc with exec or call in mysql and not having the language set to plsql

although the plsql is confusing as its usually associated with oracle pl/sql ,so poor choice jaspersoft.

but this option is applicable to ms sql server also, but jaspersoft docs and interface as usual are  not so hot on precision of language or even concepts.

hope this help someone else before there are no more jasper soft users left.

 

 

[Simple SQL Query Yet JRS Fails Validation]

problem exists, tibco says "we dont care" thanks for that

[How to compare string value in properties Expression using ireport jasper?]

i'd like to know too as apparently:

"The method EQUALS(String) is undefined for the type String"

who wrote this............

no validation on the expression editor have to exit and run the report to check (WASTE OF TIME)

DOES NOT RUN WHEN validation underlines are not shown, repoirt just fall over at runtime  (WASTE OF TIME)

and just look at teh NOISE and clean structure of the guys query above, fancy maintaining that ? anyone? I dont...

[Remove empty column from report]

try adding an expression to the "Column" (not the cells)

!$F{columnYourHiding}.toString().isEmpty() -- assumes the col is a string type

On "cell tab"  -> "Print When Expression" field

[How to remove column dynamically if column does not have any value]

I dont think any of these answers are correct !

try adding an expression to the "Column" (not the cell)

!$F{columnYourHiding}.toString().isEmpty() -- assumes the col is a string type

On "cell tab"  -> "Print When Expression" field

[hide column if values null]

I find it truly incredible that questions like this get no answer even after 10 years, if a reporting tool is designed to create reports how it can possibly be trusted when deadlines are tight, and the work needs to be delivered.

 

If this functionality is not easily accessible “by default” then there is no point in deploying or even wasting time in training people in the use of Jasper Reports.

 

Then there is the support aspect, every problem I have encountered and there are many trust me, I have had to solve with trial and error. It looks like many others here have simply left this forum and started using other tools because of the lack of creditability of Jasper Studio and reports.

 

 

 

[how to set table row and column heights?]

no you cant !