July 19, 2011 at 1:18 am
Is any one can help on this,
snoSubjectMarks
1Subject120
2Subject150
result should be like this
Subject1: 20,50
how to write the expression for this in SSRS.
July 19, 2011 at 6:36 am
If you are using SQL Server 2008 R2 you may be able to use the LookupSet function:
http://msdn.microsoft.com/en-us/library/ms157328.aspx
The other ways I've gotten something similar to work are to create a SQL function to do it in the SQL query or use a subreport to get the data to display properly.
July 19, 2011 at 6:42 am
Your SQL query can do this using FOR XML PATH...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 19, 2011 at 6:45 am
Thanx for your suggestions,
I think its better to go for sub report here and i cant implement sql functions,
data source is microsoft dynamic CRM.
Actually i have to use this data set into another report by using lookupset.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply