dbTalk Databases Forums  

Please help-some suggestions very urgent

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Please help-some suggestions very urgent in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
maya
 
Posts: n/a

Default Please help-some suggestions very urgent - 02-16-2005 , 11:22 AM






All,

I have a variable myavg in my sql reports. Now I want to display the
value of this variable in a "compute" statement, is that possible ?

Or, I have three fields

TotalCourses Subjects passed %
7 5 71.4
4 3 75

Student Total 11 8
Student average ****

I want to display the student average under % field. I have the value
but I dont know how will I place it under this field. I display the
text "Student average" using compute function

Compute .... Label 'Student average' of .... on ...

Can anyone please help ?

Thanks


Reply With Quote
  #2  
Old   
Alan
 
Posts: n/a

Default Re: Please help-some suggestions very urgent - 02-16-2005 , 03:34 PM







"maya" <maya_java (AT) yahoo (DOT) com> wrote

Quote:
All,

I have a variable myavg in my sql reports. Now I want to display the
value of this variable in a "compute" statement, is that possible ?

Or, I have three fields

TotalCourses Subjects passed %
7 5 71.4
4 3 75

Student Total 11 8
Student average ****

I want to display the student average under % field. I have the value
but I dont know how will I place it under this field. I display the
text "Student average" using compute function

Compute .... Label 'Student average' of .... on ...

Can anyone please help ?

Thanks


Show us some of what you've already done to try to solve this homework
assignment. Post your code.




Reply With Quote
  #3  
Old   
maya
 
Posts: n/a

Default Re: Please help-some suggestions very urgent - 02-18-2005 , 11:07 AM



Alan,

I dont know what u want.
I want to display student average under Student total.
student average value i have calculated using a view. student average
should be displayed under student total..


Alan wrote:
Quote:
"maya" <maya_java (AT) yahoo (DOT) com> wrote in message
news:1108574532.683848.54620 (AT) g14g2000cwa (DOT) googlegroups.com...
All,

I have a variable myavg in my sql reports. Now I want to display
the
value of this variable in a "compute" statement, is that possible ?

Or, I have three fields

TotalCourses Subjects passed %
7 5 71.4
4 3 75

Student Total 11 8
Student average ****

I want to display the student average under % field. I have the
value
but I dont know how will I place it under this field. I display the
text "Student average" using compute function

Compute .... Label 'Student average' of .... on ...

Can anyone please help ?

Thanks



Show us some of what you've already done to try to solve this
homework
assignment. Post your code.


Reply With Quote
  #4  
Old   
maya
 
Posts: n/a

Default Re: Please help-some suggestions very urgent - 02-18-2005 , 11:10 AM



Why do u say, this is a homework assigment ? I posted a sample scenario
here. Please try to offer some help.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.