Jump to content
We've recently updated our Privacy Statement, available here ×

Code_Slave

Members
  • Posts

    40
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by Code_Slave

  1. thanks, sorry I had some sort of breakdown, and asked a very stupid question.
  2. not built into the reporting program. but go find "DbVisualizer", on the internet. it is also a java program and gives good coverage for multiple databases.
  3. why would you want to take a timestamp, and try to convert it to a timestampValue?
  4. Hi, can anyone point me to the library that i report uses for graphs, I thought previously it used a different package, or are the graphic functions built in.
  5. try firing up another separate thread, then do your report stuff from this new thread.
  6. without seeing the code, it could be the ref cursor is null, I.E there was some sort of error with your select, so no ref cursor was generated , and hence the error.
  7. Do you have a data source for this? if you do not have a datasource(for debugging) it's going to be a bit difficult for me to track the problem. but I can say that if you truely DID print to pdf & to your printer AT THE SAME TIME , and the pdf was O.K, but your printed report was not then you are looking at some sort of driver issue. also a few Questions: 1a. why have you got a sub report at the top of your current report, in the page header? (AW_profile_subreport) (also you did not send me the sub report.) 1.b WHY do you have a subreport in your invNoFooter? (AWName_Bill_subReport.xml) 2. why do you have so many strange groups & buried logic in your report such as: new Boolean($V{BreakGroup_COUNT}.intValue() > 15) in band BreakGroup (it seems a bit strange that this value should be about the number where you are getting strange behaviour) 3.Why is your page footer only 2 high, it does not seem useful? 4. Your SQL is interesting!!..... , I hope that's not running against an oracle database? 5. what exactly do your 2 subreports do? I know you are getting close to your deadline. what's the chance of coding up a datasource(java class), to run the report against a standard set of data. If you can look at supplying me the 2 missing reports, and a sample datasource , i don't mind spending a bit of time looking at this for you. But personally, perhaps this (sample xml file )is not how I might have tackled the problem of generating a simple invoice Post edited by: Code_Slave, at: 2006/09/22 10:51
  8. I know it is a pain , and it is extra work, but you have not proved that the data coming out of the printer is different than what is being sent. spool your output to a pdf as well. it should not have taken this long to trace this problem. Post edited by: Code_Slave, at: 2006/09/17 07:35
  9. well , it could be any number of things I.E 1. you are not actually using the datasource, by mistake 2. the connection has not been passed to the datasource. 3. the query the datasource is using is returning an empty set post your customdatasource, I will take a look.
  10. This is only a rough guess & i have not tried this....... But as jasper is written in java , there may be a good chance that the <HTML> tags work for formatting. but that would depend on how the intrenal rendering is done in jasper. Dan would be the guy to answer this question.
  11. no. not if it is in pdf format. there is a conversion situation from jasper to pdf. you have 2 options. 1. keep it in jasper format, and render it to pdf when a user wants it in pdf 2. render it to pdf, then use itext to display it as a separate task (better solution ,but a bit more work.)
  12. I had asked for something similar, or atleast the ability to remove/lock the icons. (i might not want the user to print/save secure documents!!) quite a few months ago, but nothing has been forthcoming.
  13. try writing a customdatssource. see jasper reports ,demo folder. there is a complete example showing exactly what you want to do.
  14. it should only appear once. is the report with a subreport. or have you called it twice in code.
  15. Well you could try: 1. take your basic report , then modify the XML (related to which subreports to use) in your program, based on the user selections as the programs are running, finally compile the dynamic report & run it.
  16. Well you could try jasperreports/demo/samples/datasource. where the very capable Teodor Danciu, has already written one for you. but thats only a rough guess.
  17. Ahhh!, The number of times in my lifetime I have assumed things and been wrong. Personally , if you are going live next week, then you should be looking at the software first, and i can think of several reasons for inconsistent print, without it being a hardware problem. However,if you insist in moving onto the "hard" things before doing the easy then: you need a clear idea of how your printer connects to the computer. 1. is it via a spooler (hardware/software) 2. is it directly to the Com or parallel port. 3. is it on a shared network , or is it dedicated to the machine. Do you have the budget to just go out and buy a new printer cable/printer? Can you beg/borrow or steal a printer & cable for a couple of hours ? Where possible do the easy stuff first. Start by replacing the hardware, if that does not work then trace the print flow thru each stage, after it leaves your app. but really you should be verifying the data on each run first.
  18. on the whole java 1.4.2 is no more insecure that 1.5.0, if anything I would guess it is the other way round. 1.5.0, is in theory still under development, and if you will insist in using the latest versions , then please expect some problems. many shops are still using 1.4.2_04 and some 1.3. personally I would drop back to 1.4.2 ,and save myself the worry of why it does not work. but it apears you have a native crash in the good ol MSVCRT.dll (see how many cock ups you can find in google related to that damned thing!!) if you want to persist, have a look at some of the fixes related to MSVCRT.dll or you could file a bug report with sun.
  19. add in a small section , of debug code, to write the page out to a pdf file on the local disk. then at the end of the run compare what you have on the printer & what is on the pdf. if they are the same, then the problem is in your report, and it's compilation of the data. if the pdf is right & the printer is wrong, then you have an issue with either you printer connector, it's buffer or the drivers. or if you are using a spooler then , that may be where it's at.
  20. 1.4 million times, and you are surprised you are getting out of memory errors? you are seriously going to have to split your data set down. not to mention random crashes that occur now & again, do you really want to run such a report from the start? I would get a couple of computers on the job. possibly serialising each page out to a common disk area, for either: 1. a 3rd computer to compile & print 2. compillation at end & split print form 2 machines 3. separate thread to print each page as it has finished serialising. note , above would depend on if you were running a summary , also keep in mind that if you are doing such things as page n of X, such detail can only be completed at the end of the report, you may need to have a re-think on your report format.
  21. getting data from 2 sources is NOT a problem. even with the subreport using the data from a different database. it's all down to you needing a customdatasource class , that's all, very easy. The oracle not displaying Chinese. you must INSTRUCT the database to store multi-byte characters, if you do not then it will not, it is not a mind reader , it is only a data manipulator. There is however a way round it, even if you have your database set to ASCII. you can store the Chinese data in BLOB's , NOT CLOB. Varchar2, CLOBS , ARE FILTERED datatypes, in that they are passed thru your NLS settings, ALways on the RDBMS and sometimes on the client, depending on which drivers you are using. BLOBS are not filtered. If your oracle is commisioned in Asia, I would guess that Multibyte is already enabled.
  22. how long is a piece of string? 1. it depends on the source of your records. 2. how complex is the query. 3. speed of your computer 4. loading of your computer. for example I have 1 query that's about 2,000 records & it takes 4 minutes, to query & generate a pdf. The pdf is just 1 row =1 record* 2,000 but I can also get the timings that Giulio gets, using simple data. Now whenever i run a report I crack open a progressbar window.
  23. i'm on OSX it's the update checker for some reason. startuptime is fine , but i am getting hangs on startup. sometimes i leave it for a couple of minutes. I have a JFrame, but it is blank, quitting and restarting usually brings it up. can you not do update checks on another thread?
×
×
  • Create New...