How to display data in rdlc in 8 boxes in page horizontal

Question

I work in rdlc report and i need to display UserID UserName Country Member img 8 time per page horizontally not virtical my result as below UserID 1 UserID 2 UserName michl UserName adil Country france Country England Member participate Member admin img imgbox img img2 here 3 here 4 until 8 can you help me please i attached my report with message

Amit Gupta · Answer

Why not simply use pivot in your query? Check the below link that looks extactly you wanted to be. https://www.youtube.com/watch?v=PMrSHGTngpA Do let me know if it solves your problem.

Nitin Sontakke · Answer

Two things. First you will need a bit of imagination and second this solution is a hack! Your current result-set ( I am not going details!) column1 1 2 3 4 5 6 7 8 What I am saying is your modified result set should look as: column1 column2 1 2 3 4 5 6 7 8 This is nothing to do with SSRS your dataset should return above result set.

ahmed salah · Answer

can you clear more really i not understand

Nitin Sontakke · Answer

I think it will better if you get your data source sorted out correctly. As I am not been able to imagine any other way. For example if your data source has resultset as follows: username1 country1 member1 image1 username2 country2 member2 image2 and then it has four rows then in one tablix you will bind all these 8 columns side by side and it will grow to have 4 rows. Hope you get my point. Currently I am sure you are getting 8 rows.