744 questions
0
votes
0
answers
27
views
In my main report, how do I reference to a field that lives in a subreport?
I'm trying to print a message on my main report based on an existing value that comes from a subreport.
I tried adding the field to my main report with the same name, however it says that the field ...
0
votes
1
answer
32
views
Subreport Only Displays Last Row in Main Report in JasperReports studio
I am working with a main report in JasperReports that includes a subreport to display elements from a database. The subreport fetches the data correctly and works fine when run independently. However, ...
- 35
0
votes
0
answers
24
views
Displaying sub report is giving error as in the pic attached
I have report in which I am trying to display a chart, a Tablix and a sub-report I am able to display Chart & Tablix but not the Sub report, it is giving me the below error, what shall I do to ...
- 561
0
votes
0
answers
33
views
SSRS Multi-Column Reporting in Sub-Report Not Rendering in PDF
I have a functional multi-column SSRS report that when saved to PDF displays correctly. However, when used as a sub-report and saved to PDF it does not display correctly.
Steps (Stand alone report):
...
0
votes
0
answers
53
views
SSRS Sub Report to Excel creates Blank Row
I am trying to create a report where we can dynamically increase the column width while still retaining it as one column when exporting.
I have a Sub-Report that I pass the Data to and a value of how ...
0
votes
0
answers
13
views
SSRS Subreport Fails When Dataset Is Added
I have a report that includes a subreport. The subreport has a simple dataset with one parameter. When I test the report, it shows "Error: Subreport could not be shown." I've done some ...
- 41
0
votes
0
answers
17
views
Crystal Report - Duplicated detail lines when the sub-report in the group footer has multiple lines
Main report group is based on Contract. Detail section contains contract line items. The sub-report is placed in the group footer (linked by contract). If the sub-report has 3 lines of data, the ...
- 1
0
votes
1
answer
41
views
crystal report - uses subreport, has to get data from 2 different database in one command
I have installed crystal reports 2011 for .net 4.0. I create crystal report using visual studio. I use command to get data. the command gets data from 2 database. the 2nd database has same user and ...
0
votes
1
answer
79
views
Subreport causes application crash - VBA -MS Access
I have a report and within it a subreport.
After opening the report once, it's a matter of time until the application crashes.
I tried running the app without the subreport - that didn't crash.
With ...
0
votes
1
answer
17
views
SSRS 2008 r2 - How do I repeat a sub-report for each row of data returned in the results set?
I have a main report with multiple sub reports. The 2nd and 3rd sub-report are inside a List item.
The 2nd and 3rd sub reports are forms like this:
When I run the report I am getting a single table ...
- 173
0
votes
2
answers
152
views
Crystal report counting string values
I have a subreport that I am trying to look at a string value (not a numerical value) and if it is not null then to add 1 to a total and I need to keep a running total of this value per grouping in my ...
1
vote
0
answers
123
views
Question about the maximum number of sub reports within a report - Access
Wondering if there is an upper limit on how many sub reports can be put in a report? I’ve got a report that represents locations at a harbour. Think of this like a parking/berthage map. There are 43 ...
- 55
-1
votes
1
answer
241
views
Jasper Sub Report inside Sub report set the values to the Report only when Java Object List has One object. Nothing set when More than one in list
There are many examples regarding the jasper sub reports, but non of them wasn't enough to get work with my current issue.
I wanna set Jasper Sub report inside another sub report.
first sub report ...
0
votes
1
answer
504
views
In Telerik Reporting (Desktop), how to inject a json sub-node into sub-report string parameter
Introduction
Based on the below json sample, I am trying to define a Telerik report using both a main report and a sub-report, where se second is fed with a subset of the main report json data.
...
- 4,376
0
votes
0
answers
55
views
The bottom margin of the Rdlc Sub Report does not match the row bottom margin of the parent report
I'm working with asp.net mvc and using rdlc reporthing technology to generate reports. But I'm stuck in a bind.
This is the output of my rdlc report with sub-reports.
Where My Report Design are
and
...
0
votes
1
answer
313
views
Jasper produces report with only one page
I tried to fill a report with Java.
My main report has some subreports with different levels.
When I try to show my report, I see only the first page, I don't know where I'm wrong:
Follow structure ...
- 15.4k
0
votes
1
answer
890
views
Unable to see Jasper Report Sub Report table data populated with JSON
I've created a Jasper Report that only consists of a summary band with a table element. The data source is JSON and I am able to preview this report perfectly fine. (subJSONTest.jrxml) When I now ...
- 1
0
votes
1
answer
31
views
Subreport in BIRT binding by string
Is it possible to bind subreport by string and not by an integer? I'm trying to do it because I have such a data in database and the string (unique code) has signs like "/" and "-",...
- 300
1
vote
1
answer
33
views
IcCube - Embedded Dashboard using relative report path
In IcCube V7 reporting, I could use either absolute or relative path for referencing sub reports to be opened in an "embedded dashboard" widget.
I did not success to do the same in V8.2.2. (...
- 929
0
votes
1
answer
360
views
Jasper Report Gouping doesnt work for subreport data
I have a MAIN report and then a subreport that it is given the data from the MAIN report like this:
<subreport>
<reportElement x="0" y="0" width="...
0
votes
1
answer
152
views
Unlinked subreport is creating duplicate records in the main crystal report
I have an unlinked subreport in the report footer of the main report but for each record in this subreport, the records of the main report is getting duplicated. As it is an unlinked subreport, this ...
0
votes
1
answer
267
views
Crystal Report subreport blank field only deploy , in designer preview printer field exists
Crystal report version 2020
In Crystal Report Designer have "subreport" and have update Store Procedure in Field Explorer see new field, add new field in "subreport" in ...
- 1
0
votes
0
answers
260
views
"Data retrieval failed for the subreport" report created in VS 2017
I have created Main report and sub-report in Visual Studio 2017.
Sub-report "preview" works fine with dataset based on stored procedure.
Main report has a stored procedure that brings all &...
- 1
0
votes
0
answers
385
views
Sum values in Access Subform that have a checked box and show on Main Form
my problem is similar to Subform totals value to textbox in form returns error . I have a subform containing quantities, prices, trades dates, etc. for trades that have occurred and that data will ...
1
vote
0
answers
777
views
Making text fields stretch in two separate subreports
I have a main subreport, that contains two similar subreports placed next to each other.
These two similar subreports both contain a text field in the detail band. Detail band is set to stretch.
My ...
- 136
0
votes
0
answers
178
views
Jasperreports Studio - check if rows ins subreport contain a specific value [duplicate]
we're currently working on some delivery note Jasper Reports.
I have a main report and the detail band contains a subreport that shows the related articles.
The main report should show a specific ...
- 425
1
vote
1
answer
93
views
Jasper Subreport is not loooks same when I import it into main report
I had an issue with the output of the subreport. When I try to run it as separately then it's giving me a proper and expected output but when I try to add it into the main report then it's giving me a ...
- 66
1
vote
1
answer
1k
views
Hiding Sub-Report based on value returned from it using Jasper Studio
I am working on a report where I am having the scenario like the following:
I have got the value of Col 3 & Row 1 from Sub-Report 1 to Main Report. Now, I want to hide the Sub-report 1 if the ...
- 1,337
0
votes
0
answers
113
views
I need to hide entire sub-report based on a field value in the sub-report
I have a Jasper Report with a bunch of sub reports. I need to hide some of the sub-reports based on a specific row total within the sub report. In the screenshot example, "Sub Report 1" and &...
1
vote
1
answer
437
views
Adding Payments to Printed Invoice in Acumatica Report Designer
The Problem
Accounts Receivable has asked me to add (pre)payments to the invoices they send out because customers are paying twice (when they pre-pay and then when they get the invoice). They have ...
- 1,922
-1
votes
1
answer
2k
views
how do i call jasper which has sub report via spring boot?
I've tried several ways, but haven't found anything that works.
how do i call jasper which has sub report via spring boot ?
my controller
@PostMapping(value = "/dataSPM", consumes = ...
1
vote
0
answers
367
views
JasperReport variable is displayed when preview supreport but in master report it's throw error evaluating expression for source text
I'm using TIBCO Jaspersoft® Studio 6.15.0 for building my report.
I have a master report and a subreport with jdbc connection,
The master report and subreport retrieve data from different pl/sql ...
0
votes
1
answer
530
views
SAP Crystal Report : Subreport not showing data in production
I have a main report and 5 subreports, everything is working well except 1 subreport.
In development mode when I preview the main report all the subreports showing data perfectly, especially the ...
- 1
-2
votes
1
answer
2k
views
Jasper report with subreport using jsonql as datasource getting JRExpressionEvalException error
I had a very difficult time figuring out how to properly create a subreport using jasper reports with a jsonql datasource, so I hope it will help anybody who may encounter the same trouble.
I was ...
- 1,437
0
votes
1
answer
679
views
Jasper Subreport Only Populating On First Page - Java [duplicate]
I have a main report with a subreport in the group footer. The goal is to show this subreport on every page. In Jaspersoft Studio this works perfectly but when I compile and fill the template in my ...
- 1
0
votes
0
answers
99
views
SSRS inserting blank page
I have a main report calling three subreports. The subreports are being grouped together by the CourseID field. Page 1 shows course 1 for the first two reports. The third subpreport is for comments. ...
0
votes
1
answer
494
views
Do Queries inside a Sub Report still execute if it is Hidden
I have a situation where I want to show/hide sub-reports inside a tablix dynamically. Ideally, the content inside the hidden sub-reports would not execute to save resources. Anyone know how this works?...
-1
votes
1
answer
1k
views
Report with subreport in subreport using JsonDataSource [closed]
I have 3 .jrxml (main report, subreport and subreport in subreport) and get data from JSON. Paths to subreports jasper files I send like parameters (first subrreport - sub_jasper_report, second ...
0
votes
0
answers
52
views
SSRS subreport parameter - multi values
as you can see below, i need to pass a parameter value (red arrow)
i tried to use this expression: =iif(Parameters!Country.Count = Parameters!CountryCount.Value, Nothing, Join(Parameters!Country.Value,...
- 1
0
votes
0
answers
107
views
Adding subreports to main report from multilistbox Access vba
I am using a Microsoft Access 2010 (64 bit) database.
I have a form "MainDatafrm with a Multiselect list box "ReportList" and a button "cmd1".
I have a main unbound report &...
- 1
0
votes
1
answer
732
views
SSRS Report - Subreport can't be found
Ok, I have an SSRS report that has 2 subreports in it. One works just fine and the other works in testing but when I publish the report to my AMS platform under their instructions, the subreport ...
0
votes
1
answer
248
views
RDLC Sub Report in ASP.NET MVC using Views
I'm facing problem in generating RDLC Sub Report using ASP.NET MVC 5 Visual Studio 2019 using LINQ query.
I have two tables PartyType and Customer which is shown in Image given below. I want to show ...
- 11
0
votes
0
answers
212
views
External images in protected folder will not show on subreport RDLC
I have several external images in a company directory that need to be shown in an RDLC report (with multiple subreports) and exported into a PDF. Thanks to an answer by John, external images now show ...
- 192
3
votes
1
answer
3k
views
Subreport variable always return null
I need to put a variable in the master report which value came from a subreport. I followed instructions from the web, but I've always got null. For testing, I put "18" in the expression of ...
- 67
0
votes
1
answer
669
views
Am I able to add a page break between two subreports in SSRS?
I have an SSRS report with a tablix containing five subreports. I am trying to get it to the first page for each of the top four subreports on one page in the main report and then the first page of ...
- 47
0
votes
1
answer
2k
views
Passing multiple values to subreport parameter - SSRS
I have a report that has 4 parameters:
Year - accepts a single value for a year - ex: 2020
Carrier Group - allows the user to select a single carrier grouping
Segment - allows the end user to select ...
- 1,062
0
votes
1
answer
586
views
SSRS drill through report, How do I locate the referencing report name from main report
I have a report (developed by a previous employee), some of the columns(data) are clickable, when clicking the number(data on some of the columns) it opens another report. But when in the design mode ...
- 13
0
votes
2
answers
957
views
Subreport inside another subreport only print the first item of list of object
i'm trying to work using master report with a subreport, and this one with a subreport too.
I have an a list of Object and i am passing it as a parameter from JAVA.
When i print the Jaspers, only the ...
- 37
0
votes
1
answer
19
views
Crystal Reports - Pull Info on Deceased Records and Living Records' Spouses
I have a report that pulls in deceased executives that are tied to a company. The only parameter is the deceased date. The information is displayed in the Details section so that if they were ...
- 1
0
votes
1
answer
595
views
CR | Open subreport by clicking on database field in main report
this case is a little more difficult I think.
In my main report I have material numbers displayed in a cross table.
From time to time I need to show more details for one of the material numbers. ...
- 9