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?