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.
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.
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.
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.
------- 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for taking the time to respond back
A screen shot will work too.