[Access Denied after selecting data during AdHoc creation]

When I try to create an adhoc view, I get "access denied" after selecting a data source, and actual data that I want in the report.  I put read permission to the Domain folder and Adhoc folder, is there another folder that permission is required to?

[Right alignment not working?]

When developing a report, I have a header that needs to be right aligned.  In designer, preview, and PDF, it works perfect.  However, once it is in the repo (in Clarity for my case), the right align seems to not work.  The weird thing is, if I hit the PDF version from clarity, the alignment is fine.

In Clarity:

In PDF:

you can see how the right align works perfectly in the PDF, but not in clarity.

I am using Jaspersoft Studio Professional 5.6.1 final

 

thanks!

[Query for input control wont work in Jaspersoft, but works in My SQL Server]

I have an input control that will need to be populated by a query. When I wrote the code in My SQL Server, it works perfectly as planned. However, when I put it in the the input control, the drop down is blank. Are cases not allowed in the input control queries? Is there a work around?

here is the seemingly simple sql code:

 

SELECT a.PRSTART as date,

  case when(a.prstart <= getdate() - 7 and a.prfinish - 1  >= getdate() - 7) then 'Previous Period'

            when (a.prstart <= getdate() + 7 and a.prfinish - 1  >= getdate() + 7) then 'Next Period'

            else 'Current Period' end as period

        FROM   PRTIMEPERIOD a

        WHERE 

        (a.prstart <= getdate() and a.prfinish - 1  >= getdate())

        or

        (a.prstart <= getdate() - 7 and a.prfinish - 1  >= getdate() - 7)

        or

        (a.prstart <= getdate() + 7 and a.prfinish - 1  >= getdate() + 7)[/code]

as you can see, I need to return "Previous", "next", or "current time period" dynamically along with the date calculated. for the input control, previous, next, and current would be the visible field, while the date would be used as the value column.

thanks!

[How do you resolve Socket Closed?]

One of the reports that I have prepared is quite extensive, and takes a little bit more time than my other reports to run if you only use one parameter.  When still in the iReport, using one parameter, it does run after some time.  Once I publish it though, after attempting to run for about 3 minutes or so, I get

Socket Closed[/code]

I'm assuming that it is taking too long and it is timing out.  I've cleaned up the code to make sure only the necessities are there, and I cannot change the report.

Below is the error:

Any ideas?

[Display sum in a group header]

thanks! this did the trick

[Anyway to subtract from a "global" variable?]

For anyone in the future, one way to do it is like this:

 

http://stackoverflow.com/a/37453635/6078849

 

[Anyway to subtract from a "global" variable?]

Yes, I've tried this, but when done like that, for each record, $V{Hours} is subtracted from the initial $V{TotalHours} rather than subtracting from the new value.

[Is there a way to alter the expression of a variable during the reports run?]

Is there any way that one variable can change another variables expression..

 

for example:

If the expression for $V{v1} is 500

can we set $V{v1} to be $V{v1} = $V{v1} - 50  ... i know that wont work, but is there a way to actually accomplish this?

What i need to do is take a number and for each record i need to subtract a certain number from it continuously.

[Anyway to subtract from a "global" variable?]

In my case, i have one variable that is $V{TotalHours} -- these are the hours in which can be used.  Each instance in the report has its own field $F{Hours}.  I will need to somehow continuously subtract from $V{TotalHours}.

 

For example:

Total Hours = 100

the first record will be 100 - hours

the second record will be ^that new number - hours

the third record will be ^that new number - hours

etc..

kind of confusing.. Any ideas?

[any way to make a triangle?]

this might be a stupid question... But I notice there are eclipses and sqares, is there anyway to do a triagle? Something that im missing maybe?  I need them to indicate increases and decreases visually on a report... if not, I guess the best bet would be to use triangle images and use the expression field on when to display it.  Any ideas??

 

thanks in advance!

[What happened to my class types?]

I am trying to make a new parameter, but when I go to change the type class, it is not populating with results.. Any ideas for a solution?

Thanks in advance!