Search results for query: *

I have written our Benefit Statements in ReportSmith. It is complicated! I use the DedCalc tables. If you are interested I can send it to you. Are you SQL?

Can anyone recommend a good resource for me to access SQL statements from? I am new to SQL and trying to write statements in ReportSmith. Thanks very much, Debbie

This is what I have learned in getting only on row of data. You should write a derived field for each row of your data. Let's say you have a row of data for Date A, a row of data for Date B and a row of data for Date C. Write a derived field for Date A, a derived field for Date B, and a...

Thanks very much. Do you have this in SQL? This looks like Oracle. Am I right?

I am not sure if this is what you mean, but if you write a derived field for each row, you will get a column for each row, since the results of the derived field show up in colums.

Don't know if you got answers on this, but this is what you do. You need a derived field for every row of data. For example, if you have 3 rows with 3 different deduction codes you write a derived field for each deduction code. Then you write a fourth derived field adding up all the three...

Does anyone know how to write a dervied field that will calcualte the service date of employees? In months and years. Thanks.

I just spent 6 months creating benefit summaries for our employees. It is not easy, but can be done. I used the DedCalc tables, Job, Personal Data, and tons of derived fields.