question

MuhSQL avatar image
MuhSQL asked

Desing Report with SSRS

Hi, I want to design a report like the image that I attached, information of the customers and image, ![alt text][1] [1]: /storage/temp/967-reportlist_sql.jpg I need the second row showing beside the first row ,Can I do that with SSRS ,or this design implement by Crystal report only
ssrs-2008crystal-report
reportlist_sql.jpg (79.3 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mister Magoo avatar image
Mister Magoo answered
You can do this quite easily by including a row number and a column number in your dataset. Place the data in a matrix report item, with row number as the row group and column number as the column group, then hide the first column and first row.[Attached sample report shows how to do this using some inline data][1] [1]: /storage/temp/968-newspapercolumns.zip

4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks a lot...it's work....and special thanks for attached.
0 Likes 0 ·
But I have question? I don't have a column number in my structure table , I can use the ID in my structure table as row number but how about column number ??
0 Likes 0 ·
You can take row number modulus 2 as the column number.
0 Likes 0 ·
I have a problem,the next value showing in the next row, Why? your way very easy I tried everything but still doesn't show
0 Likes 0 ·
Valentino Vranken avatar image
Valentino Vranken answered
Have a look at the following article if you're still struggling to get that implemented: [Creating Multiple-Column Reports][1] [1]: http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MuhSQL avatar image
MuhSQL answered
Please Mister Magoo,I attached an image to show you the problem ![alt text][1] [1]: /storage/temp/973-1232.jpg

1232.jpg (28.5 KiB)
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

you need a row number that repeats every two real rows, such that you get two real rows per "row number". e.g. SELECT FLOOR(ROW_NUMBER() OVER(ORDER BY some_column)/2) as RowNum, (ROW_NUMBER() OVER (ORDER BY some_column) - 1 ) % 2 as ColNum
0 Likes 0 ·
Then you have a row group on RowNum and a Column Group on ColNum
0 Likes 0 ·
MuhSQL avatar image
MuhSQL answered
I did That: SELECT floor(ROW_NUMBER() over(order by ID asc)/2) as ID, FULLNAME, DOB,ImageData, ROW_NUMBER() over(order by ID asc)-1)%2 as [colum] FROM Person left outer JOIN ImageData ON Person.FKImg = ImageData.ImageID
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MuhSQL avatar image
MuhSQL answered
![alt text][1] [1]: /storage/temp/974-222222.png

222222.png (9.8 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MuhSQL avatar image
MuhSQL answered
I reomved the matrix and put it again ,but now the problem different: as you can see the 10010450 should be appear in row(01) not in row(11) ![alt text][1] [1]: /storage/temp/975-33333.png

33333.png (10.4 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MuhSQL avatar image
MuhSQL answered
This is the probelm : 0 10010449 0 1 10010450 1 1 10010451 0 2 10010452 1 2 10010453 0 3 10010454 1 3 10010456 0 4 10010457 1 4 10010458 0 the Id for 10010450 must be 0 not 1,how can I do that?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

you just need to subtract one from the row_number() before dividing by 2. Sorry, I was typing on my tablet earlier, and missed that...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.