Solved

How to display multiple fields in a single text box SSRS 2005?

Posted on 2010-08-21
8
961 Views
Last Modified: 2012-06-27
I have a long list of fields that I want to be displayed on a row in SSRS. To make the line shorter, I want to display two fields per text box on each row. So for example, instead of having vendor ID and vendor name in two columns side by side, I want the vendor ID to appear above the Vendor name in the same text box in the report. Is this possible? Can you provide instructions or links that describe how to do this?
0
Comment
Question by:rwheeler23
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 250 total points
ID: 33493736
That's so easy, can you provide  a screen shot of your report or the .rdl file and i'll do it for you?
basicly you'll need to do another level within the grouping.
so inside your group, right click and select insert new row--inside group - below
0
 

Author Comment

by:rwheeler23
ID: 33493905
You werre corrrect. I even found where to set the borders so it looks like one box. On this report there are 4 parameter fields. There are Beg A1 Beg Beg A2 and Beg B1 and Beg B2. By default it lined up A1 and A2 on top and B1 and B2 on the bottom. Is there anyway to A2 to appear under A1 and B2 to appear under B1?

Enter Beg Job Number    Enter End Job Number
Enter Beg Date                Enter End Date

I would prefer

Enter Beg Job Number    Enter Beg Date
Enter End Job Number
0
 

Author Comment

by:rwheeler23
ID: 33493908
You werre corrrect. I even found where to set the borders so it looks like one box. On this report there are 4 parameter fields. There are Beg A1 Beg Beg A2 and Beg B1 and Beg B2. By default it lined up A1 and A2 on top and B1 and B2 on the bottom. Is there anyway to A2 to appear under A1 and B2 to appear under B1?

Enter Beg Job Number    Enter End Job Number
Enter Beg Date                Enter End Date

I would prefer

Enter Beg Job Number    Enter Beg Date
Enter End Job Number     Enter End Date
0
 
LVL 27

Expert Comment

by:planocz
ID: 33493920
You can do it  in two different ways.
1. You can expand the detail row to have more height and place the textboxes right under each other.
2. or you can add the two together two different ways.
one way is to type in the textbox the first row in the textbox th vendor name. then press the enter key and the shift key to place a hide linefeed on the line and then type in the next field name if the vendor ID.
way two which what I use alot is to place this in the textbox..
example... =IIF(Trim(VendorName.Value)="", Trim(VendorID.Value), Trim(VendorName.Value) & " " & Trim(VendorID.Value))
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:rwheeler23
ID: 33493933
I am talking about the parameters field prompts that appear on the top of the report. I would rather have the two prompts for job numbers to appear to the left and then the two prompts to appear for the dates.
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 250 total points
ID: 33493955
That is not what I read in your question.

The parameters can be moved up or down in the parameter edit window.
which would place them in the order you want.
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 33493957
Yep, there's a work around, just re-arrange the paramters, delete and re-create them in that order.
look at the attached screen shot, I added 4 paramters and names them @1, @2, @3, and @4
so you can see how SSRS show the paramters.
 
0
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 33499111
the easiest way to do is , add more number of rows in details section and add only two columns in your table, you can place all your field in one by one each cell in the table.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now