[Grouping Date & Time by Date on Axis]

My current graph: https://imgur.com/a/MRCKS

The X axis looks way too condensed. Is there a way to clean that up so that you can still see the date and the times? Like showing in groups of dates?

[iReport to Jasper Studio - Error connecting to mySQL]

I am trying to move from iReport to the newer Jasper Studio. I have created a connection to a remote mySQL database and the connection test comes back with succeeded. But when I try to use in a report, I get a user lacks privilege error? It's the exact same credentials that are working fine under iReport: https://imgur.com/a/DeWNQ

[Line Graph - showing multiples]

@hozawa thank you that was it.

[Line Graph - showing multiples]

Report XML:

<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Portfolio Trend" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="33a22ce1-6e1d-451e-a436-5c90984f6aa9">    <property name="ireport.zoom" value="1.0"/>    <property name="ireport.x" value="0"/>    <property name="ireport.y" value="0"/>    <queryString>        <![CDATA[sELECT     *,     UNIX_TIMESTAMP(portfolio_history.`checked`) AS date_checked,     portfolio_history.`value` AS portfolio_history_value,     portfolio_history.`free` AS portfolio_history_free,     portfolio_history.`used` AS portfolio_history_used,     portfolio_history.`Value` AS portfolio_history_ValueFROM     `portfolio_history` portfolio_historyORDER BY     date_checked ASC]]>    </queryString>    <field name="checked" class="java.sql.Timestamp">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="value" class="java.math.BigDecimal">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="freeBTC" class="java.math.BigDecimal">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="usedBTC" class="java.math.BigDecimal">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="ethValue" class="java.math.BigDecimal">        <fieldDescription><![CDATA[]]></fieldDescription>    </field>    <field name="date_checked" class="java.lang.Long"/>    <field name="portfolio_history_value" class="java.math.BigDecimal"/>    <field name="portfolio_history_freeBTC" class="java.math.BigDecimal"/>    <field name="portfolio_history_usedBTC" class="java.math.BigDecimal"/>    <field name="portfolio_history_ethValue" class="java.math.BigDecimal"/>    <background>        <band/>    </background>    <title>        <band height="72">            <frame>                <reportElement mode="Opaque" x="-20" y="-20" width="595" height="92" backcolor="#006699" uuid="1607789b-2fe3-4bf0-a530-965bf514a0d0"/>                <staticText>                    <reportElement x="20" y="10" width="375" height="43" forecolor="#FFFFFF" uuid="f536f3c3-cad1-4974-9ff7-ba604f8d32f5"/>                    <textElement>                        <font size="24" isBold="true"/>                    </textElement>                    <text><![CDATA[Performance]]></text>                </staticText>                <staticText>                    <reportElement x="369" y="53" width="206" height="20" forecolor="#FFFFFF" uuid="ff0393f4-b3ed-4a3e-9e97-84cc2840a4ae"/>                    <textElement textAlignment="Right">                        <font size="14" isBold="false"/>                    </textElement>                    <text><![CDATA[Trendline since go-live]]></text>                </staticText>            </frame>        </band>    </title>    <pageHeader>        <band/>    </pageHeader>    <detail>        <band height="250">            <lineChart>                <chart>                    <reportElement x="0" y="0" width="555" height="250" uuid="a3fbbfc9-d694-449f-a56f-e34d7da30054"/>                    <chartTitle/>                    <chartSubtitle/>                    <chartLegend/>                </chart>                <categoryDataset>                    <categorySeries>                        <seriesExpression><![CDATA["#1"]]></seriesExpression>                        <categoryExpression><![CDATA[$F{checked}]]></categoryExpression>                        <valueExpression><![CDATA[$F{value}]]></valueExpression>                    </categorySeries>                    <categorySeries>                        <seriesExpression><![CDATA["#2"]]></seriesExpression>                        <categoryExpression><![CDATA[$F{checked}]]></categoryExpression>                        <valueExpression><![CDATA[$F{ethValue}]]></valueExpression>                    </categorySeries>                </categoryDataset>                <linePlot>                    <plot/>                    <categoryAxisFormat>                        <axisFormat/>                    </categoryAxisFormat>                    <valueAxisFormat>                        <axisFormat/>                    </valueAxisFormat>                </linePlot>            </lineChart>        </band>    </detail></jasperReport>

[Line Graph - showing multiples]

Hi,

I am new to this platform and trying to get my head around the iReport Designer tool. I have 2 questions:

1. Where are the html5 templates for iReport Designer? My install isn't showing any
2. When I create a basic line graph with 2 lines and date on the X Axis, it's drawing a new graph for every date but with the same graph each time.

For example, if i have 5 dates, it is drawing the graph with the correct lines but 5 times instead of the once. https://imgur.com/a/ljj2r

thanks for any assistance.