j.t.casperson

It's very odd, and a little frustrating that say I have a multiselect sql statement that says $X{IN, buildings_field, buildings_parameter}, if I don't select any buildings in the multiselect it will display all buildings as if I had selected all of them. Does anyone know why Jasper does this, and how to fix it?

Would also like to see this feature

It's not always ideal or possible to have certain text written on a Jasper report, is there a way to upload a pdf or docx to a jasper report on JasperServer? (Either saving on the jasperserver or during report generation time)

Sorry, I'm not too familiar with Postgresql. But, I would suggest compiling and previewing the report in JasperStudio (if possible) before trying it on JasperServer. Sounds like the issue is Jasper not liking your sql. I would try simplifying it to something like "select * from parts where not(parts.obsolete)" and then adding on more stuff until it throws the error again. Sorry I couldn't give a more concrete answer.

I'm not sure why I can't comment on answers given, so I'll just leave a comment here. First of all, I really appreciate those who've taken the time to respond to my question. I'm happy to see ways to change element properties and custom elements, unfortunately these don't exactly help this particular question. Since I use a jrtx stylesheet with my reports. The reason why changing properties or using a custom element doesn't work is because I need the ability to change styles via the stylesheet. As it is I have to define the style for every element I add, it works, it's just tedious and easy to forget.

Are you using MySQL?

Have you tried: select * from parts where bin = $P{Location Desired}

I have a jrtx style sheet attached to several jasper reports and every time I make a new text element, line element, table, etc. I have to manually assign the style I want to that particular element. It's kind of tedious to do this over and over again. Is there a way to assign "default style" to an element in JasperStudio so the style can be already filled the second I place an element in my report?

Dynamic column width isn't possible and neither is horizontal stretching in general for that matter. The simple answer is no.

Is your connection from the server connected correctly to where you're trying to pull the data from?

I'm using tables in Jasper and for the life of me I can't find anyway to set a variable on the width of columns. I'd actually like them to stretch width wise so each cell is only a single line of text as a second line (wrapping) would ruin everything I'm trying to do. I read that Jasper doesn't support dynamic width because it can mess up page format. However, I can manually stretch table column widths on a report on the JasperServer so why not let us do it automatically? Anyone?

Thanks! At least I have that for future reference, in the end I just created a new workspace which reset the settings. Not sure how I disabled linked resources in the first place...

According to documentation, in Jasper you can markup with html, styled, or rtf. The supported tags are <b>, <u>, <i>, <font>, <sup>, <sub>, <li>, and <br> I need a way to define my own tags (such as <h1>). I imagine there has to be a way to do this, but so far I haven't been able to find any documentation or answers. Thoughts? EDIT: Thought I should put more information down as to what I'm trying to do. I understand and use jasper stylesheets with the <style> tag, but what I'm trying to do is something like this: <textElement markup="html"/><textFieldExpression><![CDATA[$F{test_field}+" "]]></textFieldExpression> where $F{test_field}'s vaule might be "<h1>Header</h1>" or "<em>italic text</em>". Anyone know if or how this can be accomplished? In this case regular styles just won't cut it because the field is pulling from wysiwyg like editor that has styling available in it and I'd like to keep those styles in my Jasper report.

I keep getting this error everytime I try to publish a report that contains a subreport, which in turn doesn't allow me to upload the report so it's a critical blocker. Reports are running fine on the server and studio. I could upload just fine until about 30 minutes ago and I don't recall changing any settings. ANY IDEAS/LINKS WOULD BE APPRECIATED.

I think I figured out the answer. I'll post it here in case anyone has the same question. Basically you just need to write "<template><![CDATA["repo:Stylesheet_Name.jrtx"]]></template>" just below the properties in your report jrxml file. This also keeps you from having to add the stylesheet to your report on the server as a resource (which takes forever!).