[How to pass a value from main report to subreport?]

I have an EXCEL data source containig 3 fields (DONORNUMBER, LASTNAME, DOB).

I have  created a Jasper report that reads the EXCEL data . In this report i created a subreport with a different data source that reads from an SQL query.

What i want to do is to use the DONORNUMBER from the EXCEL and pass it to the SQL query in the subreport.

SELECT GENDER from DONOR_TABLE where DONOR_TABLE.DONORNUMBER = donor number value passed from the EXCEL

How do I pass the DONORNUMBER from the EXCEL into my subreport?

[Create DATASOURCE for Excel]

I was going through google searches and i did find that a lot of whats out there is confusing because many people posted notes that implied that a datasource was same as a data adapter.   That is what was throwing me off. But your response was helpful and it confirmed what i was thinking.  Thank you for your time.

[Need help with formatting date fields in an expression]

Thank you everyone for your help.    The response from A. KUZNT was colser to what I was looking for.

[Create DATASOURCE for Excel]

I have an EXCEL sheet (BUDGET.XLS) and have created a DATA ADAPTER for it that is working. I am able to read  the Excel sheet and create a jasper report (BUDGET.jrxml)from it.

 

The EXCEL source file(BUDGET.XLS)  in on a local drive H:/BUDGET

 

My problem is :

 

I want to publish the report but,

I do not know how to create a DATA SOURCE for it.

What ‘Datasource’ to select from the list of data sources

 

[Need help with formatting date fields in an expression]

IN my query I have a date field $F{DATE1} as class java.util.Date

What I want to do is to print  and concatenate $F{DATE1} and $F{DATE1} + 6 days

I want my result like this:     01/01/2019 | 01/07/2019 

My expression is:

new SimpleDateFormat("MM/dd/yyyy").format($F{DATE1})+"|"+new SimpleDateFormat("MM/dd/yyyy").format($F{DATE1} +6)

What is the correct exression to accomplish this?

 

Thank you in advance.

 

 

[Format concatenated numeric fields]

I my SQL query I have two numeric fields   $F{F1} and $F{F2} . Each is defined as java.math.BigDecimal

F1 value is 120.3415699

F2 value is 178.00987

What i what to do is to print the two fields concatenated together and | seperated with 3 decimal positions each.  This is what I want to be printed:

120.341|178.009

What is the coding for the EXPRESSION to achieve this?

 

[How to pass parameter value from main report to a TABLE]

I have a report that has two date paramaters $P{DATEFROM} and $P{DATETO}. Both paramaters also exist in the TABLE report with the same name.

 

The user is prompted for these dates. The date values have to be passed to the TABLE in my summary band. The Table has its own dataset.  

 

QUESTION: How do I pass the parameter from the MAIN REPORT to my TABLE report?

[Issue with exporting report to TXT format]

I am using Jasper Reports studio 6.7.

 

I created a very simple report that needs to be exproted to a TXT file.  When i select 'EXPORT AS TEXT', an error message appears:

Error exporting print... Character width in pixels or page width in characters must be specified and must be greater than zero.

 

Where do I find these settings for character width?

 

 

 

[How to pass parameters to a drill down report]

Problem solved.  Cause: Incorrect drill down report name was specified for '-report'.       Main report drills down sucessfully now.

[How to pass parameters to a drill down report]

I have a report (MAIN) that drills down to another report (DRILLTO).   I have created the hyperlink in MAIN . As a result, the DRILLTO report is launching as expected but non of my paramaters from MAIN are passed to DRILLTO report.

I have defined all the paramaters in MAIN in the 'HYPERLNK' tab including the "_report" that i want to pass to DRILLTO.    The same parameters appear in DRILLTO report except the "_report" parameter.

 

NAME                                      EXPRESSION

_report                                     "/reports/DRILLTO"

DRILLMONTH                    $F{COLLECT_DATE}

REGIONID                           $P{REGIONID}

DRILLTO contains DRILLMONTH amd REGIONID defined as paramaters.   

MY PROBLEM:

DRILLTO report opens as expected, but they are not being pulled into the DRILLTO report for some reason.

I checked my URL for the DRILLTO and i do see all my parameter values in there..

[Need help with EXPRESSION for divide by zero or NaN]

I need to create a java  expression as follows.

all my $V variables are java.math.BigDecimal:   BASE, AVG, VAR

 

If BASE / 0 gives a DIVIDE BY ZERO or NAN error then RESULT = 0       ELSE    RESULT = (AVG - VAR)/VAR

 

 

 

 

[Variable value changes in SUMMARY band]

