You are not logged in.
MORE INFO:
The only way it will accept reports is if I use a blank report. All other templates, even ones used as little as 48 hours ago to create a simple report have stopped working and give the "subreport" error. Not thrilled about creating the "artistic" from scratch would like to know how to restore full functionality. As a 1 man IT shop I don't have time to make visually appealing templates if there is an alternative. Please, some guru please respond...
-------------------------------------------------------------------------------------------------------------------
FURTHER EDIT:
I have now attempted to upload over 15 jrxml files to ReportServer, and ALL reports regardless of which query is used on which database, and I used about half of the default templates that come with Jasper Studio. Existing reports that were uploaded prior to this issue work with no problem (started about the past 48 hours). Any and all reports that have been uploaded give the error message claiming that "no subreport of name..." I notice that the name of the template that was used to create the report always appears in the error message, despite the report being renamed upon creation.
This issue makes ReportServer unusable at this point. Need help!
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
EDIT: I simplified my query down to:
select *
from producekl
and I still get the error:
The report could not be executed: No subreport of name rsfsx://jaspersubreport/8f9837a5-8b25-4057-90b6-8e2e4a23036b/flower1 found.
To get help please contact an administrator.
I have tried creating 6-7 different reports and all are giving this message when the jrxml is uploaded to ReportServer. The reports that were already there are running just fine, but any new report I upload is doing this. Need Help!
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
My report does not have any subreports. It is a very simple report to display the results of a sql query. The error is:
The report could not be executed: No subreport of name rsfsx://jaspersubreport/3d448636-356c-4776-a727-d59e2a90f131/cherry found.
To get help please contact an administrator.
My MySQL query is:
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 1
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 1
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 3
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 3
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 10
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 10
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 11
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 11
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 16
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 16
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 17
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 17
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 18
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 18
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
union all
SELECT t2.StoreNumber
, t2.departmentNumber
, sum(t2.Sales) AS netSales
, ifnull(sum(t3.loss),0) AS knownLoss
, ifnull(round(avg(t3.loss / t2.Sales),4),0) AS percentLoss
from ( SELECT t1.StoreNumber
, t1.departmentNumber
, SUM(t1.dollarsSold) AS Sales
FROM movement.movement t1
WHERE t1.StoreNumber = 19
AND t1.departmentNumber = 80
AND t1.saleDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND t1.saleDate < SUBDATE(curdate(), WEEKDAY(curdate()))
GROUP BY t1.StoreNumber
, t1.departmentNumber) t2
left join
(select Store, Department, sum(loss) AS loss
from producekl
where Department = 80
AND Store = 19
AND klDate >= date_sub(SUBDATE(curdate(), WEEKDAY(curdate())), interval 7 day)
AND klDate < SUBDATE(curdate(), WEEKDAY(curdate()))
group by Store, Department) t3 ON t2.StoreNumber = t3.Store
GROUP BY t2.StoreNumber, t2.departmentNumber
The report runs fine in Jasper Studio but when uploaded to ReportServer the report gives the subquery error. Report data returns the following:
Store Number Department Number Department Sales Known Loss Dollars Percent
1 80 $11,936.42 $0 0%
3 80 $10,549.54 $1,382.79 13.11%
10 80 $4,504.74 $0 0%
11 80 $11,189.86 $0 0%
16 80 $6,399.22 $0 0%
17 80 $11,734.55 $0 0%
18 80 $10,615 $0 0%
19 80 $21,361.93 $0 0%
It is not a complex report and has no subqueries. What could be the problem?
Last edited by aaronmartin1651 (2017-03-10 04:59:53)
Offline
Existing reports that were uploaded prior to this issue work with no problem (started about the past 48 hours). Any and all reports that have been uploaded give the error message claiming that "no subreport of name..." I notice that the name of the template that was used to create the report always appears in the error message, despite the report being renamed upon creation.
I have tried creating 6-7 different reports and all are giving this message when the jrxml is uploaded to ReportServer. The reports that were already there are running just fine, but any new report I upload is doing this.
Hi aaronmartin1651,
what did you do when the issue started to appear? You say it started about the past 48 hours, and what did you change when this started to happen?
If you download one jrxml file that is now working, and try to upload it again, without any change,... what happens?
Have you tried to restart reportserver and tomcat ?
Regards,
Eduardo
Offline
Restarting ReportServer and Tomcat did not help ( I restarted entire server ).
Usually when troubleshooting if there is a problem you do as you state, look to the last change made right before the trouble began. The trouble is, there were no changes. I have had Report Server installed for about a week or so. I am the only user currently, and I am still designing the initial reports before allowing our users to start signing in. The only part of ReportServer I was accessing was signing into the main screen, adding a "dadget", Going to the administrator's page, Adding a new data source, Adding a report and uploading the jrxml, and going to the scheduling page and scheduling a single 1 time report to test its functionality. Other than that I have done nothing else on the ReportServer. It is hosted on Ubuntu 16.04 Server on a DigitalOcean VPS and the server is only accessible via SSH (or through the browser to log into the ReportServer webpage).
When I upload a jrxml that was created earlier it works as a new report.
Testing would indicate that Jaspersoft may be the cause, but in the same case, there have been no changes and it seems to function with no problems.
Next testing step will be to install Jasper Studio fresh on a different machine and create a report to see if the issue persists across multiple installations.
Offline
Issue appears to be with Jasper Studio installation, somehow when creating a JRXML file it is inserting data that makes ReportServer believe there is a subreport present even when there is not. Subsequent installs on other pcs allow the creation of reports and uploading of reports with no problems.
Offline
Hi aaronmartin1651,
I'm glad you could identify the issue. What data exactly is being inserted ? Could you upload a simple example?
Cheers,
Eduardo
Offline
Well, it has happened again this time to the other computer I installed on. Same error with any report I create, all prior reports work fine. I will run out of computers if I have to keep changing them. Really need to get to the bottom of the issue. The reports work fine when run from JasperSoft Studio but when I upload the jrxml file to ReportServer I get the error. I download the jrxml using the button in Report Manager window of ReportServer from reportserver and run it and it runs just fine so clearly the issue is with the server. What should I look at?
Offline
Hi aaronmartin1651,
could you check the jrxml version in your .jrxml files not working ? You can do this with jaspersoft studio: properties -> compatibility -> version. If using the current version check what version is your current version.
Regards,
Eduardo
Offline
Hi, I'm facing the same error. Is there any solution yet?
Offline
Hi jnchin,
same here, we need a *minimal* jasper report where this issue is happening. Can you post a minimal example ? Please delete anything unnecessary for reproducing the problem.
Regards,
Eduardo
Offline
Hi Eduarno,
This is the most minimal where I had removed all database fields.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1 -->
<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="Workflow Workload" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Key" uuid="03ab1588-4afd-4792-b7c3-20aa040c675e">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="242"/>
<property name="ireport.y" value="0"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="okmdb_tdk"/>
<parameter name="host" class="java.lang.String"/>
<parameter name="from_date" class="java.util.Date"/>
<parameter name="to_date" class="java.util.Date"/>
<queryString>
<![CDATA[select * FROM OKM_NODE_PROPERTY]]>
</queryString>
<group name="GroupProcessInstance" keepTogether="true">
<groupExpression></groupExpression>
<groupHeader>
<band height="65">
<rectangle radius="10">
<reportElement x="0" y="10" width="552" height="30" backcolor="#A4D4F5" uuid="0d4ad6f9-7a13-4672-8b7f-96554be9a987"/>
</rectangle>
<staticText>
<reportElement x="393" y="45" width="87" height="14" uuid="bfcff30d-e659-4442-9bef-e725471ec5b4"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
</textElement>
<text></text>
</staticText>
<staticText>
<reportElement x="127" y="45" width="150" height="14" uuid="858c7d6a-6716-428f-be12-e11cc3d718bb"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
</textElement>
<text></text>
</staticText>
<staticText>
<reportElement x="490" y="45" width="65" height="14" uuid="bcecb178-0b61-4453-a40d-b34f84ac154c"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
</textElement>
<text></text>
</staticText>
<line>
<reportElement x="0" y="60" width="555" height="1" uuid="3e527581-6476-48d5-8f48-edabda7231fd"/>
</line>
<staticText>
<reportElement x="287" y="44" width="93" height="15" uuid="dc7b7889-8e1b-4c89-95ea-6aaab9f2f1cd"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
</textElement>
<text></text>
</staticText>
<staticText>
<reportElement x="0" y="45" width="120" height="14" uuid="90ec4510-3e9f-451c-9ee2-61fcc79fe041"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
</textElement>
<text></text>
</staticText>
</band>
</groupHeader>
<groupFooter>
<band/>
</groupFooter>
</group>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="70" splitType="Stretch">
<staticText>
<reportElement x="84" y="0" width="297" height="44" uuid="396c9be1-ce17-448b-b877-5bb9cdc9f54c"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="22" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
</textElement>
<text><![CDATA[Workflow Status Report]]></text>
</staticText>
<textField pattern="yyyy/MM/dd" isBlankWhenNull="false">
<reportElement key="textField-13" x="0" y="0" width="65" height="10" forecolor="#010101" uuid="635053cf-8217-46a2-8276-ca5272b9306f"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isUnderline="false" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
</textElement>
<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
</textField>
<textField pattern="h.mm.ss a" isBlankWhenNull="false">
<reportElement key="textField-14" x="0" y="10" width="65" height="10" forecolor="#010101" uuid="20fcda20-07fd-4e9f-bad9-cfec9b3f4c0d"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isUnderline="false" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
</textElement>
<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
</textField>
<image>
<reportElement key="image-1" x="405" y="0" width="150" height="35" uuid="545ee24c-ea34-4134-8b0a-6378d92ca818"/>
</image>
<textField pattern="yyyy/MM/dd">
<reportElement x="266" y="50" width="76" height="20" uuid="898bc76e-b3b0-4e07-a68f-b62ac061da32"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$P{to_date}]]></textFieldExpression>
</textField>
<textField pattern="yyyy/MM/dd">
<reportElement x="150" y="50" width="75" height="20" uuid="31394bf4-0cb3-4458-99f0-c98b9857de91"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$P{from_date}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="225" y="50" width="38" height="20" uuid="09420a90-b496-4172-92bd-4231c5a81ff6"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
</textElement>
<text><![CDATA[to]]></text>
</staticText>
<staticText>
<reportElement x="-1" y="50" width="141" height="20" uuid="98c3468e-e4a9-4638-8f47-df280f931bfe"/>
<textElement>
<font fontName="Arial" isBold="true" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" isPdfEmbedded="false"/>
</textElement>
<text><![CDATA[For process submitted from]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="6" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="7" splitType="Stretch"/>
</columnHeader>
<detail>
<band height="16" splitType="Stretch"/>
</detail>
<columnFooter>
<band splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="39" splitType="Stretch">
<line>
<reportElement key="line-2" x="0" y="2" width="552" height="1" forecolor="#010101" backcolor="#FFFFFF" uuid="dcc07893-0b01-4222-be20-3ffd536cd2da"/>
<graphicElement fill="Solid"/>
</line>
<textField>
<reportElement x="430" y="10" width="90" height="20" uuid="ddcf43fc-b2e3-4613-9124-66eb064b6bcd"/>
<textElement textAlignment="Right"/>
<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="520" y="10" width="32" height="20" uuid="8d1f9f30-d009-4cc9-9e53-936fbf8e74bf"/>
<textElement textAlignment="Left"/>
<textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="3" splitType="Stretch"/>
</summary>
</jasperReport>
Offline
Error shown on screen:-
Error: An error occurred during report execution.
The report could not be executed: No subreport of name rsfsx://jaspersubreport/287a528f-4514-4da2-bf20-1bbe63ce4ead/unicode found.
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: No subreport of name rsfsx://jaspersubreport/287a528f-4514-4da2-bf20-1bbe63ce4ead/unicode found. at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at
Offline
Hi jnchin,
if I open your jrxml file with jasper studio, I see a lot of warnings like these ones: https://community.jaspersoft.com/questi … -extension (PDF Font is deprecated and replaced by the Font Extension)
Delete the pdfFontName="unicode.ttf" and pdfEncoding attributes from your jrxml file. Then it works.
Regards,
Eduardo
Offline
Thanks so much Eduarno.
It solved my problem.
Offline