Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krish001
Yak Posting Veteran
61 Posts |
 Posted - 2009-10-07 : 06:36:42
|
| Hi,Iam having a tabular report where i have one column as lowest under that iam having values in textboxes as like this Lowest 1 --user enters 2 -- user enters 3 -- user enters 0 -- Null 5 -- user entersand at footer iam having sub total which gives me lowest value among them iam getting '0' as subtotal but my lowest is '1'...very urgent i need help simply in subtotal i should get lowest which the user enters... |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-07 : 09:25:45
|
| Can you post the SQL code you are using so we can get an idea of how the data is retrieved?John |
 |
|
|
krish001
Yak Posting Veteran
61 Posts |
Posted - 2009-10-08 : 15:27:15
|
quote:
Originally posted by JCirocco
Can you post the SQL code you are using so we can get an idea of how the data is retrieved?John
iam using expression min(fields!lowest.value) |
|
|
|
krish001
Yak Posting Veteran
61 Posts |
Posted - 2009-10-08 : 15:41:44
|
quote:
Originally posted by krish001
quote:
Originally posted by JCirocco
Can you post the SQL code you are using so we can get an idea of how the data is retrieved?John
iam using expression min(fields!lowest.value)
why noone is replying??? |
|
|
|
krish001
Yak Posting Veteran
61 Posts |
Posted - 2009-10-08 : 22:25:16
|
quote:
Originally posted by krish001
Hi,Iam having a tabular report where i have one column as lowest under that iam having values in textboxes as like this Lowest 1 --user enters 2 -- user enters 3 -- user enters 0 -- Null 5 -- user entersand at footer iam having sub total which gives me lowest value among them iam getting '0' as subtotal but my lowest is '1'...very urgent i need help simply in subtotal i should get lowest which the user enters...
some one plz reply............... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
|
|
|
|
|
Subtotal in tabular report