mwarner_2

I'm using Studio Let's say your collection parameter is called Groups. This is the what the user will see and chose from when making their selection(s). Create a string parameter (Physically located down under the Groups parameter) called Groups_String, with this default value: $P{Groups}.toString().replace("[", "").replace("]", "") Uncheck "Is For Prompting". In your dataset dialogue, where you might have had this ...@Groups = $P{Groups}..., change it to ...@Groups = $P{Groups_String}... Now your SQL is getting a string.

How use a Language parameter to set the number format on the report? I want to offer the report-runner two choices in the Language parameter: en-US, and de-DE. American and German. If that choice is 'en-US', then I want the number format shown in the reports like 1,234,567.89 If that choice is 'de-DE', then I want the number format shown in the reports like 1.234.567,89 How can I do that? Please and thank you,

I have a report with a table component (for export to Excel). Also the report has a No Data section, to show the user if they made input control selections that result in no data being returned. This section has an error message as well as their selections. So the way Jaspersoft handles this sort of a report: it first quieres the database in the Main Report, to see if there is any data. If not it goes to the No Data handling. If there is data, then the table component is run, which results in a second query to the dataset. This is at least twice as inefficient as it should be. Is there any way to make this work with only one query to the database?

Have Studio Professional 6.3.0.final. In my previous version of Studio, after I had entered some input control parameters and Preview-ed the report, those input control parameters were saved. So if I went back into Design, and say added a new field to the report, and then re-Preview-ed the report, those parameters would be pre-filled in for me. But now in 6.3.0, the previously-entered input control parameters, are not filled in for me. Like they were not saved or the saved values are not displayed. Really painful when I have lots of input parameters. Is this a bug?

Using 6.3.0 Studio Professional and publishing to Jaspersoft Server (Enterprise, 6.3.0, 20160621_1840) I used to be able to have multiple identical images in the same report. Think a .gif for checkboxes in columns. Or .pnf for a company logo on the report titles, Summary, and No data pages. Now, for just one image, each time I publish (regardless if I have touched the image), I must always Overwrite the existing image, or I get "Byte data not found..." error. That was never the case. I used to be able to Ignore. If I attempt to have two or more of the same named images no matter what I do, I always get the "Byte data not found..." error. That also was never the case. Is this a bug? Or is there a way around this?

In the attached screen capture of Jaspersoft Studio Input Controls (of a specific report), the "seq" input control can not be reordered to be listed before the "trans_id" input control.

Changed Resolution from Fixed to Open Changed Status from Resolved to New In Jaspersoft Studio 6.3, there is no way to reorder the input controls for a report (once the report has been exported from Studio). They can NOT be dragged and dropped. The only way to re-order them in Studio, is to delete them and then reimport them.

I do not have a resolution to my question. Wish there were one. I do appreciate you being the only person to attempt to answer this question. I down voted your solution because as you said "none of the boxes will be checked". And my question was about how to check all the boxes. I would remove my negative vote, but there is no way to reset it back to zero.

How were you able to solve the problem where IE zoom was not zooming?

Idea off the top of my head. Haven't tried it. Can you use a Return Parameter, and then use a Print when Return Parameter .equals(null) ? I just tried this, and I had no luck making it work. Sorry.

And by doing this method, then all the checkboxes for $P{m_parameter} will be checked (instead of the usual unchecked)???

For all the fields in that row (particularly for the field that might go over its width) is Properties / Text Field / Stretch With Overflow: checked. Then for all the fields in that row Properties / Appearance / Size / Stretch Type: Relative to Tallest Object. Then to vertically line up the values in that row, you might want to set all the fields to Properties / Text Field / Text Alignment: Top.

I can't do method 1 because I don't know those values ahead of time (and those values change). So I am trying to do method 2. You talk about the query for method 2. By this you are referring to the JS Server input control query for the multi-select checkbox? What is table_2, and column_2? Is $P{abc} defined as a string, or a collection, or as a what? And by doing this method, then all the checkboxes for $P{m_parameter} will be checked (instead of the usual unchecked)???

Is it possible to default check all the checkboxes for a multi-select query input control? If so, how? I have a Jaspersoft Server defined input control, and it is a multi-select query. Say the underlying database query is something like 'select all cities where the temperature yesterday was above 62 degrees'. The query would have different results every day, which means that I don't know ahead of time what the possible results of that query will be. As it is now, in Jaspersoft, not selecting any values in a multi-select input control is the exact same thing as selecting all the values. But the customer wants all the checkboxes for that input control to be checked by default (when they first see the control). I have not seen any thing in Studio or Server where I can default check the checkboxes for a multi-select query input control. Thank you.

You could... Create a "Excel or PDF" input control. Create two different sections in your, one for PDF, one for Excel. Use the Print When expression to control which section is shown (depending on the input control choice).