Link to home
Start Free TrialLog in
Avatar of accu2020
accu2020

asked on

multiple columns using a single field in SSRS

I have a crystal report that uses one field but the report generates 6 columns of the one field.  I need a simple way to show multi-column-data in SSRS.
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Give us a before and after data mockup of what you're trying to pull off here.
A screen shot will work too.
Not sure if I understand your question, not even sure about the tech you're using actually.  You're mentioning both Crystal Reports and SSRS in the same question?

If you're looking for displaying data from multiple fields in the same textbox in SSRS, they can be joined using either & or +:

=Fields!f1.Value & " " & Fields!f2.Value

The above puts a space between the two values.
Avatar of accu2020
accu2020

ASKER

I'm in the process of converting some Crystal Reports to Reporting Services.  The crystal reports version shows a single field using multiple columns on a single page; I have researched your site and you have a method to display the records horizontally, but I need it done vertically.  For example, if numbers are 1-50, using 7 columns:

-------  I need ------------------                 ----------  Your example  ---------------
1    9    17   25   33   41   49               1     2     3     4     5     6     7     8
2   10   18   26   34   42   50               9   10   11   12   13   14   15   16
3   11   19   27   35   43                     17   18   19   20   21   22   23   24
4   12   20   28   36   44                     25   26   27   28   29   30   31   32
5   13   21   29   37   45                     33   34   35   36   37   38   39   40
6   14   22   30   38   46                     41   42   43   44   45   46   47   48
7   15   23    31  39   47                    49   50
8   16   24   32   40   48

I tried reversing the formulas as you recommend, but did not give me the desired results.  Any ideas is greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for taking the time to respond back