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

ybablyuk

Members
  • Posts

    28
  • 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 ybablyuk

  1. I think problem can be in cache. Can you try clear browser caches
  2. We support same versions as in JasperReport Server. It should be IE 9 +
  3. Ok, when you put in your detail band fields you will not have empty pages, you will have pages with your data Note detail band height should be not very big (usual it same as field height), in other case you will have empty spaice after every rows.
  4. Hello, As i see you have big details band, this band will repeat for every record in your dataset. For resolve this issue you need change detail band height to 0, or remove it. <detail> <band height="0" splitType="Stretch"/> </detail>[/code]
  5. Hi Oscar, You can try use parameter $P{REPORT_CONNECTION} for change datasource dynamically.
  6. Hi, I can create report using query: select count(orderid) as o_count, shippeddate from orderswhere shippeddate >= $P{From_Date} and shippeddate <= $P{To_Date} group by shippeddate[/code]As example you can use my attached jrxml file. It's used sample sugarcrm database
  7. Default value for Date paramented should be specify as:
  8. Hello, I think problem in "group by field2" part. Can you please run you sql in any sql client, I think you will have error.
  9. Hello, You need create 2 Detail bands. In Detail 1 you need add fields and after it "Brake" component. In Detail 2 you can put same fields or other fields and "Brake" component.
  10. Yes, you can do it. Please look section "Upgrading from 3.7 - 5.2 to 5.5101CHAPTER11 UPGRADING FROM 3.7 - 5.2 TO 5.5" from install guide http://community.jaspersoft.com/documentation/jasperreports-server-install-guide-commercial-edition-1 (page 101)
  11. When you add subreport to report you able choose other datasource as in main report. So for subreport you able specify other datasource. About report parameters: you need create input control with same name as your parameter in Controls & Resources page.
  12. Hello You can do it in two way: 1. Add JRXML to report from Ireport 2. From jasperreport server create report and upload main jrxmlopen tab "Controls & Resources"Click "Add Resource…" link My proposition: you can use Jaspersoft Studio, from this report designer you can publish your report with all subreports in one click
  13. Hello, Jasperreport server support Virtual Data Source. It's datasource that can have information drom different databases. For Create report you need create Virtual Data Source, create domain from this datasource. After It you will able create domain base report. Other way, you can create subreport - that can use other datasource as main report. In this case data between databases will not joined Let me know if you need help with it.
  14. Hello, you need change "Map name Expression", by default it's "USA". It's can me any country or region. It's can be value from parameter or value from column
  15. Hello, query should be like this select t1.Col_id as t1_col_id, t1.Col_OrderedByName, t1.Col_Name_ProductName, t2.Col_id as t2_col_id, t2.Col_ProductName from Table1 t1 left join Table2 t2 on t1.col_Name_ProductName = t2.Col_id
  16. Hello You need create grouping for you timestamp column. Add to report groupFooter and add "Break" to this groupFooter
  17. Hello Look my report with 1 subreport in attached file. For run it use sample sugarcrm database I propose for you put in summary "Break" component. Let me know if you have question
  18. Hello, If you men use it in jasperreport you can use date pattern. Look attched screen. In report you can have label with text "Von :" and after this label you can put your field with correct date pattern. Or you can use pattern like this "'Von : ' MM.dd.yyyy"
  19. Hello We don't support Java 8 right now. Support will be added in next versions. I recommend use Jaspersoft Studio for design reports. Thank you
  20. Hello, It's not supported. You can use only charts that available from jasperserver or Jaspersoft studio.
  21. Hello, You can use page break or subreports. Expect it you can create few Detail bands
  22. For use Remote XML Datasource you need just put in fileName url adress like this: <fileName>http://community.jaspersoft.com/sites/default/files/answers/test_0.xml</fileName>
  23. Hello, You need create data adapter in jasperserver repository. You can found example in folder: /organizations/organization_1/reports/interactive Customers Report used Customers Data Adapter. in Report JRXML we need add property: <property name="net.sf.jasperreports.data.adapter" value="repo:/reports/interactive/CustomersDataAdapter"/>[/code]CustomersDataAdapter it's xml file with next content: <?xml version="1.0" encoding="UTF-8"?><remoteXmlDataAdapter class="net.sf.jasperreports.data.xml.RemoteXmlDataAdapterImpl"> <name>northwind</name> <fileName>repo:/reports/interactive/CustomersData</fileName> <useConnection>true</useConnection> <datePattern>yyyy-MM-dd</datePattern> <numberPattern>#,##0.##</numberPattern> <locale xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.String">en</locale></remoteXmlDataAdapter>[/code]<fileName>repo:/reports/interactive/CustomersData</fileName> - it's path to XML file in jasperserver repository, can be remoute XML file /reports/interactive/CustomersData - it's XML file taht can be uploaded to Jasperserver repository
×
×
  • Create New...