Click here to Skip to main content
15,918,889 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
how to make tables in report server horizontal like:

header2 data3,data4,... instead of

header
data1
data2
.
.
.
Posted
Updated 16-May-11 18:00pm
v2

All you need is to get data in that format => Modify the query accordingly.

Read about SQL PIVOT:
Using PIVOT and UNPIVOT[^]
Understanding PIVOT and UNPIVOT[^]
 
Share this answer
 
with tow table and write below function and call functions in tables expresions
call this function in expresion for table that to show items and try to invisible it by color it white
VB
Public Dim lst As String = ""
Function getGoodsLst(ByVal text As String) As String

        lst += text + " - "
        Return lst

    End Function

call this function in expresion for table to show item like data1,data2,...
VB
Function getGoodsLst1() As String
        Return lst
    End Function
 
Share this answer
 
v2
Comments
faezeh66 7-Jun-11 2:39am    
it is not very good solution but by sql cursor you can conbine result of one field as data3,data4,...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900