We are using Actuate 7 under a Maximo platform.
We are having some issues with Sub-reports.
When we create the sub-report and link the tables of the sub-report to the table of the main report, we get the rows in the sub-report duplicated. We are displaying the data in the sub-report under...
I am using Crystal Reports 9 over an Oracle 9 platform.
Problem :
Report has 2 date based parameters : Start Date and End Date.
In my record selection I have :
{WORKORDER.WORKTYPE} in ["LUBE", "PM"]
and ({WORKORDER.STATUSDATE} in
datetime({?Start Date}, time(0,0,0))
to
datetime({?End...
Sorry:) but that is still not it.
PMSEQUENCE is the table and INTERVAL is the field in the database table. PMNUM and JPNUM are also fields in the table.
Here is the hierarchy :
PMNUM
JPNUM
and every JPNUM has an interval value.
Now, for every JPNUM in the details section I run a...
Actually, what I'm trying to do is rather complicated.
For every row in the details section, I'm trying to insert all the values of table.field ({PMSEQUENCE.INTERVAL}) into the array interval_arr.
By doing this, I'm able to go through the array and perform a calculation and come up with one...
Crystal Version : 9
Database Connectivity : Oracle Server to Oracle 8i database
Trying to put all the values of of a database field into an array in Crystal.
What I have so far :
numberVar cnt_interval := DistinctCount ({PMSEQUENCE.INTERVAL}, {PM.PMNUM});
NumberVar i;
numberVar array...
I'm trying to do a recursive join :
If LABOR.craft = 'Y' then LABOR.NAME (GOOD TO GO!!)
else
if craft = 'N' then we have to go back into the table to get the craft code for the labor and get the labor.name for the given craft code.
What I have so far in the formula called Labor which is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.