Last post Jan 01, 2013 02:37 AM by waqar1
Dec 26, 2012 01:44 PM|Anand Reddy|LINK
I'm a newbie in ssrs.
I have a dataset with returns multiple records with 2 columns (ID, Description).
Here the column ID contains unique records.
On report I will place textboxes and now I want to set the expression to fetch Description based on the
ID and show it in textbox.
say, if ID=1 then textbox1 must display the Description of
ID = 1 ( in the same way i want to configure for each textbox)
Thanks & regards,
Dec 27, 2012 05:26 AM|Nishantg|LINK
I am considering the following.
1. You have one dataset(dsID) having ID & Description.
2. You have another dataset(dsMain) having ID with other columns.
If this is the case you can use Lookup function (SSRS 2008 R2).
Lookup(Fields!ID.Value, Fields!ID.Value, Fields!Description.Value, "dsID")
Dec 27, 2012 12:56 PM|Anand Reddy|LINK
I have only one dataset with ID & Description.
and i've textboxes on report (one textbox on top, one on bottom, and one in the middle of the report)
Now, based on the ID, I have to show the Description on textboxes (report) i.e., if
ID =1, then description for id=1 must be displayed in the textbox which is located on the top of the report, and when
ID=2 the description for id =2 must be displayed in the textbox which is placed in the bottom.
In the same way I must show the data in textboxes.
Can it be done?
Dec 28, 2012 12:17 AM|Ashutosh Pathak|LINK
Drag a list from the toolbox, set the height width as per your need. Drag textbox for ID at the top and another one in the bottom for description inside the List control you've added. by going on the list properties set the dataset to that dataset you've
created. Now drag the dataset value [ID] from toolbox to and drop it on ID Textbox, do the same for description textbox.
Let us know if you have any concern(s).
Jan 01, 2013 02:37 AM|waqar1|LINK
hm,,, @anand happy new year
drag any table,list etc in the body,,& then right click on the tablix properties ,set the dataset for the tablix (for table or list etc).. after setting the dataset ,then click on the right side of data rowthat will open the list of columns for the dataset,
as u have only 2 columns id & description ,so select one for one column of tablix,,,
later run the r eport u got the desired result,,, let me know if you have any issue....