Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by furrelkt

  1. furrelkt

    Not sure what method to use, OnRow, OnRead, Fetch()

    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...
  2. furrelkt

    Help with NULLs in calulated field

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

    Help with NULLs in calulated field

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

    Help with NULLs in calulated field

    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...
  5. furrelkt

    Help with NULLs in calulated field

    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!!
  6. furrelkt

    Help with NULLs in calulated field

    gdwood, did you receive my rod file? thanks,
  7. furrelkt

    Help with NULLs in calulated field

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

    Help with NULLs in calulated field

    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.
  9. furrelkt

    Help with NULLs in calulated field

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

    Help with NULLs in calulated field

    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.
  11. furrelkt

    Help with NULLs in calulated field

    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.
  12. furrelkt

    Help with NULLs in calulated field

    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...
  13. furrelkt

    Help with NULLs in calulated field

    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 )...
  14. furrelkt

    Help with NULLs in calulated field

    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")+...
  15. furrelkt

    Help with NULLs in calulated field

    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...
See more

Part and Inventory Search

Back
Top