SSRS display detail field across then down

I am trying to create a “detail” data section in my report where I will display all the “SerialNumbers”.

Each field is about 20 chars so I would like to print them across and then down to display as many as possible on the page. I’m still and infant when it comes to SSRS Report designer, but I’m eager to learn. I’m sure the answer is pretty simple, but I have been trying things and looking for a whole day.

Example 1):

I inserted a “list” and put in my re-occurring data…
It works create, but just displays down…

example 1a

===========================================
Example 2):

I used the table wizard to create a table… I put in rows and column groups…

e.g.

The output makes me Laugh…

======================================

I just want the data across and then down.

Please Help… I’m under a lot of pressure to get this done…

-LaMont..

2 Likes

It would help maybe if you put what you want the desired out put to be in EXCEL.

1 Like

Get rid of “SerialNumber” in the Columnn Group.

2 Likes

I have done this using a table - Google “SSRS Multiple Column Report” I would show the example except I have become feeble and do not remember if I had Breakfast. :slight_smile:

It can be done with 2, 3, 4 columns - whatever you like.
DaveO

2 Likes

Thank you so much for your response…

I’ve tried this and a hundred other things…

Yes, that gives me the same output as “list”:

The closest I’ve come is putting the field in the “column”…

This works perfect, but it puts a page break..then continues with the “detail” data on the next page

So this works for across, but now I need down…

Before you say it… I’ve tried a bunch of different ways of getting rid of the Page break. No luck yet.

Thanks,

-LaMont…

2 Likes

I found it - this is being used to show lot numbers for a pack slip. But the logic is the same.

2 Likes

Sorry I forgot you need the Column Group as a formula as well.

2 Likes

DaveO THANKS!!! You gave me the information that I needed to do this.

-LaMont…

===========================================================================

Still tweaking the ceiling calculations between the Row / Column group expresions…,but I’m getting real close,

-LaMont…

1 Like

Mr. @lamontlee: Glad you were able to translate my rambling example.

Looking good :slight_smile:
DaveO

1 Like

That’s why I say Dave is Mr SSRS.

2 Likes

Please note: for my pack slip i am doing this as a subreport so i am not interfering with the main Pack Slip

DaveO

1 Like

DaveO your “group” commands worked really well for the “formatting”, but for some reason that I don’t understand the data is repeating and duplicating.. e.g. (There are only 3 occurrences):

I’m sure there is something simple that I am missing… Thanks if you happen to know why this is happening…

Here are my formulas: (column)

Row formula:

Really appreciate any ideas I can try…

-LaMont…

1 Like

I’m just spit balling - have you tried adding a group for SerialCombo? Show the Group Header line and suppress the Detail lines?

DaveO

1 Like

I found a way to get rid of the extra lines with some “visibility” expressions… I think your suggestion to create a sub report is probably a good solution…which would probably avoid what I was seeing here… I’ll resolve this thread… Thanks ALL again for your help. -LaMont…

1 Like