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

alchavez

Members
 View Profile  See their activity

  • Posts

    27

  • 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 alchavez

  1. alchavez
    I am building reports via iReport 3.7.4, and would like some tips regarding exporting to xls format. I'd like the pdf and html version to display the page header on each page, as it currently does. I'd also like, if the xls version to only output the page header one time. I've tried several of the 'export option settings' and all of them for xls seem to result in the page header repeating for each page. So far I've had the idea that creating an alternate version that moves the page header into the 'title' band will work, but I thought I'd see if anyone had a way to get this action to occur all in the same report. Maybe do a 'print expression when' setting for the page header band and the title band based on format selected by user? Also, users are requesting a CSV option and once again I'm running into the same type of issues, the header values repeat throughout the csv output, as well as the group headers' and footers' data getting inserted into separate rows. Let me know if thoughts on just getting all the fields' data all into one row each in the CSV version with the header fields only displaying top row. Would that require an additional version of report? Is there a way for the report to just take all the rows/fields from the sql and export it into a CSV, ignoring the report's formatting? Thanks in advance, Anthony
  2. alchavez
    Thanks for the tip! My environment also has prompt to select format: pdf or html. It didn't occur to me to tie the user selection into a parameter until your message.
  3. alchavez
    I'm creating reports using iReport 2.0.4 and have some interest in doing the following: Have a text field that displays only when the report has been generated as a pdf, and another text field that only displays when the report has been generated as html. Is this possible? Perhaps using a a 'print when expression'? Thanks in advance, alchavez
  4. alchavez
    Working with iReport 2.0.4, I have a few database fields where some special characters are in the database in html format. For example a double quote ( " ) will show as ( & quot ; ) The text field will display the & quot ; instead of the " in both the html and pdf version of report. Is there a way in iReport to set up the text field to automatically convert the html special characters to regular characters. I could do this via sql query with the REPLACE function, but would probably have to do search and replace text for every html special character code used. It'd be great if anyone had any tips on this. Post edited by: alchavez, at: 2008/04/16 18:32
  5. alchavez
    Hello, The browser IE6 has this toolbar that shows up when you have your pointer hovering over an image, the "Image Toolbar". We find that this toolbar shows up in generated JasperReports in html format, and users think its part of the application and attempt to use the toolbar to print the report, which of course prints the image only (usually a blank image) We'd like to disable this toolbar. After some research I find that adding the following text to head tag of the html file disables the toolbar: <html> <head> <meta http-equiv="imagetoolbar" content="no"> </head> Is there a way to set up the report to always generate this value in the <head> tag? Thanks, alchavez
  6. alchavez
    duplicate post Post edited by: alchavez, at: 2008/02/01 18:44
  7. alchavez
    Thanks for giving the workaround! I will have to add this as a feature request for a future version iReport - the ability to convert and remove the deprecated tags.
  8. alchavez
    Thanks! That code does give the desired results. It would be great if in a future release of JasperReports, if the html automatically would output the report 'name' value to the title tag, but this workaround works great for the time being.
  9. alchavez
    Thanks for your reply! I have tried setting the html_header parameter and found that it adds the text into the header of the report, which is close, but not exactly what I'm searching for. I'm looking for a feature that will populate the <title> tag, which would result in the text showing at the top of the browser window, much like this text: "JasperForge - Re:Html Title Problem - JasperForge.org Forum", shows for this forum topic.
  10. alchavez
    I am running into this issue as well, and the links provided did not include information on how to resolve. Any tips on how to set the JasperReport jrxml file to input some text into the title tag, when the report is exported to html format? Such that the html source would have a section like this: <title>My Report Name</title> Thanks in advance!
  11. alchavez
    Hello, The application running jasper reports is generating a ton of warnings when a report is run, saying that many of the attributes are deprecated (see below for detailed error). My question is, is there a good way (preferably in iReport 2.0.3 / 2.0.4) to update the reports to help prevent these warnings. I'd like to be able to update the reports to no longer use the 'deprecated' attributes. Many Thanks, alchavez WARN [main] (JRBoxFactory.java:100) - The 'topBorderColor' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRBoxFactory.java:115) - The 'leftBorder' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRBoxFactory.java:124) - The 'leftBorderColor' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRBoxFactory.java:139) - The 'bottomBorder' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRBoxFactory.java:148) - The 'bottomBorderColor' attribute is deprecated. Use the <pen> tag WARN [main] (JRBoxFactory.java:163) - The 'rightBorder' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRBoxFactory.java:172) - The 'rightBorderColor' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRBoxFactory.java:91) - The 'topBorder' attribute is deprecated. Use the <pen> tag instead. WARN [main] (JRGraphicElementFactory.java:63) - The 'pen' attribute is deprecated. Use the <pen> tag instead.
  12. alchavez
    Hello, A quick question (couldn't find an answer after searching docs, forums, and the iReport 2.0.3 app): I would like to be able to set up my reports, so that when it outputs in html, the source code would look like the following, with the report name in the title tag: "<html> <head> <title>Report Name</title>" As it is currently, the title tag is always empty. Many thanks in advance.
  13. alchavez
    svenn, Thanks! I was missing step number 2. I changed the subreport settings to pass through the group expression, and changed the subreport query to require that information. I knew I was missing something.
  14. alchavez
    Hello, A quick request for some advice on the following situation. I must be missing some setting, developing the report in iReport 2.0.2: I've got a situation where a report requires 2 detail bands (one with the main information, the second with information pertaining to a group in the group footer). I have created a subreport in the groop footer, thinking I'd be able to print only information for the group in the subreport. Instead, the subreport is printing information for all groups, in every group footer. I haven't found any info on how to get the subreport working properly yet, so any quick thoughts on how to correct this would be appreciated. Many Thanks in advance!
  15. alchavez
    Thanks for the advice! Take note, this issue happens for all images in all reports (html only). I did check for overlapping images and found none. I also have tested the reports in Jasperserver on my local system, and the images show in html when run through Jasperserver 2.0.1. The issue occurs when run through our custom web application. Let me know any more thoughts or if I need to get the developer of the application involved and what info I might need to ask for.
  16. alchavez
    Hello, I've got reports developed in latest version of iReport. I've got my images set up like the following Image expression: new URL($P{BORLOGO}) (where BORLOGO is a url string.) Image expression class: java.net.URL The image displays properly when built in iReport. However, when I run the reports via the web app, the image only displays in pdf, not html. My question is: Should I modify the way my reports are designed to fix this problem? If so, how should I be setting up my images. For example, ts there a way I could set up the report, instead of passing in a full URL, passing in something like: /images/imagename.jpg and would this help with this problem? If you need more information, what should I ask the web developer to assist with correcting this issue? Thx in advance.
  17. alchavez
    This works great, thanks for the tip!
  18. alchavez
    I'd like to know if it is possible to do the following in iReport (running current version 2.0.2), as I have received a request for a report that does this: Can you set up a conditional group footer. For example, if the contents of the data fields in the footer are not null, then show the footer. If the Contents of the fields in the the group footer are null then the footer would not show and it would skip to the next row without showing on the report at all. Thanks in advance!
  19. alchavez
    Thanks for the suggestion, I think I will use that method instead of using the $X function. If anyone has any examples of the $X function working, that'd be great. This should work well for me in the meantime.
  20. alchavez
    Hello, A quick question - I'm attempting to create a report via iReport and set up the query similar to this: SELECT FISCAL_YEAR, ACCT_STRUCTURE, ACCT_REGION, ACCT_STATUS_CODE, ACCT_STRUCTURE_DESC FROM ACCOUNT_STRUCTURE A WHERE $X{IN, ACCT_REGION, $P{REGION}} AND LOCAL_STATUS = 'O' I set up the parameter REGION with class type of: java.util.Collection The error in iReport says that "Parameter type not supported in query : REGION class java.util.Collection" I've also tried changing the parameter class to java.util.Arrays and java.util.List with the same results. Any tips on how to correct would be greatly appreciated - thanks!
  21. alchavez
    Hello, Anyone have any ideas on how to convert an amount of minutes into HH:MM format using iReport? I did find a way to do this in SQL (the db is oracle) which would be a possible workaround: Hours: FLOOR(day1_time/60) Minutes: (DAY1_TIME/60)-FLOOR(DAY1_TIME/60))*60 But I'd prefer to have this done through the report instead of the SQL, since this report is going to have totals by group. I assume the above calculations would have to be in use, but I don't know if ireport has an equivalent of the FLOOR function, which would take a number like 6.75 and round it down to 6. Any thoughts on this would be greatly appreciated. Thanks, A.C.
  22. alchavez
    Hello all, I thought I'd post this follow-up on what I did to correct this in ireport, to help out anyone else that may search on this issue. It turns out you can use the REPORT_COUNT variable to get the record count information. Set up a field with variable REPORT_COUNT in the page header with evaluation time set to 'Now', plus 1 to get the record number at the top of the page. Add the number 1 using this: new java.lang.Integer( (1) +($V{REPORT_COUNT}.intValue()) ) Then have 2 more fields also using variable $V{REPORT_COUNT}, one with evaluation time set to 'Page' , and another with evaluation time set to 'Report'. Voila! You can use these 3 fields to get "records x to y of z" , on each page of your report. Post edited by: alchavez, at: 2007/07/23 20:31
  23. alchavez
    Hello, The reports I'm developing in ireport 2.0, have a requirement to have the following information in the header, such as this: page 1 would have: Records 1 to 20 of 100 Page 2: Records 21 to 40 of 100 ...and so on. Any tips on how to do this would be greatly appreciated. I've checked documentation and searched this forum, haven't found anything on this yet. Thanks in advance.
  24. alchavez
    Thanks, I did some more testing and I think I found the answer. I drag down the 'report title' section a half page or so. Enter the text boxes I need in the cover page on the top part of the Report Title section. Then I select Edit > Insert Page /Column Break and position it below the cover page contents, but above the actual report title - and I get the results needed.
  25. alchavez
    Hello, I'm new to JasperReports and am using Ireport 2.0.0 and so far I find it a great tool. The reports I'm developing all require a cover page, meaning a page of text, and the second page is where my report would begin. Would somebody help point to the best way to do this, as I haven't yet found out through going through documentation as well as looking for the function within the application. Many Thanks, A Chavez
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore