![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
mastereh
-
Posts
8 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by mastereh
-
-
I created a table, but now need to modify it. So I added a column, but it does not follow the colour format I had selected for the table.
How do I go about modifying the colour theme for a table I have already created?
Thanks
-
I have a table which stores the Date of birth for various policy holders.
I am trying to create a report that summarizes how many clients are of a particular age.
Ie
Number of policy holders under 25 | Number of policy holders 25 and over5000 | 4000
Does anyone know how I can write my sql to have today's date - the DOB field = age?
Thanks.
-
I created something recently where I had a table with the following data:
Total number of policies | Total number of Auto | Total Number of Property
In my case the Total Auto + Total Property had to equal Total Policies.
I created 3 seperate tables, each with their own SQL queries.
These were my three queries:
1) SELECT
count(Policy."PolicyNum") AS Total_Policies
FROM
"dbo"."Policy" Policy INNER JOIN "dbo"."PolicyTerms" PolicyTerms ON Policy."PolicySK" = PolicyTerms."PolicySK"
WHERE
PolicyTerms."TermStatus" = 'Active'
and PolicyTerms."TermExpiry" >= $P{UV_Date}2) SELECT
count(Policy."PolicyNum") AS Total_Auto
FROM
"dbo"."Policy" Policy INNER JOIN "dbo"."PolicyTerms" PolicyTerms ON Policy."PolicySK" = PolicyTerms."PolicySK"
WHERE
PolicyTerms."TermStatus" = 'Active' and
Policy."LineOfBusiness" in ('AP','AC')
and PolicyTerms."TermExpiry" >= $P{UV_Date}3) SELECT
count(Policy."PolicyNum") AS Total_Property
FROM
"dbo"."Policy" Policy INNER JOIN "dbo"."PolicyTerms" PolicyTerms ON Policy."PolicySK" = PolicyTerms."PolicySK"
WHERE
PolicyTerms."TermStatus" = 'Active' and
Policy."LineOfBusiness" in ('PC','PP' )
and PolicyTerms."TermExpiry" >= $P{UV_Date}For myself Line of business stores product info.
-
nm figured it out. Turns out I shouldn't have had my tables in the Detail section of the page. I moved everything over to Summary and it worked perfectly.
-
I've got a table which has multple columns, there should only be 1 row.
For some reason when I create my program runs the table replicates itself over and over again.
Any idea what could cause this?
-
Thanks for those.
In the end I want my table to look something like this:
Total Policies | Total Auto | Total Property | Total Commercial
5000 | 2500 | 2000 | 500
-
I'm trying to create a table which contains summarized data based on various functions.
How do I have multiple steps calculated in iReport? Do I have to create multiple tables and then use the designer to have them sit next to each other? or should I create multple sub-reports (1 for each column)?
First column:
SELECT
count(Policy."PolicyNum") AS Total_Policies
FROM
"dbo"."Policy" Policy INNER JOIN "dbo"."PolicyTerms" PolicyTerms ON Policy."PolicySK" = PolicyTerms."PolicySK"
WHERE
PolicyTerms."TermStatus" = 'Active'
and PolicyTerms."TermExpiry" >= $P{UV_Date}Second Column :
SELECT
count(Policy."PolicyNum") AS Total_Auto
FROM
"dbo"."Policy" Policy INNER JOIN "dbo"."PolicyTerms" PolicyTerms ON Policy."PolicySK" = PolicyTerms."PolicySK"
WHERE
PolicyTerms."TermStatus" = 'Active' and
Policy."LineOfBusiness" in ('AP','AC')
and PolicyTerms."TermExpiry" >= $P{UV_Date}Third Column:
SELECT
count(Policy."PolicyNum") AS Total_Person_Auto
FROM
"dbo"."Policy" Policy INNER JOIN "dbo"."PolicyTerms" PolicyTerms ON Policy."PolicySK" = PolicyTerms."PolicySK"
WHERE
PolicyTerms."TermStatus" = 'Active' and Policy."LineOfBusiness" in ('AP')
and PolicyTerms."TermExpiry" >= $P{UV_Date}Any suggestions on how to best do this would be great.
Thanks.
modifying a table
in Products
Posted
someone please help me. I don't want to remake all my tables.