My date table is like this:

RecordType Tons

01 15

01 20

02 25

03 30

03 40

04 50

 

there are multiple record types 01 and 03.  Record types 02 and 04 only have one data record each. What I want to do is to store the TONS value of each record type 02 and 04 into 2 seperate variables. Each RECORD TYPE is printed in its own DETAIL BAND. There is always the same number of records retrieved from  the database.

RECORD TYPE 02 stores into V1 and RECORD TYPE 04 V2. therefore V1 = 25 and V2 = 50

At the end of my report, in the SUMMARY band I want to do a calculation (V1 + V2). (25 + 50)

What is happening is that in the SUMMARY band V1 contains the same value as V2 for some reason. (50 + 50).

Any ideas?

[Default Value Expression for date at beginning of the year?]

My report has two parameters, $P{STARTDATE} and $P{ENDDATE}.

 

I need the dates to default to 01/01 of current year for $P{STARTDATE}   and 12/31 of current year for $P{ENDDATE}

 

Both are java.sql.Date class.  What is the coding fof the DEFAULT VALUE EXPRESSION?

[Subreport spacing]

In my main report I print 5 lines in the detail band. Then my subreport executes and that generates  more lines than is remaining on my main report. What is happenning is that the subreport instead of printing at line 6, it starts on a totally new page.

How can i get my sub report to start printing after the last line of the main report?

Jasper Studio v6.5

[Help with DEFAULT VALUE EXPRESSION]

I created  DATEFROM paramter  and I want to add a DEFAULT VALUE EXPRESSION that is 30 day prior to today.  

I am using TODAY () to get the current date but I also need 30 days prior date.

 

What is the DEFAULT VALUE EXPRESSION?

 

[Pass value from main to subreport]

excellent!!! it works exactly as you described.

[Pass value from main to subreport]

I have  report that contains a subreport. Each one has its own data set/SQL query.

The sql for my main report has two record types., 'ACCOUNT', and 'DTL'.   there is one  record for each 'ACCOUNT and multiple records for 'MAIN'.

What I want to do is for each 'ACCOUNT' record to execute the sub report query.

I need to pass the ACCOUNT.account_number to the subreport account_number query.

How can i do this? 

 

 

[PRINT WHEN EXPRESSION for a BREAK element]

In my SUMMARY section I have two SUBREPORTS separeated by a BREAK element .    I keep getting a blank page between the two subreports and another blank page at the end of the second subreport.

My BREAK type is PAGE.

I need a PRINT WHEN EXPRESSION that will do the break at 30 lines.   We are not a Java shop so we arent sure how to write the expression. I know that i will have to chnage the BREAK type to COLUMN.

UNLESS, some has another method to force a page break between sub reports.

 

 

[Version control software for Jasper Reports]

WE are researching version control software that works and plays nicely with Jasper Studio.  GIT is not in our scope we went want to avoid it.        We are a small shop, 4 developers and its difficult managingt and finding out wh made the last set of chnages. But using a checkin and checkout from repository application, this shoudl solve our problem.

 

 

[Hyperlinks URL - avoid changes when rolling into production]

I have two servers, one for development (DEV) and one production (PROD).

 

In the report I have hyperlinks. What I want is that when I am in DEV, my hyperlinks point to the webpage on my DEV server. When I am in PROD, I want the hyperlink to point to PROD.

I want to avoid having to make code changes in my report  when I roll out to PROD. I want the URL to change dynamically depending on which server the report is running from.

https://DEV.server.com     is hyperlink when report is tested in DEV.    https://PROD.server.com   is hyperlink for PROD.

QUESTION:

Any ideas on how to accomplish this?

[ORA-06553: PLS-306: wrong number or types of arguments]

We found the cause of this problem.

In our SQL script , in the WHERE statement we had a table that was comented out, but further down in the query we referenced a column  from that same table. The column was not commented.

Once we commented out the column , the SQL worked.

 

[FIELD NAMES list is not showing when READ FIELDS button pressed]

THis issue is only happening with one specific sql qery. All others are workign fine, even after we restartred studio.

[ORA-06553: PLS-306: wrong number or types of arguments]

I dont call any store procedure in the SQL script but it does conatin several sub queries.

[ORA-06553: PLS-306: wrong number or types of arguments]

I keep getting this error 

 

Caused by: java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'V'

 

what i dont understand is what is 'V' ? and what causes this type of error

[FIELD NAMES list is not showing when READ FIELDS button pressed]

I have a sql query in a Jasper report that doesnt show any errors when the READ FIELD button is selected BUT for soem reason it does not generate the feild names list