SSRS
-
Hi.
I need some tips on how to display the records in a report according to the below format in the SQL Server Reporting Services:
Ex:
If the query returns the following records:
Complaint# Complaint_Type License# License_Type
2005BNC09 Violation XV12345 law
2005BNC09 Violation HJK1239 law
2005BNC09 Violation OPL6788 law
Then the report should display like this:
Complaint# Complaint_Type License# License_Type
2005BNC09 Violation XV12345 law
HJK1239
OPL6788
The report should display one row for the complaint but the other columns should not repeat except the different license# column.
So what setting need to be done to achieve this?
Thank You
-
I don't think it is possible to achieve the exact look what you expect but the below thing is possible
Goto Table ? Properties ? Groups ? Add and in the expression add the below three
1)Complaint_Type
2)License#
3)License_Type
Add these fields in group header and Complaint# in detail section. The report look like below
Violation XV12345 law
2005BNC09
HJK1239
OPL6788
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.Thanks,
Arunkumar S P
-
Hi
Thanks for taking your time to reply
But i want the report to display like this:
Complaint# Complaint_Type License# License_Type
2005BNC09 Violation XV12345 law
HJK1239
OPL6788
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply