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 |
|
micnie_2020
Posting Yak Master
232 Posts |
 Posted - 2012-11-01 : 07:26:32
|
| Hi All,I have Master & Details Table return value for each record having 60 times.Now, if i sum(Field1). I will get the Price * 60. How can divide it based on field called NoRecord.Or How can i add sum the price with only distinct to Type & ID.Example:Type AID Price Desc1 Desc2 Desc3 [+]COM 1 1000 Test A TestB TestC 3000 << Details: Got 3 Desc. I just want the value return 1000.Please advise.Thank you.Regards,Micheale |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-01 : 09:54:13
|
| you need to bring an extra field (may be bit of row sequence number) from query for that and inside report expression you need to add a conditional logic based on IIF() function to get only unqiue values and SUM on thatfor more details post some sample data and your expected output out of it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Matrix Tablix SubTotal