Thomas Zimmer

$V{PAGE_NUMBER} != $V{PAGE_COUNT} will not work, because PAGE_COUNT counts the records on a page, not the pages themselves. instead, simply use the band "lastPAgeFooter" and leave it empty. Cheers, Thomas http://www.thomaszimmer.net

edit: sry, zooming is NOT an option:so then just zoom your report until the fields are big enough to show the content. at some point of content size you won't be able to see it anymore in design view : only: beside you do not shrink the font size :works pls. post the report to understand better Thomas

create field(s) in your report, they will hold the content of your records/bean. then create text field(s) in the detail band with expression $F{field-name} to show the content. Thomas

you can achive this quite simple with the brand new cool DateRanges in jasperreports: 1. Define a first parameter in your report, which gets the count of days you want to go back. In an input control in jasperserver (if you use that), you can build a combo box selection with a static value list, where the user sees 'latest 7 days records','latest 30 days records','latest 90 days records', but the passed value is an integer. 2. Define a second parameter, which's type is "net.sf.jasperreports.types.date.RelativeDateRange" and initialize it with an expression, usinf the user's selection: "new net.sf.jasperreports.types.date.DateRangeBuilder("DAY-"+$P{selector}).toDateRange()" Then you can use the second parameter, e.g. in a sql statement by typing ".... WHERE date_colum >= $P{param2}.getStartDate()" See the attached report to make it more clearly :-) Cheers, Thomas http://www.thomaszimmer.net

do not copy .jasper files to the server, it will not use them. a delete of the .jasper file would have had the same effect, because iReport doesn't find the compiled report then, an compiles it again from the jrxml. Jasperserver caches the compiled .jasper files (ivisible to you) and stores the for a re-run. but jasperserver also recognizes changes in the jrxml, so that it recompiles, if the jrxml is change/uploaded. Have fun, Thomas

I'm wondering if indeed your column 'i.sku_id' contains a 'Y', 'N' or NULL? You are comparing 'i.sku_id' with the parameter... i would assume, that you have only data output now, if the parameter is null. Cheers, Thomas http://www.thomaszimmer.net

that's not possible. not without hacking the server code. only administrators are allowed to set permissions. and there is no user-level permission manging. you will have to create a role per user, then restrict access to the folder only to the user's own role. Cheers, Thomas http://www.thomaszimmer.net

let me say, there aren't any stupid questions, stupid answers only. The text is there, you just can see it in the design view. I assume the text shows correctly, if the report is executed? if not, do the following: shrink the text, you will see it. activate the option "Print When Detail Overflows", you should see a part of teh text at least. if you want to see the whole text, transform the 'static text' to a 'text field', then activate options "Print When Detail overflows" AND "Stretch with overflows" Cheers, Thomas http://www.thomaszimmer.net

At first, I would say, your question ist not completely clear. what does "in a tabular form mean"? horizontal or vertical? ist the count of passed values static or dynamic? normally you would put your data record by record in a bean (her simply a bean containing a date), and then put the beans into a collection and then instantiate a JR Bean DAtasource. Design your jrxml report to show record after record in the detail band. Have a look here: http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRDataSource.html or here: http://javabeansinjasper.blogspot.de/ or many, many other resource simple to find by www search. Cheers, Thomas http://www.thomaszimmer.net

log in as superuser (pw: superuser). navigate manue Manage > Server Settings > Ad-hoc Settings here the display of ad-hoc records is set to 200.000 by default. Cheers, Thomas http://www.thomaszimmer.net

you will have to compile (or preview) the subreport before re-running the main report. Ireport will not recognize changes in subreports, if it finds them already compiled... Cheers, Thomas http://www.thomaszimmer.net

that looks virtually impossible. pls. post your report Cheers, Thomas http.//www.thomaszimmer.net

as far as your example shows, that's not an ad-hoc report, it'a simple report. With this simply create your report with iReport, it should hav all the three parameters (with correct datatypes List/String/Int whatever). Of course you do not hav to use all the three in the report query, just use the last. Cheers, Thomas http://www.thomaszimmer.net

After "organizations/..." you have to put the unique id of your organization, then the path. Like this: .../fileview/fileview/organizations/Organization_2/Reports/Samples/Employees.pdf? And you were absolutely right about the file extension, it is not needed. Greetz

no differences at all, except for different version numbers. I always used the originals. for ETL that should be no problem at all. Within workbench i don't know, if the xml specification of the schema design jasperserver uses is 100% compatible Cheers, Thomas http://www.thomaszimmer.net

use a secondary dataset with groups, then define the table using the dataset. Cheers, Thomas http://www.thomaszimmer.net

your question did not get better, posting it twice! nobody knows the structure of your website. check the documentation of jasperreports server, possibly webservices can work for you. There are samples in the server-dir: jasperreports-server-cp-5.0.0samples... Cheers, Thomas http://www.thomaszimmer.net

yes, barcode4j supports code128, too. the barcode4j must have an option like "textPosition", set it to "none". unfortunately no property to align the bar code. either set a constant width (if possible) or use a minimum width and let the barcode shrink, if the code expression gets longer Cheers, Thomas http://www.thomaszimmer.net

what (the hell) does "a minor change in query" mean? what looks the report like? Cheers, Thomas http://www.thomaszimmer.net

sure. if your datasource really delivers a collection of collections, or at least one element of your fields is a collection of beans, then you can use that field to create a new bean datasource. otherwise it won't make sense. Cheers, Thomas http://www.thomaszimmer.net

possibly the extension ".pdf" is missing? i tried and works fine for me... Cheers, Thomas http://www.thomaszimmer.net

you could have selected that within the installation... 1) shutdown the jasperserver 2) to change later, modify the "server.xml" in "/apache-tomcat/conf/" Search for Connector port="8080" and change for your needs. if there is another tomcat instance running on your system, it would be a good idea to change the shutdown port as well. 3) start the server Cheers, Thomas http://www.thomaszimmer.net

define a parameter in your subreport (as type DateRange). in your main report select the subreport element and add the Date-Range value to the parameter list in subreports´ properties. Cheers, Thomas http://www.thomaszimmer.net

I assume they removed this option in the Express version, as the open source versions always targeted a local, single machine and single user development of ETL Projects. Cheers, Thomas http://www.thomaszimmer.net

which version of jasperserver are you using?