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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to create reoprt such as this

Author  Topic 

sayer
Starting Member

35 Posts

Posted - 2013-04-29 : 01:11:55
i use sql R2 2008

i want way to apply good design like this report in image


http://aman-services.net
for office
???? ???? ???????

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-29 : 01:29:29
hmm...the date values look a bit weird (year 2574??)

anyways

what you need is a matrix report with rowgroup as StudentID and column as Date

then for data use like
IIF(Max(Fields!StudentName.value) Is Nothing,"no","yes")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -