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

madhukiran

Members
  • Posts

    54
  • 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 madhukiran

  1. jasperreports 1.2.6.jar contains a post script exporter class (JRPostscriptExporter).. you can probably give it a try
  2. If i need to integrate Jasper reports in a joomla page, what are the options I have.. I understand joomla is a php based app , though i have no idea of PHP :D can i use joomla to call the web services of jasperserver and run the reports/is there any way to integrate JRXMLs directly , without useing jasperserver.. please help
  3. does jasper support netezza as a database for reporting/jasper repository ???? i couldnt find any info on this in the forums!
  4. I am connecting to an Excel ODBC Datasource through JDBC-ODBC driver from JasperServer. When I test the connection, it says "Test Successful" but when i run the report with the excel datasource, it says the followign error: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhaustedany help on this? Post Edited by madhukiran at 08/06/2010 08:35
  5. http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=211
  6. hi , got a small qn ive already designed some 40 odd reports with the 'pdffontname' attribute and removing that from every report becomes cumbersome.. is there any way that these reports would run fine(with desired fonts) on a linux server just by adding the font extensions jar to the appn classpath
  7. My report detail band has calls a single subreport. And i have assigned a print when expression to the values inside the subreport. Now i need to have alternate shading to my report. If i use ($V{report_count}.intValue()%2)==0, then the shading occurs based on the row count. But i dont want this to happen.I am removing the line if subreport is blank. I want the row colour to change only whn the subreport returns data. The row count keeps changing even if subreport line is removed. Pls help
  8. Hi, I need to change the font size of certain fields in a report based on parameter input. I think palcing fields one over the other is a really cumbersome solution. I read in a post that the entire report font size can be changed during runtime by accessing the jasperdesign object. But how can this be implemented to change the font size of a given field and not the entire report font size
  9. madhukiran Wrote: ->You need to define a parameter of type java.util.List say p1 ->then you have to create a variable which is of type java.lang.Boolean and its expression is new Boolean($P{p1}.add($F{your_field_from_query}) keep the rest type as report so that all the values from the field get added into the para p1 --> now use it in your where clause as follows: where $X{IN,col_name,p1} the only issue with this is that parameter p1 wont get initiated and wud throw null,unless u make it as a prompt and click ok when it prompts.. im not able to initiate the type list.. any help on that from anyone???? ok..for the default value of the para.. jsut give new ArrayList()
  10. sorry i couldnt see the obvious choice: just use new ArrayList()
  11. hi matt, i need to set a default value for my parameter.. but the syntax mentioned by you just creates a fixed size list and i cannot add anything further to it.. pls help
  12. ->You need to define a parameter of type java.util.List say p1 ->then you have to create a variable which is of type java.lang.Boolean and its expression is new Boolean($P{p1}.add($F{your_field_from_query}) keep the rest type as report so that all the values from the field get added into the para p1 --> now use it in your where clause as follows: where $X{IN,col_name,p1} the only issue with this is that parameter p1 wont get initiated and wud throw null,unless u make it as a prompt and click ok when it prompts.. im not able to initiate the type list.. any help on that from anyone????
  13. Hi, I need to store certain values fetched from a single-column query in a list/collection so that i could use that in the Collection in another query's where clause.. I need the syntax to add values frm the field into the Parameter/Variable list.. does add() function help???
  14. Thanks for the reply.. I need to hide the page footer and a logo field in the header actually.. and im using my own application and not a jasperserver... I ignore pagination only when i export to excel.. so instead of adding a parameter like OUTPUT_IS_EXcel il use ignore pagniation itself in my case .. thanks for the help by confirming that ignore pagination is set to false if not true!!
  15. I am using a single jrxml which executes to give both pdf and excel outputs.. Now I do not want certain fields bands to print when the report is excel. Is there any way to do this?? P.S. I am passing the parameter IS_IGNORE_PAGINATION as true when running excel reports. So,I have give the print when expression to the fields to be hidden during excel generation as new Boolean(IS_IGNORE_PAGINATION.toString().equals("false")... but my doubt here is, does IS_IGNORE_PAGINATION default to false or null??? I can see that it is an in built parameter and it should default to false .. but just wanted to confirm....
  16. Even im facing a problem.. even after my fields being lined up vertically and horizontally. When i give a data value , it wraps the cell so that the data in the cell is printed in two rows.. whereas the pdf format prints the same dat ain a single row.. need help on this
  17. There is a problem, i have an image in my page footer which prints only in the first page. Its blank in the other pages. I have checked the remove line when blank option for my image. But it is sad that the page footer's size does not change dynamically when the element is removed. This results in a lot of space wasted in my report. Any help pls??
  18. When i export a report to excel from ireport, the rgb valus of the color gets changed.... the coulour gery(rgb 219,219,219) is printed as blue in the excel out put.. pls help
  19. the sort works fine when you first add the outer group by field first, then the inner group-by field in the sort options.(in case we are using multiple groups)
  20. I am not getting the point .. how to force a locale
  21. last page footer is a good choice.. but it usually aligns the elemnts relative to bottom... so better use summary band(unless ur element is a page number)
  22. hi you need to right click on required fields and select 'add node as field' from the xpath navigator on the right side of the query window
  23. when i change the report locale to spanish, the deciam lseparator changes from dot to comma.. but i want to retain the decimal separator as a dot.. please help
  24. Hi all,, I have a problem with my group header.. i need to print the group header only when there is data in the detail band.. I have checked the reprint header option. but since i have a subreport in my gorup footer whic h returns some notes as data, the group header is getting displayed even after the detail band is exhausted and just the footer is getting run... i dont want this to happen.. i want the header to be printed only when dta is avaiable in detail any help would be highly appreciated
  25. $V{page_number} wont work.. use the last page footer or summary band
×
×
  • Create New...