June 23, 2008 at 7:30 am
Assuming my RS dataset ALWAYS returns 1 row of data, what's the best way to render a single line of output in a vertical presentation in RS 2005?
Example:
SELECT Servername, ServerIP, ServerEdition, ServerServicePack FROM MyMetaData
WHERE Servername = 'Server123'
I'd like to see the 4 columns displayed in vertical format
Server Name: ServerABC
ServerIP: 10.1.1.0
Server Edition: 2005
Server SP: SP2
Instead of: ServerABC 10.1.1.0 2005 SP2
(Should I use a TABLE, MATRIX, or LIST?) thx in advance.
June 23, 2008 at 10:37 am
To list my output in vertical format, I created 1 dataset and manually added 8 text boxes (1 label; 1 data element) for each of the 4 elements in the datasets. Then populated the 4 data text boxes using the 'expression' feature.
June 25, 2008 at 7:53 am
Dear DBASkippack,
try to do one thing...
Create a dataset which has single row and four columns say A,B,C,D
Now, Drag and Drop a Matrix Control in your report.
Now Drag and drop all the columns required into Columns Section.
You can increase the width of column of matrix.
Now Preview the report...
June 26, 2008 at 8:42 am
Hari.Sharma -- Exactly what I was looking for -- worked great. Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply