Below is my table
Based on Duration I need to add my client id in SSRS report 2005 1+1+3 =5
Any help much appreciated
Have you tried select distinct? Ex:
select distinct clientname, clientid, duration, totalduration
You can get the sum by using this expression:
Or use this example to get distinct values for the clientid column: Custom Aggregates
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?