Portlight

At the risk of sounding really lost - does not importing the common.lang not add it to the classpath when compiling.

inserting the code you have gives me many errors - I have already tried the file you have for download and it gives me the same errors....DateUtils can not be resolved. I replaced your paramaters with my params names. what do i need to look for to resolve these errors

I believe that I could use the getFirstDayOfWeek() any ideas on how to format this in iReports

Can you create the calender strictly using the java.date util I need to group according to a day of the week

I am trying to format a report that groups the data together by week - with each Sunday being the begining of a new week. I have included a screen shot to explain what I am looking for. I have looked at the java commons language and think that my be the answer, however am a little fuzzy on how to format exactly what i am looking for. variable to group on is starttime.

Jasper Reports uses java to calculate dates, crystal reports looks like you can create an sql query, I have created the same query in the st_proc. ISSUE: coming up with three different results code used in st_proc: datediff(S,clstartcalltime,a.cldatetime)/60 as [Response Time], rounds up and does not give the after decimal portion (1.48 minutes) - however this piece of code will need to be removed from the st_proc when I launch the reports. Currently I am merely trying to figure out why I am getting different results. code used in crystal reports: (DateDiff ("s", {CC_Report_CrewHistory;1.Call Started}, {CC_Report_CrewHistory;1.Crew Filled}))/60 (This is the result that I must match using iReports - preferably without changing the st_proc. code used in iReport (java) -$F{Crew Filled}.getMinutes()-$F{Call Started}.getMinutes() does not give me a double it returns an int - which rounds - I need to return or somehow cast this to a double - both crew filled and call started are timedate types in the database. I am including two pics so that you can see the results of each piece of code. Any help is GREATLY appreciated.

Jasper Reports uses java to calculate dates, crystal reports looks like you can create an sql query, I have created the same query in the st_proc. ISSUE: coming up with three different results code used in st_proc: datediff(S,clstartcalltime,a.cldatetime)/60 as [Response Time], rounds up and does not give the after decimal portion (1.48 minutes) - however this piece of code will need to be removed from the st_proc when I launch the reports. Currently I am merely trying to figure out why I am getting different results. code used in crystal reports: (DateDiff ("s", {CC_Report_CrewHistory;1.Call Started}, {CC_Report_CrewHistory;1.Crew Filled}))/60 (This is the result that I must match using iReports - preferably without changing the st_proc. code used in iReport (java) -$F{Crew Filled}.getMinutes()-$F{Call Started}.getMinutes() does not give me a double it returns an int - which rounds - I need to return or somehow cast this to a double - both crew filled and call started are timedate types in the database. I am including two pics so that you can see the results of each piece of code. Any help is GREATLY appreciated. Post Edited by suki at 03/03/2011 14:40

Use irpeorts to layout your jrxml, link the images you wish to see in you ireport format - load these up to the jasperserver and it should customize pretty easily for you. Use the background band as well as the headers to include images.

I need to create a variable called reponse time that is calculated within JasperServer / iReport. I am currently using datediff(S,$F{Call Started},$F{Crew Filled})/60 labeling is ResponseTime both $F{Call Started},$F{Crew Filled} are passed via the stored procedure error given during the compile time is S cannot be resolved Purpose of variable - I need to take the start time and the end time to calculate the time it took from the call to the the time of filling the schedule. I can get it to work in the stored procedure but we are trying to avoid changing the st_proc. Suggestions? Will also be using this variable to get the average time between responses, the shortest time and the longest time.

Is there a way to email the report results from a scheduled report as embedded html instead of as html attachements. This would be extremely helpful for our purposes

I sorted within the st proc and it now works - thank you

I have set up a group based on store number but for some reason it is reprinting the columns of data instead of going to the next group. so the data is printing as such store 1 store 4 store 2 store 1 store 5 store 6 store 1 I need to be able to print each store one time so that the data can be aggregated under each unit. I have tried to accomplish this using groups. What could i be doing wrong.

I need to add some variables to my report using datetime stamp I have the group based on teams i need to add a variable that takes the start time and the end time then averages each project by team name so avg(start - finish) is the calculation that I would assume to use however I am unsure of how to use the datetime fields in calculations withing iReport.

java.lang.UnsupportedClassVersionError: Bad version number in .class file I did have the 4.0 installed - installed seemlessly. I unistalled jasperserver...reinstalled the older version. Purpose: My employer needs me to test the process for upgrading from 3.7 to 4.0. I need to get 3.7 running first! - any help appreciated.

Fixed Post Edited by suki at 02/15/2011 16:37

It is not true. I was looking at a backup file that was created of our system. I found what I needed.

this is the what i am putting in the command prompt C:\Users\jessie.brown.NS-1> js-export --uris = ContentFiles/Covington --output-di r = c:\covington This is the results 'js-export' is not recognized as an internal or external command, operable program or batch file. Do i need to place the js-export script somewhere else or how can i fix this.

I just installed the newer version of jasperserver. This is a new install on a test machine. The 3.7 version still being active on the release machine. When trying to compile reports stored in the directory created for the test machine i get the following error. When trying to compile a report that i pull from the older machine the report compiles with no error. what might i be missing. Caused by: java.io.FileNotFoundException: C:\Program Files (x86)\jasperreports-server-cp-4.0.0\ReportList\Payments\Credit Card Payments.jasper (Access is denied)     at java.io.FileOutputStream.open(Native Method)     at java.io.FileOutputStream.(Unknown Source)     at java.io.FileOutputStream.(Unknown Source)     at net.sf.jasperreports.engine.util.JRSaver.saveObject(JRSaver.java:71)     ... 4 more

When i create a userinput with named variable an xml file is created. Where in the jasper directory tree are these stored and what would the name of the file likely be.

yes to some degree, however strangely enough none of the files you listed are in either instance

I have gone through and made sure that the jar files are added. which files did you add....I connecting to a 2008 ms sql database please

I have installed the jasperserver 4.0 (using bundled options) on a test server. We currently have jasperserver 3.7 running on our main server. I need to add the database connection that is in the server 3.7 to the test server I go through the process of setting up the connnection via the add data source....i am using the same settings which are in the server 3.7 - however the test still returns as connection failed. I made sure that the server name was correct and not localhost. what am i missing

I am working on installing the jasperserver 4.0. I get an error in the buildomatic: install_resources/export/js-catalog-oracle.zip any ideas - i do have glassfish already installed but was hoping not to use this particular installation of glassfish (want to do full install using buildomatic)

yes, that is what i found. I re-read the pages you sent me to. I could not find that in the jasper server 3.7 - are you saying that you can do this in server 3.7 and that there is no need to upgrade

found it in the server 4.0 options! thank you