achurchill
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by achurchill
-
-
Hello,
Is there a way to customize the parameter pop-up dialog in a report? I have a lot of parameters that are the same but for multiple loans for instance:
Loan 1
Open Date =
Loan Amount =
Loan 2
Open Date =
Loan Amount =
and so on. I am using Jaspersoft Professional 5.5 and working on Jasperserver but i and my organization has no access to the Jaspersoft configuration.
Thanks
-
I switched it up from:
<property name="net.sf.jasperreports.export.xls.formula" value="IF(G7<>"",G7,IF(K7<>0,K7,H7))"/>
To:
<property name="net.sf.jasperreports.export.xls.formula" value="IF(NOT(G8=""),G8,IF(NOT(K8=0),K8,H8))"/>
not sure if anyone still can answer why the <> does not work?
-
Hello,
I have a report that I want to put a formula in a certain cell and it does not seem to reconize the formula as a correct formula. The formula string is blue and when I take out the <> it displays as green. I am using Jaspersoft Studio Professional 5.6.0 on Windows 7 machine.
Below is the block I am trying to fix
<textField isBlankWhenNull="true">
<reportElement x="1180" y="20" width="100" height="20" uuid="0f7eb733-3cbf-4a14-98b4-56e55fc04b33">
<property name="net.sf.jasperreports.export.xls.formula" value="IF(G7<>"",G7,IF(K7<>0,K7,H7))"/>
</reportElement>
<textElement>
<font size="8"/>
</textElement>
</textField>Does anyone have any idea? Maybe I can use something else then <>?
-
Sorry I might have misled you on the data I actually have. In my SQL query I have unions to get the data output below. The problem is in Jaspersoft I want to have the ACCOUNT_NUMBER1 flush underneath the FIRST_NAME column with the column headers ACCOUNT_NUMBER1 to PRIMARY_PHONE underneath the FIRST_NAME until the TELE_LAST_LOGIN_TIME. I am not sure if I can achieve this by Groups or sub reports but the query is broken up in a CTE in different queries and are unioned.
CURERNT SQL OUT PUT:
FIRST_NAME MIDDLE_NAME LAST_NAME SUFFIX AGE HAS_ONLINE_BANKING OB_LAST_LOGIN_TIME HAS_TELE_VOICE TELE_LAST_LOGIN_TIME ACCOUNT_NUMBER1 ACCOUNT_TYPE ACCOUNT_ELIGIBILITY ACCOUNT_OPEN_DATE ACCOUNT_CLOSE_DATE CORRESPONDENCE_DATE E_NOTICE_OPTION E_STMT_OPTION E_STMT_NOTIFICATION HAS_DIRECT_DEPOSIT TOTAL_AMOUNT_ACH HAS_MOBILE_DESPOIT MONTHLY_AVG_AMOUNT ADDRESS_ONE ADDRESS_TWO CITY STATE ZIP EMAIL PRIMARY_PHONE SHARE_ID SH_TYPE SHARE_OPEN_DATE APYE_POSTING_DATE APYE_AVERAGE_BALANCE CURRENT_SHARE_BALANCE PERSON_CATEGORY COURTESY_PAY_LIMIT COURTESY_PAY_ATM_DEBIT COURTESY_PAY_ATM_DEBIT_CH_DATE COURTESY_PAY_OTHER COURTESY_PAY_OTHER_CH_DATE LOAN_ID LN_PERSON_LINK_CATEGORY LOAN_OPEN_DATE LOAN_CLOSE_DATE ORIGINAL_LOAN_DATE ORIGINAL_FUNDING_DATE CURRENT_LOAN_BALANCE LN_TYPE_DESCRIPTION CREDIT_SCORE_CATEGORY CREDIT_SCORE CREDIT_LIMIT INTEREST_APR LOAN_LAST_ACTIVITY_DATE MATURITY_DATE CALCULATED_GRADE LOAN_TRANSFER_AMOUNT LOAN_TRANSFER_PERCENTAGE LOAN_TRANSFER_EFFECTIVE_DATE LOAN_TRANSFER_EXPIRATION_DATE DEBIT_CARD_NUMBER CARD_STATUS DEBIT_TRANS_COUNT CARD_ACTIVATION_TIME CARD_EXPIRATION_DATE CARD_ISSUE_DATE LAST_TRANS_DATE CREDIT_CARD_NUMBER CREDIT_CARD_OPEN_DATE CARD_TYPE CREDIT_CARD_LAST_ACTIVITY_DATE Jay T Test NULL 21 Y 6/13/2015 Y 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 55555555 Test Test 6/13/2015 NULL 6/13/2015 Mail notice only E-notice only Yes No 11111 N NULL 567 Test NULL Tets 1 PA 11111 tttttest@gmail.com 657 777 7777 1 Savings 6/13/2015 NULL NULL 3 Primary owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 4 Checking 6/13/2015 6/13/2015 3333333 3333333 Primary owner 100 N 6/13/2015 Y 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 6 Traditional IRA 6/13/2015 NULL NULL 3333333 Primary owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 8 Money Market 6/13/2015 NULL NULL 3333333 Primary owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 6000 TRAD IRA CD 12 M 6/13/2015 NULL NULL 3333333 Primary owner 0 N NULL N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 Primary 6/13/2015 NULL 6/13/2015 NULL 0 Personal Line of Credit TransUnion FICO 04 222 555 0 6/14/2015 6/14/2015 D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 Primary 6/13/2015 NULL 6/13/2015 NULL 666666 Indirect Used Vehicle TransUnion FICO Auto 08 3333 666 0 6/14/2015 6/14/2015 D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 7010 Primary 6/13/2015 NULL 6/13/2015 NULL 0 Visa Platinum Credit Card None 0 7777 0 6/14/2015 NULL None NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1.11111E+15 Issued 10 6/12/2018 6/12/2018 6/12/2018 6/12/2018 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1.11111E+14 Issued 10 6/12/2018 6/12/2018 6/12/2018 6/12/2018 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1.11111E+11 6/12/2018 Visa 6/11/2018 NULL NULL NULL NULL NULL NULL NULL NULL NULL 6666666 Test Test 6/13/2015 NULL 6/13/2015 Mail notice only E-notice only No NULL NULL N NULL 300 Test NULL Test CA 11111 tttttest@gmail.com 657 777 7777 1 Savings 6/13/2015 NULL NULL 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 Vacation Club 6/13/2015 NULL NULL 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 Holiday Club 6/13/2015 NULL NULL 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 4 Checking 6/13/2015 NULL NULL 0 Joint owner 100 N 6/13/2015 Y 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 8 Money Market 6/13/2015 NULL NULL 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 7777777 Test Test 6/13/2015 NULL 6/13/2015 Mail notice only Mail notice only No NULL NULL N NULL 300 Test NULL Test 544 PA 11111 tttttest@gmail.com 657 777 7777 1 Savings 6/13/2015 NULL NULL 3333333 Joint owner 0 N 6/13/2015 N NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL EXPECTED OUTPUT IN Jaspersoft:
FIRST_NAME MIDDLE_NAME LAST_NAME SUFFIX AGE HAS_ONLINE_BANKING OB_LAST_LOGIN_TIME HAS_TELE_VOICE TELE_LAST_LOGIN_TIME Jay T Test 21 Y 6/13/2015 Y 6/13/2015 ACCOUNT_NUMBER1 ACCOUNT_TYPE ACCOUNT_ELIGIBILITY ACCOUNT_OPEN_DATE ACCOUNT_CLOSE_DATE CORRESPONDENCE_DATE E_NOTICE_OPTION E_STMT_OPTION E_STMT_NOTIFICATION HAS_DIRECT_DEPOSIT TOTAL_AMOUNT_ACH HAS_MOBILE_DESPOIT MONTHLY_AVG_AMOUNT ADDRESS_ONE ADDRESS_TWO CITY STATE ZIP EMAIL PRIMARY_PHONE 55555555 Test Test 6/13/2015 6/13/2015 Mail notice only E-notice only Yes No 11111 N 567 Test Tets 1 PA 11111 tttttest@gmail.com 657 777 7777 6666666 Test Test 6/13/2015 6/13/2015 Mail notice only E-notice only No N 300 Test Test CA 11111 tttttest@gmail.com 657 777 7777 7777777 Test Test 6/13/2015 6/13/2015 Mail notice only Mail notice only No N 300 Test Test 544 PA 11111 tttttest@gmail.com 657 777 7777 SHARE_ID SH_TYPE SHARE_OPEN_DATE APYE_POSTING_DATE APYE_AVERAGE_BALANCE CURRENT_SHARE_BALANCE PERSON_CATEGORY COURTESY_PAY_LIMIT COURTESY_PAY_ATM_DEBIT COURTESY_PAY_ATM_DEBIT_CH_DATE COURTESY_PAY_OTHER COURTESY_PAY_OTHER_CH_DATE 1 Savings 6/13/2015 3 Primary owner 0 N 6/13/2015 N 6/13/2015 4 Checking 6/13/2015 6/13/2015 3333333 3333333 Primary owner 100 N 6/13/2015 Y 6/13/2015 6 Traditional IRA 6/13/2015 3333333 Primary owner 0 N 6/13/2015 N 6/13/2015 8 Money Market 6/13/2015 3333333 Primary owner 0 N 6/13/2015 N 6/13/2015 6000 TRAD IRA CD 12 M 6/13/2015 3333333 Primary owner 0 N N 6/13/2015 1 Savings 6/13/2015 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 2 Vacation Club 6/13/2015 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 3 Holiday Club 6/13/2015 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 4 Checking 6/13/2015 0 Joint owner 100 N 6/13/2015 Y 6/13/2015 8 Money Market 6/13/2015 3333333 Joint owner 0 N 6/13/2015 N 6/13/2015 1 Savings 6/13/2015 3333333 Joint owner 0 N 6/13/2015 N -
Hello,
I am using Jaspersoft Studio Professional 5.6.0 and I want to generate a report like the one below in excel. The query I have looks nice IBm DB2 SQL but I am not sure how to do this in Jaspersoft Studio. Any help is appreciated.
Full Name Age
Joe Anderson 34
Account Number Account Type
234433 Personal
Share Name Share ID
Savings 0001
Account Number Account Type
3333333 Personal
Share Name Share ID
Savings 0001
Full Name Age
Joe Anderson 34
Account Number Account Type
234433 Personal
Share Name Share ID
Savings 0001
Account Number Account Type
3333333 Personal
Share Name Share ID
Savings 0001
Report generates great in Jaspersoft Studio Professional but does not get by the Parameter dialog in Jasperserver
in Products
Posted
Hello,
I produced a report that has 74 parameters and I generate it in Jaspersoft Studio Professional 5.6.0 and it works perfectly. However, when I upload it to JasperServer Professional 5.6 build 20140527_1807, it does not even get pass the parameter dilaog box even when I enter all 74 paramters which all of them are not mandatory. I know I might get some thoughts on why a 74 paramter report but that is the way it is. I am guessing it maybe a configuration issue with JasperServer but I don't have access to the configuration but I can send any thoughts over to the people that control it.
Thanks in advance