I have update a bit but I couldn't group it based on Student name

I tried but no luck here is the RDL attaching

USE [Demo]
GO
/****** Object:  StoredProcedure [dbo].[up_GetStudentHistory]    Script Date: 21-02-2022 15:39:43 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*****************************************************************************
**File:...

• This reply was modified 2 years, 9 months ago by  sqldevlearn.

Yeah I  need help in rdl design as per the posted image

Here is the fiddle http://sqlfiddle.com/#!18/334d74/1/0

Also ('EPOGEN 20 000 U/ML MDV 1ML"EA"') is giving as EPOGEN 20  where it should be EPOGEN 20000 U/ML

declare @t table (name varchar(50))
insert into @t (name) values...

Here is one way that does it:

declare @t table (name varchar(50))
insert into @t (name) values 
('ARANESP 100MCG PFS SOLD BY THE'),
('ARANESP 200MCG PFS SOLD BY THE'),
('ARANESP...

I have the sample fiddle here

http://sqlfiddle.com/#!18/d2781/2

The last row data I need some modification

MCG MCG MCG MCG mcg MCG GM GM MG MG MG U/ML U/ML CREAM ML uni...

• This reply was modified 3 years, 3 months ago by  sqldevlearn.
• This reply was modified 3 years, 3 months ago by  sqldevlearn.

Resolved 

=IIF(IsNothing(First(Fields!IsActive.Value,"ds")) OR First(Fields!IsActive.Value,"ds") = true, "Yes", "No")

If not can any one tell how can i read blob data in sql itself by assigning it to a string or some thing