ckampshoff
-
Posts
111 -
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 ckampshoff
-
Cannot use my Java classes working with JSS: ClassNotFoundException
ckampshoff replied to valerianomoreno's topic in Products
I'm facing the same issue. Upt o version 6.16.0 everything works fine with the Scriptlet things. After updating to 6.17.0 the Scriptlet doesn't work. I did like the KBA said how to add the Scriptlet to the Jaspersoft Studio. That didn't work. So I put the jar file into my plugins folder. Add the jar file in the Java Build Path Section. Restart the Studio an it doesn't work either. Any other hints why it doesnt'work with the new version? -
Hi, thanks for your answer. We solved this issue with the using of an own Scriptlet. We're able to give the database name and the scriptlet connect to the correct oracle database the user selected from a drop down list. At the end of the report we close the connection.
-
Hello again, I have the CE version of the Jasperserver 5.2. and here everything is fine. I have several reports which are scheduled and work very well. No problems. I'm sorry but I really don't know why it won't work for you. Perhaps sone one else has the pro version of the jasperserver and knows why this won't work. Sorry.
-
Have you typed in the date / time value or have you chosen it by using the calender control?
-
Have you test it with two times the "00" for the time value? I had a similar problem, by scheduling a report. I forgot the "nulls" for the seconds and after that it worked for me.
-
Hi, I think you have to type in the date/time like this : 10.10.2014 09:00:00 Don't forget the the two "00" for the seconds. HTH
-
Hi at all, I'm trying the new Jaspersoft Studio (CE 5.6.1 final) and I was wondering if there's a possibility to use different data source (other than the one for the main report) for every subreport in one main report. In iReport I'm able to do that by using the "com.jaspersoft.ireport.designer.utils.Misc.getConnection("my datasource")" but I didn't find anything simple like that for the Studio. Only a hint for something like this: net.sourceforge.jtds.jdbc.Driver("jdbc:jtds:sqlserver://192.168.0.144","user","password"). I don't want to write my user and password combination in clear text into my report. Has someone a workaround for this and is it possible to get this on the Jasperserver to work? Kind regards Christina
-
Hi, you are searching for the variable $V{PAGE_NUMBER}. PAGE_COUNT gives you the number of records on the actual page, as far as I know. Hope this helps Christina
-
Changed Resolution from Open to Fixed Changed Status from Assigned to Resolved I tested this issue in the new release 5.0.0. And now it works. So I'll close this issue.
-
Hi, did you some setting to your table. e.g. Edit the "connection / Datasource Expression"? For that you right click on your table and choose "Edit table datasource". On the first tab choose "Use connection expression". iReport automatically fills the field with $P{REPORT_CONNECTION}. If you have parameters for your datasource you can set them in the same window under "Parameters". Hope this helps. Kind Regards.
-
Hi, have you tried to fill the "Range Axis Max Value Expression" in the properties of the charts with the same value? Kind regards
-
Hi, that means that your report can't get any data. Does your Query return some data? Have you created the table with a dataset or as an empty table? If you choose empty table: have you filled it with your fields from your query? Kind regards
-
Hi, ok let's have another try. Go in the "Report Inspector" to your cross tab. There you have the point "Row Groups" and "Column Groups". Click on the "+" and choose your group so that it is highlighted. On the right side of iReport in the properties window you'll find the point "Bucket Value Class". Please choose your class there. Hope this helps. Kind regards
-
Hi, I had the same problem. Here's a workaround: switch to the XML-View of your report. There search for "bucket". Then you have to change the lines in the code to something like this: <bucket> <bucketExpression class="java.math.BigDecimal"><![CDATA[$F{MY_FIELD}]]> </bucketExpression> </bucket> For "class" enter the class you need for your field. I hope this helps you. Kind regards
-
Hi, you can also do this by setting a property expression under the properties of the text field. You should klick "add" and choose net.sf.jasperreports.print.keep.full.text and type in as property value: true. That should work as you expected if you export your report in Excel. Regards Christina
-
Hi, you should try to do this with the jasperserver. There you can upload your created reports and schedule them. The scheduling is a build-in functionality in jasperserver. Regards Christina
-
preview/output differs from Word (OK) + PDF (bold lost)
ckampshoff replied to gramberg's topic in Products
Code:HTH means: Hope this helps :-) I spoke of the properties of the textfield. (Not the font drop down list on top of the report). If you klick on your textfield (which you want to be printed out in bold) you'll get an properties window of the textfield. In this there's an area which is called "Text properties" on the bottom of this properties window. There you can choose the "PDF Font name". Hope this helps ;-) -
preview/output differs from Word (OK) + PDF (bold lost)
ckampshoff replied to gramberg's topic in Products
Code:Hi, have you set the PDF-Font-Type? You have to choose the PDF-Font like "Helvetica-Bold" so iReport uses the bold font instead of the normal font. HTH Christina -
Code:Hi guys, I tested the new iReport version 3.7.6. and the same problem still appears. This is a big problem for me because I often use this kind of calculation. Does anybody know how to solve the problem or has a workaround for it? Regards Christina.
-
Hi @ all, I'm currently testing the new iReport Version 3.7.5. The feature are very helpful and it's nice to work with it. But I'm facing a problem: If I open an existing report with the newest iReport version, it resets the Calculation Type of the Subreport Retrun variables to "Nothing". Has anybody else the same problem? Is there a workaround for this? Regards Christina
-
Hi, have you tried to use the "to_date" function? Like WHERE DATECREATED < to_date( '28/07/2010','dd/mm/yyyy') ? HTH Christina
-
Hi, try this: SELECT DTBL_STUDENT."DISTRICT_CODE" AS STU_DISTRICT_CODE, DTBL_STUDENT."STUDENT_KEY" AS STU_STUDENT_KEY, FTBL_ENROLLMENTS."STUDENT_KEY" AS ENROLL_STUDENT_KEYFROM "K12INTEL_DW"."DTBL_STUDENTS" DTBL_STUDENT, "K12INTEL_DW"."FTBL_ENROLLMENTS" FTBL_ENROLLMENTSWHERE DTBL_STUDENT."DISTRICT_CODE"='2082' AND DTBL_STUDENT."STUDENT_KEY" = FTBL_ENROLLMENTS."STUDENT_KEY" HTH Christina
-
Hi, have you set the PDF-Font to bold? In iReport you have to set a font for the "normal" output and a special font for PDF output. For example I use SansSerif for report out put and Helvetica for PDF font name (I use iReport 3.6.0). If I want the font to be bold I have to check the checkbox "Bold" in the properties window and have to choose another PDF font "Helvetica-Bold". HTH Christina
-
Hi, try to use columns. This may help you: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=73144 HTH Christina.
-
Hi Giovanni, have you tried to use the build-in variable PAGE_NUMBER? I had a similar problem in one of my reports. I have a subreport in the summary band of my main report. The main report won't print a page footer on the summary band, if it flows over more than one page. So I created an extra page footer in my subreport and there I use the PAGE_NUMBER variable of the subreport. To get the sum of all pages I used the Evaluation time "Report" (I use iReport 3.6.0). That did the trick for me. HTH Christina.
