Datareport Question

[pinkpanther2070]

Is it possible to add, subtract, divide a function on a datareport, if so can you lead me in the right direction?

Pinkpanther2070

[Negative0]

There are 8 functions provided by the data report function control (SUM, Std. Deviation, Std. Error, etc.). You can only add this control to Group Footers and Report Footers.

Hope this helps,

[pinkpanther2070]

if you already have you functions established ex sum(field1) = function1, sum(field2)=function2, is there a way to say function1/function2 = value, in the footer of the report

[Negative0]

Do you want to Sum the Sums? Or do you want just one sum to show up at the bottom of the DR.

If you want to sum the sums, you can just use the Function control.

Hope this helps,

[pinkpanther2070]

Yes I want to manipulate the sums, so all i need to do is use another control!

So how do I tell VB that I want to function1/function2=function3

[Negative0]

I dont think you can do that in the DR, but you could probably do it in your SQL statement.

SELCT A,B, A/B as ADIVB FROM TABLE1

Hope this helps,

[pinkpanther2070]

Thanks for all your help, I dont think that the data report is capable of that either, I will try to do something else with my sql statement

[Negative0]

Yeah the DR has VERY VERY limited functionality, you have to do a lot of work with SQL. I also use temporary databases to generate my reports, I will just put everything I need in one table and just do it all though code. This method works very well for complicated reports.

[pinkpanther2070]

Yes this is true, I have found it out the hard way (Program is just about done, I'm debugging and adding things were needed)

I beleive I will try out Crystal next time