Search results for query: *

I have a report that i need to calculate the days reguardless of instances. The out put now is this... Date TASK Hours Days 2005-01-01 this task 8 1 2005-01-02 this task 8 1 2005-01-02 different 2 1...

I was able to figure it out!! :) thanks for all your help

Yes. I Just get blank fields in the ETC-ETC12 rows...

gdwood(new Daddy) Hope all is well with you and your family... well, i gave up with the report for a while cause i couldnt get it. but, i need to get back at it, i have been reading information about aggegates on the actuate forum, but i still cant get it. so i keep trying. I have two reports...

Oh, congrats~ That's great i am sure you are very happy, have a great time. I didn't get it solved but i will keep trying! Thanks for all you have done though, i really appreciate it! again, congrats!!

gdwood, did you receive my rod file? thanks,

yes it works fine when taking out the parameters. i just needed to enhance it.

textual query, and using tables and views, no temp tables at least i dont think so. I have taken the report writing over and am very new.

How can i declair the sum of ETC1-12 as a variable in the ql code ?

I think that i am more confused, i did have what you had above and gave me no errors but it didnt print anything in the field either. its just blank where there should be the addition of the ETC1-ETC12 fields minus the ETC. So i am not sure where to go from here.

gdwood, okay i spoke too soon, it did work now its not... so i am confused. so let me know if you think you might have a solution for my report. thanks so much.

WEll, now unforgunately i am really confused. I need to start over... I have 12 controls they are [ETC1-ETC12.], i want to make another control called [var] not a database field just an computed field that adds all the [ETC1-ECT12]together and then subtracts the [ETC] field. So i made a control...

Hey there gdwood, well i got it all in and took out the SUM but now it doesnt display anything because in the ETC7-ETC12 there is going to be NULLS or Nothing cause there is no time there yet. How do i now account for the nulls? here is the OnRow function: Sub OnRow( row As AcDataRow )...

Okay here is my code for the OnRow, thanks so much for your help! :) Sub OnRow( row As AcDataRow ) Super::OnRow( row ) Dim Var as double Var = SUM(Row.GetValue("ETC1")+Row.GetValue("ETC2")+Row.GetValue("ETC3")+ Row.GetValue("ETC4")+Row.GetValue("ETC5")+Row.GetValue("ETC6")+...

oops, i had ()after SUM but i changed it around, i am getting this error: NewReportApp::Frame::VarControl%BuildFromRow%AcDataRow(4): Actual: '[' Expecting: '(', '+', '-', [currency constant], [floating constant], [hexa constant], ID, [A-Z], [date constant], [integer...

okay i made a variable called Var, and in the BuildOnRow, i have this, Function BuildFromRow( row As AcDataRow ) As AcBuildStatus BuildFromRow = Super::BuildFromRow( row ) Dim Var as double Var = SUM()[ETC1] + [ETC2] + [ETC3] + [ETC4] + [ETC5] + [ETC6] + [ETC7] + [ETC8] + [ETC9]...

I am fairly new to Actuate. I am working on a report that has 12 fields (ETC1-ETC12) I want to add them together, then subtract ETC. Only problem is that there are NULLS in say ETC7-ETC12 because no time is recorded yet. How do i write either a SQL code or Function to handle the NULL values...